Data restriction on universe

[Former Member]

Good moorning

I have this hierarchy : Bank manager -> Area manager -> Group leader -> Sector -> fact table

Our problem lies in the restrictions at the level of data we want to operate within a universe, I apply a data restriction on Bank manager level.

when we apply a restriction on the highest group of a hierarchy is only used on reports when the table with the restriction is used, if you lower levels never takes the filter lower

how can i solve this issue?

For example

Restriction -> Bank manager = u2018JUAN PEREZu2019

When a user build a report at Area manager level the query looks like the following:

SELECT Area manager , Count (clients)

FROM Area manager, Group leader, sector, fact

Where ...

as you see, it doesnt take the restriction

even thow when the report use Bank manager :

Select Bank manager, Area manager, count(clients)

From Bank manager, Area manager, Group leader, sector, fact

Where u2026.

And Bank manager = u2018JUAN PEREZu2019

[former_member142702 · Accepted solution]

Hi

you have to force your universe to add the Bank manager table in any query. You can do this by adding it also the lower hierarchy levels. In the Universe designer just double-click eg. on the Area manager object, press the Tables button and highlight all the hierarchy related tables.

Regards,

Stratos

[Former Member]

Actually this is the best form to aplicate the security. force in the universe to use the tables of your hierarchy.

[Former Member]

thank you very much it works,

im looking for other solution just to have choices