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.

Creating OLAP reports with hierarchy and level elements in Version 8.2

 

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)

Article ID: Published Date: Last Revised Date: Platform: Control:
2169 04/30/2011 07/10/2014 ASP.NET Web Forms (Classic) OlapGrid
Tags:
Did you find this information helpful?
Add Comment
You must log in to leave a comment

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.