Forum Discussion

ShereenLavi's avatar
ShereenLavi
New Contributor III
10 months ago

Reporting Base in Extensible cubes does not provide correct results, given workaround

Within our design we are using 3 layers of extensible cubes with extensibility across Entity, Account and UD dimensions. We are finding inconsistent results when the user is in the parent cube and are attempting to ‘drill’ to lower detail in an Ad Hoc Grid. In the attached video you will see a user using the .Base member expansion and doing a right-click drill and receiving differing results. In talking with OneStream, this appears as expected functionality because of extensibility. We were provided a workaround (adding .Option expansion) which is not user friendly given the availability of a .Base button in the member expansion. Logging this enhancement request because this is not a user-friendly functionality and the inconsistent results could cause users to not trust the results they are seeing in an ad-hoc grid.

We understand we can put it into a parameter per case CSRC009442

.Base.Options(Cube = Global, ScenarioType = Actual, MergeMembersFromReferencedCubes = False) 

which can be referenced on the Member Expression Builder, but again, not user friendly experience.