Facing error while working with Aggregate function in MDX (MultiDimensional-Expresson)
0
votes
1
answer
438
views
Hi everyone hope you're doing well
I'm using Aggregate function to aggregate the value of my measure
for two specific years as you can see below :
select aggregate ({[DimTime].[Year].& ,[DimTime].[Year].& },[Measures].[IndentCount]) on 0 from [Procurement]
according to the fact that aggregate function accepts two parameters :
Aggregate (Set_expression , Numeric_Expression)
What is wrong with my MDX query?
I get this error :
The Axis0 function expects a tuple set expression for the argument. A string or numeric expression was used.
Thanks in advance
Asked by Pantea
(1510 rep)
Apr 3, 2019, 12:45 PM
Last activity: Aug 24, 2020, 08:03 AM
Last activity: Aug 24, 2020, 08:03 AM