Can I look at OLAP cubes?

Posted on 2014-08-28
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
    LVL 4

    Accepted Solution

    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.
    LVL 7

    Author Comment

    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

    "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
    LVL 7

    Author Comment

    Thanks. Going to try it today.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. (htt…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now