Skip to Content
0
Former Member
Jan 14, 2011 at 09:44 AM

Comparing different date characteristics

35 Views

Hi All,

I have a report where I want the date running down the left and comparing different keyfigures across the top.

For Example:

I want to see days running down and value for Order Qty, Expect Delivery Qty and Actual Delivery Qty on each line for the relevant date.

The data for Order, Expected Delivery and Actual Delivery are all in different InfoCubes and joined by Mulitprovider.

The issue is that the dates in each cube are in a different characteristic field, so how do I align them within the report?

Order Cube

-OrderDate

-OrderQty

Expected Cube

-AvailableDate

-ExpectDelQty

Actual Cube

-CalDate

-ActualQty

Please let me know how to show these different keyfigures all relative to a single date.

Thanks,

Terrence