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

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
    ACCEPTED ANSWER

    Re: Creating Groups from Members

    ‏2012-10-03T03:35:04Z  in response to GOICEHOCKEY
    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
      ACCEPTED ANSWER

      Re: Creating Groups from Members

      ‏2012-10-03T17:22:59Z  in response to SystemAdmin
      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
        ACCEPTED ANSWER

        Re: Creating Groups from Members

        ‏2012-10-04T00:03:49Z  in response to GOICEHOCKEY
        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.