Budget data increment in BPC10

[Former Member]

Dear All,

Could you please help me on below issue.

my customer  want to increase Budget (Which is already available in BPC cube not in BW cube)with 6% in BPC for few cost centers with cost elements for all the periods of 2015.

Could you please provide me how to do it in BPC as i'm new to BPC.

Below is the example: before increment

Cost center      Cost element     2015.01     2015.02    2015.03...

15000               310022               1000          1055         1072

15000                450000               870             960          1042

after increment, it should be like below

Cost center      Cost element     2015.01     2015.02    2015.03...

15000               310022               1060          1118         1137

15000                450000               922             1018         1105

Thank you.

Prem

[Former Member · Accepted solution]

Dear Vadim,

Its working. Thank you for your help.

I do have one question here. instead of hadcoding the cost center, cost elements and time in logic script. can we make as these as a selection during the running of the DM package.

Thanks

Prem

[former_member186338 · Accepted solution]

Yes, sure!

In the advanced DM script correct the PROMPT(SELECTINPUT... to include the required dimension names.

Then in script logic use:

*XDIM_MEMBERSET COSTCENTER=%COSTCENTER_SET% // %XXX_SET% variable will contain members selected by user in PROMPT...

Vadim

[former_member186338 · Accepted solution]

Something like:

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%,COSTCENTER,COST_ELEMENT")

Script logic:

*XDIM_MEMBERSET COSTCENTER=%COSTCENTER_SET%

*XDIM_MEMBERSET COST_ELEMENT=%COST_ELEMENT_SET%

*XDIM_MEMBERSET TIME=%TIME_SET%

//If you want:

*XDIM_MEMBERSET CATEGORY=%CATEGORY_SET%

*XDIM_MEMBERSET RPTCURRENCY=%RPTCURRENCY_SET%

Vadim

[Former Member]

Dear Vadim,

Excellent. Thank you very much.

just used below prompt

PROMPT(SELECTINPUT,,,,"%CATEGORY_DIM%,%CURRENCY_DIM%,%TIME_DIM%,%ENTITY_DIM%,%ACCOUNT_DIM%")

Working as expected.

Thank you very much.

[former_member186338]

By the way, in PROMPT statement I prefer to use real dimension names instead of %XXX_DIM% to have a clear picture: like TIME instead of %TIME_DIM% if your time dimension is named TIME.

And yes, statements like *XDIM_MEMBERSET XXX=%XXX_SET% are not required in the simple case, because %SELECTION% from PROMPT will set the incoming script scope inline with members selected by user. In complex scripts when you have to change scope multiple times the statement *XDIM_MEMBERSET XXX=%XXX_SET% will reset scope to initial script scope.

B.R. Vadim

[former_member186338]

Hi Prem,

I have already answered your first same question, what was the idea to duplicate question?

Vadim

[Former Member]

Dear Vadim,

I have wrong posted the previous question.

as per correct requirement I need to increase the data in BPC.

Not from while loading the data from BW cube.

Thanks

Prem

[former_member186338]

Just use script that I posted for the previous question (save it under somename.lgf) and create DM package with the chain DEFAULT_FORMULAS... Edit advanced DM script and enter the name of the script instead of default.lgf. Run this package.

Vadim