Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Drill From Summary is returning rows from Data Workbench that were loaded to a different cube

edited Mar 17, 2021 2:30PM in Planning 3 comments

Summary

Drill From Summary is returning rows from Data Workbench that were loaded to a different cube

Content

When using drill from summary in IGNORE mode, if you drill on a dimension member with > 1000 descendants, it is ignored in the drill (which is fine) but the drill-through returns all matching rows for different cubes as well.

e.g. we have data loaded against an account 511000 in the Group model, and lower level data against the same account and the Project in our Margin model.

When we drill on the Total Project number, the drill-through only matches on the account, and returns the rows from both Group and Margin loads. This is obviously wrong.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!