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

use members of different hierarchy

Started by NewtonsCannon, 15 Mar 2012 06:56:20 AM

Previous topic - Next topic

NewtonsCannon

Hello, new to Cognos and working on a little mod to a report.

I have members (east, west, central). These are under the [locations].

The goal is to take one location and add it to the east.  The location is in the west.
I have tried all of the set/union variations for ( Children([East Region]) , [25 HILLIARD]).

What I don't want to do is to just list all the east locations and this one from the west.   Forgive me if i am killing the terminology.

Eric

CognosPaul

A set will only accept members from the same hierarchy.

You should be able to do a simple union(children([East Region]),[25 HILLIARD])

What error are you getting?

NewtonsCannon

Thanks, I tried that. 

My error is "The set 'unionSet' cannot have members from different hierarchies."

Eric

CognosPaul

Why are the different locations placed under different hierarchies? Create a single hierarchy with the top level consisting of East, West, Central.

Having them in separate hierarchies would allow you to do something like tuple(Sales,East,2010,West,2010) (or in English, show the intersection of sales, east, 2010, and west) which doesn't make any sense at all.

NewtonsCannon

The locations are under their own member.  The regions are under location.

so
[Locations]
    [Locations]
        [store 12]
        ....
[West]
....

That's how it is.  I do not have permission to change the structure.

Guess I just have to set([the locations that i want])

Thanks.