Dimensions are the components that label, store, and arrange data. Each dimension contains a hierarchy of related members grouped in a parent/child structure. In Oracle Planning and Budgeting Cloud (PBCS), there are seven dimensions out of the box which are Account, Currency, Entity, Period, Scenario, Version, Year. (See the links for each of the Oracle Docs for information on each of these dimensions.)
You can also create up to 13 user-defined custom dimensions. One of the user-defined dimensions that should be essential for any organization that loads data from multiple sources is the Source dimension.
The Source dimension allows users and administrators to readily identify the location from which the data originated. Common types of sources are:
Source dimensions are especially useful for data reconciliation. It is often difficult to reconcile slices of data to a specific source once data is aggregated in the database. With a source dimension, users can refresh the dataset with the specific source member and compare to source information.
For reporting, "Total_Source will combine all of the data at the aggregated level.
So, does your organization use a "Source" dimension in the application? If not, I strongly recommend this during your next upgrade.
Want to learn more about Oracle PBCS ? Please complete the form below and we'll get back to you shortly.
Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost