SQL Server Analysis Services announcement
-
1 VotesWho will be announced the next SQL Server Analysis Services Guru? Read more about October 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...
-
0 VotesAfter Deployment Model to SSAS 2016 Could not see any Connection , tables or Roles
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 -
0 VotesHow to filter out results of inner join in MDX from OLE DB source
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 ... -
0 VotesMDX Query # (6) : How to get the average value
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 -
0 Votesadd multiple select into a query named
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 -
0 VotesMDX Reference Actual sales with Forecast revision
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 -
1 VotesOrder a set in MDX based on a dimension member
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 -
0 VotesPerformance of Unnatural Hierarchies
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 -
0 VotesTabular - Replace BLANK value in DAX Measure with string like 'N/A'
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 -
0 VotesThe XML for Analysis request timed out before it was completed. Timeout value: 300 sec..
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 -
0 VotesSSAS 2012 Multidimensional Cube taking longer to run on SQL 2016
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 -
0 VotesSAP HANA as a DATA Source in SSAS
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 -
0 VotesDoes distinct measure groups using same fact table affect processing time?
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 -
0 VotesHow Can I improve this MDX query ( #5) : Overwriting context
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 -
1 VotesAn error occurred while opening the tabular model on the workspace database. Reason: The type initializer for 'Microsoft.AnalysisServices.BackEnd.DAXServices' threw an exception.
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 -
0 VotesDAX SWITCH Evaluates all combinations
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 -
0 VotesGrand Totals Incorrect and not reflecting filtered only items
= 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 -
0 VotesSSAS MD count events
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 -
0 VotesUnexpected Error - xmhistogramcache
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 -
0 VotesTabular Cube - can't create partitions when using a friendly name
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 -
0 VotesHow to remove ALL at month level in cross join MDX query
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 ›
