Hi - I have a Sales Cube with the Time characteristic based on "Sales document Create date" and the Delivery Cube has the time characteristic based on the "Delivery Document Create Date". When I am making a Multiprovider out of both cubes, since the time dimension is not the same I can only see data out of one cube when I use Fiscal Year/period as a filter in the query.
Has anyone come across this issue? When creating Multiprovider out of sales and delivery what date have you based the time characteristic out of in both the cubes?
Appreciate any input you can provide.