10:45 AM Sunday Room: PSEC4502
Compare and contrast how multidimensional and tabular models achieve the same result in quite different ways. You’ll learn where multidimensional decorates the metadata of the model, while tabular offloads responsibility to DAX. You will also see how the design goals of the DAX language – which are akin to Excel formulas and relational-database concepts – differ from MDX and traditional OLAP. In addition, the session discusses the benefits of database compare for SSAS tabular models.
Many of the code samples are for currency conversion, but techniques can be used in a broad range of scenarios (not only currency conversion), adding valuable knowledge to your SSAS arsenal. The demo content also covers BISM Normalizer, which is a free tool developed by the SQL community for the SQL community.