Search code examples
ssasmdx

Query (8, 5) Parser: The syntax for 'SELECT' is incorrect

I have the following MDX code and getting the above error on it. I have found a few articles but so confused about how to alter it:

CREATE MEMBER CURRENTCUBE.[Measures].[Calculated Member]
 AS SELECT
NON EMPTY
{
 [Measures].[Unit Count]
} ON COLUMNS
FROM [Testing], 
VISIBLE = 1  ;

Can someone re write that to make it work?

Solution

  • You can create a calculated measure in cube structure tab where you can right click -> New Measure and select the table -> column name and aggregation (count and distinct count within it).

    Then you can open AS in SSMS and write query and specify your where clause

    select [Measures].[Order Key Distinct Count] on columns from testing WHERE ( [Dim].[Hierarchy].&[Value] )