creating a MDX query using a control?

Question

creating a MDX query using a control?

doug moore

Mr or Mrs. 500

Points: 520
More actions
April 18, 2016 at 8:59 am

#315709

I currently have a very old dundas control that creates a MDX query using their object
DundasOlapDataProvider > Dundas.Olap.Data.DimensionDescriptor
we moved away from this dundas and moved towards Telerik. I need to create the MDX query perhaps with a control.
is there any type of .net or other control I can use to auto create my MDX query?
Doug

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Alan Burstein SSC Guru Points: 61136 More actions · Answer 1

doug moore (4/18/2016)
I currently have a very old dundas control that creates a MDX query using their object
DundasOlapDataProvider > Dundas.Olap.Data.DimensionDescriptor
we moved away from this dundas and moved towards Telerik. I need to create the MDX query perhaps with a control.
is there any type of .net or other control I can use to auto create my MDX query?
Doug

There's a few things you can use... Off the top of my head:

1. In SSMS you can connect to your Analysis Services instance and "browse the cube". Then drag in some measures and dimensions. then click the Design Mode icon.

2. If you have SSRS installed you can create a datasource connection to a cube then use the Query Designer. The interface provided is pretty similar to what you see when you browse the cube in SSMS.

3. There's this little Excel Macro: Display the MDX query of an Excel 2007 PivotTable. You can set that up, create a pivot table against the cube then look at the MDX that's created when you add columns/rows to the pivot table.

"I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

-- Itzik Ben-Gan 2001

doug moore Mr or Mrs. 500 Points: 520 More actions · Answer 2

I already can print out my MDX queries made by dundas. I already see the formatting and can possibly replicate it by code in a crude way.

I am looking for a control I can use in my .net web page that I can just add the dimensions and axis and filters and it builds out the query for me dynamically for the web page.

I am not looking to do anything through a GUI because the web page has to build dynamic queries for my customers based upon their selections.

Doug