Now that we've covered the basics of reporting against the cubes, let's make a few comments about each individual cube. When possible, we'll comment on the multiple measure groups that exist in a given cube. Refer to our previous discussion on incompatible measure groups and dimensions to ensure that mismatched measures and attributes do not cause havoc in your own report.
The Financials cube is probably the most useful and, not surprisingly, most popular cube. Data in this cube is pulled from the transaction tables of the General Ledger and Bank Reconciliation modules from GP. Additionally, multidimensional analysis information is included in this cube for those organizations that make use of this tool in GP.
Users should note the presence of an Amount – GL Trans measure and a Signed Amount – GL Trans measure in the GL Transactions measure group. The Amount – GL Trans measure is a measure calculated as debits minus credits. The Signed Amount – GL...