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
    Posts
    10

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

    Hello,

    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.
    Leo

  2. #2
    Join Date
    Feb 2009
    Posts
    9

    Default

    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:

    Code:
    <Measure name="xyz" ...>
        <CalculatedMemberProperty name="FORMAT_STRING" expression="Iif([Measures].[verschil] <= Abs(-25000), '|#%|style=green', '|#%|style=red&#39;)">
        </CalculatedMemberProperty>
    </Measure>
    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.