How to generate a combination , with different year.

[Former Member]

Hi All,

I have a requirement , were in i need to generate a combination in such a way tht,

for a combination of { brand, unit, 2008, volume}

need to generate a combination { brand, unit, 2009, volume}

{brand, unit, 2010, volume}.

i have only 2008 data in my cube, by creating an input ready query on this, i must be able to enter the values into the cube ,even for 2009 n 2010.

Please let me know how to achieve this.

Thanks & Regards,

Priya.

[Former Member]

Hello Priya,

Just create simple planning function COPY to generate the values for 2009 and 2010.

Just follow the steps as usual for creting planning function

specify how characterstics are used , select fiscal year as fileds to ba changed

and in the parameter set enter from value 2008 to to value 2009

from value 2009 to to value 2010.

this is best way to generate data for new combnations.

Further if you wnat u can create Inpuet ready querys based on ur client requirement.

I hoep this will help you to generate combinations for 2009 and 2010.

Best regards

SS

[former_member212742]

HI,

this can be easily solved through Input ready query :

Create a input ready query and 3 restricted KF. restric each of them with char to make it input ready. for the restriction of the Fiscal year use the variable which u use it in the variable screen for the first restricted KF.For the second and third use offset to increment the variable value as +1 and +2.

So if the user enters data in the three KF it gets saved as three different records one for each fiscal year.

Regards.

Shafi.

[Former Member]

You can copy 2008 data to 2009 & 2010 using simple copy function and create an input ready query where user can enter plan data based on year. If you are using WAD to create user interface you can call the copy function just before the query gets displayed if you want to perform automatic copy and doesn't want user to click on button to trigger the copy function.

[Former Member]

Hi,

scenario A: Manual input: Generate a query which contains 2008, 2009, 2010 fiscal years in the restriction and in which you show all possible combinations. Then you can manually input those years.

scenario B: You generate 2009 and 2010 out of 2008. You can either run a COPY function from 2008 to 2009 and 2010 or you apply more complex logic using FOX, e.g. by applying some increase ratio.

Which way you want to go?

Regards,

Andreas