add manual grouping to a report

[blom0344]

We have multiple BO full client reports that need to be converted to C8 reports. Apart from designing a framework based on a set of BO universes, there is a grouping functionality of which I am not sure it exists in Cognos.

With BO full client I can create a grouping variable and assign multiple values of a dimension to this new grouping member.

example:

dimension: color

values: red,white,black,grey,yellow,blue,purple,brown,green

Suppose I want to group this into a higher hierarchy that designates the nature of the color:

new grouping variable: color-type

group1: basic color
group2: non-basic color
group3: no color

Assigning the list of colors would then yield:

basic color red
basic color yellow
basic color blue
non-basic color purple
non-basic color green
non-basic color brown
no color white
no color black
no color grey

For a fixed list I could either solve this in the framework by a CASE construction or by adding a grouping table.
However, in some cases grouping is performed on free-text fields (which one can no intercept prior to reporting)

Can this be solved in C8 (RS;QS;AS ?)

Ties Blom

 

[mennooo]

Hi Ties,

Query Studio has the option of custom grouping delivering the functionality you need

Success!

Menno

 

[blom0344]

Yes,

We did a little test by defining a custom grouping in query studio and re-opening the report in report studio.
What we see is that the custom grouping has been 'reworked' into a extensive CASE statement.
So, we are hoping that by porting a first attempt from query studio to report studio will do the trick...

Thanks!

Ties Blom