1

I have defined a cube with a hieararchy of Dates such: Year is a top level then there's Month level.

I have deployed the cube using SSAS VS 2022 and SQL Server 2019.

But when I query it using the following MDX expression:

WITH
MEMBER MEASURES.COUNT AS [Measures].[Count]                                                 
SELECT     MEASURES.COUNT    ON COLUMNS,
DRILLDOWNLEVEL({[TIME_DIM].[Hierarchy].[YEAR]} )   ON ROWS                                                                 
FROM [CUBE1]

I get results such as

Year    Month   Count
2020    1   20 #some rows such as this one are duplicates
2020    1   20 #some rows such as this one are duplicates
... ... ...

What could be the reason, did I miss defining a Level in a hieararchy in SSAS ?

Improve this question
2
  • Why are you defining a calculated measure for count? If its a base measure then I dont see the benefit. Try removing the calculation and just use the base measure Commented Jun 17, 2023 at 19:30
  • its a customized count with the same name as the usual "count" Commented Jun 17, 2023 at 19:33
Related questions
0
SSAS/MDX : create calculated measure for specific month
0
How to calculate average on two dimensions in MDX
0
MDX wrong sum on grand total in excel
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.