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

OBIEE Subject area Issue

Received Response
1
Views
3
Comments
User_CSM8K
User_CSM8K Rank 1 - Community Starter
edited Aug 13, 2024 5:55PM in Oracle Analytics Cloud and Server

Hi All,

Let say that i have two subject area call it as A and B ,i am trying to build a report using those subject area.

When i select A subject area then later add B and generate a report then report is fetching correct results.

when i select Subject area B then A the report is not fetching the results.

Answers

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

    Dear OP

    You may want to explain your issue a bit better since based on your information provided, all we can do is "assume things".

    Are you talking about two subject areas based on the same model? Does "when I select" mean "when I use measures from A" or "when I use attributes from B" or vice versa? Or Both?

  • User_CSM8K
    User_CSM8K Rank 1 - Community Starter

    i have two Subject area  from Same Business Model

    Call it as Purchase and other is workforce .

    When i am trying to create a new report

    Case 1: New --> Analysis --> Workforce

    Later i add Subject area Purchase

    and try to create a report using the attributes from both the subject area report is fetching the correct results.

    Case 2 : New -->Analysis-->Purchase

    Later i add Workforce and try to create a report using the attributes report fetches incorrect results.

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

    "attributes" and "correct  / incorect results" ... oh well I guess that is about as precise as one can expect an answer these days...

    Basically your dimensionality isn't correctly configured in your RPD. Conformed and non-conformed dimensions not tied to the correct facts or not at the correct level so basically all your cross-star queries are wrong.