Customer Exit Varable

[Former Member]

I'm having material with release date as attribute.

The keyfigures in my cube are based on CalMonth for the materials.

In my query I need to display the keyfigure for the material for the Calmonth derived from the releasedate of the material.

I restricted the kf by a variable for CalMonth. Please guide me how I can derive the CalMonth from release date. I guess I have to use a Customer Exit on CalMonth...read the 0MATERIAL to get the release date for that material and convert it to Month.

Any suggestions for the coding would be helpful.

Thanks,

Vish

[former_member188975 · Accepted solution]

Hi Vish,

If the Release Date is a navigational attribute of 0MATERIAL, then you can include this in the InfoProvider (check it on as nav) and then add it to your query and restrict Release Date with a variable directly.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu,

Thanks for the reply. I did that.

What we want is the kf for the release date month and kf for the release date month -1, kf for the release date month - 2 and so on.

Ex: if the release date is 09/01/2007, we want the key figures for months 09, 10 11 and so on.

Any help is greatly appreciated. I will assign the points.

Thanks,

Vish

[Former Member · Accepted solution]

Vish,

One possible solution is virtual key figure. Check out the following discussion.

you can find a lot of stuff on virtual key figure on sdn.

-Saket

[Former Member · Accepted solution]

Virtual Keyfigures - Worked