Showing Top x Values in a Pivot Table

One of the benefits of utilizing a straight table over a pivot table is the ability to limit the dimension values. With a straight table it’s quite easy, simply click on the Dimension Limits tab, under the Limits section, check the Restrict which values are displayed using the first expression check box. Select the show…

Read More

Intro to Planning and Budgeting Cloud Service Dashboards

Dashboards in Oracle’s Planning and Budgeting Cloud Service are an extremely powerful and intuitive tool to use during the planning and forecast process. Data visualization allows users to absorb information in new and more constructive ways, by instantly describing and viewing patterns in your operational and business activities. [caption id="attachment_7121" align="aligncenter" width="640"] (image courtesy of Oracle)[/caption]  …

Read More

Qlikview – Creating a Heat Map Using “ColorMix”

Overview The colormix in Qlikview is a function that allows for different colors to be used in lieu of the default color scheme. As it states, it mixes colors depending on the minimum limit and maximum limit of an expression. There are several ways to create heat maps, but this should help with creating simplified…

Read More

CA 11: Custom Navigation Bar Entries

Many users have asked, "can I create a starting point other than Team Content?"  Well, the simple answer is "Yes."  This allows users to access a folder that may be nested many level deep in the Cognos folder structure right from the welcome area.  Adding additional entries to the navigation bar on the left can…

Read More