Page Comparison

Info
Prerequisite All information in this page is conditional upon the following setting in the CXO Configurator: In previous versions, this setting only applied to SSAS Multidimensional Models. In the current version it also applies to Tabular Models.

Meta-data retrieval

...

Dimensional Models

For Multidimendional Multidimensional models:

...

the dimension-mapping usually looks like:

...

Based on this specification, in case a meta-data refresh is requested the following MDX query is being excuted executed for the Account dimension:

WITH MEMBER [Measures].[__CXO&MD_Id] AS [ACC].[ACC].CURRENTMEMBER.Name
MEMBER [Measures].[__CXO&MD_Name] AS [ACC].[ACC].CURRENTMEMBER.Name
MEMBER [Measures].[__CXO&MD_Parent] AS [ACC].[ACC].CURRENTMEMBER.PARENT.Name
MEMBER [Measures].[__CXO&MD_DESCR] AS [ACC].[ACC].CURRENTMEMBER.PROPERTIES("Language1")
SELECT {
[Measures].[__CXO&MD_Id], [Measures].[__CXO&MD_Name],
[Measures].[__CXO&MD_Parent], [Measures].[__CXO&MD_DESCR]
}
ON COLUMNS,
[ACC].[ACC].ALLMEMBERS ON ROWS
FROM [CXO]

...

Meta-data retrieval Tabular Models

For Tanbular Tabular Models:

...

The dimension mapping looks like:

...

As you can see, only 3 columns are rerieved retrieved and [Measures].[__CXO&MD_DESCR] is omitted, because we cannot retrieve it from the current hierarchy ([ACC]).

...