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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Creating OLAP reports with hierarchy and level elements in Version 8.2

Platform: ASP.NET Web Forms (Classic) |
Control: OlapGrid |
Published Date: April 30, 2011 |
Last Revised Date: July 10, 2014

 

Previously, to create implementations of OLAP reports with hierarchy and level elements, you would assign only the dimension name, which is more than enough to fetch the hierarchy, level element, and members contained in it. However, in the current implementation, Syncfusion makes it mandatory to include hierarchy and level elements.

The reason for this is that in previous implementations, if a hierarchy was not specified, the default hierarchy would be fetched from the cube schema; the case is the same for levels and members.  The cube schema holds the entire information of the SSAS cube, which in turn queries the offline or deployed cube to retrieve the information, leading to serious performance issues if multiple dimensions are specified.

In the current implementation, accessing cube schema has been removed by making hierarchy and level mandatory in the reports.

Previous Report Structure

[C#]

DimensionElementdimensionElementColumn = newDimensionElement();

// Specifying the Dimension Name

dimensionElementColumn.Name = "Customer";

// Adding the Column member

olapReport.CategoricalElements.Add(new Item { ElementValue = dimensionElementColumn });

[VB]

Dim dimensionElementColumn As DimensionElement = New DimensionElement()

' Specifying the Dimension Name

dimensionElementColumn.Name = "Customer"

 

' Adding the Column member

olapReport.CategoricalElements.Add(New Item With {.ElementValue = dimensionElementColumn})

 

Current Report Structure

[C#]

 

DimensionElementdimensionElementColumn = newDimensionElement();

// Specifying the Dimension Name

dimensionElementColumn.Name = "Customer";

// Specifying the Hierarchy Name

dimensionElementColumn.HierarchyName = "Customer Geography";

// Adding the level with the Hierarchy Name

dimensionElementColumn.AddLevel("Customer Geography", "Country");

// Adding the Column member

olapReport.CategoricalElements.Add(dimensionElementColumn);

[VB]

Dim dimensionElementColumn As DimensionElement = New DimensionElement()

' Specifying the Dimension Name

dimensionElementColumn.Name = "Customer"

' Specifying the Hierarchy Name

dimensionElementColumn.HierarchyName = "Customer Geography"

' Adding the level with the Hierarchy Name

dimensionElementColumn.AddLevel("Customer Geography", "Country")

 

' Adding the Column member

olapReport.CategoricalElements.Add(dimensionElementColumn)

ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

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