Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Syntax error at line 16, column 9, token 'String'

  1. #1
    Join Date
    Jun 2010

    Default Syntax error at line 16, column 9, token 'String'


    We get this error:

    Mondrian Error:Syntax error at line 16, column 9, token 'String'

    This is the code:

    Format String = Iif([Measures].[verschil] <= Abs(-25000), '|#%|style=green', '|#%|style=red')

    What does the error mean?
    Thank you in advance.

  2. #2
    Join Date
    Feb 2009


    Did you define your format string in the mondrian schema file?

    If yes: Quotes in the format string cause problems because the format string gets surrounded by quotes when the MDX is generated. Try adding a property with the name FORMAT_STRING and place your string in the "expression" field.

    The result should look like this:

    <Measure name="xyz" ...>
        <CalculatedMemberProperty name="FORMAT_STRING" expression="Iif([Measures].[verschil] <= Abs(-25000), '|#%|style=green', '|#%|style=red&#39;)">
    Last edited by mburger; 10-28-2011 at 05:50 AM. Reason: added code tags
    Markus Burger-Scheidlin
    ITGAIN Consulting GmbH Hannover, Germany

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.