union or concatenation function in dimensional data

[cognos05]

Hi,

I am using dimensional reporting..

I have a level named regions in my dimension location.

This region level has many members like east,west,north south,Canada,Australia,Asia etc..

I want my report to show the  regions  East,west,north, south and below that
I want other regions like Canada ,Australia and Asia to be shown as one data item comprising all 3 values.
That is give a name other regions and it should have the values of Asia plus Australia plus Canada.

Can I achieve this in dimensional reporting.. Union of Canada,Australia and Asia shows all three elements but I want them to show as only one item named other regions but have all 3 regions value comprised.

thanks,
Nithya

[rockytopmark]

3 dimensional functions used...

- Total(), to create a single instance from a set of members
- Member(), to create an "Others" member from an instance
- Union(), to create a set from 1 set and an "Others" member

Union(
   set([North],[South],[East],[West])
,
   member(
         Total(currentMeasure within set set([Canada],[Australia],...))
   , 'other','Others')
)

[cognos05]

Hi,
Thanks for the reply. That makes sense of using three functions.

I  have this expression on my first row and I have a sales as measure and i have different time periods on columns.

Its showing zero value for entire other row.

Thanks,
Nithya

[cognos05]

Hi I was able to achieve that using the 3 dimensional function that you mentioned.

Thanks a lot.

Thanks,
Nithya