Problem with XDIM_Filter Instruction!!

64 Views

Hi Experts,

I am using BPC 7.5M and have been upgraded from BPC 5.1 in recent past, There is one script logic containing instruction:

FLAG_PERIOD = CATEGORY.CURRMO

*XDIM_FILTER TIME > %FLAG_PERIOD%

The CURRMO property contains values like "2011.SEP", now when I am validating the logic it is giving syntax error in validation result window, please find the result below:

Validation Result:

Application: Headcount

Logic file: HCFormulas.LGF

Validation status of executable file: Success

Validation status of syntax: Failed

- Invalid syntax found; see statements in red

*It is showing the line "XDIM_FILTER TIME > %FLAG_PERIOD%" in red font, This same was working fine in 5.1 version.

*In BPC 7.5 M, I have updated the XDIMFILTER instruction with:*_

*FLAG_PERIOD = CATEGORY.CURRMO

*XDIM_FILTER TIME = [TIME].PROPERTIES("ID") > %FLAG_PERIOD%

And it validates fine but when I ran the package calling this logic it gave error:

u201CError in step 1 of QueryCubeAndDebug: -2147467259 Query (1, 247) Parser:

The syntax for 'SEP' is incorrect.u201D

Just for you information CURRMO property in this case is having value u201C2011.SEPu201D and Time dimension ID members also contain this value u201C2011.SEPu201D.

Please Advice.

Thanks in Advance!!

Thanks & Regards,

Rohit