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.
Syncfusion Feedback

Why are the latest versions of Mondrian, incompatible with Syncfusion OLAP Controls?

All the Mondrian versions above 3.2 have been configured, checked and the following problems were encountered with ADOMD.Net provider and Mondrian server but not with Syncfusion controls.

Issues Raised From the Mondrian Server:

  1. MDX queries should definitely contain “WHERE” clause. Without “WHERE” clause the following exception is thrown.

 

The following error occurs when executing MDX through “adomdCommand.ExecuteCellSet()” without WHERE clause.

             Inner exception - 'Element' is an invalid XmlNodeType.

 

Note: This issue occurs in 3.3, and resolved in 3.4, but later raised in 3.5 and above versions.

 

  1. When you try to get the level members using the pre-defined method “GetMembers()”in ADOMD the following issue occurs.

 

cid:image001.png@01CFC10B.1F91E5D0

Figure 1: Error

The purpose ofGetMembers()” is to populate member editor of OLAP Client for Slice and Dice operation.

 

C:\Users\Adithi\AppData\Roaming\Skype\adithis_1918\media_messaging\media_cache\^E156575D5AD5F5B40DD2BB637D1F405C0AF5A09212CEBB9791^pimgpsh_fullsize_distr.jpg

Figure 2: GetMembers()

Note: This occurs from 3.3 and above versions.

Issue Reports:

In Mondrian JIRA, feature reports are already logged for providing “native” format support to “ADOMD.Net”. You can find the Mondrian JIRA links as follows.

Other User/ Customer Reports:

http://jira.pentaho.com/browse/MONDRIAN-1836

http://jira.pentaho.com/browse/MONDRIAN-131

The following issue report was logged by a Syncfusion Developer.

Syncfusion Developer Report:

http://jira.pentaho.com/browse/MONDRIAN-2186

Root Cause:

The root cause of the problem is the XML returned by Mondrian service to ADOMD dll is not compatible.

 

Figure 3: Root Cause

Work Arounds:

OLAP Chart

OLAP Chart and OLAP Grid can be made compatible with all versions of Mondrian by adding a dummy dimension at the Slicer axis in-order to generate “WHERE” clause.

 

DimensionElement dimensionElementSlicer = new DimensionElement();

dimensionElementSlicer.Name = "Product";

dimensionElementSlicer.AddLevel("Product Categories", "Category");

olapReport.SlicerElements.Add(dimensionElementSlicer);

 

OLAP Grid

OLAP Client

Need to downgrade to Mondrian 3.2 version since there is no solution or work-around for the “GetMembers()” issue raised, the key method to get and populate members inside member editor for slice and dice operation.

 

Downgrading is just a temporary solution until Mondrain addresses the issue at their end.

 

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
3899 02/12/2015 03/19/2015 JavaScript ejPivotGrid
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Warning Icon 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.Close Icon