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
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