Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: extracting XML CDATA from mondrian.xml

  1. #1
    Join Date
    Nov 2007
    Posts
    3

    Default extracting XML CDATA from mondrian.xml

    Hello All

    I am reading a mondrian.xml file with the PDI "Get XML Data" step. I am struggling to extract the CDATA from annotations and measure expressions.

    Could somebody kindly provide a sample config for the XPath, Element, and Result Type settings in the "Fields" for the CDATA found in a simple annotation and/or measure expression please

    fyi.....I am trying to avoid using the Stax step to keep the transformation simple

    measure expression example::

    <Measure name="contract_actions" datatype="Numeric" formatString="#,###;(#,###)" aggregator="sum" caption="Actions (Contracted)" visible="true">
    <Annotations>
    <Annotation name="AnalyzerBusinessGroup">
    <=!=[=C=D=A=T=A=[Measures (Contract)]=]=>
    </Annotation>
    </Annotations>
    <MeasureExpression>
    <SQL dialect="generic">
    <=!=[=C=D=A=T=A=[(CASE WHEN rate_type_group IN ('CPA') THEN contract_units ELSE 0 END)]=]=>
    </SQL>
    </MeasureExpression>
    </Measure>

    the foodmart.xml mondrian file could be used for an example as well (attached)

    Thank you in advance
    Attached Files Attached Files
    Last edited by highsierra; 03-16-2016 at 10:47 AM.

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.