If you are unable to create a new account, please email support@bspsoftware.com

 

[Report Studio] filter each row of a cross table individually

Started by binf, 10 Sep 2020 03:05:47 AM

Previous topic - Next topic

binf

Cognos Version: 11.1.7

Hello, I've recently started working with Report Studio and have the following problem:
The degrees of students per year are to be displayed in a cross table. Different filter should be used in each line. With relational data the whole thing is no problem, but now I want to create the whole thing with dimensional data.
I have 3 dimensions and a key value for this. The key value are the unique students. The first dimension is the years as a column. The second dimension is the qualifications and the third dimension is the condition "further education". This dimension consists of "is further training" and "is not further training".

In the first line, all graduations should be displayed as a total. To do this, I add the hierarchy "All" of the qualification dimension to the cross table. That works. In the second line, only the values ​​for degrees similar to Masters should be shown. To do this, I add the qualification dimension again and group the corresponding values, all others are hidden. That works too. In the third line, the second line should now be filtered with the third dimension. All master's-like degrees that are not advanced training should be shown as a total. I have my problems here. I have already carried out various attempts but it always leads to errors or nothing is displayed.
One attempt was e.g. creating a new object with the following function:
filter ([qualification dimension]; [further training dimension] = [no further training])

What do I have to do, to get the third line displayed?

Thanks for Help,
Chris