We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Strange MDX query

Thread ID:

Created:

Updated:

Platform:

Replies:

118137 Feb 4,2015 03:16 AM Feb 5,2015 08:30 AM Silverlight 1
loading
Tags: OlapClient
ARdekS
Asked On February 4, 2015 03:16 AM

HI Sincfusion,

We are looking for OLAP component, and your is pretty good. But MDX queries make me sad.

We made some simple query with filter, and MDX query look like a big ugly monster.

Let me show you example.

SELECT   NON EMPTY({[Measures].[Order Count]})  dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME  ON COLUMNS ,  NONEMPTY( VISUALTOTALS( ({{hierarchize(Union(Intersect(VISUALTOTALS({ Except(Descendants([Date].[Calendar], 1, SELF_AND_BEFORE) , {[Date].[Calendar].[Calendar Year].&[2005], [Date].[Calendar].[Calendar Year].&[2006], [Date].[Calendar].[Calendar Year].&[2007], [Date].[Calendar].[Calendar Year].&[2008], [Date].[Calendar].[Calendar Year].&[2009]}) }), Drilldownlevel({ [Date].[Calendar] })) , Except(Drilldownlevel({ [Date].[Calendar] }) , {[Date].[Calendar].[Calendar Year].&[2005], [Date].[Calendar].[Calendar Year].&[2006], [Date].[Calendar].[Calendar Year].&[2007], [Date].[Calendar].[Calendar Year].&[2008], [Date].[Calendar].[Calendar Year].&[2009]})))}}) ),{[Measures].[Order Count]})  dimension properties MEMBER_TYPE, PARENT_UNIQUE_NAME  ON ROWS  FROM [Adventure Works]  CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE

How this query is in EXCEL

SELECT NON EMPTY Hierarchize({DrilldownLevel({DrilldownLevel({[Date].[Calendar].[All Periods]},,,INCLUDE_CALC_MEMBERS)},[Date].[Calendar].[Calendar Year],INCLUDE_CALC_MEMBERS)}) DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME,[Date].[Calendar].[Calendar Semester].[Calendar Year] ON COLUMNS  FROM (SELECT ({[Date].[Calendar].[Calendar Year].&[2010]}) ON COLUMNS  FROM [Adventure Works]) WHERE ([Measures].[Order Count]) CELL PROPERTIES VALUE, FORMAT_STRING, LANGUAGE, BACK_COLOR, FORE_COLOR, FONT_FLAGS

Differences are obvious. Your mdx designer made it using "EXCEPT". That very tough way for OLAP CUBE, and requires much resources to execute.

Why is that and can you change it?

Kind regard, Aleaxander.


Jesus Arockia Sankaran S [Syncfusion]
Replied On February 5, 2015 08:30 AM

Hi Alexander,

Thanks for your interest in Syncfusion products.

We have updated the response in incident 134883 which you have created. Please refer the incident for further follow up.

Regards,

Jesus Arockia Sankaran S



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;