Topic
  • 3 replies
  • Latest Post - ‏2012-10-04T00:03:49Z by SystemAdmin
GOICEHOCKEY
GOICEHOCKEY
135 Posts

Pinned topic Creating Groups from Members

‏2012-10-02T16:07:51Z |
Is there anyway in Report Author using Dimensional Hierarchy to use certain members and group them into different
groups? Like take all members shown as BLACK, RED, BLUE and associate them to a Group DARK and YELLOW, WHITE to LITE.

I need to have a Section created for the colors that the Crosstab would show the Group First and under the group, it will show the actual colors as node members.

DARK LITE
BLACK RED BLUE YELLOW WHITE
1 1 4 2 3

Or, do I need to establish it at cube level first?

Thx in advance for your time.
Updated on 2012-10-04T00:03:49Z at 2012-10-04T00:03:49Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Creating Groups from Members

    ‏2012-10-03T03:35:04Z  
    I would suggest that this would be better done in the cube design.

    The alternative is to create a calculated member which aggregates the set of members (using an aggregate function in the report) to create the higher-level summary values. However, this does not give you the ability to drill down on the summary members.
  • GOICEHOCKEY
    GOICEHOCKEY
    135 Posts

    Re: Creating Groups from Members

    ‏2012-10-03T17:22:59Z  
    I would suggest that this would be better done in the cube design.

    The alternative is to create a calculated member which aggregates the set of members (using an aggregate function in the report) to create the higher-level summary values. However, this does not give you the ability to drill down on the summary members.
    If you can refer me to a document, I'll greatly appreciate it.
    Any types of Step by Step or a more detail explanations will be great!
    Thx so much Phil.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: Creating Groups from Members

    ‏2012-10-04T00:03:49Z  
    If you can refer me to a document, I'll greatly appreciate it.
    Any types of Step by Step or a more detail explanations will be great!
    Thx so much Phil.
    I'm not really sure what sort of document you would need for this. Adding a new level to your cube should be possible using the same steps you have followed to create your original cube. If you are looking for information on the aggregate function then the tooltip in Report Studio should give you some information although I suppose you could also look at the dimensional functions document from the Proven Practices site.

    http://www.ibm.com/developerworks/data/library/cognos/page82.html

    However, I still stand by the recommendation to create the new level in your cube instead of using the aggregate function.