Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: url parameter for xaction

  1. #1

    Default url parameter for xaction

    Hi Pentaho friends,

    can i recive parameter from the request-url for xaction input.

    something like this: ...test.xaction&products=Plains

    I want to change the jpivot view with this parameter.

    Regards

  2. #2

    Default

    I tried the following, but it does not work:

    Url:
    Code:
    http://server:8080/pentaho/Pivot?solution=Standard&path=/Projekt&project=PROJECT&action=Test.analysisview.xaction
    xaction:
    Code:
      <inputs>
          <projekt type="string">
          <default-value>all</default-value>
             <sources>
                 <request>project</request>
            </sources>            
        </projekt> 
        ...
    <inputs>
    Code:
    <actions> 
        <action-definition> 
          <component-name>PivotViewComponent</component-name>  
          <action-type>Pivot View</action-type>  
          <action-inputs> 
            <projekt type="string"/>
            <mode type="string"/> 
          </action-inputs>  
         ...
    <query>... where [Project.Project].[all].[{PREPARE:project}]</query>
    Catalina.out:
    Code:
    MondrianError:MDX Object [Project.Project].[all].[{PREPARE:project}] not found in cube
    Could anybody help me. It's very important for me

  3. #3
    Join Date
    Oct 2007
    Posts
    235

    Default

    {PREPARE:myVar} only works with SQL queries. Just use {myVar} in an mdx query.
    SQL: as much of a standard as the English language

  4. #4

    Default

    great, it works. Thanks

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.