[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 41
  • Last Modified:

Translate SQL Query to MDX

Is there any way to translate the below query, to MDX format ? i'm having trouble with grouping.....

select Site, [Date Time],
COUNT([Agent Name]) cntAgents,
SUM([Available Time Net]) Sum(AvailTime),
Sum([Logged On Time Net]) SumLoggedOnTime,
SUM([Not Ready Time Net]) SumNotReadyTime,
SUM([Calls Answered]) SumCallsAnswered, SUM([Handled Calls Talk Time])
Sum(HandledCallsTalkTime)
from dbo.temp_AgentTimenet (this would be the cube [Agent Time Net]
where Site = 'WBD'
and  [Date Time] between '2014-08-01 00:00' and '2014-12-31 23:59'
group by [Site], [Date Time]
order by [Date Time]
0
Auerelio Vasquez
Asked:
Auerelio Vasquez
1 Solution
 
Phillip BurtonCommented:
It largely depends on how your cube is set up.

Try going to the Cube - Browser within SSMS and using the GUI to create the query, and then click on "Design Mode" to see the resulting MDX.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now