Is it possible to get a grand total of rows and columns when using an MXC Cube?
I want to understand MXC cubes more. One thing I have found is that I cannot get row and column totals when using an MXC cube and so have to create a duplicate of the MXC cube, setting the datatype to DOUBLE and not MXC. I then have to create a second datareader to populate this cube due to MXC cubes having to be populated with dedicated datareaders.
I'm quite happy knowing haw to achieve all that I can with my current processes but if there are alternative methods of achieving this, I'd be very interested in learning of them. I'd also be interested to learn more of how other users use MXC Cubes. I learnt from Michele Roscelli how to use them to relate and count entities horizontally and vertically across trees and now use them prolifically.