Question:
I know someone mentioned in this forum that date key figures couldn't be used in BPS.
However, that was some time ago, so, has that changed? Is there any trick to achieve it?
I have a requirement where users need to input a "Release Date" for a product, maybe you can think of a workaround.
Thank you for your help.
Answer:
date as key figure is still not available as of SEM-BW 3.20. We are now trying for work around and if we are successful, let me surely share...
Answer:
Surprise, surprise: I managed to use a date key figure in my layout!
You just need to create a key figure of type Date and data type DEC (instead of data type DATS).
It works nicely, but be careful with aggregation, though.
Answer:
Yes, it works.
Rgds
Answer:
Dear all
I also tried that ; indeed it works... and we needed to have a Date as 'ready for planning' key figure...
but challnege next would be to be able to use that "date" key figure in logical FOX formulas..!! would that be possible..??
pls do give a brief idea? (i ask this this ' date ' kf is stored as decimal(some strange number) in Infocube!! )
merci , ciao !!
sumeet
Answer:
hi
wasnt logged in.. at previous post..
regds
sumeet
_________________
____________________
Is it a good day !!??
Answer:
date as a key figure is stored as a number. I am not sure about its usage in Fox? but definetly it can be used in user exits. Here we have converted this number back to date and done some comparision with date type char.
DG
Answer:
well DG is right, its usage with FOX is limited... well in our case we need to calculate number of months diff. between current date (CD) and the Key figure date (KD).
since the date key figure(dec type) (KD in this example, gives us number of days (since 01.01.0001) so I stored another numeric contsnt as CD (days since 01.01.0001 using Func mod. - fima*days*months*..)
hence diff of CD & KD gave me # of days , and hence I got number of months also.
summary: if u need #of days as base of calculation logics . go in for Date KF (dec type) to be processd by FOX, else as DG suggests user exists are the only way out.
regds
sumeet