Two sets specified in the function have different dimensionality

[Former Member]

Hi all,

I got this error message when running my logic script: -2147467259 Two sets specified in the  function have different dimensionality.

I'm not sure what I did wrong here. I run a data manager package and user will chose which run a logic script file:

Here the package script:

DEBUG(ON)

PROMPT(RADIOBUTTON,%CHECKLCK%,"Select whether to check work status settings when running logic.",1,{"Yes, check for work status settings before running logic","No, do not check work status settings"},{"1","0"})

PROMPT(SELECTINPUT,,,"Please select category, entity and time for restatement",%CATEGORY_DIM%%TIME_DIM%)

TASK(Execute formulas,USER,%USER%)

TASK(Execute formulas,APPSET,%APPSET%)

TASK(Execute formulas,APP,%APP%)

TASK(Execute formulas,SELECTION,%SELECTIONFILE%)

TASK(Execute formulas,LOGICFILE,%APPPATH%\..\AdminApp\%APP%\MyFile.LGF)

TASK(Execute formulas,RUNMODE,1)

TASK(Execute formulas,LOGICMODE,1)

TASK(Execute formulas,CHECKLCK,%CHECKLCK%)

-----------------------------------------------------------------------------------------------

This is logic script file

*SELECT(%ALL_TCS%,"ID","TERRITORYCODE","[CALC]='N'")

*SELECT(%TIME_SET%,"ID","TIME","[CARRYFORWARD]='Y' AND [CALC]='N'")

*SELECT(%CATEGORY_SET%,"ID","CATEGORY","[CALC]='N'")

*XDIM_MEMBERSET RPTCURRENCY=CURR_STAGE

*XDIM_MEMBERSET DATATYPE = ULTIMATE,ULTIMATEINPUT,RECOGINPUT

*XDIM_MEMBERSET TERRITORYCODE = %ALL_TCS%

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_FILTER ENTITY = [ENTITY].properties("INTL_FLAG") = "INT"

*XDIM_NOSCAN X_USD,C_NONE

*CALCULATE_DIFFERENCE=0

*DESTINATION RPTCURRENCY=T_USD,CURR_NONE

*IGNORE_SECURITY

*WHEN ACCOUNT.RATETYPE

  *IS  "AVG"

        *REC(FACTOR=1, RPTCURRENCY=X_USD)

//        *REC(FACTOR=0)

*IS "LC"

        *REC(FACTOR=1, RPTCURRENCY=C_NONE)

//        *REC(FACTOR=0)

*ENDWHEN

*COMMIT

[Former Member · Accepted solution]

Hi,

what is this line for

*DESTINATION RPTCURRENCY=T_USD,CURR_NONE?

Because the RPTCURRENCY in your *REC statements is different than these two.

BR,
Arnold

[Former Member · Accepted solution]

Amold,

That like not suppose to be there.

I commented out them already.  So the error not really because of RPT currency.

I found out because of this line:

*XDIM_FILTER ENTITY = [ENTITY].properties("INTL_FLAG") = "INT"

Then I used the other way like this and then the error gone:

*SELET(%ENTITY_INT%,"ID","ENTITY","INTL_FLAG='INT'")

*XDIM_MEMBERSET ENTITY = %ENTITY_INT%

I'm still not sure why.