Home Forums Data Warehousing Strategies and Ideas Capturing the Reason For Change for Type 2 changes RE: Capturing the Reason For Change for Type 2 changes

  • March 3, 2014 at 7:08 am

    #1693545

    EricEyster (3/3/2014)

    ... but the Kimball design assumes your users are getting data from the relational engine.

    I disagree with that statement. Sure, the relational data warehouse containing the dimension and fact tables is what the multidimensonal Measures and Dimensions (i.e. Cubes)are built on, but users query the data stored in Cubes directly from SSAS whether that be via Excel (pivot tables), PowerView/PowerPivot, MDX queries, SSRS or third party products.