Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

Categories

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

whenever we add new column to the report it is not displaying the values of that column

Received Response
113
Views
11
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    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.