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.
BoldSignA modern eSignature application with affordable pricing. Sign up today for unlimited document usage!
Hi Erik,
We would like to inform you that
we cannot directly get the Dimension members
from Dimension Collection. Dimension Collection have list of hierarchies each of which has list
of levels each of which has list of members.
1.If you would like
to populate the listbox only with dimension names, the
following code can be used.
foreach (var dim in olapDataManager.CurrentCubeSchema.Dimensions)
{
foreach (var hyrar in
dim.Hierarchies)
{
DataListBox.Items.Add(hyrar.UniqName);
}
}
2.If you would like to
populate the listbox with level names only, the
following code can be used.
foreach (var dim in olapDataManager.CurrentCubeSchema.Dimensions)
{
foreach (var
hyrar in dim.Hierarchies)
{
foreach (var
level in hyrar.Levels)
{
DataListBox.Items.Add(level.UniqName);
}
}
}
3.If you would like
to populate the listbox with members only,
the following code can be used.
foreach (var dim in olapDataManager.CurrentCubeSchema.Dimensions)
{
foreach (var
hyrar in dim.Hierarchies)
{
foreach (var
level in hyrar.Levels)
{
foreach (var
members in level.Members)
{
DataListBox.Items.Add(members.Caption);
}
}
}
}
Kindly let me know if you have any concerns.
Regards,
Jesus Arockia Sankaran
Hi Erik,
We would like to let you know that, by using the currentcubeschema.Dimensions, we can only select members from a single dimension. Because we can only retrieve the schema information at this point, the data will be retrieved after generating MDX query internally.
Selecting or filtering members by using different dimension is not possible
in this method. For those things we have to go for MDX query or OlapReport.
Thanks for your interest.
Please let me know if you have any concerns.
Regards,
Jesus Arockia Sankaran S
