Relative proportional spread issue.

Post Reply
deepu_sree
Posts: 29
Joined: Tue Jun 22, 2010 4:01 pm
OLAP Product: IBM TM1
Version: 9.5
Excel Version: 2007

Relative proportional spread issue.

Post by deepu_sree »

Hi All,
I've an issue with Relative proportional spread - here are my dimensions

Period: DIM_PERIOD
-FY2010/11
Relative Proportional Spread issue.doc
(49.5 KiB) Downloaded 278 times
-- FY2010-P01
-- FY2010-P02
............
-- FY2010-P12

Expense lines: DIM_EXP
--Total Exp
--- E1
--- E2
--- E3
--------E31
--------E32
--------E33
--------E34
--- E4

Scenario dimension: DIM_SCENARIO
Scenarios
----Actual
----Full yr Budget
----Revised Budget

Location dimension: DIM_LOCATION

Geos
-- US
----- Region1
----------Sub-Region1
--------------Country
-------------------State
-----------------------City
-------------------------Store
-- APAC
-- EUROPE

My issue is:
a) I want to budget data for FY2010 budget scenario using the Actuals for FY2009 Actual scenario.
b) But when I try to use Relative proportional spread, my time dimension is grayed out and I'm not able to change any of the values.

I've attached the screenshots. Can you guys let me know how I can do the above functionality with my existing dimensions?
Post Reply