outer join in reports Not to all lookUp

[Rambo2292468]

I am facing following problem

I have one fact table and 8 DIM tables as lookup


Action performed : did setting in VLDB propertities to preserve all Look up table.........

result:It creates left outer join for all lookup but i need to apply left Outer to only 3 Dim table than all 8

Query: I need to use left outer Join only to some specific DIM and not to all.can I achieve in MSTR ?

Early help is really appreciated

gudiya

 

[entaroadun]

Change your VLDB setting back.

There is a Report Data Option that allows you to preserve elements for specific attributes. (In other words, MSTR will outer join to the dim tables with those attributes.)

 

[Rambo2292468]

Thanks Entaroadun
i did following task :
1. I did VLDB setting to preserve all lookup tables based on fact table key
2.change the attribute setting to same lookup tables based on fact table key ,kept all attributes as Default and change the required attribute to Outer .

But it didnt work ...

Thanks

 

[entaroadun]

You want the fourth option. Preserve lookup table elements joined to final pass result table based on template attributes w/filter.