Forum Discussion

kmd's avatar
kmd
Contributor II
7 hours ago

Application Reports - duplicated dimensions

Wondering if anyone else is seeing duplicated dimension IDs in some of the built-in Application Reports (the example below is based on the "Member Property Changes Audit Report")

We're on V9.1 but have seen the same issue in 7 and 8 as well.

The results do vary depending on which of the duplicated dimensions you select.

If you've also seen this, has OneStream provided any explanation as to why this exists?

 

1 Reply

  • JJones's avatar
    JJones
    Icon for OneStream Employee rankOneStream Employee

    The member list that is returned is based on the results of the SQL Query that is tied to the parameter used in this report (AuditDimensionList_ONC).  The query for the parameter is doing a Union on the Audit table and should be returning distinct values.  If you create a data adapter and run the Query associated with the parameter, it should show the duplicates and you could look to see if they have the same DIMID or different DIMID's and that would explain the duplicates.

    You could also open a support case with the support team and they could look at the query and results from your application to understand why there would be duplicate results from the audit table.