IBM Support

Custom Fact created in AW shows different results for 8.4 versus 10.1

Technote (troubleshooting)


A custom fact built on top of Workforce Performance shows different results in 10.1 than in 8.4


Row counts for a particular period for a particular country are 6 times higher


The root cause of the issue is attributed to differences in the security dimension. In 8.4, there is only 1 user with no EMPLID while in 10.1, there are 6 distinct users.


Adaptive Warehouse 10.1
PeopleSoft source with custom security and fact

Diagnosing the problem

The diagnose the problem, take the SQL from the query that is returning multiple rows and break it down until the dimension causing the issue is identified. Compare this dimension to the old 8.4 version

Resolving the problem

Synchronize the custom security dimension between 8.4 and 10.1 so that the results will be the same

Document information

More support for: Cognos Analytic Applications
Cognos 8 Workforce Performance

Software version: 10.1

Operating system(s): Windows

Reference #: 1640611

Modified date: 12 June 2013