What's new in Customer Journeys?

Connect and learn more!
Essbase data load rule and SQL interface error — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase data load rule and SQL interface error

Received Response
edited May 27, 2020 12:52PM in Essbase 8 comments


Object not found when running a SQL interface based rule



We have the following error when executing both a SQL interfaced based Data Load Rule or Data Build Rule.

1. We define a connection toward ADW which validates OK

2. We define a data source, the query is recognized and works OK

3. We create a script (rule) : database / inspect / scripts / rule, rules is set up and validates OK

4. We load data using the DLR KO

Error while executing SQL "Select 
    'C' || fc.compte as indicateur,
    'M' || TO_CHAR(fc.date_ecriture, 'MM') as mois,
    fc.cod_section as section,


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!