Calculating forecasted averages

[Radhika]

Hi All,
We have a cube which has four dimensions

Mode: Period, YTD, 4 Week Average, 26 Week Average
Week: 2012 - 2012w01, 2012w02 ...2012w52, 2013-2013wo1,2013w02
DimX: Total - Sub A:Leaf1,Leaf2..Leaf4, Sub B:Leaf5,Leaf6,Leaf7
Measure:Value 1, Value 2, Calc 1

The data is loaded in the cube

1 Period, 2012w01, Leaf 1, Value 1
2 Period, 2012w02, Leaf 1, Value 1
3 Period, 2012w03, Leaf 1, Value 1
52 Period, 2012w52, Leaf 1, Value 1
53 Period, 2013w01, Leaf 1, Value 1
54 Period, 2013w02, Leaf 1, Value 1
. . .
104 Period, 2013w52, Leaf 1, Value 1
2 Period, 2012w01, Leaf 2, Value 1
4 Period, 2012w02, Leaf 2, Value 1

Etc.

3 Period, 2012w01, Leaf 3, Value 1
6 Period, 2012w02, Leaf 3, Value 1
Etc.

Can you please help me to write a script which create a 4 week moving average for every 2013 week as in the following example:

(4 Week Average,2013w02)

=((Period,2012w51)+(Period,2012w52)+(Period,2013w01)+(Period,2013w02))/4

Thank You,
Radhika

[lotsaram]

To start with you need at minimum ytd, 4 week rolling and 26 week rolling consolidations in your week dimension. There is also the issue of feeding the calculations in the mode dimension which in this case could also be "fed" by being consolidations of period or could be fed by regular feeders.

If you want any further assistance please provide screenshots of the structure of the 2 dimensions above and the REAL code (not pseudo code) of what you have actually attempted.

[Radhika]

Hi Lotsaram,
Thank You for your response.

The code has been attached for your reference. Please guide me.

Thank You,
Radhika

[lotsaram]

The code has been attached for your reference. Please guide me.

It has been explained many times before so I don't know why I need to go through it again but the admins, MVPs and other users offering advice are not paid for the service and are doing so in their own time (not to mention the supposition that many of the people asking for help are "consultants" working for companies undercutting the rates of the genuine experts to customers who are none the wiser as to the quality of the services the are receiving.) So please if you have questions then follow the request for assistance guidelines and any additional requests. You were asked to provide some dimension structure screenhots and the rules you had written. What you attached was an archive file of (incomplete) data directory extracts. To view the dimension structure it would be necessary to download the file, decompress it and load as a local TM1 server. In my books that's not exactly making it easy for anyone to help you out. I'll leave it at that.