Using @XWRITE and @XRETURN

@XWRITE Function The function that has been commonly referred to as XREF’s big brother, XWRITE is a function in the newer releases of Hyperion that fills almost all the gaps that XREF had.  XWRITE is a function that allows a calculation script to push data to another Essbase database or application (as opposed to XREF’s…

Read More

Advanced Row Formatting in IBM Cognos TM1 Active Forms

Author:  Jim Bullis, Sr. Management Consultant, eCapital Advisors Active forms in IBM Cognos TM1 can provide a lot of flexibility in terms of formatting your data. After creating an active form, the formatting of the rows is handled in the Format Range of the worksheet. To expose the Format Range you can click the Show…

Read More

Using FDM for Essbase drill-through

Often when developing Essbase reporting applications with FDM, there are additional levels of granularity of the data that are not needed in Essbase, but exist in FDM.  For example the “Invoice #” or “PO #” may be needed when drilling into detail from Essbase, however that same data does not need to reside in the…

Read More

When to Deploy an Active Report

By Trevor Schulte, IBM Cognos BI Consultant, eCapital Advisors With Cognos 10, IBM released a new report type called Active Reports.  The Active Report is an archived HTML (.MHT) file that can empower users in data exploration and analytics.  The reports are similar to PDF files as they are static files with self-serving data.  However,…

Read More