If your measure column in criteria is from f1 then back end query will have f1. If it is from f2 then the back end query will have f2.
If there are no measures in you report, and you want the back end query to have f2 table, then you need to set implicit fact column from f2.
Double click on subject area in presentation layer, and select implicit fact column as any measure column from f2 fact table.
Let me know if it solves your problem.
The measure column which is used is comming from both the fact table f1 and f2. But when i take this measure and run in the backend I get the fact table f1.
And the implicit fact column is defined on the fact table f2.
So I am not sure why in the backend it is f1 when I take only one measure in criteria and implicit fact column is defined on f2.
I have a measure 'po amount' which is comming from two fact tables cost_f and line_f from physical layer. I have a implict fact column in presentation layer on a column(internal-row count) from cost_f table.
Now, when I take only 'po amount ' in criteria, in the backend query it should have cost_f table, but i am seeing line_f table.
The reason I am checking in this direction is.
I have criteria with 4 columns and measure column 'po amount' and run the result it is fecting from line_f table.
The same 4 columns and measure column 'po amount' and one new column 'cost center' is added to the critera the fact table changes to cost_f table.
In both the cases the result should result from cost_f table, not sure why line_f is comming in backend query.
Since you have a measure in your your report implicit fact column is ignored.
Your measure is mapped to 2 facts and obiee is selecting one of the fact sources . (not sure based on what criteria).
If you want your report to get data from F1 pull your implicit fact column (internal-row count) in the report and hide it .
Hope this helps.
Edited by: Maqsood Hussain on Nov 16, 2012 6:08 AM
1.If you want your report to get data from F1 pull your implicit fact column (internal-row count) in the report and hide it .
This was spot on, including the implicit fact column worked for my report. Thanks.
2.Your measure is mapped to 2 facts and obiee is selecting one of the fact sources . (not sure based on what criteria).
Generally what would be the criteria's for this kind of results.So that I would be doing analysis on it.