cancel
Showing results for 
Search instead for 
Did you mean: 

Epm10:Logic: Allocation/Error

Former Member
0 Kudos

Hi experts,

hope someone could help.

I wrote this script :

*SELECT (%ACCGFG%,ID,TACCOUNT,GFG=Y)

 

*XDIM_MEMBERSET AUDITTRAIL=Input

*XDIM_MEMBERSET CATEGORY=Budget

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET COUNTRY=%COUNTRY_SET%

*XDIM_MEMBERSET CUSTOMER=%CUSTOMER_SET%

 

*WHEN TIME

*IS %TIME_SET%

 

*WHEN COUNTRY

*IS %COUNTRY_SET%

 

*WHEN CUSTOMER

*IS %CUSTOMER_SET%

 

*FOR %GFG%=%ACCGFG%

*REC(EXPRESSION=(TACCOUNT.%GFG%,COUNTRY=No_Country,CUSTOMER=No_Customer)*(TACCOUNT.PL100)/(TACCOUNT.PL100,COUNTRY=World,CUSTOMER=TotalCustomer))

*NEXT

 

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

But, While executing with the DataManager or UJKT, I get this message ?

RUN_LOGIC:LINE 19 syntax error: " missing ) in parenthetical"

In UJKT, I get this log :

LOG:

FILE:\ROOT\WEBFOLDERS\DEMO \ADMINAPP\Finance\TEST.LGF

USER:BI_1

APPSET:DEMO

APPLICATION:Finance

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

AUDITTRAIL,CATEGORY,COUNTRY,CUSTOMER,MEASURES,RPTCURRENCY,TACCOUNT,TIME

#dim_memberset=6

AUDITTRAIL:Input,1 in total.

CATEGORY:Budget,1 in total.

RPTCURRENCY:LC,1 in total.

TIME:2013.01,1 in total.

COUNTRY:DZ,1 in total.

CUSTOMER:Customer0001,1 in total.

 

REC :([TACCOUNT].[PL310]

REC :([TACCOUNT].[PL320]

REC :([TACCOUNT].[PL330]

                    1

([TACCOUNT].[PL310]

var $2$=3.4300000000000003E-01;var $1$=4.2499999999999999E-01;($1$;

UJK_VALIDATION_EXCEPTION:LINE 19 syntax error: " missing ) in parenthetical"

Tks for your help,

Rgds,

Olivia.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Experts,

I change my script -- and don't have any error, BUT :-(, No Data are written.

Here is my script :

*SELECT (%ACCGFG%,ID,TACCOUNT,GFG=Y)

*XDIM_MEMBERSET AUDITTRAIL=Input

*XDIM_MEMBERSET CATEGORY=Budget

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET COUNTRY=%COUNTRY_SET%

*XDIM_MEMBERSET CUSTOMER=%CUSTOMER_SET%

 

*WHEN TIME

*IS %TIME_SET%

 

*WHEN COUNTRY

*IS No_Country

*WHEN CUSTOMER

*IS No_Customer

 

*FOR %GFG%=%ACCGFG%

*REC(EXPRESSION=%VALUE%,%GFG%*(TACCOUNT.PL100)/(TACCOUNT.PL100,COUNTRY=World,CUSTOMER=TotalCustomer))

*NEXT

 

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Someone can help please ?

Tks for your help,

Olivia.

former_member186498
Active Contributor
0 Kudos

Hi Olivia,

in the REC function the first parameter must be FACTOR or EXPRESSION with the formula, in your last example just the input value without change, and after the destination dimension values where you want to write the result (but you have a calculus)

Kind regards

     Roberto

Former Member
0 Kudos

Thanks Roberto.

In fact, I want to  write on :

- My %GFG% Account,

- Country_Set

- Customer_Set

But, the result I want to write must be the result of a calculation :

- it must be the allocation of some data I have input on the %GFG% Account ;

- this allocation must follow the %age of the the PL100 for the Country et Customer Selected on the Global PL100.

Sorry i m not sure to well understand what i am supposed to put 😕 ?

Could you help ?

Tks for your help,

Olivia

Former Member
0 Kudos

Here is my new script :

*SELECT (%ACCGFG%,ID,TACCOUNT,GFG=Y)

 

*XDIM_MEMBERSET AUDITTRAIL=Input

*XDIM_MEMBERSET CATEGORY=Budget

*XDIM_MEMBERSET RPTCURRENCY=LC

*XDIM_MEMBERSET TIME=%TIME_SET%

*XDIM_MEMBERSET COUNTRY=%COUNTRY_SET%

*XDIM_MEMBERSET CUSTOMER=%CUSTOMER_SET%

 

*WHEN TIME

*IS %TIME_SET%

 

*WHEN COUNTRY

*IS No_Country

 

*WHEN CUSTOMER

*IS No_Customer

 

*FOR %GFG%=%ACCGFG%

*REC(EXPRESSION=%VALUE%,TACCOUNT=%GFG%,COUNTRY=%COUNTRY_SET%,CUSTOMER=%CUSTOMER_SET%,TIME=%TIME_SET%)

  *NEXT

 

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

I m not sure to understand what is doing wrong 😞

Tks for your help.

Rgds,

Olivia.

former_member186498
Active Contributor
0 Kudos

Hi Olivia,

Try *SELECT (%ACCGFG%,ID,TACCOUNT,"[GFG]='Y'")

the rest seems right.

If not ok could you please write what kind of error do you receive?

Kind regards

     Roberto

Former Member
0 Kudos

Hi Roberto,

I finally solved the problem.

Tks,

Rgds,

Olivia.

Answers (0)