Excel parent level hierarchy is showing different values when filters are used for cube browisng

Topics: Developer Forum
May 8, 2015 at 4:26 PM
Edited May 8, 2015 at 4:26 PM
I have very weird issue. When i am browsing my cube with filters and user define hierarchy using excel , its not giving me the correct totals on parent level of hierarchy .

Measure : Amount
Filters : Time , Department
Hierarchy : Location-Department-Program

Location = 1,2,
Department = A,B,

If no filer is applied result is like this

Location Amount
1 100
2 200

But if filter Department =A is applied then it should display results based on department on parent level too.
But on the location level its displaying total for all departments and if i bring another measure value then it
refresh automatically and display correct total.

Its only happening if the filter dimension i am using in also in the user hierarchy and if user hierarchy is not having
having filter dimension then everything is working properly

I don't know if I have to make any changes in particular property level for dimension or it is problem with Excel connection. Well, we are using Proclarity and with its everything working perfectly.

Any help would be appreciate.

May 8, 2015 at 10:16 PM
So are you using ASStoredProcedures for any of these measures?

If this is just a general SSAS issue you should ask this question on the MSDN forums http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlanalysisservices