FDM export to Essbase error

787126 Jul 28, 2010 9:11 PM

Hello,

I'm trying to Export data from FDM to Essbase. When I export using the 0-Replace method, I get the following error:

Data Clear Error
Calc Script Failed.
Code=10410
Description=Essbase API Procedure: [EsbCalc] Threw code: 1012004 - 1012004 - [Wed Jul 28 15:40:11 2010]XXXXX/PLANNING/IncStmt/admin/Error(1012004)

Invalid member name [ ]
.

The 1-Merge method doesn't return this error - is load w/ replace not supported with Essbase?
If so, does anyone know how to script a custom export event? It seems there is a way to link to a Load Rule, but I would like to generate these scripts in FDM.

There is a related thread:
FDM - Script
but this doesn't work for me. Do I link to a script of type Custom (General)?

Thanks in advance!

1. Re: FDM export to Essbase error

TonyScalese Jul 28, 2010 9:35 PM (in response to 787126)

You're mapping to a member that does not exist in Essbase. Check your maps.
Like Show 0 Likes(0)

Actions
2. Re: FDM export to Essbase error

787126 Jul 28, 2010 9:55 PM (in response to TonyScalese)

Thanks for your reply.

When I try to link to a script (with a validation group), it gives me this error:

User [admin] cannot access calc script: AB

Otherwise if I don't link to that validation group (with the script details) it seems to import OK.
Like Show 0 Likes(0)

Actions
3. Re: FDM export to Essbase error

JeffJon Jul 29, 2010 3:08 PM (in response to 787126)

Looks to be an essbase permission error. Check that the admin user has access to the calc script that is identified in the error code.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.