Issue with multiple kta at rpd

Question

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

Gianni Ceresa · Answer

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.

User_ELAU0 · Answer

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

Gianni Ceresa · Answer

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.