Calculation with members from different dimensions of DMR package ?

[raztos]

Hi everybody,

I need to create following crosstab report in Report Studio(Cognos 10.1) from DMR package.

1. In columns I have to make total for members from 2 different dimensions (it's against the business logic, but I have to do it)
2. Then must be on row, which is calculation for each column of Total column in percent.

Plase take a closer look to screenshoot for better understanding.

Thanks a lot for any advice.

[raztos]

Hi All,

nobody can answer ?

Thanks

[wyconian]

Hi have you tried a tuple function?  Not sure if this will work on DMR but it works on a properly dimensionalised source (i.e. a cube).

It's a bit complicated but there are details in the report stuio user guide.  Reply if you need any help to use this.

Boa Sorte

[Grim]

Hi have you tried a tuple function?  Not sure if this will work on DMR but it works on a properly dimensionalised source (i.e. a cube).

It's a bit complicated but there are details in the report stuio user guide.  Reply if you need any help to use this.

Boa Sorte

Tuple info:
http://www-01.ibm.com/support/docview.wss?uid=swg21339536