Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Unable to pass parameters in measures level.

  1. #1
    Join Date
    Oct 2014
    Posts
    13

    Default Unable to pass parameters in measures level.

    Hi,

    I am trying to show a pie chart for day wise as 3 measures like power consumption,production and feed size this one fine.

    i have created a ccc pie chart of 3 measures like power consumption,production and Specific Energy Consumption for day wise in my dashboard its working fine but i am facing a problem to show the data of individual measures using bar chart as popup component by clicking on power consumption measures its show the hour wise data .

    And i used a mdx queries:
    1.For pie chart query:
    SELECT
    NON EMPTY {Hierarchize({[Department.All].[Limestone Crusher]})} ON COLUMNS,
    NON EMPTY {Hierarchize({{[Measures].[Power Consumption(kWh)], [Measures].[Production(Tons)], [Measures].[Specific Energy Consumption]}})} ON ROWS
    FROM [Cement_Analyser]
    WHERE {[Date.All].[Day].Members}

    Click Action:
    function f1(s,c,v){

    //this.chartDefinition.title = Dashboards.getParameterValue("dprtmnt");
    alert(s.format("{series}"));
    Dashboards.fireChange('dprtmnt',s.format("{series}"));
    alert("you have clicked on"+" "+dprtmnt)
    render_pop1.popup($(this.event.target));
    //alert(dprtmnt);
    }




    2.For popup component query:
    SELECT
    NON EMPTY {Hierarchize({{[Measures].[Power Consumption(kWh)], [Measures].[Production(Tons)], [Measures].[Specific Energy Consumption]}})} ON COLUMNS,
    NON EMPTY {Hierarchize({[Time.All].[Hour].Members})} ON ROWS
    FROM [Cement_Analyser]
    WHERE CrossJoin([Date.All].[Day].Members, {[Department.All].[Limestone Crusher]})

    How i can achieved this .can anyone help me to solve my problem.
    Attached Images Attached Images  

  2. #2
    Join Date
    Oct 2014
    Posts
    13

    Default Unable to pass parameters in measures level.

    Hi,

    i have created a ccc pie chart of 3 measures like power consumption,production ans specific energy consumption for day wise in my dashboard its working fine but i am facing a problem to show the data of individual measures as popup component by click action for hour wise.

    If am click an power consumption then i want show a hour wise consumption and click an production then show a hour wise production data like wise i want show all measures.
    and m using a mondarian mdx queries.
    1.
    SELECT
    NON EMPTY {Hierarchize({[Department.All].[Limestone Crusher]})} ON COLUMNS,
    NON EMPTY {Hierarchize({{[Measures].[Power Consumption(kWh)], [Measures].[Production(Tons)], [Measures].[Specific Energy Consumption]}})} ON ROWS
    FROM [Cement_Analyser]
    WHERE {[Date.All].[Day].Members}
    Click Action:
    function f1(s,c,v){

    //this.chartDefinition.title = Dashboards.getParameterValue("dprtmnt");
    alert(s.format("{series}"));
    Dashboards.fireChange('dprtmnt',s.format("{series}"));
    alert("you have clicked on"+" "+dprtmnt)
    render_pop1.popup($(this.event.target));
    //alert(dprtmnt);
    }

    2.Query for click action component:

    SELECT
    NON EMPTY {Hierarchize({{[Measures].[Power Consumption(kWh)], [Measures].[Production(Tons)], [Measures].[Specific Energy Consumption]}})} ON COLUMNS,
    NON EMPTY {Hierarchize({[Time.All].[Hour].Members})} ON ROWS
    FROM [Cement_Analyser]
    WHERE CrossJoin({[Department.All].[Limestone Crusher]}, {[Date.All].[2017].[2017-05].[2017-05-18]})
    Attached Images Attached Images  

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.