Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho CDF Reporting

  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.

  2. #2

    Default

    Hi Adul Dame,

    delete the line
    Code:
    postExecution:function(){buildToolTip(initialRegionSelect);}
    and don't forget to delete the comma in the previous line by "executeAtStart:true"

    Then try it again.

    For your info - I've changed your code like the following code - and it works:
    Code:
         var region;
         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;
    //           }
    //         },
             valuesArray:[["1","Lisbon"],["2","Berlin"]],
             executeAtStart: true         
           };
     
         var components = [regionSelect];
         // The initial dashboard load function definition
         function load()
         {
          Dashboards.init(components);
         }
         // The initial dashboard load function execution
         load();

    Greetings
    neckit
    Last edited by neckit; 03-08-2011 at 11:44 AM. Reason: edit

  3. #3

    Default

    thanks a lot neckit.

    I have done the changes according to you. it works good now. do you have any idea about fusion plugins and integrating them into CDF ?
    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.