OBIEE RPD: Snowflaked table not showing up as a fact table in the BMM layer

Question

I am using the RPD tool to create a data model for a database which has 6 tables.

Dimensions : ProductFamily, ProductionLine,Company,CurrencyExchange

Facts: WorkOrderStats, WorkOrder

But, WorkOrder is not getting taken as a fact table in the BMM layer. How do I make the WorkOrder as a fact table in the BMM layer?

Any input is sincerely appreciated.

Thank you

Answer 1

That's not how facts work in OA. Facts never join to facts. Ping me on slack. I created that exact RPD last Friday.

Answer 2

If you want to join your fact table to an other fact table you have to create an other alias for your fact, the new alias will act as a dimension. in your case create an alias for F_workorder name it Dim_workorder for exemple and join your F_workorderStat to this dimension and keep F_workorder and it's relations just remove the relation between F_workorderStat and F_workorder it's not going to work that way.