Time Dimension

[Former Member]

Hi,

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

Thanks

Naharaajan

[Former Member · Accepted solution]

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

Srini

[Former Member · Accepted solution]

Hi Srini,

Thanks for your help. Your explanation was very helpful.

Thanks

Murali

[former_member242420]

Hi,

In sap BW Keyfigures will not be assigned to any dimension. All keyfigures are in Fact table.

You can write a formula to substract two KF dates and get your number of days from request to actual shipping.

OR

You can create them as Date characteristics and add them to time dimension. Here you can create Cal Key figure to substract two KF dates and get your number of days from request to actual shipping.

Hope this helps..

vamsi.