Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Essbase Substitution Variables and Import Formats

783124May 3 2012 — edited May 4 2012
Does anyone please know of a way to make use of Essbase Substitution Variable values in FDM Import Format scripts? We would like to load data through FDM to Essbase based on the current version substitution variable (i.e. &CurVersion), so that the data is submitted against the correct member.

We have tried writing "&CurVersion" into the respective column of the .DAT file, however Essbase is unable to import data to "&CurVersion", throwing an error saying that this is not a valid member (even with the quotation symbols removed)

Does the FDM Essbase adapter allow for substitution variables to be used? If so, how can we go about this? The only other alternatives we can think of are to:
a) Process the .DAT file before it is imported to Essbase, to replace all occurrences of "&CurVersion" with the actual subsitution variable value retrieved using MaxL inside a batch script)
b) Load the data to a different member, and then copy inside Essbase using a calc script.

A better solution would be more preferable!
This post has been answered by SH_INT on May 3 2012
Jump to Answer

Comments

SH_INT
Answer
Use a load rule from FDM to load the data ignore the FDM value for version in the generated .dat file and set the load rule to use the substitution variable in its header for the Version dimension.
Marked as Answer by 783124 · Sep 27 2020
783124
Perfect, this will definitely be a more preferable solution, thanks!
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details