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]

    Code:
                    
                        regionSelect = 
                          {
                               name: "regionSelect",
                               type: "select",
                               parameter:"region",
                               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,
                               postExecution:function(){buildToolTip(initialRegionSelect);}
                          }
                          initialRegionSelect = Dashboards.clone(regionSelect);
                          initialRegionSelect.postExecution = function(){Dashboards.processChange(this.name);};   
                        
                        
    // 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()
                        {
                            Dashboards.init(components);
                        }
    
                        // The initial dashboard load function execution
                        load();
    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
    Regards,
    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.