Best Design of an Essbase cube

Summary

Best Design of an Essbase cube

Content

Hi Gurus,

Could you please shed your thoughts on this:

Requirement:

Analyse budget data based on Region(E.g Central and Brand (1 or 2):

Say If i want to analyse Central Region of Band 1 how do i achieve ( since they Regions  are  same  for both bands)?

Dimensions planed :

Year

2017

2018

Period

January to Dec

Scenario

Budget ( only)

Reference:

Stakes

Free-bets

Gross Win

Stakes%

Free-bets%

Gross Win%

Products:

                Games

                             Cards

                Sports

                              Football

Shops:

             Brand1

                               UK

                                      London

                                                   Central

                                                               Shop 1

                                                               Shop 2

                                                   East

                                                              Shop 3

                                                              Shop 4

                                                   West

                                                              Shop 5

                                                              Shop 6

                                                   South

                                                              Shop 7

                                                              Shop 8

         Brand 2   

                               UK

                                     London   

                                                   Central

                                                               Shop 11

                                                               Shop 12

                                                   East