I have a cube with one of the dimension as Category(IN, OUT), the measures are sum, avg and distinct products of that category.
The question is: How I can fix / make default and lock the category dimension whenever the cube is browsed by any tool.
The problem is that:
If user exclude the category dimension in the browser window the summation will be of both the categories (IN & OUT), but I always want the output to be divided as category. In other words how can I lock the category dimension as the default
selection and always display the mesures in category as below:
IN Summation Value, Avg Value, Distinct Value
Out Summation Value, Avg Value, Distinct Value
View Complete Post