BPC Report Issue

[Former Member]

Hi Floks/Experts

I am facing an issue in BPC report , i am using BPC10 version

In my report

1.There were no member formulas

2.There were no Macros written in the sheet.

Dec 2015 Working(Category) is “Nil”, so Jan 2016 Working ,should also be “Nil” but in the Report $ 30,324 is populating

when i checked In  BW for Jan 2016 Working balance is “Nil”

Please throw your inputs to resolve this issue

Thanks

Purushottam

Message was edited by: purushottam parasa

[former_member186338]

Sorry, but full details required:

1. Report screenshot with ALL dimension members visible.

2. Cube info - PERIODIC/YTD?

3. TIME dimension info (fiscal year?) Administration screenshot.

4. BPC & BW version and SP...

5. RSA1 selection

...

Vadim

[Former Member]

Hi Vadim

Thanks for your response.

Please let me know if any information required

Requesting you to please see the attached the screen shot below

we are in BPC10 Version with BW 7.3 version , i am attaching time dimension values in the attachment

Thanks Vadim

Message was edited by: purushottam parasa

Time_DimValues.csv.zip

[Former Member]

Hi Purushottam,

Can you create a new report in BPC with Dimension members as you shown in your BW screen & post the screen shot of it including Page Axis.....

Aravind

[former_member186338]

1. Report screenshot with ALL dimension members visible. - ID's required, not descriptions!!!

3. TIME dimension info (fiscal year?) Administration screenshot. - NON standard Year OCT-DEC

4. BPC & BW version and SP... - Very OLD!!! Please Upgrade both!

"Dec 2015 Working(Category) is “Nil”, so Jan 2016 Working"  - what do you mean by dependency of Jan on Dec?

Vadim

[Former Member]

Hi Vadim /Aravind

Thanks for your time .

we found the issue with CARRY_FORWARD.LGF

For few accounts carry forward logic is not working (it is showing old values only), we applying the fix in Q environment , once it done i will update you the status. (

//--------------------------------------------------------------------------------------------------------------*

//  Script Logic Name: CARRY_FORWARD.LGF

   //  Purpose:  Calculates Carry forward and

//  Calculates 120001 A/R Trade (DSO*OPERATING
REVENUE)/DAYS IN MONTH and 200001 - A/P Trade (DPO/DAYSINMONTH)*OPERATING
EXPENSES

//10/2/12   
Added CAP Interest

//--------------------------------------------------------------------------------------------------------------*

//Seclect Business Area based on ACTIVE_REV property of the
BUSINESS_AREA dimension

*SELECT(%BABSCALC%,ID,BUSINESS_AREA,"[ACTIVE_REV] =
Y")

*SELECT(%TM6%,[START_PERIOD],SCENARIO,ID="WORKING")

*SELECT(%TM7%,[NEXT_PERIOD],SCENARIO,ID="WORKING")

*SELECT(%ACCT%,ID,ACCOUNT,"[DIMLIST]=BS")

We are including below line ------

*FOR %OFFSET% =
0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30

//Carry Forward

*XDIM_MEMBERSET ACCOUNT = %ACCT%

*XDIM_MEMBERSET TIME =
TMVL(%OFFSET%,%TM7%)

*XDIM_MEMBERSET ACCOUNT = %ACCT%

*XDIM_MEMBERSET DATASRC = Input,
PROJECTS, ADJUSTMENTS, BW

*XDIM_MEMBERSET SCENARIO = WORKING

*XDIM_MEMBERSET FLOW = Opening

*XDIM_MEMBERSET RPTCURRENCY = LC,USD

*WHEN ACCOUNT

*IS *

*REC(FACTOR=0)

*ENDWHEN

*COMMIT

*ENDFOR

****************************************************************

*FOR %OFFSET% =
0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30

//Carry Forward

*XDIM_MEMBERSET ACCOUNT = %ACCT%

*XDIM_MEMBERSET TIME = TMVL(%OFFSET%,%TM6%)

*XDIM_MEMBERSET ACCOUNT = %ACCT%

*XDIM_MEMBERSET DATASRC = Input, PROJECTS, ADJUSTMENTS, BW

*XDIM_MEMBERSET SCENARIO = WORKING

*XDIM_MEMBERSET FLOW = BAS(ALL_FLOW)

*XDIM_MEMBERSET RPTCURRENCY = LC,USD

*WHEN ACCOUNT

*IS *

*REC(FACTOR=1,FLOW=Opening,TIME=TMVL(%OFFSET%,%TM7%))

*ENDWHEN

*COMMIT

[former_member186338]

Ups, strange... What do you want to achieve with this script? There are syntax errors in the provided script (like *FOR without *NEXT, not supported keyword *ENDFOR, etc...)

Can you explain your script requirements in line with

Vadim