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.
Hi All,
nobody can answer ?
Thanks
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
Quote from: wyconian on 24 Feb 2012 09:22:41 AM
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