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

Technote (troubleshooting)


Problem(Abstract)

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

Symptom

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


Cause

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.

Environment

Windows
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

Rate this page:

(0 users)Average rating

Document information


More support for:

Cognos Analytic Applications
Cognos 8 Workforce Performance

Software version:

10.1

Operating system(s):

Windows

Reference #:

1640611

Modified date:

2013-06-12

Translate my page

Machine Translation

Content navigation