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 Calculation Script Parameter (with spaces)

MikeTONov 14 2017 — edited Nov 20 2017

Hi All,

I have an Essbase target application with calculation scripts using Runtime Variables.  In my target application setup, when I select POV Category to pass the category name (Forecast October) as a runtime variable, Essbase ultimately errors out because it wants double quotes around words with spaces in its fix statements.  I was able to workaround this quite easily by putting "Forecast October" in my data load rule integration options field #2 and reference it in the calculation script parameters.

Just curious if there is a way to make FDMEE pass quotations along to Essbase when using the POV Category parameter in my Essbase Target application settings.

Thx,

Mike

Comments

InoL

I am currently also working on a Forms to Apex conversion and encounter the same problems. Alas, you do have to make Ajax calls and confirm dialogs before actually submitting the page.

This (in my case anyway) means a redesign of Forms processing.  All the necessary checks need to be done before submitting the page. So, a Form proces like this:

<do something>

<confirm?>

<do something>

<confirm?>

<final commit>

has to be redesigned to

<do some checks via an Ajax call without committing data>

<confirm?>

<post and commit>

This usually means you first get all the confirmation messages back in one message instead of multiple confirms (as was usually the case in Forms).

If this kind of redesign is not possible, you should hold temporary results in a collection before actually committing the data.

BTW: it gets worse when you have Forms with a POST-FORMS-COMMIT trigger!

Niels IH

Thanks for your reply

Perhaps collections are the way to go. I would rather not offcourse.

I think it will mean that i have to rewrite the standard save action of the interactive grids to process the row(s) through ajax and handle the user interaction before they are actually submitted by the grid.

Perhaps i can come up with some plugin design to do this in a more general way..

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 18 2017
Added on Nov 14 2017
5 comments
488 views