→ Hyperion 11.1.1 Documentation Library
Find more @ ↓
http://download.oracle.com/docs/cd/E12825_01/index.htm
→ New Enhancements to ESSBASE (EAS) in Hyperion 11.1.1
• Varying Attributes
• Typed Measures
• Backup, Transaction Logging and Replay
• Aggregate Storage Partial Data Clear
• Aggregate Storage Databases as Targets of Partitions
• New Calculation Script Functionality
• New MDX Functions
Find more @ ↓
http://download.oracle.com/docs/cd/E12825_01/epm.111/eas_new_features.pdf
→ New Enhancements to Reporting and Analysis in Hyperion 11.1.1
Oracle Hyperion Smart View for Office
• Architecture and Data source Support
• Data Source Manager
• Smart Slices
• Report Designer
Oracle Hyperion Financial Reporting
• Copy and Paste Repository Items
• Improved Search Options
• External Content in Books
• Annotations
Oracle Hyperion Web Analysis
• Advanced Expressions in Calculations
• Formatting Usability Improvements
• Printing Improvements
• Import and Export Multiple Report Objects
Find more @ ↓
http://download.oracle.com/docs/cd/E12825_01/epm.111/hs_new_features.pdf
Source: http://www.oracle.com/
Monday, June 20, 2011
Tuesday, June 14, 2011
Aggregate Storage Outline
tes
“No” in ASO:
^
1. An aggregate storage outline cannot be converted to a block storage outline.
2. Do not use the file system to copy a block storage outline into an aggregate storage application.
3. ASO can have only “Stored” and “Dynamic” hierarchies.
4. Multiple hierarchies enabled dimension is automatically tagged as label only.
5. Essbase automatically tags the dimension as a stored hierarchy.
6. You cannot specify the accounts dimension as a stored hierarchy. (Default dynamic)
7. The first hierarchy in a multiple hierarchies enabled dimension must be a stored hierarchy.
8. Stored hierarchies cannot have formulas.
9. Stored hierarchy dimensions cannot have shared members.
10. If a member has the no-consolidation operator (~) on all its children, the member must be tagged as label only.
11. A stored hierarchy cannot contain a non shared instance and a shared instance of the same member. Non shared instances of a member must be in the same dimension as the shared member (same for block storage outlines).
12. A stored hierarchy can contain a shared instance of a dynamic hierarchy member only if the dynamic hierarchy member is a level 0 member without a formula.
13. A shared member automatically shares any attributes that are associated with its non shared member.
14. Dynamic hierarchies can contain any consolidation operator.
15. Dynamic hierarchies can have formulas.
16. If a member has the no-consolidation operator (~) on all its children, the member must be tagged as label only.
17. Do not increase the maximum size of the aggregate storage cache beyond what is needed.
18. Time balance reporting is not supported with Dynamic “Time” dimension. Time dimension must be stored hierarchy to support Time balance reporting without Skip zeros and shared members must be at level zero.
19. No write back capability (ASO – BSO transparent partition is a workaround).
20. Cannot load data to non-level zero members in an aggregate storage outline.
Please refer Essbase Adim Guide for more information on Aggregate Storage Kernal (ASO).
“No” in ASO:
^
1. An aggregate storage outline cannot be converted to a block storage outline.
2. Do not use the file system to copy a block storage outline into an aggregate storage application.
3. ASO can have only “Stored” and “Dynamic” hierarchies.
4. Multiple hierarchies enabled dimension is automatically tagged as label only.
5. Essbase automatically tags the dimension as a stored hierarchy.
6. You cannot specify the accounts dimension as a stored hierarchy. (Default dynamic)
7. The first hierarchy in a multiple hierarchies enabled dimension must be a stored hierarchy.
8. Stored hierarchies cannot have formulas.
9. Stored hierarchy dimensions cannot have shared members.
10. If a member has the no-consolidation operator (~) on all its children, the member must be tagged as label only.
11. A stored hierarchy cannot contain a non shared instance and a shared instance of the same member. Non shared instances of a member must be in the same dimension as the shared member (same for block storage outlines).
12. A stored hierarchy can contain a shared instance of a dynamic hierarchy member only if the dynamic hierarchy member is a level 0 member without a formula.
13. A shared member automatically shares any attributes that are associated with its non shared member.
14. Dynamic hierarchies can contain any consolidation operator.
15. Dynamic hierarchies can have formulas.
16. If a member has the no-consolidation operator (~) on all its children, the member must be tagged as label only.
17. Do not increase the maximum size of the aggregate storage cache beyond what is needed.
18. Time balance reporting is not supported with Dynamic “Time” dimension. Time dimension must be stored hierarchy to support Time balance reporting without Skip zeros and shared members must be at level zero.
19. No write back capability (ASO – BSO transparent partition is a workaround).
20. Cannot load data to non-level zero members in an aggregate storage outline.
Please refer Essbase Adim Guide for more information on Aggregate Storage Kernal (ASO).
Thursday, April 28, 2011
EIS (Essbase Integration Services)
Essbase Integration Services enables to create Essbase cubes directly connecting to the tables, views and columns of relational databases and data warehouses. It acts as a bridge between the relational data sources and Essbase applications for transferring metadata and data. This is done through a logical model created from tables and columns in the relational database called as OLAP model. This OLAP model is then used to generate a Metaoutline. A Metaoutline is an outline template that contains the structure and the rules required to generate an Essbase database outline. This eliminates building of dimension build and data load rules, thereby reducing development time. 
Features: Essbase cubes built through EIS as two features,
- Hybrid Analysis
- Drill-Through Reports
Latest Versions: Hyperion 11 (as of April 2011). In this new version for Essbase, a new concept has been introduced called as "XOLAP". ( we shall discuss on this in another post)
Related Information:
- Everything about EIS from Oracle - http://www.oracle.com/technetwork/middleware/bi-foundation/integration-services-086831.html
Subscribe to:
Posts (Atom)