SQL Server Analysis Services announcement
-
1 VotesWho will be announced the next Microsoft TechNet Guru? Read more about September 2017 competition
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that ...Sticky | 1 Replies | 163 Views | Created by [Kamlesh Kumar] - Friday, September 01, 2017 9:56 AM | Last reply by [Kamlesh Kumar] - Tuesday, September 19, 2017 8:40 PM
-
1 Votes
maxumun number of consecutive late arrivals
hi all - i am trying to figure out the maxumun number of consecutive late arrival of orders by vendors. i am using the ...Answered | 12 Replies | 163 Views | Created by SnowShine429 - Friday, September 15, 2017 5:26 AM | Last reply by SnowShine429 - 1 hour 3 minutes ago -
0 Votes
Operation Cancelled due to locking conflicts
I just inherited a 2016 multi dimensional cube and when trying to run simple MDX queries I get: Operation Cancelled due to locking conflicts. I get the same error when trying to ... -
1 Votes
DAX: Sum of Averages
I have a column "scheduled hours" which is basically the number of hours an employee is scheduled to work each day. This data is repeated for each record in the table for the employee and ...Proposed | 7 Replies | 152 Views | Created by VivDev - Friday, September 15, 2017 8:47 PM | Last reply by VivDev - 13 hours 56 minutes ago -
0 Votes
SSAS tabular object reference not set to an instance of an object
Hi, I am working on a new model with Analysis services in tabular mode, so when I try to import data from data source and set the impersonation information as "Service ... -
0 Votes
MDX for Exponential Moving Average
hi Using information from Mosha's blog on Moving Averages, I was able to create the MDX to calculate a Weighted Moving Average, but am just not smart enough to figure out an ... -
0 Votes
Don't see button "Set as DirectQuery" in SSDT partition editor
I am learning Tabular and converting the AW sample to DirectQuery. This article (https://www.mssqltips.com/sqlservertip/2934/directquery-mode-in-sql-server-2012-analysis-services-ssas-tabular/) shows ...Answered | 19 Replies | 104 Views | Created by intrasight - Wednesday, September 20, 2017 7:41 PM | Last reply by intrasight - 15 hours 20 minutes ago -
0 Votes
SSAS Tabular DirectQuery - how to observe queries being sent to relational engine?
I did sone Googling but found nothing explaining how to monitor DirectQuery activity. I am running MDX queries against SSAS and getting back data. I assume ...Answered | 4 Replies | 43 Views | Created by intrasight - Friday, September 22, 2017 2:50 AM | Last reply by intrasight - 15 hours 31 minutes ago -
8 Votes
MDX script editing error generated at each keystroke
I'm having the same issue in VS2012. When I edit an MDX script the error window pops open between each keystroke. I have to copy the script into notepad, edit, then return it to the MDX editor. Very ...Answered | 13 Replies | 5001 Views | Created by Tampa - Monday, May 20, 2013 5:47 PM | Last reply by Alexander Jarmai - 19 hours 6 minutes ago -
0 Votes
On Parent Filter Records of underlying Caclulated Members
Header > Detail. Example Below is data on Header Level(2) The calculated Members: vQuantity is header total of detail sum(QtyRec - QtyInv) then Qty3 based off ...Unanswered | 10 Replies | 118 Views | Created by Ismailc1 - Wednesday, September 20, 2017 6:30 AM | Last reply by Ismailc1 - 19 hours 30 minutes ago -
0 Votes
AggregationFunction None - Drillthrough
Hi, in our fact table we created a none aggregatable measure, which should be only accessible via drillthrough. The idea behind was to save time and storage for processing a ...Answered | 2 Replies | 75 Views | Created by yger - Friday, September 15, 2017 1:31 PM | Last reply by yger - 19 hours 56 minutes ago -
0 Votes
Date as Measure to be used in Structure with aggregation max
Hi, I have 3 date calculated members used in a structure where on detail level the true value but on parent level its max date but due to my detail being ...Answered | 3 Replies | 78 Views | Created by Ismailc1 - Wednesday, September 20, 2017 6:54 AM | Last reply by Ismailc1 - 22 hours 21 minutes ago -
1 Votes
how to combine previous year total in current year calculation mdx
hi , below is my example 2017 ...Proposed | 1 Replies | 57 Views | Created by elango.mg - Thursday, September 21, 2017 9:30 PM | Last reply by willson yuan - Friday, September 22, 2017 4:54 AM -
0 Votes
MDX NON EMPTY error "Either you do not have permission to access the specified member"
Hoping someone else has encountered this... SSAS 2016 Tabular (build 13.0.4451.0). Connected as an admin user (me), running MDX in SSMS. The above error occurs using a simple ...Unanswered | 1 Replies | 42 Views | Created by dufflecoat_philosopher - Thursday, September 21, 2017 5:08 PM | Last reply by willson yuan - Friday, September 22, 2017 3:19 AM -
1 Votes
Copy SSAS 2000 Cube
We have an old SSAS 2000 CUBE that is still used by the business. We are in the process of upgrading but we also need to make a redundant back up of the 2000 cube on another server. The other server ...Proposed | 2 Replies | 59 Views | Created by Vintrix - Wednesday, September 20, 2017 2:53 PM | Last reply by willson yuan - Friday, September 22, 2017 2:26 AM -
2 Votes
SSAS: A Dimention's value is showing many times(it's not a duplicate issue ) in Excel
Hi All, I am runing into an issue which is strucking me for few hours, there are two columns (MCGroup and MarketingCode) from dimention table, I want to make them show up as ...Answered | 4 Replies | 88 Views | Created by Johnny.Wang.MS - Wednesday, September 20, 2017 12:38 PM | Last reply by willson yuan - Friday, September 22, 2017 2:05 AM -
0 Votes
Disadvantages and Advantages of Multiple SSAS insances on one Server?
Hi, Can someone share disadvantages and advantages of Multiple SSAS insances on one Server? Best ...Proposed | 2 Replies | 60 Views | Created by taghalib - Wednesday, September 20, 2017 11:45 AM | Last reply by willson yuan - Friday, September 22, 2017 2:03 AM -
0 Votes
SSAS 2014 Calculated Measure is showing NULL Value
0 THEN [Measures].[Employee Count Within One Year] / [Measures].[Total Employee Count] ELSE NULL ...Proposed | 4 Replies | 75 Views | Created by S Kumar Dubey - Wednesday, September 20, 2017 6:31 AM | Last reply by willson yuan - Friday, September 22, 2017 1:19 AM -
0 Votes
CUBE Browser not showing any data
Hi, I have data in the underlying tables. Processed the dimensions and the cube. The cube browser is not showing any data. If i take the SQL from the DSV and run it using SSMS i can ...Answered | 2 Replies | 44 Views | Created by bk6741 - Wednesday, September 20, 2017 1:05 PM | Last reply by willson yuan - Friday, September 22, 2017 1:16 AM -
0 Votes
SSAS Relative Time question
Hi all, New to SSAS, so hope you don't mind the eas(ish) question. I've created a calculated member "Previous Month" with the following ...Unanswered | 5 Replies | 112 Views | Created by Bertrand011 - Tuesday, September 19, 2017 2:28 AM | Last reply by Bertrand011 - Thursday, September 21, 2017 11:53 PM -
0 Votes
summarization measures on each row in a dax query
Hi we run 2012, soon to be 2016 enterprise. My new tabular model has a measure called AgreementRate and a number of evaluation related dims like evaluator , person being evaluated, ...Unanswered | 19 Replies | 429 Views | Created by db042190 - Monday, August 21, 2017 4:53 PM | Last reply by db042190 - Thursday, September 21, 2017 7:39 PM - Items 1 to 20 of 40171 Next ›
