When working with Oracle's PBCS (Planning and Budgeting Cloud Service), the Data Load process can get a little tedious. Anywhere from building the application to creating dimensions and members, one single error can cause the data load to fail. Every step requires paying utmost attention to every detail (Names, properties, etc.).
FDMEE gives Financial Analysts total control of the integration process to define source data, create mapping rules to translate data into the required target format, and to execute and manage the periodic data loading process. There are 3 main stages while running Data Load:
Often times, the importing stage fails as a result of improper dimension mapping. You should begin by auditing the dimensions in Import Format to correspond to the file you are loading. A single mismatched dimension could cause the importing stage to fail.
If all of the dimensions are mapped correctly, and you are still dealing with an error message, move on to the design analysis.
Unique Designs in a company’s data structure makes the one-to-one mapping process extremely complex.
Resolving data quality prior to moving forward with any mapping would be imperative to ensure the accuracy of all future integrated reporting and, ultimately, the success of the project.
In data validation stage, Data Management attempts to validate the loaded data with the existing members in the application.
If you encounter the following error messages during the export stage, the dimensions and members are not likely to be mapped correctly. Even a dimension name can cause the same problem.
Look through the loaded file, confirm that all the dimensions abide by the Import Format
Check the header of the file and see if there is any special characters (#,!, etc.)
Using SmartView, confirm that there are no duplicated members and make sure that all of the dimensions are valid for its specific Cube. Lastly, fix the member properties if there is any error found
These are just a few common error messages that I encountered while working through Data Management in FDMEE. There will be many other error codes if the application and format are not set correctly.
"Getting errors might feel frustrating and overwhelming, but the accomplishment of working through the errors and successfully fixing them are extremely satisfying for Paradigm SES Consultants like myself."