Hi,
I have created a module that contains detailed actual transaction data. The module is based on a transaction ID list and properties like month, account and cost center (and other details).
That module feeds into another module for reporting, using the SUM function.
I'm able to Drill Through to Transaction Level detail from the reporting module. It seems to work great. However, if I drill through at a parent account or cost center level, the filters don't work correctly.
Also, I have Selective Access set up for the Cost Center lists. When working on the report module, users are only able to see their Cost Centers. However, if they Drill Through at a Parent Cost Center, because the filter fails, it shows ALL Cost Center transaction detail.
How can I:
1) Fix the Drill Through to Transaction Detail to detail with Parent Accounts and\or Cost Centers
2) Limit the Transaction Detail to only the Cost Centers that have Selective Access
Thanks