Hi,
We have several Item codes from different manufacturers. Each of the item codes have different Introduction Month.
For ex: Item1 is introduced in Jan1995, Item2 in Feb2006 etc.
Every month we get the report for all the Item codes. Here is our reporting requirement.
(Initial 3 months from Intro month)
Item1 publisher1 quantity
Item2 publisher2 quantity
Any suggestions are greatly appreciated and rewarded.
Thanks,
Vish
Hi,
Create a variable with processing type Replacement path to hold the intro month
Create a retricted key figure for Quantity
Restrict that key figure with a range
The range should be between the variable you have created and the variable you have created +3 (this is done using Offset)
Hope it helps,
Gilad
Hi Gilad,
Thanks for the quick response. Can you please clarify more!
Create a variable with processing type Replacement path to hold the intro month
do you mean creating a variable on CalYear/Month which uses replacement path. Replacement path asks for query result..please clarify..How can I refer it to the Intro Month which is defined as a characteristic in the Cube.
Thanks,
Vish
Add a comment