Error messages of just numbers within Smartview 11.1.2

Recently we have encountered numeric error messages in multiple environments when using Smartview 11.1.2.x.  Typically a single number is shown with no accompanying description.  The error message looks like the following, but may list some other specific number: [caption id="attachment_3955" align="aligncenter" width="296"] (click to enlarge)[/caption] The fact that there is no descriptive text makes troubleshooting…

Read More

Bullet Charts: The New Gauge

Author:  Kim Beuchler, eCapital Advisors Consultant Gauge charts have long been a favorite of executives for comparing actuals to forecast but they often fail to accurately depict the message. Enter the bullet chart. This chart type is endorsed by visualization expert Stephen Few and uses a linear structure rather than a circular structure. In the…

Read More

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