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

Related questions

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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.