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

Classification in Active Report

Started by mbianka, 12 Nov 2018 06:31:36 AM

Previous topic - Next topic

mbianka

Hello.

I would like to build up the classification structure in Active Report (Report Studio, Cognos 10.2). This structure available on more module (Work Order, Asset, etc.) . 
I have data in database like this ( in CLASSANCESTOR table):

CLASSANCESTORID   ANCESTORCLASSID   HIERARCHYLEVELS   CLASSSTRUCTUREID   ANCESTOR
          1234                         MAIN                         3                           3333               1254
          1233                      TEST1.1                        2                           3333               2524
          1232                         TEST2.1                     1                           3333               3232
          1231                         TEST3.1                     0                           3333               3333
            ....                           ......                       .....                        .....                   .....

I need a structure like this:

MAIN
    TEST1.1
          TEST2.1
                 TEST3.1
    TEST1.2
    TEST1.3
          TEST2.2
          TEST2.3
                  TEST3.2


I don't know how can I show this structure. I tried Network diagram in Visualization, but I can't connect the data.

Any ideas how can I show and use this Classification?

Thank you