The following syntax error occurred during parsing: Invalid token, Line 1,

[Former Member]

Hello Experts,

I hope someone could help me. I am trying to create a MDX formula in Account dimension (Cuenta).

When formula created use "Iif" syntax, system give the following error:

- [CUENTA].[H1].[#X000] Parser: The following syntax error occurred during parsing: Invalid token, Line 1, Offset 15, [.

My Account dimension (Cuenta) has 3 parent, and the formula introduces is:

'Iif([Cuenta].[H1].[BLOQ_FASEC]<0.5 and [Cuenta].[H1].[BLOQ_FASEC]>-0.5,0,[Cuenta].[H1].[BLOQ_FASEC])

We try another syntax

'Iif([Cuenta].[BLOQ_FASEC]<0.5 and [Cuenta].[BLOQ_FASEC]>-0.5,0,[Cuenta].[BLOQ_FASEC])

But same error persist.

Could you have any idea?

Thanks

[sorin_radulescu · Accepted solution]

Can you check into dimension properties what is the size of FORMULA propertiy?

Make sure is bigger than number of chars from your formula.

Do you have multiple hierarchies for CUENTA?

The formula which you mentioned it has to be into column: FORMULAH1.

Also make sure that your formula doesn't have an end of line at the end. That can cause again problems.

Regards

Sorin Radulescu

Edited by: Sorin Radulescu on Apr 22, 2010 11:03 AM

[Former Member]

Thank you very much!!!!

You are right!! The problem was property length. Dimesion process great

Thank you again

[Former Member]

Hello,

Thank you very much for you answer,

However X000 is the member where this formula we desire to define, so I think problem could be the syntax of this formula.

[Former Member]

Thank you very much Sorin:

I try to process again the dimension, but the following error appears intriducing the MDX formula you give me:

- [CUENTA].[H1].[#X000] Parser: The end of the input was reached.

Do you know what could be?

Thank you very much

[Former Member]

Hi,

This problem is coming from some other dimension formula. You must be having some other formulae in your account member sheet. Please check the reference of the member X000 in the functions.

[Former Member]

Hi,

Please modify the formula as:

Iif(((Cuenta.H1.BLOQ_FASEC<0.5) and (Cuenta.H1.BLOQ_FASEC>-0.5)),0,Cuenta.H1.BLOQ_FASEC)

I just added few brackets.

Hope this helps.

[sorin_radulescu]

you need brackets for conditions.

Logc oerators like AND, OR have higher priority then other operators like >.

So the syntax has to be :

'Iif(((Cuenta.H1.BLOQ_FASEC<0.5) and (Cuenta.H1.BLOQ_FASEC>-0.5)),0,Cuenta.H1.BLOQ_FASEC)

Regards

Sorin Radulescu