Skip to Content
0
Former Member
Jul 26, 2009 at 08:29 PM

Multiple queries/Merged dimension dispalying data in report

52 Views

Hi All,

I am using BOXI 3.1, In my report i have 2 queries both are using the same universe. First query will return data for current date and second query return for previous date. This is the only diffrence between 2 query apart from this it has same number of objects and filters.

I am doing merge dimension on basis of Transaction number, so the report need to display only those transaction number which is present today and yesterday.

Now i need to display the data in report such that 1st row will dispaly data for current date and second row will display data for previous date so user can compare the data for same transaction number.

Now when i drag transaction number and measure objects from query1 and same from measure from query2 below (i.e. second row) it display data perfactly but when i drag dimension objects whose values are diffrent for both days the report displays 4 rows instead of 2 rows. It multiplied the rows.(If dismension value is same then its working fine).

Can anyone please tell me how to display the data for 2 days one below other with dimension values are diffrent.

Thanks for the help.