I am running a report out of Cognos to show all expenses on expense reports during the specified timeframe, with the goal of running analytics to further analyze the data. I have noticed in my analytics testing that I am getting multiple false positives, because if an expense report was approved with exception or has some other edit made to it, the same expenses on the same expense report will show up multiple times in the Cognos report I have generated.
On some expenses, it is clear which are duplicates, however, this is not the case for all. In an attempt to avoid wasting time investigating multiple "duplicate" expenses which are truly resultant from edits the same expense report, I was wondering if there is a way to edit the report being run to only show each report one time, for instance, only the last iteration of the expense report which has been submitted.
I would hope this is a relatively simple change, however, I am new to Cognos reports and cannot find a way to make the change in poking around at the settings or from what I have seen in the help guides.
Please let me know if you have have any advice on how to make this change or if you need further detail.
Is this a report that you built yourself? If so, I may be able to help you a bit. Another question, does your company have our Business Intelligence buy up or are you using Analysis (free version of Cognos reporting)?
Feel free to send me a private message on here. I'll await your reply. If you could, please send me your company name and the report name you are working with.