Pages

Monday, January 9, 2012

Hyperion Essbase Limitations

Hyperion Essbase Names and Related Artifacts Limit Size Table

Artifact
Limits
Alias name
  • Non-Unicode application limit: 80 bytes
  • Unicode-mode application limit: 80 characters
Alias table name
  • Non-Unicode application limit: 30 bytes
  • Unicode-mode application limit: 30 characters
Application name
  • Non-Unicode application limit: 8 bytes
  • Unicode-mode application limit: 30 characters
Application description
  • Non-Unicode application limit: 79 bytes
  • Unicode-mode application limit: 80 characters
  • Custom-defined function name
  • Custom-defined macro name
  • Custom-defined function specification
  • Custom-defined macro specification
  • Non-Unicode application limit: 127 bytes. MaxL and the API truncate characters after 127 bytes.
  • Unicode-mode application limit: 128 characters. MaxL and the API truncate characters after 128 characters.
In either case, no truncation on server. No error is displayed if truncation occurs.
Custom-defined function and macro comment
  • Non-Unicode application limit: 255 bytes. After 255 bytes, characters are truncated by MaxL and API.
  • Unicode-mode application limit: 256 characters. MaxL and the API truncate characters after 256 characters.
In either case, no truncation on server. No error is displayed if truncation occurs.
Database name
  • Non-Unicode application limit: 8 bytes
  • Unicode-mode application limit: 30 characters
Database description
  • Non-Unicode application limit: 79 bytes
  • Unicode-mode application limit: 80 characters
Directory path
For example: Hyperion/products/Essbase/EssbaseServer/bin
  • Non-Unicode application limit: 256 bytes
  • Unicode-mode application limit: 1024 bytes
Environment variable name
320 bytes (Unicode- and Non-Unicode-mode applications)
Environment variable value
256 bytes (Unicode- and Non-Unicode-mode applications)
File name for calculation scripts, report scripts, or rules files
  • Non-Unicode application limit: 8 bytes
  • Unicode-mode application limit: If included within a path, the smaller of the following two values:
    • 1024 bytes
    • The limit established by the operating system
If not included within a path, as in some MaxL statements, 1024 bytes.
Filter name
  • Non-Unicode application limit: 30 bytes
  • Unicode-mode application limit: 30 characters
Group name
  • Non-Unicode application limit: 30 bytes
  • Unicode-mode application limit: 30 characters
LRO cell note
  • Non-Unicode application limit: 600 bytes
  • Unicode-mode application limit: 600 characters
LRO URL
512 characters (always single-byte characters)
LRO description for URLs and files
  • Non-Unicode application limit: 80 bytes
  • Unicode-mode application limit: 80 characters
Member comment field
  • Non-Unicode application limit: 255 bytes
  • Unicode-mode application limit: 256 characters
Member name
  • Non-Unicode application limit: 80 bytes
  • Unicode-mode application limit: 80 characters
Essbase Server name
  • Non-Unicode application limit: 29 bytes
  • Unicode-mode application limit: 50 characters
Qualified member name limit: the number of levels that can be specified in a qualified member name
  • 20 levels
Password
  • Non-Unicode application limit: 100 bytes
  • Unicode-mode application limit: 100 characters
Substitution variable name
320 bytes
Substitution variable value
256 bytes
Trigger name
  • Non-Unicode application limit: 30 bytes
  • Unicode-mode application limit: 30 characters
UDA
  • Non-Unicode application limit: 80 bytes
  • Unicode-mode application limit: 80 characters
User name
  • Non-Unicode application limit: 30 bytes
  • Unicode-mode application limit: 30 characters
Other Size or Quantity Limits:

Artifact
Limits
Caches: data, data file, and index
2 GB
Formula size
64 KB
Number of security filters
  • Per Essbase Server: 65535
  • Per Essbase database: 32290
Number of users and groups (combined)
30,000 Exceeding this limit results in an error.
Number of aggregate views within an aggregation
1023
Rules file maximum record size
64 KB

No comments:

Post a Comment