Referencing ASO Summary Data in BSO Calculations

The Short of It Using the @XREF function, we can leverage consolidated data from an Aggregate Storage database to drive Block Storage (Essbase/Planning) calculations in a fast, dynamic process. Example Your company (Pop Inc.) sells snacks and drinks from kiosks. You calculate driver-based revenue metrics for an array of FP&A exercises based on Year-Over-Year impact.…

Read More

IBM Planning Analytics and the Secure Gateway

  Are you a current or future TM1 user interested in loading on premises data into IBM Planning Analytics Cloud?   This blog describes how to set up a secure connection to safely transmit data to the IBM Planning Analytics Cloud from on premises databases.   As IBM describes here, the IBM Secure Gateway “provides a…

Read More

Cognos Analytics: Report Performance Details

Performance Details in Report In today's analytics environment, timeliness of data is important.  Along with timeliness, reports and analyses need to be swift.  With Cognos Analytics 11 R7 and higher, there is a feature within Report called Performance Details which helps authors determine if queries or visualizations need to be tuned to boost overall run…

Read More