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

4 concurrent sql loads using the "multiple rules_file syntax"

Received Response
9
Views
4
Comments
edited Aug 2, 2018 2:36AM in Essbase 4 comments

Summary

4 concurrent sql loads using the "multiple rules_file syntax"

Content

Essbase manages the creation and committing of buffer data, and I am looking for a way to specify to "override" the existing values when the data commits from the buffer to the cube as follows:

import database $apNAME.$dbNAME data connect as \"$USER\" identified by \"$PWD\" using multiple rules_file datload1, datload2, datload3, datload4 to load_buffer_block starting with buffer_id 1967 on error write to \"$ERR_FILE\";

This is supported by easy SQL statements but we know that the easy SQLs will contain duplicated data.

Is there a way to direct Essbase to override values using this syntax?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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