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.