Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Rohan
420
How to group dimensions in Pivot data selector
posted

I have placed a pivot grid and data selector on one user control. I am using flatdatasource for pivot. To add measures, I have written the code something like this...

cubeMetadataValues.DimensionSettings.Add(new DimensionMetadata()
{
SourcePropertyName = "CostPrice",
DisplayName = "Cost Price",
DimensionType = DimensionType.Measure,
GroupName = "Price"
});
cubeMetadataValues.DimensionSettings.Add(new DimensionMetadata()
{
SourcePropertyName = "OriginalPrice",
DisplayName = "Original Price",
DimensionType = DimensionType.Measure,
GroupName = "Price"
});

I can see the groups created in Measures section of pivot data selector as seen in attachment.

How to create such groups for all the dimensions? I've more than 30 dimensions to show in data selector control and would like to organize them in logical groups. Has anyone did something like this? Any code sample would be appriciated.

Thanks,

Regards,

Rohan Bhat

Parents
  • 138253
    Offline posted

    Hello Rohan,

     

    Thank you for your post. I have been looking into it and I can say that the approach you use seems to be the best one for achieving the functionality you want, so I can suggest you use it for all your dimensions. Also if I think of a better solution I will let you know.

     

    Hope this helps you.

Reply Children