Categories
- All Categories
- 127 Oracle Analytics News
- 23 Oracle Analytics Videos
- 14.5K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
one logical column multiple physical tables

Hi All, can you please help understand how does OBIEE generates code if user drags a single logical column which maps to multiple physical columns.
Example: In the below screen shot activity amount measure mapped to 3 physical LTS.How does Obiee generates code when user drags this column in the analysis?
Which table it uses in code and on what basis?
Thanks
R
Answers
-
The BI server itself looks for the most efficient LTS to fulfill the request being sent from the presentation server. So LTS choice (or choices) will depend on selected fact and attribute columns, dimensionalities around the fact, hierarchy levels etc.
0 -
Chris, thanks for your input.In the above diagram,Logical levels for Fact_W_GL_BALANCE_F & Fact_W_GL_BALANCE_F_HFM are same.How can we force BI server to select FACT_W_GL_BALANCE_F_HFM instead of other fact. thanks R
0 -
Several ways possible and all depends on your detailed requirement in the larger solution. In short (but not an exhaustive list):
1.) Implicit fact columns
2.) LTS Priority Groups
3.) Bespoke models forcing certain join paths
4.) Using "fake" columns for forcing explicit LTS selection:
Create a new column called "source" or sth like that and enter as a source expression 'ChooseMe'. That filter "source=ChooseMe" can then be added as a default business model or subejct area filter in the RPD's Manage->Security or in any analysis or front-end object.
Jeff wrote about some of the options here: https://s3.amazonaws.com/rmc_docs/biforum2011/Mcquigg_Metadata.pdf
0