Thoughts, ideas and solutions from a few EPM consultants.
Featured-post FDMEE Load Rule

Spaces in FDMEE Load Rules? No Problem!

Keith Kikta

Let's be honest underscores or hyphens as a replacement for spaces are ugly. "Load Actuals to Planning" looks way better than "Load_Actuals_to_Planning" or "Load-Actuals-to-Planning". Unfortunately, if you have spaces in a load rule name it can be hard to execute it via the loaddata.bat command provided by FDMEE.

Example 1: The spaces just act as more arguments

E:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality>E:/Oracle/Middleware/user_projects/epmsystem1/financialdataquality/loaddata.bat username -f:password Load Actuals to Planning Y Y STORE_DATA REPLACE N JUN2019 JUN2019 SYNC
Number of arguments: 12
Argument 0: loaddata
Argument 1: username
Argument 2: -f:password
Argument 3: Load
Argument 4: Actuals
Argument 5: to
Argument 6: Planning
Argument 7: Y
Argument 8: Y
Argument 9: STORE_DATA
Argument 10: REPLACE
Argument 11: N

EPMFDM-140149:Invalid data rule name Load specified.
Each space becomes a new argument

Example 2: Escaped quotes look a little better but even then its expecting to see a load rule with double quotes in the name.

E:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality>E:/Oracle/Middleware/user_projects/epmsystem1/financialdataquality/loaddata.bat username -f:password \"Load Actuals to Planning\" Y Y STORE_DATA REPLACE N JUN2019 JUN2019 SYNC
Number of arguments: 12
Argument 0: loaddata
Argument 1: username
Argument 2: -f:password
Argument 3: "Load Actuals to Planning"
Argument 4: Y
Argument 5: Y
Argument 6: STORE_DATA
Argument 7: REPLACE
Argument 8: N
Argument 9: JUN2019
Argument 10: JUN2019
Argument 11: SYNC

EPMFDM-140149:Invalid data rule name "Load Actuals to Planning" specified.
Spaces work but the quotes change the meaning

So it seems as if we have no choice, we have to use something other than space!? Not so fast, it just so happens that the loaddata batch command treats plus (+) signs as spaces, similar to how web search engines use plus signs to represent spaces in a URL.

Notice the URL in the Address Bar

So keep using spaces. If you need to call a load rule via batch for say scheduling purposes, just replace the spaces with plus signs.

E:\Oracle\Middleware\user_projects\epmsystem1\FinancialDataQuality>E:/Oracle/Middleware/user_projects/epmsystem1/financialdataquality/loaddata.bat username -f:password Load+Actuals+to+Planning Y Y STORE_DATA REPLACE N JUN2019 JUN2019 SYNC
Number of arguments: 12
Argument 0: loaddata
Argument 1: username
Argument 2: -f:password
Argument 3: Load Actuals to Planning
Argument 4: Y
Argument 5: Y
Argument 6: STORE_DATA
Argument 7: REPLACE
Argument 8: N
Argument 9: JUN2019
Argument 10: JUN2019
Argument 11: SYNC

EPMFDM-140173:Rule execution completed successfully.
Changing spaces to plus signs work!
Share twitter/ facebook/ copy link
Please enter at least 3 characters 0 Results for your search