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

[ShereenLavi]

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.

[Henning]

Hi, if I read your post correctly, you meant to post this here as an official request for an enhancement, correct?

This post is actually in the Reporting forum, where people can discuss topics and do Q&A. Suggestions to add new features in OneStream can be posted in "IdeaStream" 🙂

If I understand correctly, someone already posted the same request / suggestion here:

Allow .Base drill to work in Cube Views and Quick Views in apps with extensibility without .Options ...

If that is what you are asking for, please like this post to generate more attention.

[ShereenLavi]

THanks