To follow up on the question above – the technique described above did not quite get what we were looking for. It provided the ability to use totals for the differing groups of Dist Channels but it did not provide all the functionality of creating a Dimension to roll the Dist Channels together differently. So we added an Attribute to the Dist Channel called Combined Channels that designated how the Dist Channels should roll up and then marked that attribute as a Virtual Dimension (attribute hierarchy) in the Connector. This allows users to see a new dimension called Combined Channels that works on all the information in Stratum where the Dist Channel is included. So all the current years and the historic without having to reload or update any transaction data. Soooo…..the Sum(tuple) idea – a good idea in some cases and another option is Virtual Dims.
