Grand total issue when selecting current period.
After processing multidimensional cube the data exported to the 'Excel pivot'. In that pivot when selecting the [time calculation][Current period] the unique month is showing the total 10 years count. But I'm filtering only current year 8 months.
Below is the calculation
Scope([Time Calculation].[Current Period],[String].[String Hierarchy].allmembers, [Key Figure].[Key Figure Long Name].allmembers);
THIS = (Measures.currentMember,[Time Accounting Period].[Accounting Month Hierarchy].currentMember);
2011 2012 2013 2014 2015 Grand total
10 20 10 30 40 110
My Issue when filtering
2011 2014 2015 Grand total
10 30 40 110
But the Grand total is '80'
We would need further details to understand the issue better. Can you please share which Azure products/services are you using, your scenario and issue in detail as well as end goal. Thanks.
Sign in to comment
I'm using Microsoft visual studio Community 2017 for Cube development(Version 15.9.34).
My issue is Cube data in excel is showing wrong 'Grand total' when selecting Unique month column from pivot.
Actually the grand total value is displaying whole sheet sum. Instead of showing selected sum.