I have two cubes: invoice_ship_date and invoice_request_date
The $ amount in invoice_ship_date cube is based on the shipments date. The $
amount in invoice_request_date is based on the date that the sales order was
requested by our customer. For exampl,

A sales order $1000 was requested in August but didn't ship until
Septmember. It's in October now. If I filter in August, I would see $1000
show up in the invoice_request_date cube but NOT in the invoice_ship_date
cube...

The invoice_ship_date cube doesn't care when the sales order was requested,
the invoice_request_date cube does't care when the products were shipped.

If I want to see the $ that were quested for August and also were shipped in
August, how do I do that? Is it possible from what I have?

Yes its possible.
You need to put both dimensions into the same cube and then plot your facts
against both.

I presume that at the moment you are using the same Time dimension in both
cubes and that you are joining them in a virtual cube. This won't work
because if you slice your time dimension by August then you will only see
facts that occured in August.

Basically...you need 2 time dimensions!

Regards
Jamie Thomson


"christy" wrote:

Sounds like a good plan. I have only one shared time dimension. How do I
create two time dimensions in the virture cube?


Jamie wrote:

Just create 2 normal dimensions as you would normally and add them to your
virtual cube as you would normally.

It may be that you don't even need a virtual cube actually. Both time
dimensions can go in 1 cube.



"christy" wrote: