Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g: Measure not aggregate to root level hierarchy

Question
1
Views
0
Comments
856390
856390 Rank 1 - Community Starter
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

Hi,

I have a fact table and a hierarchy and I want that in a report, some measures show value at root level of the hierarchy, but others show null value at that level (or at a level higher than one I set, maybe only leaves), but when I drill down over them,I could see the agregate data in that intermediate levels.

It's possible? Any tip about how to achieve it?¿

Thanks.