This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
      • SharePoint Server 2013 resources
      • SQL Server 2014 Express resources
      • Windows Server 2012 resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 1

SQL Server Analysis Services announcement

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
SQL Server Analysis Services
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    1 Votes

    Who will be announced the next SQL Server Analysis Services Guru? Read more about October 2017 competition

    SQL Server
     > 
    SQL Server Analysis Services
    What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...
    Sticky | 0 Replies | 79 Views | Created by [Kamlesh Kumar] - Sunday, October 01, 2017 8:02 AM
  • large check mark
    0 Votes

    After Deployment Model to SSAS 2016 Could not see any Connection , tables or Roles

    SQL Server
     > 
    SQL Server Analysis Services
    I created the SSAS Tabular Data Model Solution in VS 2015 and Deployed that in SSAS 2016 Analysis services. After deployment I could not see any Object under any folder. can you ...
    Unanswered | 1 Replies | 34 Views | Created by Abhishek Parsai - 11 hours 30 minutes ago | Last reply by willson yuan - 51 minutes ago
  • large check mark
    0 Votes

    How to filter out results of inner join in MDX from OLE DB source

    SQL Server
     > 
    SQL Server Analysis Services
    I have a requirement here.I am generating reports for AVP using foreach loop.A variable holds the Email_address of all AVP.The foreach loops over every email and generates reports for each AVP.The ...
    Unanswered | 0 Replies | 25 Views | Created by msdnpublic1234 - 6 hours 17 minutes ago
  • large check mark
    0 Votes

    MDX Query # (6) : How to get the average value

    SQL Server
     > 
    SQL Server Analysis Services
    Suppose I have data from Jan 1st 2010 to  Jan 31 2012, meaning that Jan will appear 3 times in the data set whereas other months will appear twice each. My following MDX query is unable to ...
    Answered | 3 Replies | 110 Views | Created by justforsake - Sunday, October 08, 2017 7:14 AM | Last reply by justforsake - 6 hours 39 minutes ago
  • large check mark
    0 Votes

    add multiple select into a query named

    SQL Server
     > 
    SQL Server Analysis Services
    hello , please i have this querry witch i try it in my database SSMS but now i want to add this querry in my cube ssas , so my idea is to add this querry in a query named but it doesn't work any idea ...
    Unanswered | 1 Replies | 76 Views | Created by AsmaGh - 10 hours 51 minutes ago | Last reply by Olaf Helper - 9 hours 20 minutes ago
  • large check mark
    0 Votes

    MDX Reference Actual sales with Forecast revision

    SQL Server
     > 
    SQL Server Analysis Services
    Hi all, hoping some one can help me please with some MDX. I have the following simplified structure in a cube, we do forecast revisions during each quarter during the year however ...
    Proposed | 10 Replies | 121 Views | Created by rockyboy1 - Thursday, October 05, 2017 9:18 AM | Last reply by rockyboy1 - 9 hours 21 minutes ago
  • large check mark
    1 Votes

    Order a set in MDX based on a dimension member

    SQL Server
     > 
    SQL Server Analysis Services
    Hi , I have the following Query :- SELECT { } ON 0 , ...
    Proposed | 5 Replies | 86 Views | Created by Nimo0102 - Friday, October 06, 2017 10:02 AM | Last reply by Nimo0102 - 13 hours 35 minutes ago
  • large check mark
    0 Votes

    Performance of Unnatural Hierarchies

    SQL Server
     > 
    SQL Server Analysis Services
    There is a performance bug in SQL analysis services (multidimensional) related to unnatural hierarchies. (not performing as well as cross joins on the related attributes.)  The underlying ...
    Unanswered | 2 Replies | 70 Views | Created by David Beavonn - Friday, October 06, 2017 7:31 PM | Last reply by David Beavonn - 13 hours 46 minutes ago
  • large check mark
    0 Votes

    Tabular - Replace BLANK value in DAX Measure with string like 'N/A'

    SQL Server
     > 
    SQL Server Analysis Services
    Hi Guys, I have a DAX measure in a SSAS Tabular model that is just a sum of an integer field - In some cases this field is blank. Now it is fine if you are looking at a bunch of ...
    Answered | 3 Replies | 51 Views | Created by FPJVenter - 21 hours 9 minutes ago | Last reply by Alexei Stoyanovsky - 15 hours 5 minutes ago
  • large check mark
    0 Votes

    The XML for Analysis request timed out before it was completed. Timeout value: 300 sec..

    SQL Server
     > 
    SQL Server Analysis Services
    Options, including the recommendations made ...
    Unanswered | 1 Replies | 86 Views | Created by bejazep - Wednesday, October 04, 2017 1:18 AM | Last reply by Simon_Hou - 18 hours 5 minutes ago
  • large check mark
    0 Votes

    SSAS 2012 Multidimensional Cube taking longer to run on SQL 2016

    SQL Server
     > 
    SQL Server Analysis Services
    We are migrating from SQL 2012 to SQL 2016. As a part of this migration, we are moving SSAS 2012 cubes to SQL 2016. Multidimensional cubes that used to finish execution by 1 min 30 seconds now takes 4 ...
    Unanswered | 1 Replies | 84 Views | Created by UG12 - Tuesday, October 03, 2017 8:28 PM | Last reply by Simon_Hou - 18 hours 15 minutes ago
  • large check mark
    0 Votes

    SAP HANA as a DATA Source in SSAS

    SQL Server
     > 
    SQL Server Analysis Services
    Dear all, is there anyone used SAP HANA as a DATA Source in SSAS ? if yes, please help with the process or steps ...
    Proposed | 3 Replies | 138 Views | Created by Pravi Kumar - Thursday, September 28, 2017 5:38 PM | Last reply by willson yuan - 19 hours 49 minutes ago
  • large check mark
    0 Votes

    Does distinct measure groups using same fact table affect processing time?

    SQL Server
     > 
    SQL Server Analysis Services
    Hi all, Something is not 100% clear to me. I am re-viewing a cube that has a massive fact table. There are 2 distinct measure groups created "Distinct hotels" and ...
    Answered | 3 Replies | 131 Views | Created by Yvanlathem - Saturday, October 07, 2017 2:05 PM | Last reply by Yvanlathem - 20 hours 12 minutes ago
  • large check mark
    0 Votes

    How Can I improve this MDX query ( #5) : Overwriting context

    SQL Server
     > 
    SQL Server Analysis Services
    For me these queries are meant to learn MDX. I am guru in SQL and Excel, depending on the client and how the data is available I approach problems. Recently I faced a similar problem where I had to ...
    Unanswered | 1 Replies | 81 Views | Created by justforsake - Sunday, October 08, 2017 12:48 AM | Last reply by willson yuan - 20 hours 45 minutes ago
  • large check mark
    1 Votes

    An error occurred while opening the tabular model on the workspace database. Reason: The type initializer for 'Microsoft.AnalysisServices.BackEnd.DAXServices' threw an exception.

    SQL Server
     > 
    SQL Server Analysis Services
    Error occurred while opening the tabular model with analysis service, SQL Server 2012 SP3.  ============================ Error ...
    Proposed | 3 Replies | 800 Views | Created by JMJ27 - Tuesday, September 13, 2016 1:21 AM | Last reply by RajivSingh1237 - 21 hours 49 minutes ago
  • large check mark
    0 Votes

    DAX SWITCH Evaluates all combinations

    SQL Server
     > 
    SQL Server Analysis Services
    Hi, I currently have poor performance on a DAX calculation SWITCH function which evaluates all possible combinations.  This calculation evaluates in on ...
    Unanswered | 1 Replies | 83 Views | Created by Rogier Wijsman - Friday, October 06, 2017 10:49 AM | Last reply by willson yuan - 23 hours 53 minutes ago
  • large check mark
    0 Votes

    Grand Totals Incorrect and not reflecting filtered only items

    SQL Server
     > 
    SQL Server Analysis Services
    = 0, sum( //EXISTING Descendants(Axis(1).Item(0).Item(0).Hierarchy.CurrentMember,,LEAVES)  Descendants([Vw Dim Items].[Forecast ...
    Unanswered | 1 Replies | 62 Views | Created by Mark G1109 - Friday, October 06, 2017 6:23 AM | Last reply by willson yuan - Monday, October 09, 2017 2:52 AM
  • large check mark
    0 Votes

    SSAS MD count events

    SQL Server
     > 
    SQL Server Analysis Services
    Hi all – we have a fact table that stores responses from inquires that we send out to our customers. Each customer receives an inquiry with 5 questions ...
    Proposed | 6 Replies | 127 Views | Created by SnowShine429 - Monday, October 02, 2017 7:25 PM | Last reply by willson yuan - Monday, October 09, 2017 1:57 AM
  • large check mark
    0 Votes

    Unexpected Error - xmhistogramcache

    SQL Server
     > 
    SQL Server Analysis Services
    Hello, While Drillthrough from EXCEL i'm getting below error message. (Attached Screenshot as well) I'm connecting SSAS Tabular model from Microsoft ...
    Unanswered | 1 Replies | 78 Views | Created by Sunil Aravindakshan - Friday, September 29, 2017 9:38 AM | Last reply by Simon_Hou - Monday, October 09, 2017 1:49 AM
  • large check mark
    0 Votes

    Tabular Cube - can't create partitions when using a friendly name

    SQL Server
     > 
    SQL Server Analysis Services
    Hello! I created a tabular cube that uses view instead of tables. I want to use friendly names in the cube. I have no ...
    Proposed | 2 Replies | 91 Views | Created by Matthias Mathewson - Monday, October 02, 2017 5:58 AM | Last reply by willson yuan - Monday, October 09, 2017 1:42 AM
  • large check mark
    0 Votes

    How to remove ALL at month level in cross join MDX query

    SQL Server
     > 
    SQL Server Analysis Services
    Hello All, I have some confusion on crossjoin function within MDx. I don't want the records with "All" at month level in the result set, Can ...
    Proposed | 3 Replies | 128 Views | Created by NagaManikanta - Tuesday, October 03, 2017 1:26 PM | Last reply by RichardLees - Sunday, October 08, 2017 11:59 PM
  • Items 1 to 20 of 40237 Next ›
Announcement: 1

SQL Server Analysis Services announcement

  • Link
    FAQ - Analysis Services Information, Webcasts, Tools, Samples
    Edward Melomed Tuesday, December 16, 2008 11:27 PM
     References:

    Books On-Line Homepage

    Analysis Services Information Hub

    Tutorials

    Guded Tours

    SQL Server Customer Advisory Team

    TechNet Webcasts

    Videos on LernMicrosoftBI.com

    Product Code Samples

    Community Samples

    MDX Studio Project


Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

Would you like to participate?

  
Privacy statement
Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2017 Microsoft