Strategy ONE

Relating Objects from Analysis Services to Strategy

Microsoft Analysis Services 2012, 2014, 2016, 2017, 2019 and Azure (Analysis Services 2012/2014/2016/2017/2019/Azure) has a unique modeling approach for building cubes.

The translation process involves the following steps:

  1. From Analysis Services 2012/2014/2016/2017/2019/Azure to XMLA: Analysis Services 2012/2014/2016/2017/2019/Azure exposes cubes through the XMLA model, which is derived from the ODBO model. XMLA defines an object model that is used in conjunction with MDX to query cubes.
  2. From XMLA to Strategy: After Analysis Services 2012/2014/2016/2017/2019/Azure objects are translated into the XMLA model, they are translated into the Strategy metadata model. You can then interact with Analysis Services 2012/2014/2016/2017/2019/Azure content while working within the paradigm that is consistent with the rest of Strategy's products.

This diagram shows how Analysis Services 2012/2014/2016/2017/2019/Azure objects are exposed in XMLA and then how they are related to objects in the Strategyenvironment.

The process for each Analysis Services object is described in the following topics: