After running the package result is not showing in report?

[Former Member]

Hi Experts,

I am calculating some percentage on actual for the period of 2016.01. and i want see that value in my plan column. So that written a script like

*XDIM_ADDMEMBERSET ACCOUNT=BS

*XDIM_ADDMEMBERSET TIME=2016.01

*XDIM_ADDMEMBERSET CATEGORY=Actual

*XDIM_ADDMEMBERSET PCTR=310501

*WHEN ACCOUNT

*IS BS

*REC(FACTOR=.1,CATEGORY="ABP")

*ENDWHEN

When i run the package it is showing as succeed but when i am refreshing the report it not showing calculated results.

Thanks

Gowtham

[Former Member · Accepted solution]

Hi Gowtham,

Show the screenshot of the data manger package status.....

What is your scope? Instead of XDIM_ADDMEMBERSET use XDIM_MEMBERSET for scoping...

Refer this document..

http://sapassets.edgesuite.net/sapcom/docs/2015/08/6cdcaf53-557c-0010-82c7-eda71af511fa.pdf

Regards,

JP

[Former Member · Accepted solution]

Hi JP,

Thank you for your reply.

My package status is succeeded. Please check the attachment.

Thanks

Gowtham

[Former Member · Accepted solution]

Please show the detail view of status!

[Former Member · Accepted solution]

Hi JP,

We are calculating for the planning based on actual for the balance sheet members.

For ex:

I have 2000 in my cash & bank member in account dimension for period of 2016.01.

here i want plan on the actual with 2.5% and i want this value in plan(ABP) column.

Thanks

Gowtham

[Former Member · Accepted solution]

Hi JP,

Thanks again.

Here is the log status,

LOG BEGIN TIME:2016-07-28 14:17:15

FILE:\ROOT\WEBFOLDERS\TARASOFT\ADMINAPP\TRS_FINANCE\CALABP.LGF

USER:g99999

APPSET:TARASOFT

APPLICATION:TRS_FINANCE

[INFO] GET_DIM_LIST(): I_APPL_ID="TRS_FINANCE", #dimensions=8

MEASURES,RPTCURRENCY,TIME,ACCOUNT,TCATEGORY,ENTITY,PCTR,SEGMENT

#dim_memberset=6

RPTCURRENCY:INR,1 in total.

ENTITY:3100,1 in total.

ACCOUNT:BS,1 in total.

TIME:2016.01,1 in total.

CATEGORY:Actual,1 in total.

PCTR:310501,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.00 s.

LOG END TIME:2016-07-28 14:17:15

File path: \ROOT\WEBFOLDERS\TARASO\TRS_FINANCE\PRIVATEPUBLICATIONS\C01020\tempfiles\20160728141715\CALABP.LOG

Thanks

Gowtham

[Former Member · Accepted solution]

NO records are generated! What is 2.5 %? Is it fixed value stored in some member or you just have to multiply by 2.5%?? Balance sheet members..BS is a member or node?

Have you read the document shared by me?

Regards,

JP

[Former Member · Accepted solution]

Refer this for examples....BPC Script logic for Dummies? (Part 1) | SCN

[Former Member · Accepted solution]

Hi JP,

Thank you for sharing the doc...

I have tried with your doc help. BS is node so i have changed the script as *BAS(BS).

Now it is showing calculated value on actual column. But my requirement is I want see the actual + calculated value in plan column. For this what i have to do.

Thanks

Gowtham

[Former Member · Accepted solution]

Hi Gowtham,

Write it this way....

*XDIM_MEMBERSET TIME=2016.01

*XDIM_MEMBERSET CATEGORY=Actual

*XDIM_MEMBERSET PCTR=310501

*WHEN ACCOUNT

*IS BAS(BS)

*REC(FACTOR=0.025,CATEGORY="PLAN")

*ENDWHEN

Hope this helps...

Regards,

JP

[Former Member · Accepted solution]

Hi JP,

Thanks it is working fine.

But i am getting the calculated values only in ABP column. I need actual + Calculated values in ABP column.

for Ex:

I have 10000 actual and calculated with 0.1 than my result is 1000 in ABP column.

Now i need this 10000 and 1000 =11000 in my ABP column

Thanks

Gowtham

[former_member186338 · Accepted solution]

May be:

*REC(FACTOR=1.025,CATEGORY="PLAN")

[Former Member · Accepted solution]

Yes...1.025...

[Former Member · Accepted solution]

*XDIM_MEMBERSET TIME=2016.01

*XDIM_MEMBERSET CATEGORY=Actual

*XDIM_MEMBERSET PCTR=310501

*WHEN ACCOUNT

*IS BAS(BS)

*REC(EXPRESSION=%VALUE% + (%VALUE% * 1.025),CATEGORY="PLAN")

*ENDWHEN

Try this......Please check for the synatx....I dont have system to test it.....

Regards,

JP

[former_member186338 · Accepted solution]

Ups,

*REC(EXPRESSION=%VALUE% + (%VALUE% * 1.025),CATEGORY="PLAN")

Incorrect - it will be %VALUE%*2.025

[Former Member · Accepted solution]

Vadim....sorry but why 2.025? Dint get that logic...

[Former Member · Accepted solution]

Hi,

Than you Vadim and JP.

It is working fine and showing correct values.

Thanks again

Regards

Gowtham