Values are not rolling up to parent members.

[Former Member]

I have written script which is showing correct results for the base members like month 2008.04,2008.05,2008.06 etc, but, these values are not rolling up to correctly on 2008.Q1, 2008.Q2,2008.Q3, 2008.Q4.

screenshots for the script, report and Time Dimension are attached.

another issue is how can I make this script dynamic for TIME?

[former_member186338]

The script is also incorrect!

Please provide full info inline with

if you really want to get some help.

Vadim

[Former Member]

Ok thanks Vadim, ACCTYPE for 300001 is LEQ, so, it will be YTD. My another issue is how can I make this script dynamic for TIME, so that user can select Time dynamically on the prompt screen

I am using SAP BPC 10.0 NW with JAVASCRIPT

Model - HGS Planning

Dimensions - CATEGORY, ACCOUNT, TIME, ENTITY, AUDITTRAIL, BUILDING, BUSINESS OPERATIONS, CLIENT, PROFIT CENTER GROUP, PROFIT CENTER, VERSION

dimension in red colour are User Defined.

the logic for calculating value of 300001is as follows:

the value of current month of 300001 = Value of 300001 in the previous month

i.e,the value of 300001 in April will be same the value present in March in the same account. So, If I enter '2' in March, the after running DM Package , '2' should populate under April.

[former_member186338]

"user can select Time dynamically on the prompt screen" - what do you mean by select TIME?

Single month or multiple months?

What month the user will select: source or target?

Please explain in details - I am unable to help you without detailed info!

And what about BPC version and SP???

Vadim

[Former Member]

Vadim, I am using SAP BPC 10.0 NW and don't know how to check SP ?

Here 'User can select Time Dynamically' means as you can check in my Script I have hardcoded the Time in For Loop

*FOR %T%  = 2008.04, 2008.05, 2008.06, 2008.07, 2008.08, 2008.09, 2008.10, 2008.11, 2008.12, 2009.01, 2009.02, 2009.03

It means this script is running for this Time only.

But, I just want  to make it Dynamic, it means that user can select any Time as Target on the prompt whether it single month or multiple months.

For example - (2008.04, 2008.05, 2008.06, 2008.07, 2008.08, 2008.09, 2008.10, 2008.11, 2008.12, 2009.01, 2009.02, 2009.03) or (2009.04, 2009.05, 2009.06) or (2010.01)

[former_member186338]

"I am using SAP BPC 10.0 NW and don't know how to check SP ?" - means that you didn't read the document:

To make it Dynamic: user selection for P_TIME is stored in %P_TIME_SET% variable.

You can use loop:

*FOR %T%=%P_TIME_SET%

But it's a bad idea to select target months - if no record in target the source will not be copied! Select source months (push, not pull)! Something like:

*REC(EXPRESSION=%VALUE%,P_TIME=TMVL(1,%T%))

Vadim

[Former Member]

Vadim, my business requirement is , I have an Account 'Share Capital  - 300001' in Balance Sheet and its ACCTYPE is 'LEQ', Its value in the current month is same as present in the previous month.

so, I need to write a script in which value of '300001' for the current month should come from its previous month. My source is 'Value present in the Previous month of 300001' and Target  is 'Value present in Current month of 300001'.

For example - If value present in 300001 in March08 is '2', then '2' should be present in  for the whole Financial Year that means from April08 to March09.

Now, I have modified my script with TMVL(1,%T), but after running the DM,  value from Source is NOT populating in Target.

I have attached the screenshot for script, Report and DM Prompt screen.

In these screenshots, I  have taken 2011.01 as source and 2011.02, 2011,03 and 2011.04 as my Target accounts, but after running DM, Target account should show '2' but it is displaying correct values.

[former_member186338]

Ups, looks like you have issues with the logic and the sequence of events...

First: You may have data entered at any month: APR - 2, JUN - 6 ... etc...?

Second: You want to recalculate full Financial Year (APR-MAR)?

Third: What is the finance logic you want to achieve?

May by you are trying to perform CARRY FORWARD to the next year?

Vadim

P.S. And can I see your SP???

[former_member186338]

Hi Bhawna,

Please look on the ACCTYPE of 300001 - AST?

AST/LEQ accounts are always YTD even in Periodic Model

Vadim