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