Skip to Content
0

Filter on Universe

Jan 27, 2017 at 03:38 PM

17

avatar image

Hello Guys

I have a requirement here, hope someone can help me

We have two universes (built on same database and tables), one per country

The tables used in the universe have data for both the countries, Country A and Country B

Universe 1 is for Country A

Universe 2 is for Country B

Now we have to limit the data at the Universe level, Country A users when they pull Universe 1 and run adhoc reports, they should be only seeing Country A data default

And Country B users when they pull Universe 2, they should only see Country B data

We have a main dimension table (D1), and we have a column Country_Name, values as 'A' and 'B'. We we have other dimension tables too but no country info

We have around 8 fact tables and all are joined to D1

Can someone help me here

Thanks

Simon

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jan 27, 2017 at 05:33 PM
0

Create predefined filter at universe level and you need to select option "apply on universe" in the filter.after that whenever user create report in the universe then bydefault filter will apply.

Let say for univere 1 create filter where country='A' and select the checkbox apply on universe and export.

After that when ever user will create/run report on universe A then automatically filter will apply.

Same you can see in webi report sql.

Share
10 |10000 characters needed characters left characters exceeded