Pages

Saturday, February 26, 2011

MDX Extraction VB Tool

I had already posted one blog about extracting MDX from Excel pivot table by installing Excel add-in. This post is again about extracting MDX. It is a very small executable file, which can be downloaded from below link and can be used to extract mdx.

Steps:

1. Run ExtractMDX.exe file and browse Excel Workbook, from which you want to extract MDX.. 
 

2. Select Worksheet, which has Pivot table created on Analysis Services cube.

3. If selected sheet has Pivot Table, Then it will get listed in "Select Pivot Table" drop down list. Select appropriate Pivot table.

4. Now click on "Extract MDX" button to extract mdx of the selected Pivot table.It may ask for below option:
5. Click 'OK'. MDX will get displayed in "Pivot Table MDX" text box.

6. This MDX can be saved/copied for future reference. "Refresh" button can be used to reset all selected settings.

Readers: Kindly share your comments & suggestions.
    Posted by Surya Sen Singh at 1:06 PM

    3 comments:

    1. Jason CampbellJune 21, 2011 at 6:02 AM

      http://olappivottableextend.codeplex.com/

      Very clean, free adin from codeplex

      ReplyDelete
    2. Surya Sen SinghJune 26, 2011 at 11:44 PM

      Thanks Jason for sharing this link. This is good stuff.
      I had created similar add-in with just 1 feature of showing MDX of execl pivot tables 3 years back and uploaded it @

      http://ssasbysss.blogspot.com/2011/02/mdx-extraction-of-excel-pivot-table.html

      ReplyDelete
    3. Mindmajix Technologies INCOctober 24, 2018 at 12:05 AM

      Thank you for sharing the information. This will really help me to learn more about SSAS.

      ReplyDelete

    Subscribe to: Post Comments (Atom)