Syntax error while compiling

[Former Member]

Hi Gurus,

I have started with VC and while compiling a model, I get a syntax error in Fiscalyear (variable in the query).

the message is "The expression in field 'FiscalYear' contains an error: Syntax error".

"Stopped due to errors"

Have no clues as the other variable (Cost center) is working fine.

We are on NW7.0 SP13

Tks

KS

[Former Member]

Hi

Have you used any custom setting in that variable? When you are getting this error, at the time of deployment or at the time of execution of the error.

Regards

Sandeep

[Former Member]

Hi,

I used a system variable 0P_FYEAR in the query and also tried with a custom variable with same parameters. (No customisations) both give error while compiling in VC.

The query works fine when executed from query designer.

tks

KS

[Former Member]

Hi

Right click on the joining line after that form. Go to the field mapping & go to the field for the 'Fiscal Year'

Do following changes

If by default you are getting there '@Fiscal year' then make it '@Fiscal year_Key' means whatever is there, just add "_key" after that. Then instead of compiling & deploying, Directly Deploy the model & then check if you are getting any error.

Regards

Sandeep

[Former Member]

Hi Thanks, The issue resolved when I added a XMLA system to portal for BI.