)
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: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Essential JS2

Syncfusion jQuery based widgets are no longer in active development. Switch to our pure JavaScript based next generation Essential JS 2 library.

Syncfusion Feedback

How to find the default hierarchy name of a Dimension?

Platform: jQuery |
Control: ejPivotGrid |
Published Date: February 17, 2015 |
Last Revised Date: June 18, 2019

This KB illustrates that how to find the default hierarchy name of a Dimension.

Solution:

You can find the default hierarchy name of a dimension from the Olap report by using the following code example.

C#

public Dictionary<string, object> InitializeClient(string action, string customObject, string clientParams)
{
OlapDataManager DataManager = null;
DataManager = new OlapDataManager(connectionString);
DataManager.SetCurrentReport(CreateOlapReport());
string defaultHierarchyName = "";
var Dimensions = DataManager.CurrentCubeSchema.Dimensions;
for (int i = 0; i < Dimensions.Count; i++)
{
if(Dimensions[i].Name == "Enter valid dimension name")
defaultHierarchyName = Dimensions[i].DefaultHierarchyName;
}
return olapClientHelper.GetJsonData(action, DataManager, clientParams);
}

VB

Public Function InitializeClient(ByVal action As String, ByVal customObject As String, ByVal clientParams As String) As Dictionary(Of String, Object)
Dim DataManager As OlapDataManager = Nothing
DataManager = New OlapDataManager(connectionString)
DataManager.SetCurrentReport(CreateOlapReport())
Dim defaultHierarchyName As String = ""
Dim Dimensions = DataManager.CurrentCubeSchema.Dimensions
For i As Integer = 0 To Dimensions.Count - 1
If Dimensions(i).Name = "Enter valid dimension name" Then
defaultHierarchyName = Dimensions(i).DefaultHierarchyName
End If
Next i
Return olapClientHelper.GetJsonData(action, DataManager, clientParams)
End Function

 

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.

Up arrow icon

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

Live Chat Icon For mobile
Live Chat Icon