Performance of Run Time Prompt Limits in Calc Manager

When using run time prompt limits in Calc Manager, performance is faster when using Essbase member list functions that are explicitly defined and accessed directly in Planning. The following member list functions are defined in Planning

  • @CHILDREN
  • @ICHILDREN
  • @DESCENDANTS
  • @IDESCENDANTS
  • @ANCESTORS
  • @IANCESTORS
  • @SIBLINGS
  • @ISIBLINIGS

Member list functions not defined in Planning can also be used. However, any member list function that is not defined in Planning accesses Essbase using the Essbase Outline API calls. The outline API calls are considerably slower since they require opening the outline in order to obtain the member list. Opening outlines, especially large outlines, can take a long time to complete.

Click to Download Performance of Run Time Prompt Limits in Calc Manager (Right click or option-click the link and choose "Save As..." to download this pdf file)

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: ahmed awan]

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today