|
The Adapter for Microsoft® SQL Server® Analysis Services Tabular Data Model provides access to Analysis Services data sources that are deployed using the Microsoft SQL Server Analysis Services Tabular protocol, whose underlying architecture is an in-memory columnar database. The main metadata object of a Tabular database is a Model, which is a set of joined tables. A Perspective is a subset of a model.
Note that the Adapter for Microsoft SQL Server Analysis Services Tabular Data Model is for use only with Analysis Services data sources that are deployed in tabular mode. For access to Analysis Services data sources that are deployed in Multidimensional mode, use the Adapter for SQL Server Analysis Services (SSAS) available in prior releases.
The underlying language, Data Analysis Expressions (DAX), is radically different from the Multidimensional Expressions (MDX) language used with the multidimensional model.
Data within the model is not pre-aggregated, as it is with the multidimensional cube. A tabular model always contains tables and columns, while OLAP elements (such as measures, KPIs, and hierarchies) are optional. When you generate a synonym for a tabular model or perspective, the synonym describes tables as segments and columns (as well as optional measures and KPIs) as fields. If the model contains hierarchies, their structure is reflected in the synonym by properly organizing the fields that describe hierarchy levels. WebFOCUS requests against these synonyms are similar to requests against a relational data source in the sense that DAX queries generated by the adapter reference tables and columns rather than cubes and their OLAP elements (such as dimension attributes), and data selection is expressed in terms of filter predicates rather than sets of dimension members.
| WebFOCUS | |
|
Feedback |