How to implement the below SQL in RPD - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

How to implement the below SQL in RPD

Received Response
71
Views
20
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    And how does HRS figure into this phyiscally?

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Christian,

    HRS is the OBIEE view created in physical layer and it has joins with W_PLAN_TIME & W_PA_HRS. So is the reason in BMM layer I added in LTS.

    Thanks !

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    OK that looks fine bbut you havent answered my question about the content levels. Are they set for all fact sources?

  • 3174977
    3174977 Rank 5 - Community Champion

    Yes, I have set the content for all LTS in fact. I am having another issue now..

    without adding columns from HRS view  the report looks as below which is correct.

    when I add the column from HRS view it is duplicating the rows..Why is this happening.Sorry Christian if I am aksing silly questions..Please don't mind.

    Why this happening..

    Thank you so much !

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    This means that the query grain changes. Make sure your keys are in order and that all your measures have proper aggregation rules. Also make sure that the view (which is just code) acutally retrieves the correct results for a query like that.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    By the way it's not about "asking silly questions" as you put it. A proper training would simply be much more efficient than just clicking around, discovering things one after the other and missing half of the important facts.

  • 3174977
    3174977 Rank 5 - Community Champion

    Hi Christian,

    Yes, the SQL in the view is retrieving the right results only.but when it comes to OBIEE the grain of the data is changing and also it is taking lot of time to retrieve the results..the performance is very bad..

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    That's why I initially balked at the usage of a view. Things should be modeled correctly and in a performing fashion in the database. Views hide complexity and modeling options behind code which is never a good thing.

  • 3174977
    3174977 Rank 5 - Community Champion

    Agreed Christian. What are the options that we have now so that I can suggest our team in proceeding further on this.

    Appreciate all your help Christian:)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    As I said: actually model it physically into a proper table structure which follows your DB guidelines and employs all appropriate performance techniques as fit your case (indices, partitioning,...)