Group measures in FastCube2, banded
in FastCube 2
Hello!
I have many measures in my Cube report and I would like to 'separate' them, 'organize' them, 'group' them together, like on this table generated in Excel.
In this example I grouped the columns by continents... is it possible to do this kind of banding or grouping together in Cube?
I mean in code! I am using Delphi 7 + FastCube2. Is it possible to make it with code in Delphi?
Thank you in advance!
Comments
Hello.
Yes, grouping is the basic feature of FastCube.
Use code like:
fcxSlice1.XAxisContainer.AddDimension(fcxSlice1.SliceFields.ItemByName['Continent'], 'Continent', 'Continent');
fcxSlcie1.XAxisContainer.AddDimension(fcxSlice1.SliceFields.ItemByName['Country'], 'Country', 'Country');