Issue with multiple kta at rpd

User_ELAU0

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

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

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

Gianni Ceresa

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.