Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Filter Parent-child hierarchical column by dimension attribute

Hello,

I have a simple star schema BI model with a fact table and a parent-child dimension table. In the logical schema i have a hierarchical column based on the parent-child dimension.

If i make an analysis using the hierarchical column, I am not able to filter by any other attribute of the dimensional table. Every time I get a no-data-found exception.

Also, even if I filter for a code or parent-code I get the same result.

Note that in the presentation column the columns I am filtering are from the dimensional table, not the parent-child hierarchical table.

Does anyone have a workaroud for this? Do you know if kind of interaction should be possible or not?

Thanks

This post has been answered by Massimo Dal Monico-Oracle on Apr 2 2024
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Mar 11 2024
2 comments
621 views