BPS Planning Layout - Data Column issues

[former_member353620]

My basic question is: is it possible to configure a characteristic in the data column such that it contains a range of values, instead of just a single value. We have requirements to produce a series of comparison columns for things such as "Year-to-Date" (sum of a range of fiscal periods), "Prior 12 Months" (again, sum of a range of periods), and so forth. Unfortunately, the BPS layout configuration of data columns only allows you to specify a single characteristic value. If you configure it with a variable that contains the range, the system only uses the LOW value of the range, not the full range. The ability to provide such comparison columns is critical to our users' ability to see prior information and make a determination of new plan values for the plan year.

Any thoughts or suggestions on how I should approach this, or alternative approaches to take?

[Former Member]

Hi,

I am having this same issue in my project...exactly this same requirement. I see that this message dates back to 2005. Is there any solution for this now?

Regards,

Michael

[Former Member]

Hi Michael,

It doesn't seem to be possible that you can have multiple values in a data column. What you can do is to create multiple data coumns and one column for total. Then you can hide all the columns except for the total column.

See if this helps.

Regards,

SK

• pls assign points if it helps

[Former Member]

Hi Shashikant,

Thanks for your response. It sounds good but is there way to hide data columns? Please advice.

Regards,

Michael

[Former Member]

Hi,

If it an excel layout you can hide them in the third screen of the layout builder.

Regards,

SK

• pls assign points if it helps

[Former Member]

Hi Shashikant Khemani,

I dont think it is possible. If you are very sure, can you explain me how.

Thanks for your help.

Regards,

Michel

[Former Member]

If you use BI-IP, this is easily doable; because input-queries give you all facilities of queries also - so you can display aggregated figures easily.

[Former Member]

Hi,

It seems you can hide the columns simply the way you can do in normal excel

sheet.

Regards

[Former Member]

John,

This has been an issue with BPS since you can only display data columns of the granularity you specify rather than a range such as YTD similar to what you can do in BW restricted key figures.

The work around is to create and store the numbers in

1) YTD key figure in say fiscal year current year fiscal period current period and/or

2) Prior 12 months Key figure and store the number against fiscal year current year fiscal period # or first period period of the year...

Hope this helps and assign points if you found it useful.

Mary

[former_member353620]

Thanks for responding, Mary. That confirms what I thought I had to do. The same for the calculations as well that I have to do, like variances and annualizations.

- John