COMMANDS
COMMANDS- frequently used commands are:
- SET COMMANDS
- FIX COMMANDS
- IF . . . ELSEIF . . . ELSE . . . ENDIF
- AGG
- CALC DIM
COMMANDS
COMMANDS- frequently used commands are:
COMMENTS
OPERATORS
Operators define equations for Business Rules.
There are three types of operators:
FIX COMMANDS
The FIX . . . ENDFIX command block restricts calculations in a BSO database to a specific set of members within that database.
COMMANDS- frequently used commands are:
Calculation Manager
allows Service Administrators to create, validate and deploy scripts, rules and rulesets.
• Service Administrators can launch rules from Calc Manager, which can be useful
during testing.
Oracle Business Rules:
BUSINESS RULES- EPBCS
Business Rules are used to calculate stored data that persists in the database.
Oracle EPBCS (Enterprise Planning and Budgeting Cloud Service)?
EPBCS has world-class Budgeting and Forecasting, Data management, and Analysis capabilities of Oracle Hyperion Planning.
EPBCS (Enterprise Planning and Budgeting Cloud Service) | PBCS (Planning and Budgeting Cloud Service) |
1. 3 BSO - Custom Plan Types | 3 BSO - Custom Plan Types |
2. 3 ASO - Custom Plan Types | 3 ASO - Custom Plan Types |
3. 1 Consolidated Reporting Cube | 1 Consolidated Reporting Cube |
4. EPBCS MODULES- Pre Built |
|
1. Financials | |
2. Workforce | |
3. Capital | |
4. Projects | |
5. Strategic modeling | |
5. FDMEE( Integration Tool) supports | |
6. Smart View, FR (Reporting Tool) supports |
2. Difference between PBCS& EPBCS
6. Configuration of EPBCS Modules.
7. Creating an EPBCS Application.
8. Metadata and Data loading
9. Data Maps/Smart Push.
10. Task List, Data Form, and Calculation Manager Rules.
11. Smart List
12. Menus
13. Valid Intersection.
14. Navigation Flow
15. Workflow
16. Dashboard
17. Migration
18. Security
19. Cloud Data Management
20. Smart View
21. EPM Automate Utility
22. Business Rules
=============Interview EPBCS=====
1. Interview Questions- EPBCS.
1. What is Hyperion Software?
Hyperion Software is an OLAP/Multi-Dimensional/BI/BPM/EPM Tool.
2. What is Hyperion Essbase?
Essbase is a multidimensional database where the data will be stored in cells & Blocks.
3. What are the two storage options available in Essbase and what are the differences?
Difference between BSO- ASO
BSO(Block Storage Option) | ASO(Aggregate Storage Option) |
1. Write back in BSO. | No write-back in ASO |
2. most of the Dimensions are dense in BSO | Most of the dimensions are sparse in ASO |
3. can create more than 1 database per Application in BSO | cannot create more than 1 database per Application in ASO |
3. Less no. of Dimensions(between 4 and 8) in BSO | large number of dimensions (more than 10) in ASO |
4. Much suited for planning applications. | Not much suited for planning applications. |
5. Calc Script/Two-Pass/Attribute Dimension | no Calc Script/Two-Pass/Attribute Dimension |
6. Supports LRO | Doesn’t Support LRO |
7. Convent BSO to ASO | can’t convert ASO to BSO |
8. Currency Conversion | No Currency Conversion |
9. Supports- Partitions- Linked, Transparent, Replicated | support - Linked& Transparent |
10. Copy Database | no- Copy Database |
11. Sparse, Dense | no- Dense, sparse |
12. parent level- loading data | no - parent level- loading data |
13. Attribute Dimension | attribute dimensions- Sum only |
14. Dynamic time series | no- Dynamic time series |
15. at any level, we can load | can load Data only to” Level 0” in ASO |
16. Not Available DTS | available DTS |
EPBCS Interview Questions
1. Can we create multiple Applications in EPBCS?
In PBCS/EPBCS, it's limited to One application per environment. If you want more you may have to buy a new POD, per App.
2. Can I delete application in PBCS/EPBCS environment?
Yes, you can delete application and create a new one yourself.
3. What is the amount of space allocated for my application?
Including backups (inbox/outbox) and application size, it can grow up to 150 GB.
========
EPBCS Basic Questions
* Oracle EPBCS (Enterprise Planning and Budgeting Cloud Service)?
EPBCS has world-class Budgeting and Forecasting, Data management, and Analysis capabilities of Oracle Hyperion Planning.
* How many Dimensions are there in EPBCS?
20 Dimensions in EPBCS
* How many plan types are there in EPBCS?
3 BSO Plan Types and 3 ASO Plan Types
single Planning application with m
* Difference between EPBCS, PBCS?
EPBCS (Enterprise Planning and Budgeting Cloud Service) | PBCS (Planning and Budgeting Cloud Service) |
1. 3 BSO - Custom Plan Types | 3 BSO - Custom Plan Types |
2. 3 ASO - Custom Plan Types | 3 ASO - Custom Plan Types |
3. 1 Consolidated Reporting Cube | 1 Consolidated Reporting Cube |
4. EPBCS MODULES- Pre Built |
|
1. Financials | |
2. Workforce | |
3. Capital | |
4. Projects | |
5. Strategic modeling | |
5. FDMEE( Integration Tool) supports | |
6. Smart View, FR (Reporting Tool) supports |
* How many cubes can be created in EPBCS?
EPBCS provides 7 total cubes:
Each of these cubes has a unique aggregate storage application name.
* Dimensions in EPBCS?
* What are the advantages of EPBCS?
EPBCS comes with custom planning, free-form planning, and customized groovy scripts offered as Enterprise cloud features. Pre-built content can be gradually customized to your planning needs, and all modules can be integrated with each other.
* What are the features of EPBCS?
* What is Oracle EPBCS used for?
EPBCS is a flexible application based on Oracle Hyperion Planning that supports Enterprise-wide Planning, Budgeting, and Forecasting in a cloud-based deployment model.
* Who uses EPBCS?
EPBCS is utilized by Budget Managers to create the annual Budget and by KU departments and SSCs to manage their budget which includes Tracking/Forecasting revenue and expenses.
==========DIFFERENCE================
* What is the difference between Hyperion Planning and EPBCS?
Oracle EPBCS includes pre-built yet flexible dashboards that can fit your exact dimensionality, a feature that is missing from Hyperion Planning.