Enter a long URL to make tiny:

Excel Addin to extract MDX Query

One the question raised by my end users is, how they can view the MDX query out the Pivot table in excel they created connecting to an OLAP database. Excel has the excellent facilty to connect to a OLAP database and generate Pivot table using multi-dimensional cube. The pivot table can be defined by dragging and dropping the measures and dimension values with ease.

Found this super cool addin which eases out this pain of exacting the MDX query out of the Pivot table.

http://www.codeplex.com/OlapPivotTableExtend

The addin is easy to install and use.

Recompiling Database objects programatically

To recompile stored procedure

sp_recompile [@object=] objectname


To compile view use

sp_refreshview @viewname

Kerberos Delegation Site

Here is a good blog site where you can start with trouble shooting delegation issues

http://blogs.technet.com/askds/archive/tags/Kerberos/default.aspx

Querying Database object definition

How to query for T-SQL definition for objects in SQL Server 2008

You can query for object definition using sys.sql_modules catalog view in SQL 2008

Example :

SELECT OBJECT_NAME(object_id), definition FROM SYS.SQL_Modules where Definition like ''


Example :
DECLARE @SearchString NVARCHAR(MAX)
SET @SearchString = 'xyz'

SELECT @SearchString, [name] , OBJECT_DEFINITION(OBJECT_ID([name]))
FROM sys.all_objects
WHERE OBJECT_DEFINITION(object_id([name])) LIKE '%' + @SearchString + '%'