Forum Stats

  • 3,837,065 Users
  • 2,262,222 Discussions
  • 7,900,196 Comments

Discussions

Issue with multiple kta at rpd

I have table 5 tables

A(dimesion1)

B(dimesion2)

C( fact1)

D (fact2)

E( fact3)


Where A and B have relationship with all 3 fact tables.at bmm layer I have multiple tables sources with this 3 fact tables

Now I am trying to create report where my report should use two dimensions and C( fact1) but report is using D (fact2)

How can i make that it should use C( fact1) in the report

I tried using priority group as give C( fact1) as 1, But did not helped .

Can anyone please suggest

Answers

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,635 Blue Diamond

    Well, if you have a single logical table merging your 3 fact tables, you should either decide if the 3 facts provide data for the same measure or if they all provide different measures.

    All in all you don't give enough info to know exactly how your model is built, what is the expected behavior etc.

    Keeping it simple: if it does query the wrong, your model is wrong.

  • User_ELAU0
    User_ELAU0 Member Posts: 8 Blue Ribbon

    It is not single lts, as mentioned it has 3 lts

  • Gianni Ceresa
    Gianni Ceresa Managing Director | Oracle ACE Director Member Posts: 6,635 Blue Diamond

    You said you have 3 logical table sources, not 3 logical tables.

    If you have 3 logical table, each having different LTS pointing to the different physical tables, it's impossible that selecting a logical column from C you get a column of D instead.