Data Managment: Cognos Data Manager (v10.1): Problems with Pivot implementation

Data Manager now has an interesting feature in the Data Stream component of a Fact build into which you have configured PIVOT functionality – when you try to edit the Data Stream you get the dreaded ‘NULL Pointer value’ error.  Traditionally this has sent Data Manager experts directly to the Quit button as it usually indicated something catastrophic was about to happen so get out while you still can (if you can).  NOW THIS IS NOT the action you should take.

Instead, you click the OK button for as many times as you have pivot columns in the data stream item (e.g. if you have pivoted a set of months columns then you probably have to click OK 12 times).  You will eventually be in the editor for the Data Stream component but now all your pivots have been deleted.

You should exit and save at this point otherwise you may continue to get the null pointer errors.  You can then re-enter the Data Stream component and edit it to your hearts content.  Once you have made your changes you need to re-introduce your pivot configurations and then OK and Save – you will now have a working Pivoting Data Stream again.

Hopefully this is fixed in a later release but for those that are unable to update at this time I hope this note does at least let you realise that all is not lost and Data Manager can still function, just the developer’s life has been made a little harder.

Update: This bug has been resolved in v10.2

Related Articles

QMetrix is ISO/IEC 27001 certified: Information Security Management System

QMetrix is pleased to announce we are now ISO/IEC 27001 certified, demonstrating our commitment to information and data security. Highlighted by various data breaches in recent times, cyber threats and criminal activities are on the rise. It is paramount for organisations to uphold high security standards and manage cyber-risks even before they occur in order

QMetrix is named 2024 APJ Workday Adaptive Planning Partner of the Year

QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner  of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage

Stay in touch

Get the latest insights from QMetrix straight in you inbox.

Scroll to Top

This website uses cookies to ensure you get the best experience on our website. More Information

Skip to content