Cash Management (CBDM) Data Mart

The Cash Managment Data Mart provides for treasury reporting on daily transactions that flow through the Cash Management system. The Cash Management Data Mart allows you to compare balances such as Bank, Cash Flow, Adjustments, and General Ledger Account as well as transaction statuses against your Cash Code Groups and Bank Instruments. This provides you with the necessary analysis needed to support the ongoing conduct of the treasury business.

You can define the dimensions for the Cash Management Data Mart on Cash Ledger Data Mart Setup (CBDM.1).

These dimensions are required for the Cash Management Data Mart:

Dimension	Description
Calendar	Define the parameters for the time dimension of your data mart. After you have defined your parameters, you can select Adjustments to change their default settings such as data consolidations and member names.
Intraday	Define the Cash Management Data Mart's Intraday dimension. Because you can run the Cash Management Data Mart several times a day, the Intraday dimension saves each run's data separately.
Currency	Define the currency dimension in the Cash Management Data Mart. On this form, you need to specify how you want the system to calculate the currency that populates the data mart.
Organization	Specify which company or company group you want to include in the Cash Management Data Mart.
Cash Code	Define the cash code dimension in the Cash Management Data Mart. On this form, you must specify the cash code groups and in what order you want them to populate the data mart.
Tran Status	Provide member names for the balance and status metrics in the Cash Management Data Mart.
Bank Inst	Provide member names for the bank instruments that you want to include in the data mart.