Dashboard Report

[phanicrn]

Hi All

I am creating a dashboard report, with two list and combination chart.

In Query 1  I have the following fields and i am using two filters

Member_active ='1' and Date prompt filter..

Product type
Product Group
Product Code
Account Balance
Member Active


In Query 2 Iam using one filter to get all Active member

Product Type
Product Group
Product Code
Account Balance
Member_Active


Query 1 display data for selected date,how many member are active and account balance.

query 2 display data for all members who are active and their account balance

Now in combination chart, i want show both the query1.account balance and query2.account balance.. and i am using combination chart..

If i do union on both queries. i am only getting quer2 result. query 1 is missing.  now how do i get query1.acccount balance in the chart


comination charts

Measure-- Query1.account balance

Categroy--Product Type,

Series, query2.account balance
product group, product code.


Now when i run the report, i am getting a crossproduct join error, now who do i resolve this issue..

Help me guys..


Thanks
Phani

[phanicrn]

Problem Solved.

I used paramters  value to get  the information..

[MDXpressor]

Thank you for taking the time to post your solution.