Forum Discussion

ShereenLavi's avatar
ShereenLavi
New Contributor III
11 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.