hide dimension a pivot table

[chrisg]

Hello,

For articles, we have the following hierarchical data structure:

main group, category, article

Some customers do not use the Diminsion 'category'. Therefore, this is always the same value in the Diminsion category.

How is it possible to hide this dimension for customers who do not use them in a pivot table?

My goal is to deliver an application as a standard and not fit every application for the customer.

Many thx

Christoph

[#2]

Hi Chris,

If you are using QV11then you can resolve this by checking the enable condition box in 'Settings for Selected dimension' dimension Tab of Pivot Table>>Properties. If you are going to reduce your application for different groups or if you are going to put access restriction for groups, then in the expression you can mention the group name and based on that you can choose to show or now show that dimension to the particular user or group.

PFA qvw file for reference.

Thanks,

Amey.