10.5.3 Oracle Essbase - Mapping Data Points to Essbase
Data points can be linked to Essbase
- individually using the Value panel;
- via drag and drop;
- via the "Insert Object(s)" ribbon button; and
- "Ctrl + T" keyboard shortcut.
Value Editor panel
If you change the data adaptor to “Oracle Essbase” or click on the Configure Data Adaptor button, the following form will appear:
Member selector
Context Defaulted Dimensions
Other dimensions are all dimensions other than those that have been given a context. When mapping a document, unless a member is explicitly used from a dimension, it will be assumed to be the top member for that dimension
Drag and drop
Speed Up Mapping By Disabling Auto-Update
When Essbase adaptors are modified by dragging and dropping a member onto a row, column, or entire table, the value of each data adaptor that is modified will be retrieved from Essbase. This will introduce a delay between the dropping of a member and initiating the next drag action. This delay will depend on how many objects are updated and the speed of the Essbase connection. If the delay is noticeable, you can speed up the mapping process by temporarily disabling auto-update using the toggle button at the top of the Automation panel:
With this toggled on, Report Authority will store the connection changes but will not attempt to retrieve data from Essbase. You can complete your mapping, and once completed, you can trigger the global refresh links process.