Our database development team shared a great news that I must post here. In my previous post, I mentioned about how Cognos BI (Report Studio and Analysis Studio) stop showing numbers for aggregated levels as soon as any rule is added to the TM1 cube.
Well, as per the documentation from IBM, the latest version of TM1 (v10.1.1) solves this problem. Please see below from the IBM documentation:
Rule-aware aggregation in Cognos TM1 and Cognos BI
IBM Cognos TM1 now allows the aggregation computation to take into account Cognos TM1 cube rule definition so that Aggregate computations are now aware of Cognos TM1 cube rules.
In previous versions of Cognos TM1 the default aggregation could not be computed by the Cognos Business Intelligence (BI) server when applied to Cognos TM1 rule-calculated cells.
With rule-aware aggregation in place, the aggregation numbers are reported based on the semantics of the Cognos TM1 rules.
We haven't yet tested this feature but we are surely looking forward to it. I will keep you all updated on progress via this blog.