Hi,
Aggregate function cannot be used on calculated measures. Not sure why your first query gets a huge value ?
I think you could try create two new member and arrange them like
WITH MEMBER as Date.Date.R1
aggregate( Date.Datekey.Begin1:Date.DateKey.End1)
MEMBER as Date.Date.R2
aggregate( Date.Datekey.Begin2:Date.DateKey.End2)
member totalMeasures as
(measureA + measureB + measureC)
SELECT
totalMeasures on 0,
{ Date.Date.R1, Date.Date.R2} on 1
FROM [yourCube]
Regards,
Lukas
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
What can I do if my transaction log is full?--- Hot issues November
How to convert Profiler trace into a SQL Server table -- Hot issues November