Example of add dimension promotion code

  1. Search table coitem_mst which include column promotion_code in “All Cube” sheet “Cube Dim Raw Data.xls”, get cube information (Cube Sales Product Contribution Analysis).
  2. In extension space load promotion_code_mst data from Data Lake or SQL or other source.

    If it is from the Data Lake:

    1. Add Data Lake column after you create the query-based object in connect VariationNumber,DLDeleteIndicator,lastModified, and criteria “Where lastModified >='V{InforCSIPromotionCodeLastExtractDate}'” added after variable {InforCSIPromotionCodeLastExtractDate} is created.
    2. Add logic, making sure the time converts to local time.
    3. Add the delete logic.
    4. Add hierarchy and gain, then publish.
    5. Add CSI_Promotion_Code lastmodified to source InforCSILastExtractDate.
    6. Add new variable, then publish.
    7. Add dimension source.

      If it is from other sources, you only need to add hierarchy and gain in dimension, then publish and add source to dimension package.

  3. In ConformedDimension space:
    • Add this join to a new dimension - join [Level(Src BI link site info.Src BI link site info)]
    • Add hierarchy and gain.
    • Publish.
    • Add new Dimension to package.
  4. In Sales Model space, Dim price promotion is loaded from ConformedDimension space and does not need to be changed. Add the column promotion code Cube Sales Product Contribution Analysis. Follow this code map:

    Code Map2

    1. View Coitem add new column promotion code.
    2. Cube Base Sales Product Contribution Analysis add column promotion code
    3. Cube Sales Product Contribution Analysis add column promotion code.
    4. Edit hierarchy Cube Sales Product Contribution Analysis add column promotion code.
    5. Publish changes and ensure there are no errors.
    6. Add change to package.