Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Auto Includes and CDF

  1. #1

    Default Auto Includes and CDF

    Hello,

    I'm having a bit of trouble getting auto includes to work. Having looked at this blog post

    http://pedroalves-bi.blogspot.co.uk/...rt-in-cdf.html

    and this page

    http://redmine.webdetails.org/projec...wiki/Framework

    I have setup the following paths

    The CDA file I am trying to include is in

    Code:
    pentaho-solutions\cdf\includes\FOLDERA\filename.cda
    The dashboard I am executing is in

    Code:
    pentaho-solutions\FOLDERA\FOLDERB\FOLDERC\dashboard.xcdf
    Inside the CDA file I have the following

    Code:
    <?xml version="1.0" encoding="utf-8"?>
    <CDADescriptor>
        <DataSources>
            <Connection id="1" type="sql.jndi">
                <Jndi>jndiName</Jndi>
            </Connection>
        </DataSources>
        <DataAccess id="getURL" connection="1" type="sql" access="public" cache="true" cacheDuration="3600">
            <Query>
                select ${wmURL} as wm_url
                </Query>
            <Parameters>
                <Parameter name="wmURL" type="String" default="${[session:wmUrlCont]}"/>
            </Parameters>
        </DataAccess>
    </CDADescriptor>
    So the call to the context I have been using is

    Code:
    Dashboards.context.getURL
    This is always coming up as undefined. I have checked that the session variable wmUrlCont is in the session using psi-probe and that is all fine.

    Is there something wrong with the way I have setup the include paths, or is the way I'm accessing the context incorrect? Having read the description of how this all works I would expect to be seeing another call to /content/cda/doQuery for the data access id's in the CDA file , would this be correct?

    Thanks for any help on this,

    stevens_ns

  2. #2

    Default

    Hi stevens
    I checked this under all last stable builds (13.09.10) and I wasn't able to reproduce it. To check this I used one cda sample queries, located in the plugin-samples/cda/cdaFiles (sql-jndi.cda). I placed that query in /cdf/includes/myFolder and created a dashboard inside /myFolder. After render my dashboard I contains the result set. It is located in Dashboard.context.queryData.(your query id)
    Can you please try to follow these steps and check if it is still reproducible on your side?

  3. #3
    Join Date
    Oct 2013
    Posts
    2

    Default

    It is nice to see your post here, I am a path of exile lover and I love its release so much, if you have any ideas want to share with me, I would be really happy.
    The path of exile currency is very important in the game, and if you have a good way to farm it, I would be so happy to know it.
    Have a nice day.

  4. #4

    Default

    Hi,

    Thanks for getting back to me.

    I tried your example using

    Code:
    Dashboards.context.queryData.getURL
    It still didn't work, so I moved the dashboard so it was in the top level folder so we now have the cda file in here

    Code:
    pentaho-solutions\cdf\includes\FOLDERA\filename.cda
    And the dashboard in here

    Code:
    pentaho-solutions\FOLDERA\dashboard.xcdf
    Which is the same as your example.

    Not sure what we're doing wrong here, is there a way of listing things that are available in the Dashboards context?

    Thanks,

    stevens_ns

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.