I am new to OBIEE 12c and building RPDs in the Administration Tools. I built a star-schema, and many of my dimension tables contain foreign keys from other dimension tables. For example, I have an OrderList table and inside this table, I have a PortCarrier_ID, which refers to the PortCarrier table. I can then get the Carrier and Service Level associated with this Order ID. I can also get the Origin Port and Destination Port from the Port Carrier Table. The PortCarrier table has a Dest_Port_Location_ID and Orig_Port_Location_ID. These two IDs refer to other attribute tables, Orig_Port_Locations and Dest_Port_Locations, respectively. I think you get the idea. I have all of my data and SQL and pictures in a GitHub Repo, if you wish to refer to that:
GitHub - jaredbach/LogisticsDataset: Supply Chain Logistics Problem Dataset (0 Bytes)Here is a picture of my schema (it is also in the GitHub repository but putting it here for ease)
This is what it looks like in the Oracle BI Administration Tool (RPD builder).
When I run the consistency check, everything is all good, but I am trying to build hierarchies, so that I can correctly drill down on all of my data. Everything kinda feeds back to the FreightRates, OrderList, and PlantConstraints, so I want to drill down on all of these. These are what the hierarchies look like.
When I try to do the level based hierarchies, however, I receive the following error when I drag the BMM layer to the Presentation layer.
Does anyone know how I can fix this, so I can correctly drill down on everything? When I tried to just create a single hierarchy with the OrderList table, I got this error.
When I made a single hierarchy with just FreightRates, I got this error.
When I made just a single hieracy for FrieghtRates, there was no error. I think I need to combine all of the hierarchies somehow but am not sure how to do that. Any input would be helpful. Thanks so much, in advance.