Skip to Content
author's profile photo Former Member
Former Member

Initial 3 months quantities

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 07:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 08:42 PM

    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 comment
    10|10000 characters needed characters exceeded