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.
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
1 person found this helpful
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