on 01-27-2017 3:38 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.