BPC 10.0 NW Logic Script

[Former Member]

Hello experts,

I have written the following logic script but it does not generate any records.  The log file from UJKT is also included below.

Can you please help me troubleshoot?  Thanks!

BR,

Vijay

Logic Script:

*XDIM_MEMBERSET ACCOUNT = 800001

*XDIM_MEMBERSET DATASRC = INPUT

*XDIM_MEMBERSET PARTNERPC = I_NONE

*XDIM_MEMBERSET PROFITCENTER = PUS1283

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET VERSION = P_WV

*XDIM_MEMBERSET WEEK=NOWEEK

*XDIM_MEMBERSET TIME=2016.12

*XDIM_MEMBERSET PRODUCTCAT = PRODUCTCATPAR

*XDIM_MEMBERSET CUSTOMERTYPE = NOCUSTOMERTYPE

*XDIM_MEMBERSET STAT = NOSTAT

*XDIM_MEMBERSET SUBDEPT = NOSUBDEPT

*WHEN ACCOUNT

*IS *

*REC(EXPRESSION= %VALUE%/5,TIME=2016.12,WEEK=WK53,DATASRC=INPUT,PRODUCTCAT=NOPRODUCTCAT)

*ENDWHEN

LOG file from UJKT:

LOG:

FILE:\ROOT\WEBFOLDERS\..... \ADMINAPP\FORECASTING\TEST.LGF

USER:....

APPSET:....

APPLICATION:FORECASTING

[INFO] GET_DIM_LIST(): I_APPL_ID="FORECASTING", #dimensions=13

ACCOUNT,CUSTOMERTYPE,DATASRC,MEASURES,PARTNERPC,PRODUCTCAT,PROFITCENTER,RPTCURRENCY,STAT,SUBDEPT,TIME,VERSION,WEEK

#dim_memberset=12

ACCOUNT:800001,1 in total.

DATASRC:INPUT,1 in total.

PARTNERPC:I_NONE,1 in total.

PROFITCENTER:PUS1283,1 in total.

RPTCURRENCY:LC,1 in total.

VERSION:P_WV,1 in total.

WEEK:NOWEEK,1 in total.

TIME:2016.12,1 in total.

PRODUCTCAT:PRODUCTCATPAR,1 in total.

CUSTOMERTYPE:NOCUSTOMERTYPE,1 in total.

STAT:NOSTAT,1 in total.

SUBDEPT:NOSUBDEPT,1 in total.

SCRIPT RUNNING TIME IN TOTAL:0.17 s.

[former_member200327 · Accepted solution]

Hi Vijay,

I can see that you restricted each Dimension to just 1 member. Is each of them base member or some are  Nodes? If there are Nodes use BAS(...). If all of them are base members try t/a LISTCUBE and put each of those members you have in the scope. Does is bring any data?

Regards,

Gersh

[former_member186338]

Looks like you don't have data in the scope!

Vadim

[former_member198992]

Vijay,

try to add  following at end of your code-

*COMMIT

Regards

Veera

[former_member186338]

Hi Veera,

Never recommend to add *COMMIT to WHEN/ENDWHEN code - absolutely useless!

Vadim

[Former Member]

Thanks Veera and Vadim.

Any other suggestions?

BR,

Vijay