Re: Problem displaying OLAP cube results in Excel

If you capture the MDX query submitted by Excel using the SQL Profiler
tool, and execute it separately in Management Studio, you can check the
number of rows being returned.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Very strange problem I am facing
    ... Could you run the SQL Profiler and execute the ... After the insertion check the profiler output for the activities happened. ... Execute sp_depends to get the dependant objects on that table. ...
    (microsoft.public.sqlserver.server)
  • Re: SCOPE_IDENTITY() returns NULL
    ... My program uses Delphi ADO VCL components: ... I traced with SQL Profiler and it seems that between above ... Execute() and Openthere many internal commands are ... >> insert statements into an identity column occur in the scope. ...
    (microsoft.public.sqlserver.programming)
  • Re: executenonquery - insert works only in debug mode
    ... If I execute this code in run mode ... > insert fails and table Magazzini_Selezionati is empty. ... you will find the Sql Profiler among other tools shipped with SQLServer. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: SQL Server and LAN Manager Authentication Level
    ... I've run SQL Profiler and I've noticed following: ... SQL:BatchStarting EXECUTE ... Best regards and a Happy Easter ...
    (microsoft.public.sqlserver.security)
  • How to extract the underlying MDX
    ... browser, either through Management Studio or Analysis Project? ... I tried with SQL Profiler, and am seeing something that is not too ...
    (microsoft.public.sqlserver.olap)