Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
whenever we add new column to the report it is not displaying the values of that column
Answers
-
3174977 wrote: employee _name is coming from W_PA_Hrs table only..there is no other table with employee information. and both W_PA_HRS & W_PLAN_TIME tables are fact tables.. there is no join relation between those tables in physical layer..they are 2 seperate tables..In BMM I have created one fact W_TIME_F and added these two tables as seperate LTS.
" there is no join relation between those tables in physical layer" => What? So the one above is the business model? Can you please use proper naming for your objects since it's really unreadable.
So as I said the PLAN_TIME source must be on the Grand Total level for your degen dim employee information since it doesn't contain it for example.
Still you should step away from the RPD for a moment and draw a clean diagram first and then implement (and properly name) everything. Proper physical aliases with speaking names. Proper logical tables with speaking names. Understanding your issue with #1 names without knowing if BM or physical model (that's why you rename for example) in here is hard enough.
0