one logical column multiple physical tables

7688438

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

[Deleted User]

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.

7688438

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

[Deleted User]

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