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
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?
Thanks, I tried that.
My error is "The set 'unionSet' cannot have members from different hierarchies."
Eric
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.
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.