If you are unable to create a new account, please email support@bspsoftware.com

 

Exploration - Any Cognos-based ways to easily find the "Invalid data record"?

Started by FerdH4, 03 Aug 2023 12:49:34 PM

Previous topic - Next topic

FerdH4

I used Explorations' "Create dashboard from the charts" link which worked decently well.  I only gave Exploration two data item names for it to create the initial Visualization.  Then I clicked on that "Create dashboard from the charts" link and Cognos created a tabbed Dashboard containing a total of eight Visualizations - the first of which was the initial Visualization which was displayed from the first Exploration query attempt.

Anyhoot, two of those Visualizations offered up an "Insights" link.  In the "Show meaningful differences", the Insights displayed "Invalid data record" and mousing over that link only gave me the name of the data item where the invalid data was found...and also said that was excluded from the analysis.

There was also a yellow "Annotation warnings" link next to the "Insights" link.  Clicking on that warning essentially repeated the info from the prior sentence.

Is anyone aware of any techniques, tools, etc. included inside of the 11.2.x UI which might help me to EASILY identify which value or which record is in error? I feel comfortable using Reports to look for anomalies;but, less experienced Dashboard users will not have the luxury to do that.  I'm always looking for any easy technique which Cognos might have Easter Egged into the application.