What do u mean by Date analysis

[Former Member]

Hi Gurus,

What do u mean by the driving date of your analysis in the Info Cube???I have a bunch of dates as charachteristics in my infocube..........and i can use them all in analyzing my data........

[Former Member · Accepted solution]

Hi Southie,

You are right..you can use all the dates for analysis of the data for a date range..

But in general ..when we mention the driving date ..its the way you want to look at the data..

For EG: A document posted in FI has a lot of dates ..

The user might want to look at reports by the Posting date Fiscal year Period ..when he is analysing expenses..

Or when he wants to analyse Approvals..his driving date is Approval date..

Normally the driving date is mapped to all other time characteristics in the cube..

Hope it helps..

Ashish..

[Former Member · Accepted solution]

Hi Southie,

as you can understand, a "driving date", that is a relevant date from a reporting point of view, is a peculiar functional concept (that, in a secon step, requires some technical/modeling choice in your BW).

In other words, when you build a cube you have to select FOR EVERY KF a reference date...since there is not a simple reference date (even if you can set your situation in such way), but you can decide (in accordance to your business requirements) that your "delivered qty" has the delivery date as reference and, at the same time and in the same cube, the order qty with order creation date...

Hope now is clearer...

Bye,

Roberto

[Former Member · Accepted solution]

HI Roberto and Ashish,

Thanks for your replies. In my Cube i have 3 dates in 3 seperate dimenstions, the created on date, Actual GI date and Planned Ship date....the users want to do the analysis by order created date........does this mean that all my KF's have to reference to this date to satisfy the functionality??? will this solve the problem???

Thank You,

Southie

[Former Member · Accepted solution]

This means that yuo have to:

1) map every time reference in your cube (0CALDAY, CALMONTH, FISCPER and so on...) with your order creation date and

2) execute this mapping for every KF (for each row of your update rules)

That's all!

Bye,

Roberto

[Former Member · Accepted solution]

Since the users want to analyze the data with respect to create date..It would be helpful if you map the create on date to the other time characteristics in your cube..

eg: 0CALDAY,Fiscal Year, FY Period, 0CALMONTH..whatever you will be using for analysis..

<i>does this mean that all my KF's have to reference to this date to satisfy the functionality???</i>

what did you mean by KF`s have to reference..

Ashish..

[Former Member · Accepted solution]

Ashish,

Roberto was suggesting that i map every KF to the time charachteristic in the Update rules..........please read his reply above, thats what i meant..........

Thanks

[Former Member · Accepted solution]

Got it Southie..thanks..

Good that your problem is solved..

Ashish..

[Former Member · Accepted solution]

Hi Roberto,

I understand the first step and know how to do the mapping of created on date to the time charchteristics, but how will u map each KF to created on date in the update rules???? Sorry for frustrating questions...i am a novice in this field and i am only learning.........And u and Ashish and a lot of other Gurus are helping me out in a unimaginable way......

Thank You

Southie

[Former Member · Accepted solution]

It's enough to click YES on the pop-up that appears after you assign a char to a time reference "Do you want to transfer this mapping to every KF ?" or something similar...

otherwise you can always do it manually row by row (but with no doubt is more confortable the first option !!

Bye,

Roberto