Server Internal error: An unexpected exception occured in MDX Query

Question

Hello everybody,

maybe i can find help here for my MDX Problem.
When i run an MDX Query using Functions like "Space()" or "Format()" i get an Error Message:

"Server Internal error: An unexpected exception occured."

here are some examples of queries, where these errors happen:

With   


MEMBER [Measures].[ParameterCaption] AS '[Client Service].[Client Service].CURRENTMEMBER.MEMBER_CAPTION'  
MEMBER [Measures].[ParameterValue] AS '[Client Service].[Client Service].CURRENTMEMBER.UNIQUENAME'  
MEMBER [Measures].[ParameterLevel] AS '[Client Service].[Client Service].CURRENTMEMBER.LEVEL.ORDINAL'  
MEMBER [Measures].[ParameterHierarchy] AS Space(4*([Measures].[ParameterLevel]-1)) + [Measures].[ParameterCaption] --Error with Space Function. When the Space Function is removed, the query works fine.  

SELECT (  
      EXCEPT( {[Client Service].[Client Service].Members}, {[Client Service].[Client Service].[All],[Client Service].[Client Service].&[0], [Client Service].[Client Service].&[-19351400].DATAMEMBER})  


) ON ROWS  
, {   

[Measures].[ParameterCaption]  
,[Measures].[ParameterValue]  
,[Measures].[ParameterLevel]  
,[Measures].[ParameterHierarchy]  

} ON COLUMNS  
FROM(  
       SELECT(  
       [Client Service].[Client Service].&[-19351400]  



       ) ON COLUMNS  
       FROM  
             [CS UDWH]  

)  

or

With  
MEMBER [Measures].[ParameterCaption] as   
--CASE @TimeScope  
CASE "ymd"  
   WHEN "ym" THEN [Date].[Year].CurrentMember.Name    
   WHEN "yw" THEN [Date].[Year].CurrentMember.Name       
   WHEN "ymd" THEN [Date].[Year Month].CurrentMember.Name    
   WHEN "ywd" THEN [Date].[Year Week].CurrentMember.Name   
   WHEN "di60" THEN [Date].[Date].CurrentMember.Name   
   WHEN "di30" THEN [Date].[Date].CurrentMember.Name   
   WHEN "di15" THEN [Date].[Date].CurrentMember.Name   
   WHEN "ymdi15" THEN [Date].[Year Month].CurrentMember.Name    --NEW  
   WHEN "ymdi30" THEN [Date].[Year Month].CurrentMember.Name    --NEW  
   WHEN "ymdi60" THEN [Date].[Year Month].CurrentMember.Name    --NEW  
   WHEN "wi15" THEN [Date].[Year Week].CurrentMember.Name  --NEW  
   WHEN "wi30" THEN [Date].[Year Week].CurrentMember.Name  --NEW  
   WHEN "wi60" THEN [Date].[Year Week].CurrentMember.Name   
 End  

MEMBER [Measures].[ParameterValue] as   
--CASE @TimeScope  
CASE "ymd"  
   WHEN "ym" THEN [Date].[Year].CurrentMember.UniqueName    
   WHEN "yw" THEN [Date].[Year].CurrentMember.UniqueName        
   WHEN "ymd" THEN [Date].[Year Month].CurrentMember.UniqueName     
   WHEN "ywd" THEN [Date].[Year Week].CurrentMember.UniqueName    
   WHEN "di60" THEN [Date].[Date].CurrentMember.UniqueName    
   WHEN "di30" THEN [Date].[Date].CurrentMember.UniqueName    
   WHEN "di15" THEN [Date].[Date].CurrentMember.UniqueName    
   WHEN "ymdi15" THEN [Date].[Year Month].CurrentMember.UniqueName     --NEW  
   WHEN "ymdi30" THEN [Date].[Year Month].CurrentMember.UniqueName     --NEW  
   WHEN "ymdi60" THEN [Date].[Year Month].CurrentMember.UniqueName     --NEW  
   WHEN "wi60" THEN [Date].[Year Week].CurrentMember.UniqueName   
   WHEN "wi15" THEN [Date].[Year Week].CurrentMember.UniqueName   --NEW  
   WHEN "wi30" THEN [Date].[Year Week].CurrentMember.UniqueName   --NEW  
End  

Set DateScope as   
 --CASE @TimeScope  
CASE "ymd"  
   WHEN "ym" THEN [Date].[Year].Children  
   WHEN "yw" THEN [Date].[Year].Children       
   WHEN "ymd" THEN [Date].[Year Month].Children  
   WHEN "ywd" THEN [Date].[Year Week].Children   
   WHEN "di60" THEN [Date].[Date].Children   
   WHEN "di30" THEN [Date].[Date].Children   
   WHEN "di15" THEN [Date].[Date].Children   
   WHEN "ymdi15" THEN [Date].[Year Month].Children --NEW  
   WHEN "ymdi30" THEN [Date].[Year Month].Children --NEW  
   WHEN "ymdi60" THEN [Date].[Year Month].Children --NEW  
   WHEN "wi60" THEN [Date].[Year Week].Children  
   WHEN "wi15" THEN [Date].[Year Week].Children  --NEW  
   WHEN "wi30" THEN [Date].[Year Week].Children  --NEW  
End  

 MEMBER [Measures].[ParameterOrderId] as   
--CASE @TimeScope  
CASE "ymd"  
   WHEN "ym" THEN StrToValue([Date].[Year].CurrentMember.Properties("ID"))  
   WHEN "yw" THEN StrToValue([Date].[Year].CurrentMember.Properties("ID"))  
   WHEN "ymd" THEN [Date].[Year Month].CurrentMember.Name  
   WHEN "ywd" THEN StrToValue([Date].[Year Week].CurrentMember.Properties("Week Sort"))  
   WHEN "di60" THEN [Date].[Date].CurrentMember.Name  
   WHEN "di30" THEN [Date].[Date].CurrentMember.Name  
   WHEN "di15" THEN [Date].[Date].CurrentMember.Name  
   WHEN "ymdi15" THEN [Date].[Year Month].CurrentMember.Name --NEW  
   WHEN "ymdi30" THEN [Date].[Year Month].CurrentMember.Name --NEW  
   WHEN "ymdi60" THEN [Date].[Year Month].CurrentMember.Name --NEW  
   WHEN "wi60" THEN StrToValue([Date].[Year Week].CurrentMember.Properties("Week Sort"))  
   WHEN "wi15" THEN StrToValue([Date].[Year Week].CurrentMember.Properties("Week Sort")) -- NEW  
   WHEN "wi30" THEN StrToValue([Date].[Year Week].CurrentMember.Properties("Week Sort")) -- NEW  

End  


SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue],[Measures].[ParameterOrderId]} ON COLUMNS   
 ,Order(DateScope,[Measures].[ParameterOrderId],DESC) ON ROWS   
 FROM (SELECT [Date].[Date].[All].FirstChild:StrToMember('[Date].[Date].['+ Format(NOW(),"yyyy-MM-dd")+ ']') on COLUMNS FROM [CS UDWH]) -- Error with Format Function  

If i dont use the Space() or Format() Function, these 2 MDX Queries run without a problem.

Environment:
Analysis Server Version: 13.0.6404.1
Server Mode: Multidimensional
Default Compatibility Level: 1100
Supported Compatibility Levels: 1050,1100
Microsoft SQL Server 2016 (SP3-OD) (KB5006943) - 13.0.6404.1 (X64) Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: )

Any help is appreciated!

Thank you and Kind Regards,
Sebastian