Forum Discussion

aignn's avatar
aignn
Helper II
6 years ago

AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr'

Hi!   I try get data from Analysis Services by query and i get this error: AnalysisServices: The type initializer for 'Microsoft.AnalysisServices.AdomdClient.NamespacesMgr' threw an exception.   ...
Need Help
aignn's avatar
aignn
Helper II
6 years ago

mwegener 

No problem:

 

SELECT {[Measures].[Completed]} ON 0,
    NON EMPTY CrossJoin(
	    Hierarchize([Work Item Tree].[Work Item Tree Hierarchy].Members),
        [Work Item].[System_Id].[System_Id],
        [Work Item].[System_Title].[System_Title],       
        [Work Item].[System_AssignedTo].[System_AssignedTo],
        [Work Item].[System_State].[System_State]
    ) ON 1
 FROM [Teams]
WHERE ([Date].[Year - Month - Date Hierarchy].[Month].&[2019-11-01T00:00:00])
mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi aignn 

 

did you solve your problem?


If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.