Category / Section
How to get the default hierarchy name of a dimension from the Cube?
1 min read
You can find the default hierarchy name of a dimension from the Cube through the following code example.
C#
public MainWindow() { InitializeComponent(); this.olapGrid1.OlapDataManager = new Syncfusion.Olap.Manager.OlapDataManager("Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;"); this.olapGrid1.OlapDataManager.SetCurrentReport(SampleReport()); this.olapGrid1.Loaded += olapGrid1_Loaded; } void olapGrid1_Loaded(object sender, System.Windows.RoutedEventArgs e) { string defaultHierarchyName = ""; var Dimensions=this.olapGrid1.OlapDataManager.CurrentCubeSchema.Dimensions; for (int i = 0; i < Dimensions.Count; i++) { // Enter the valid hierarchy name that you want to check. if (Dimensions[i].Name == "Customer” ) { defaultHierarchyName = Dimensions[i].DefaultHierarchyName; break; } } }
VB
Public Sub New() InitializeComponent() Me.olapGrid1.OlapDataManager = New Syncfusion.Olap.Manager.OlapDataManager("Data Source=http://bi.syncfusion.com/olap/msmdpump.dll; Initial Catalog=Adventure Works DW 2008 SE;") Me.olapGrid1.OlapDataManager.SetCurrentReport(SampleReport()) AddHandler Me.olapGrid1.Loaded, AddressOf olapGrid1_Loaded End Sub Private Sub olapGrid1_Loaded(ByVal sender As Object, ByVal e As System.Windows.RoutedEventArgs) Dim defaultHierarchyName As String = "" Dim Dimensions = Me.olapGrid1.OlapDataManager.CurrentCubeSchema.Dimensions For i As Integer = 0 To Dimensions.Count – 1 'Enter valid hierarchy name which you want to check. If Dimensions(i).Name = "Customer" Then defaultHierarchyName = Dimensions(i).DefaultHierarchyName Exit For End If Next i End Sub