Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

one logical column multiple physical tables

Received Response
11
Views
3
Comments
Rank 5 - Community Champion

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?

logical.png

Thanks

R

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 10 - Analytics Guru

    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.

  • Rank 5 - Community Champion

    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

  • Rank 10 - Analytics Guru

    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

    pastedImage_1.png

    2.) LTS Priority Groups

    pastedImage_0.png

    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

Welcome!

It looks like you're new here. Sign in or register to get started.