Question & Answer
Question
Is SSAS Tabular Mode supported?
Answer
Current versions of Cognos software do not detect whether a Microsoft SQL Server Analysis Services (MSAS) cube is operating in Tabular Mode. The Cognos software will therefore not attenuate its query generation for Tabular Mode; all else equal the same MDX query statements will be generated regardless of whether the cube is in Tabular Mode or Multidimensional mode.
The queries that current versions of Cognos generate are attenuated for the Multidimensional Mode.
Tabular Mode supports most but not all of the types of queries that Multidimensional Mode does, so Cognos may send MSAS some queries that are not supported in Tabular Mode - these will typically cause the report at hand to error.
The queries that current versions of Cognos generate are attenuated for the Multidimensional Mode.
Tabular Mode supports most but not all of the types of queries that Multidimensional Mode does, so Cognos may send MSAS some queries that are not supported in Tabular Mode - these will typically cause the report at hand to error.
In order for SSAS Tabular model 2016 to work in Cognos Analytics 11.1.x, you must have at least one MDX Measure
MDX Building Measures
https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/mdx/mdx-building-measures?view=sql-server-2017
Microsoft have documented some of the constraints of Tabular Mode here:
https://msdn.microsoft.com/en-us/library/hh212940.aspx
Microsoft have documented some of the constraints of Tabular Mode here:
https://msdn.microsoft.com/en-us/library/hh212940.aspx
Related Information
[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
12 June 2019
UID
swg22014003