We are trying to migrate an existing ware house into SAP BI. The ware house deals with shipping releases and has two dates request_ship_date and actual_ship_date.
In our custom data ware house there was a time dimension table which was related to the fact table. The time dimension table was based on the day of the month.
In our SAP training we were told that SAP provides the Time dimension table and 0CalDay suited our requirement.
We have done the following
Created request_ship_date and actual_ship_date as key figures ( clicking on the time option provided) .
After activating the info cube these KPIs are not related to the time dimension table.
We are able to go into the Time characteristic and create a 0CalDay characteristic.
The question is how to we relate the dated based KPIs (request_ship_date and actual_ship_date) to the Time dimension.
We would like to execute queries for example the number of days from request to actual shipping.
Any help and reference to material will be helpful
Srinivas Neelam replied
Hi Naharaajan, Welcome to SDN.
As you created request_ship_date and actual_ship_date dates as keyfigures, you can use them to find out difference in query with reference to some other date(may be delivery creation date..!!, assigned to 0calday).
In this way, based on 0calday selection, you can find out difference deliveries variance(date diff).
In BW we can not create a time characteristic, but we can create a characteristics which represents date.
So in your case, take one of the dates(request_ship_date or actual_ship_date) as reference and assign to 0calday and use it for analysis/selection/restriction purpose.
Hope it Helps