Filter condition should apply for each context created at universe!!

[Former Member]

HI

Scenario:

--> I have 6 fact tables,  so created six contexts.

--> All fact tables are having one dimension called -"Ref_Source"

--> We should apply filter on - "Ref_Source" field

Problem:

If I pull data from more than one fact/context [Each fact is having one context] table, the filter should apply for all the context/sql's generated.

But it's not happening in my queries.  HOw to achieve this.

Note: if i use one fact table at a time it's working fine but if i try to use multiple facts it's not working.

[Former Member]

Filter condition defined in universe:

Ref_Source = @aggregate_aware(fact1.ref_sourece,fact2.ref_sourece,fact3.ref_sourece,fact4.ref_sourece,fact5.ref_sourece,fact6.ref_sourece).

-----------

Note:

Suppose if we try to query from context1 and Context2, sql engine will generate 2 sql's one for each context

Expected:

the query generated should be-

select * from context1 where fact1.ref_source='abc'

select * form context2 where fact2.ref_source='abc'

[Former Member]

Hi Guys,

Issue resolved

Solution: Instead of using the filter objects from each fact - we have created a separate DIM table for those DIMs. It solved the problem.

Now the DIM table is a confirmed DIM for all facts

Thanks..

[Former Member]

Create a filter object and use it to apply across universe or to specific class where it resides.