Forum Stats

  • 3,757,491 Users
  • 2,251,236 Discussions
  • 7,869,842 Comments

Discussions

Error parsing formula for [FIX STATEMENT] (line 1): unknown member name ["Explicit"] in function [@I

Sardonix
Sardonix Member Posts: 17
edited Jun 7, 2015 6:40PM in Financial Data Management

First and foremost we're having similar issue as Nathan below -- with slightly different errors for different period loads.  I load Jul-FY14 and data loads, returns error list with 10-15 lines similar to Essbase load errors (rejected members).  I load Aug-FY14 and get the message below.  My question is this -- if the same location, category and only period is different, why is the error behavior different.  I would expect BOTH to either return the error list (rejected members) with errors in the error report box or both blow up with the below error.

Thoughts??   FDM/ESSBASE 11.1.2.2:500

Thanks, Tim Smith

(Thanks to Nathan -- sure you got your issue resolved by now)

========= Nathan's post =========

Hi,

V11.1.2

I am trying to export data to essbase from fdm. I have got a data file to import and validate. However, when I do an export I receive the following error

Data Clear Error

Calc Script Failed.

Code=10410

Description=Essbase API Procedure: [EsbCalc] Threw code: 1200497 - 1200497 - [Tue Mar 01 10:19:59 2011]<server</<appname>/<databasename>/nathan.goodearl/Error(1200497)

Error parsing formula for [FIX STATEMENT] (line 1): unknown member name ["Explicit"] in function [@IDESCENDANTS]

I have exported the data load and there is a single data entry which shows each dimension and the amount aggregated. From the error is appears it is trying to load this one line instead of the level zero data. I am fairly new to FDM so the way to data is presented might be correct....either way the data isn't being loaded to Essbase.

Thanks,

Nathan

Tagged:

Answers

  • Francisco Amores
    Francisco Amores Member Posts: 1,693 Bronze Crown
    edited Jun 7, 2015 6:40PM

    Hi,

    First and foremost we're having similar issue as Nathan below -- with slightly different errors for different period loads.  I load Jul-FY14 and data loads, returns error list with 10-15 lines similar to Essbase load errors (rejected members).  I load Aug-FY14 and get the message below.  My question is this -- if the same location, category and only period is different, why is the error behavior different.  I would expect BOTH to either return the error list (rejected members) with errors in the error report box or both blow up with the below error.

    So it seems that the clear script FDM executes for Essbase is raising the error only when you run Aug. For July it is not raising the error but probably non existing members in Essbase.

    So you would need to do some troubleshooting.

    Have you customized the adapter action scripts or running specific calc scripts you created for clear?

    I would also write the FIX statement being executed by FDM in a log so you can see the final statement executed in Essbase. You can do that by modifying the action script LOAD in the Essbase adapter.

    Hope that helps.

This discussion has been closed.