Daily Budget Distribution

HI Essbase gurus,

We have a scenario where monthly budget is loaded at regional level say (LondonArea1 Coral) and month level January with percentages - Freebets_Percentages so that       .

Could you please help in designing calc script so that Freebets at month level is distributed to  all the  dates and base companies.

Please find the attached sample template.

Dimensions:

1)Reference(Accounts)

                        Freebets

                        Stakes

                        GrossWin

                        Freebets_Percentages

                        Stakes_Percentages

                        GrossWin_Percentages

                       

2) Year

2017

3) Period

          Jan

                 01-01-2017

                 02-01-2017

                     -

                     -

                  31-01-2017

4)Scenario

                BABase

5)Products

      Gaming

                    FOBT_Cards

      Sports

                    OTC_FOOTBALL

6)Region

               Coral

                                    UK

                                            London

                                                          LN1 Coral

                                                                            C1001

                                                                            C1002

              Ladbrokes

                                   UK

                                           London

                                                         LN1 Ladbrokes