Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pivot View xaction problem

  1. #1

    Default Pivot View xaction problem

    Hi all,

    I tried to modify the "Steel Wheel Analysis" example to make it work with my data. The result is a white page. Can someone tell me what shall I do to make it work? I do need the Pivot Viewer!

    I post the .xaction file in question here.
    I will also post in a following message another .xaction of mine that does wok perfectly. It uses mondrian too, but it doesn't use the Pivot View Component.

    Please Help me!

    Thanks a lot.
    Danilo Pompei


    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence>
    <name>analysis_default.xaction</name>
    <title>%title</title>
    <version>1</version>
    <logging-level>ERROR</logging-level>
    <documentation>
    <author>Danilo Pompei</author>
    <help/>
    <result-type>report</result-type>
    <description>%description</description>
    <icon>analysis_default.png</icon>
    </documentation>

    <inputs>
    <mode type="string">
    <default-value/>
    <sources>
    <request>mode</request>
    </sources>
    </mode>
    </inputs>

    <outputs>
    <model type="string"/>
    <connection type="string"/>
    <mdx type="string"/>
    <options type="list"/>
    <title type="string"/>
    <url type="string">
    <destinations>
    <response>redirect</response>
    </destinations>
    </url>
    </outputs>

    <resources/>

    <actions>
    <action-definition>
    <component-name>PivotViewComponent</component-name>
    <action-type>Pivot View</action-type>
    <action-inputs>
    <mode type="string"/>
    </action-inputs>
    <action-outputs>
    <model type="string"/>
    <connection type="string"/>
    <mdx type="string"/>
    <options type="list"/>
    <title type="string"/>
    <url type="string"/>
    </action-outputs>
    <component-definition>
    <title>Drill Down to Pivot Table</title>
    <viewer>Pivot</viewer>
    <model>samples/steel-wheels/analysis/myschema.mondrian.xml</model>
    <options>
    <personal/>
    <cube-nav/>
    <mdx-edit/>
    <sort-conf/>
    <spacer/>
    <level-style/>
    <hide-spans/>
    <properties/>
    <non-empty/>
    <swap-axes/>
    <spacer/>
    <drill-member/>
    <drill-position/>
    <drill-replace/>
    <drill-thru/>
    <spacer/>
    <chart/>
    <chart-conf/>
    <spacer/>
    <print-conf/>
    <print-pdf/>
    <spacer/>
    <excel/>
    </options>

    <driver><![CDATA[org.postgresql.Driver]]></driver>
    <location><![CDATA[mondrian]]></location>
    <connection><![CDATA[jdbc:odbc:PostgreSQL35]]></connection>
    <user-id><![CDATA[postgres]]></user-id>
    <password><![CDATA[mypassword]]></password>
    <query><![CDATA[SELECT {[Measures].[Var_anno_prec]} ON COLUMNS, {[Dim_cliente_cons_cod].[Cliente_cons_cod].[69]} ON ROWS FROM Vendite]]></query>
    </component-definition>
    <action-name>Pivot View</action-name>
    <logging-level>DEBUG</logging-level>
    </action-definition>

    </actions>
    </action-sequence>

  2. #2

    Default

    Here I post a similar .xaction of mine that does work!


    <?xml version="1.0" encoding="UTF-8"?>
    <action-sequence>
    <name>JFree_ChartComponent.xaction</name>
    <title>%title</title>
    <version>1</version>
    <logging-level>DEBUG</logging-level>
    <documentation>
    <author>Danilo Pompei</author>
    <description>%description</description>
    <icon>JFree_ChartComponent.png</icon>
    <help>Help</help>
    <result-type>rule</result-type>
    </documentation>

    <inputs>
    <chart-type type="string">
    <default-value>.png</default-value>
    <sources>
    <request>type</request>
    </sources>
    </chart-type>
    <codice type="string">
    <sources>
    <request>codice</request>
    </sources>
    </codice>
    </inputs>

    <outputs>
    <content type="string">
    <destinations>
    <response>content</response>
    </destinations>
    </content>
    </outputs>

    <resources>
    <catalog>
    <file>
    <location>E:\myschema.mondrian.xml</location>
    <mime-type>text/plain</mime-type>
    </file>
    </catalog>
    </resources>

    <actions>
    <action-definition>
    <component-name>MDXLookupRule</component-name>
    <action-type>OLAP</action-type>
    <action-inputs>
    <codice type="string"/>
    </action-inputs>
    <action-resources>
    <catalog type="resource" mapping="catalog"/>
    </action-resources>
    <action-outputs>
    <query-results type="result-set" mapping="query_result"/>
    </action-outputs>
    <component-definition>
    <driver><![CDATA[org.postgresql.Driver]]></driver>
    <location><![CDATA[mondrian]]></location>
    <connection><![CDATA[jdbc:odbc:PostgreSQL35]]></connection>
    <user-id><![CDATA[postgres]]></user-id>
    <password><![CDATA[mypassword]]></password>
    <query><![CDATA[SELECT {[Measures].[Var_anno_prec]} ON COLUMNS, {[Dim_cliente_cons_cod].[Cliente_cons_cod].[{codice}]}
    ON ROWS
    FROM Vendite]]></query>
    </component-definition>
    </action-definition>

    <action-definition>
    <component-name>JavascriptRule</component-name>
    <action-type>JavaScript</action-type>
    <action-inputs>
    <query_result type="result-set"/>
    </action-inputs>
    <action-outputs>
    <content type="string"/>
    </action-outputs>
    <component-definition>
    <script><![CDATA[content=((parseFloat(query_result.getValueAt(0,0))*100).toString()).substring(0,5);]]></script>
    </component-definition>
    </action-definition>

    </actions>
    </action-sequence>

  3. #3

    Default

    Hi all,


    Please I really need this to work!

    Does anyone have any clue? Any help would be really appreciated!


    Thanks all,
    Danilo Pompei

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.