ssasmdxcubemdx-query

MDX query in SSAS calculated member

I tried the MDX Query in SQL correctly But I will insert that query in the VisualStudio(SSAS) in the Calculated Members section, but the process time will be faulty

Select 
[Measures].[Fact Student Status Count]on columns
From [Cube_REG_Amozesh DW]
Where ( [Dim Student Status].[Student Status Key].[Student Status Key]-[Dim Student Status].[Student Status Key].&[0])

I get the following error:

Severity Code Description Project File Line Suppression State Error MdxScript(Cube_REG_Amozesh DW) (2, 5) Parser: The syntax for 'Select' is incorrect. (CREATE DYNAMIC SET CURRENTCUBE.[RegSt] AS Select [Measures].[Fact Student Status Count]on columns from [Cube_REG_Amozesh DW] where ( [Dim Student Status].[Student Status Key].[Student Status Key]-[Dim Student Status].[Student Status Key].&[0]), DISPLAY_FOLDER = 'شاخص' ; ). 0

Solution

  • its worked:

    CREATE MEMBER CURRENTCUBE.[Measures].RegST AS [Measures].[Fact Student Status Count]-([Measures].[Fact Student Status Count],[Dim Student Status].[Student Status Key].&[0])