Can I look at OLAP cubes?

Posted on 2014-08-28
Medium Priority
Last Modified: 2016-02-18
I'm working with C# code and it's MDX query that hits the OLAP cube (that's what the developer said)

I have SQL Server 2012. Can I look at OLAP cube? run it, view in Profiler?? It's not like a SQL statement it, is it?
Question by:Camillia
  • 2

Accepted Solution

Randy Knight, MCM earned 1000 total points
ID: 40291751
Yes you can.  You need to connect to the SSAS server using Management Studio.  When you connect you'll choose to connect to Analysis Services instead of the database engine.  From there you can see the SSAS database and find the cubes, dimensions, etc.  And browse them right from within SSMS.  You can also execute MDX queries against the database.

Author Comment

ID: 40291763
Thanks. I'll take a look. I think the developer said I can't. Maybe he didn't understand my question.
LVL 37

Assisted Solution

ValentinoV earned 1000 total points
ID: 40291985
"run it, view in Profiler?? It's not like a SQL statement it, is it?"

MDX is similar to SQL but has its own syntax.  You can run Profiler against the SSAS instance if you'd like a trace of the MDX commands.  When setting up the trace you need to select Analysis Services as Server Type, similar to what Randy described for SSMS.

More info: Introduction to Monitoring Analysis Services with SQL Server Profiler

Author Comment

ID: 40292440
Thanks. Going to try it today.

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question