Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho CDF Reporting

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Default Pentaho CDF Reporting

    Hi buddies,

    I tried making a simple CDF report, and loaded a single component; in template.html

    the component is regionSelect [Select]

                        regionSelect = 
                               name: "regionSelect",
                               type: "select",
                               valueAsId: true,
                               htmlObject: "regionSelect_object",
                               queryDefinition: {
                                  queryType: "mdx",
                                  jndi: "cncitidsa",
                                  catalog: "solution:/demo/Schema2.xml",
                                  query: function(){
                                       var query = "select NON EMPTY {[Measures].[Leads], [Measures].[Conversion]} ON COLUMNS, NON EMPTY Hierarchize(Union({([city.all Cities].[All city.all Citiess], [Cards.All Cards].[All Cards.All Cardss], [Time.Years].[All Time.Yearss], [Channel.Channels].[All Channel.Channelss], [Agency.Agencies].[All Agency.Agenciess])}, Crossjoin([city.all Cities].[All city.all Citiess].Children, {([Cards.All Cards].[All Cards.All Cardss], [Time.Years].[All Time.Yearss], [Channel.Channels].[All Channel.Channelss], [Agency.Agencies].[All Agency.Agenciess])}))) ON ROWS From [cubeCiti]";
                                       return query;
                               executeAtStart: true,
                          initialRegionSelect = Dashboards.clone(regionSelect);
                          initialRegionSelect.postExecution = function(){Dashboards.processChange(;};   
    // These are the components to be loaded into the dashboard within the [] separated by 
                        var components = [regionSelect];
                        // The initial dashboard load function definition
                        function load()
                        // The initial dashboard load function execution
    i find out that the data retrieves and the system shows the a busy processing sign which does'nt goes away; and have to stop it manually.

    any thing where my code is going wrong? how should i solve ?
    please suggest its urgent.

    i have added my html file (in form of txt) please check.
    Attached Files Attached Files
    Last edited by atuldarne; 03-08-2011 at 02:51 AM. Reason: Adding the html file
    Atul Darne.

Tags for this Thread

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.