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 ?
Asked by Sam
(111 rep)
Jun 17, 2023, 04:25 PM