Skip to Content
author's profile photo Former Member
Former Member

Splitting of Columns in report

Hi Guys,

Can some please help me with the following requirement. I have a report built on a multiprovider which brings 3 key figures from 3 different cubes. I have a user entry variable (CALMONTH1) which is used to restrict 2 of the key figures and a customer exit variable (CALMONTH2) which looks upong the value of CALMONTH1 value entered by the user and uses the same value to restrict the third key figure.

CALMONTH1 can be entered as multiple months or range (say July to Sept). In the above mentioned scenario, the report is summing up the results for multiple months and showing the aggregated value (as expected). But the user wants to know if there is a way to split the results into multiple columns based on month. To be clear...if the user enters CALMONTH1 as July - Aug, then the layout of the report should be

July

KF1 KF2 KF3

SUM1 SUM2 SUM3

AUG (as the next column to KF3 of July)

KF1 KF2 KF3

SUM1 SUM2 SUM3

so that he can compare the values for different months. Please let me know if this functionality can be achieved without any additional inputs from the user. Any reply is highly appreciated and duely rewarded.

Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    Posted on Aug 02, 2006 at 02:16 AM

    Hi,

    You can try the following:

    Place 0CALMONTH into free chars area (aggregated accross months values) and applying drill down by it (indvidual months results).

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 02, 2006 at 05:20 AM

    Joseph,

    Try having the calmonth restricted by mulltiple single values , only change will be that the user will have to select every month h/she wants and you will get the report the way you want to...

    Arun

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks a lot for all your suggestions guys. I created a new navigational attribute and it served my purpose. But your suggestions were very helpful. Have assigned you all points.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2006 at 01:18 AM
    Add comment
    10|10000 characters needed characters exceeded