Skip to Content
0
Apr 22, 2014 at 07:19 AM

How to merge calendar month dimension on dashboard??

95 Views

Hi All

can anyone get me solution for below issue?

Report : Vendor Performance

Reporting tool : Dashboard

Selection : Vendor1

Requirement : Should show the report as you see in pic 1

1. I have three different KPI's which has to be shown in same table like u see in Pic 1 and each KPI values comes from different queries.

2. When i map this data to excel i am getting values as you see in Pic 2, Pic 3 and Pic 4.

3. if you see Pic 1 (data comes from query 1) there is data for JAN where as we dont have JAN data for Pic 2( or query 2).

Now my question is how we can combine all this values as we see in Pic 1?.. I need all values to be shown for respective month. for example if there is no data for march and it should be blank.

Can it be done on BW side if not in BO?\

Note : I am able to done this on webi report by merging calendar month for all three query.

Thanks in advance

Attachments

Untitled.png (15.7 kB)