Question:
Hi all,
We are in BW 3.5 and we need to calculate the number of days in a month in
the query for us to derive other key figures (calculated). Is there a way to
do derive the number of days in month based on every fiscal period in the
report? Eg. See below :
I have a report runs from Fiscal Year/period : 001.2002 to 012.2002
Therefore the query report should show as below :
Fiscal Year/Period No Days in Month
001.2002 31
002.2002 28
003.2002 30
.... ...
012.2002 31
I was thinking of using the variables definition in the query but this
variable definition will produce only one set of value only as this exit
does not pass for every records. Eg. As below if I use variable for multiple
periods. Basically this variable will be useful if the report only run for
ONE range of dates or only for ONE period(month).
Fiscal Year/Period No days in month
001.2002 31
002.2002 31
003.2002 31
....
012.2002 31
Can't use virtual key figure as well as it cannot read from time dimension.
Thanks for your help.
Answer:
Create a characteristic as CHAR 6, add it to the cube, in the update rules move 0FISCPER to it, then use it in a virtual key figure.
_________________
Leandro,
Tuly Idiots Shadow Supporter