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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Customized Grouping to Create a Section

Started by gosoccer, 05 Oct 2012 03:41:06 PM

Previous topic - Next topic

gosoccer

I have a need to display Site Information in the following manner,
SITE TYPE (LARGE, SMALL)
LARGE SITE #s (123, 234) and SMALL Site#s (012, 087)

So the Crosstab will look like

First Row:                LARGE                |           SMALL
Second Row:           123  234             |      012  087
Third Row (Count)    1       9               |        1       11

I tried using the Customize Grouping on the Site #s and created the LARGE and SMALL groups. But everytime I drop the
site# as a data item to the Crosstab, the GROUPING is take over. So I am getting only

First Row:                LARGE                |           SMALL
Third Row (Count)    1       9               |        1       11

without the second row. I CAN'T even create Section from the Data Item so it would break the rows down as following,
Report Listing Breaking based on the Section established,

First Row:                LARGE               
Second Row:           123  234           
Third Row (Count)    1       9     

First Row:                SMALL               
Second Row:           012  087         
Third Row (Count)    1       11     

Any help will greatly appreciate it.
Thx :)





gosoccer

so basically I'm trying to have a separate row under the Crosstab Node Member. please see attached.

First Row (Node Member):                LARGE       |     MEDIUM               
Second Row (Dropped Data Item       9| 8 | 7            |4  |5   |6           
Third Row (Count)                              1| 2 |100           20 |40 |60

Using the set defenition, I established the Customized Grouping for LARGE and MEDUIM. it is doing
what it suppose to do. Then I created a data item and dropped it under this Crosstab Node Row, so the second grouping of sizes will be shown but no luck!! it stays with the first grouping since the dropped data item is based on the same item that has the GROUP customization of LARGE and MEDIUM.

Please HELP!!!

blom0344

You may get  better response by pointing out whether you are reporting on a relational of dimensional package..

gosoccer

This grouping need using Crosstab is related to Dimensional Package where there is Dimension-Hierarchy-Level exists for the members.

Some Success using the below procedue,


  • I created the Groups using Group Customization option for the Top Row of the Crosstab. Works great!
    For the second Row, here is what I did,
    I created a separated Data Item from the same exact member.
    I dragged/dropped this new Data Item to underneath the Crosstab Top Node Member to create the second grouping.
Now, the First Row is showing the           LARGE        |     MEDIUM
and Second Row is showing the Sizes      9| 8 | 7            |4   |5   |6     
and of course the bottom Counts are showing properly.

Please confirm my work if you don't mind and let me know why it is running so slow?

Thx in advance for your time.