Can I look at OLAP cubes?

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?
LVL 8
CamilliaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Randy Knight, MCMPrincipal ConsultantCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
CamilliaAuthor Commented:
Thanks. I'll take a look. I think the developer said I can't. Maybe he didn't understand my question.
0
ValentinoVBI ConsultantCommented:
"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
0
CamilliaAuthor Commented:
Thanks. Going to try it today.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.