Need to limit rows in Dimension table through section access but running into circular loops

abe786 — Wed, 06 Jun 2018 15:19:48 GMT

Hi,

We are trying to implement section access in our existing apps to open up the dashboard to our customers.

See attached qvw for sample data model we are having. The username/password is a/123.

As seen in the data model, we have bridge table which contains two keys CA_ID and CO_ID. In the example, we are trying to limit the countries through section access. Reduction field is CO_ID, which connects to country table and CA_ID which connects Fact table.

The solution works well and rows in Dim1 are also reduced to three rows for country login a (USA ) to values 1,9,10 .

Now comes the twist, we only discovered later on that there is another relationship between country and dim1 i.e. commented out table dim1_bridge. For USA there are only be 2 possible values for Dim1 i.e. Phone & Laptop (DK1, 1 & 9).

If i include the commented table (dim1_bridge), then I run into circular loop.

Can anybody suggest a data modelling solution for above problem, I need to reduce the Dim 1 table, according to dim1_bridge table such that user a does not see headphone in dim1 listbox, even though fact table may still contains the row linking CA_ID 1 to DK1 10 after reduction.

topic Need to limit rows in Dimension table through section access but running into circular loops in QlikView

Need to limit rows in Dimension table through section access but running into circular loops