Inverse Formula - Disaggregation

[VijayetaSharma]

Hi Experts ,

I have a input ready % share formula in my query again calquarter and Calmonth .

% share = Share Value *100

inverse formula = % Share /100

Let say if I enter 25 in %share then .25 get stored against Share value in cube for Calquarter "3/2015" but that 25 gets divided among respective months (07/2015,08/2015,09/2015) of quarter as 10 , 10, 5

What my requirement is that if I enter % share as 25 for a Quarter then the same value 25 should get stored for respective months as 25, 25,25

I have set Dis-aggregation and analog distribution again self reference .

Request your help!!!

Thanks

Vijayeta

[sheldon_piao]

Hi Vijayeta,

If 25, 25, 25 for 07/2015,08/2015,09/2015, this Calquarter value will be 75, which is not consistent to your input value 25. So I am curious what kind of records you would like to get for the relevant infoprovider.
Can you explain it more ?

Best Regards,
Sheldon.

[VijayetaSharma]

Hi Sheldon,

The Calqurter should also have 25 . It is percentage input ready formula , which suppose to have same value against Calmonth, Calquarter, Year,company code, profit center, controlling area, Version, vtype , actual period .

%Share = Share Value *100 (Input Ready Formula)

Share Value = %Share/100 (Inverse formula) - which will store in infoprovider

The way data should be in Cube is shown below:

Calquarter	CalMonth	Year	Actual Period	company code	vtype	profit center	Controlling area	Version	Share Value
Q3 2015	Jul-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q3 2015	Aug-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q3 2015	Sep-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q4 2015	Oct-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q4 2015	Nov-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q4 2015	Dec-15	2015	Q3 2015	M01	20	BA	L60	R2	0.25
Q1 2015	Jan-16	2016	Q3 2015	M01	20	BA	L60	R2	0.25
Q1 2015	Feb-16	2016	Q3 2015	M01	20	BA	L60	R2	0.25
Q1 2015	Mar-16	2016	Q3 2015	M01	20	BA	L60	R2	0.25

Also ,even in planning workbook if I just want to see Share value again CalQuarter , it should display .25 and not .75

Please you help.

Vijayeta

[gregor_dieckmann]

Hi Vijayeta,

I think your question was already answered in thread

in my last memo. What is unclear in this memo?

Regards,

Gregor

[VijayetaSharma]

Thanks Gregor,

I went through that link already and I cannot use DSO , I have cube and it is existing model .

I need some options for Cube

[cornelia_lezoch]

then you need to use a copy function instead of the disaggregation

[Former Member]

Hi Vija,

you may try following approach:

Keyfigure One is your share Value

Keyfigure Two is a Counter of detailed Records

Visible / Plan Keyfigure is a calculated Keyfigure  dividing Keyfigure One by Keyfigure Two .

Inverse Formula is Keyfigure One = Plan Keyfigure * Keyfigure Two

Disaggregation Option for Keyfigure One would be Full Value according to Keyfigure Two.

Hope this helps.

Regards Nils

[gregor_dieckmann]

Hi,

just for completeness, to understand why Nils suggrestion works you may read thread:

http://scn.sap.com/thread/3770702

There you can find all the details.

Regards,

Gregor