How to Display Daily Movement Debit and Credit Separately in FRS Using the ADB Cube

Summary:

We have a requirement to display Daily Movement Debit and Daily Movement Credit in separate columns in an FRS (Financial Reporting Studio) report using the ADB cube.

Currently, the ADB cube provides only a single member, Net Daily Activity, and does not appear to have separate members for Daily Movement Debit and Daily Movement Credit, unlike the normal GL cube where Period Movement DR and Period Movement CR are available as separate members.

The business users require the report to support FRS features such as expansion and drill-down, so developing the report in BI Publisher is not an acceptable alternative.