infoAdvantage--Duplicate Document Issue Workaround

When developing a report, depending on where the document information is being pulled from, report developers need to start carefully analyzing the need for utilizing the Duplicate Rows and No Duplicate Rows options in infoAdvantage Webi or Business Objects Thick Client.

The simplest approach to determining which option should be selected lies in where you pull the document information.  For example, in the General Accounting Universe,

Note:  Dimension Objects cannot be pulled from both the Document Class and the Accounting Journal Class if the option No Duplicate Rows is selected. 

As for other universes, the key to deciding the correct option is to build your report, run it and verify that the data matches back to eMARS Financial.  If you notice that your results are doubled or quadrupled, you should go back into your query and choose to not return duplicate rows.  If this option does not solve your problem, it is possible that there is something else that needs to be changed in the query.  At that point, you should contact the Customer Resource Center (CRC) via e-mail @ Finance.CRCGRoup@ky.gov for assistance.