Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Unable to automatically create level based hierarchy?

Bit of a silly question, but I inherited an RPD and noticed something funny.
I am tryint to "automatically" create hierarchies, and noticed I am not able to on some tables, while others I can.
For example
For this table when I right click I have the option to create a hierarchy
Whereas when I click on another table I dont have the option
Just curious what could be causing this?
I have a feeling something was not set up right and want to fix this
Answers
-
Is the logical table where you can't create an hierarchy an actual dimension?
Is it linked to a fact table?
0 -
Argh I think I figured it out
This RPD is quite a mess
It looks like the tables where I am not able to create a logical hierarchy is because they actually ALREADY have a hierarchy....
It looks like the genius that was working on this renamed the tables and hierarchies. Was pretty messy but I was able to track down the table and its corresponding hierarchy.
Some tables had a hierarchy already with a different name, and some other tables had no hierarchy. Which led to me "sometimes" being able to create a logical hierarchy automatically and other times not.
0