Post reply

Many Products on Many Promotions Problem...

  • December 6, 2015 at 3:52 pm

    #145785

    Hi

    I'm struggling to find a way of quickly selecting promoted products within a promotion for pre and post promotion analysis within my SSAS cube.

    I have the following excerpt from my fact table:

    PK SalesRecordID

    FK CustomerNo

    FK ProductCode

    FK DateKey

    PromotionNumber (line stamp from EPOS)

    QtySold

    My promotion table looks like:

    PK PromotionLineID

    PromotionNumber

    FK ProductCode

    Date Validity From

    Date Validity To

    A promotion is assigned a unique number and can have many products on it. A product can appear on more than one promotion and this is causing the problems.

    What I need is a way of selecting a promotional offer (and its products) to review it's performance pre and during the promotion. If I select only the transactions stamped with the offer number I lose the pre-promotional performance.

    I have tried referenced links but to no avail and named sets does not seem to be the correct solution for over 1000 promotions?

    Any help would be greatly appreciated!

    Thanks

    Adrian

  • December 8, 2015 at 2:21 am

    #1844581

    Hi, are you asking how to model this, how to set it up in SSAS or how to write MDX to achieve this? 🙂

  • December 8, 2015 at 1:48 pm

    #1844772

    Dave Morrison (12/8/2015)

    Hi, are you asking how to model this, how to set it up in SSAS or how to write MDX to achieve this? 🙂

    Hi

    It's a modelling query I think, not sure how I should setup the cube and dimensions in a way that can achieve this? My users access these cubes via excel and it is a time consuming task for them to select each product one-by-one from a basic products dimension.

    Thanks

    Adrian

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply