-
aggregate time and nonemptycrossjoin
I can aggregate time using MDX like this:
**********************
--with
--member TimeByHour.Agg as 'AGGREGATE({ [TimeByHour].[All TimeByHour].[2005].[July].[19] : [TimeByHour].[All TimeByHour].[2005].[July].[20] })'
select
{[Measures].[Calls], [Measures].[Is Abandon In Ivr],[Measures].[Abandoned In IVR Rate] , [Measures].[Is Queued], [Measures].[Is Abandon Pre Answered] , [Measures].[Abandoned PreAns Rate] , [Measures].[Total Abandoned Rate] , [Measures].[Is Answered] , [Measures].[Is Answered And Attributed] , [Measures].[Main Sales] , [Measures].[Conv] , [Measures].[AveCallTime], [Measures].[Call Time] , [Measures].[IsDefaultExt] } on columns,
nonemptycrossjoin( [IACD_InboundTypes].[Inbound Number].members, [MediaCampaigns].[CampaignID].members) on rows
from acd_calls
where [TimeByHour].[All TimeByHour].[2005].[July].[19]
--where TimeByHour.Agg
******************
The uncommented out code allows the nonemptycrossjoin to function correctly, but when I switch the code to use the aggregate, the nonemptycrossjoin stops working and returns all rows which is really bad.
Any help for me here?
Thanks,
Richard
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|