Budget allocation

Hi Gurus,

Scenario: Load shop level budget at babase and  month level and allocate/distribute to day level  using percentages loaded at regional level

Dimensions:

Reference Dense

Period dense

Report year Spars

Scenario Sparse

Division Sparse

Reference

             UK Games - (4169)                                                                            

                Revenue                                                                             

                Expenses                                                                            

                GW

             UK_Games_Percentages                                                               

                Revnue%                                                                            

                Expenses%                                                                        

                GW%                                                                                    

                                                                                               

Period:                                                                                

                Jan

                               20170101

                                    ¦

                               20170131

               Feb            

               Dec

Year:

        Y2017 to Y2020

Scenario                                                                                              

                Budget

                                  BABase              

  Division

             EM Coral (East midlands Coral)

                                                              EM1 Coral Racing Ltd   

                                                                                                   Shop1074

                                                                                                   Shop1078

Step(1) Load shop level budget at babase and  month level

Lock&Send

                                    UK Games - (4169)

                                     Y2017

                                     BABase

                                     Jan

                     C1074    100

                     C1078    200

Step2: Lock&Send - Load “UK_Games_Percentages” at EM Coral (regional level ) for all the dates ( 1