HYPERIONISM

Hyperion Planning + OBIEE v/s Jedox EPM/BI suite

2016-03-28T00:36:00.003-07:00

Hyperion Planning + OBIEE v/s Jedox EPM/BI suite

After working in Hyperion suite of products for more than 9 years I got an opportunity to work on another EPM/BI suite of products called Jedox (http://www.jedox.com/en/) . To be honest after being in a relationship for 9 years with Hyperion it was a tough situation to try something new J . In past 9 years I rarely got a chance to work on something other than HYPERION ( Worked on MS BI and few other BI tools like Tableau for a small POC and evaluation), so was pretty excited and tensed when I got into Jedox .. So, below are few things on which I can compare Hyperion suite of products (Planning,Essbase, FDM and OBIEE) v/s Jedox . As I don’t have much exposure to some other Hyperion products like HFM, ODI, don’t think I am a correct person to compare it with any other product. Also, as stated prior about 9 years of love affair with Hyperion I will still try to be as neutral as possible ( That would be tough!!)

1. Ease of Application Building/ Dimension building :

Hyperion Essbase : There are multiple ways to build your dimensions in essbase like manually adding members in EAS, using rule files or using some other ETL tools like ODI.

Hyperion Planning: Again same as Essbase there are multiple ways like using outline load utility, EPM , ODI etc..

Jedox: Dimension building is pretty simple in Jedox. Similar to Essbase, you can add members manually or using flat files or from RDBMS using in-built ETL. One more flexible option in Jedox is that you can build dimension just by copy+pasting data from excel/text file into Jedox Excel Ad-in.

Overall, both products are pretty developer friendly when it comes to dimension building. One advantage of Jedox over Hyperion is that as it is in-memory product you don’t have to go through painful dense restructures after adding members in your Account/Period dimension. Hyperion gives much more properties tagged to members (Like Skip missing while taking average or Balance account etc) which are missing in Jedox and can be achieved only by using database formula.

2.Calculation capabilities:

Hyperion Essbase/Planning: Hyperion has very powerful calculation engine. There are multiple ways to perform complex calculations required for planning/budgeting. With extensive list of functions available you can fulfil almost all kind of business requirements.

Jedox: In Jedox you can perform simple calculations using DB formula (Similar to essbase member formula) for complex calculations you need to use ETL transformations

Hyperion is a clear winner when it comes to complex calculations and ease of doing it. Jedox calculations will be faster, but it has limitations. It is extremely difficult ( sometimes impossible) to perform some of the complex calculations in Jedox ETL which are pretty simple to do in Hyperion.

Customization of Look-n-Feel :

Jedox clearly has an upper hand, when it comes to customization. In Hyperion there is very limited opportunity to customize artifacts like user webform or user task lists. Jedox interface in simple words is like an enhanced excel which you can publish, so possibilities are limitless.

ETL capabilities:

Hyperion Essbase/Planning adapters are available in various ETL tools like FDM, ODI, ERPi, EIS (No longer there) . Jedox has its own ETL module which can perform all kind of ETL operations.

No one is a clear winner here. If you want to integrate your EPM with Oracle GL then definitely Hyperion has more options and more in-built capabilities. Jedox ETL is comprehensive as well and can perform most of the ETL tasks. From licencing standpoint, for Jedox you don’t need to buy one more ETL , whereas in Hyperion in most of the cases you do need to pay for ETL separately.

In-Built planning/Budgeting features:

Hyperion Planning gives many out of the box features like tasks lists or workflow which are not available readily in Jedox. But, you can build them as per your requirements with some efforts and knowledge of PHP.

BI capabilities:

Jedox is much better in terms of quick turn-around time and performance when it comes to building BI dashboards and reports. I found building a dashboards and interactive reports more convenient in Jedox as compared to OBIEE. For basic Financial Reports (generally achieved using HFR in Hyperion ) will take similar efforts in both products. May be in Jedox you can customize them more as it is basically excel report published as Web report.

Server Maintenance/Installation :

Jedox has very straight forward installation and it’s pretty simple in terms of server maintenance as well. You won’t require a full time server admin in case of Jedox. Again, with the evolution of oracle cloud and PBCS this might be an invalid point in future. Jedox also has its own cloud offering.

Application Maintenance/Support :

I personally think that supporting/ maintaining Hyperion application would be simpler as compared to Jedox (Again this might be because of 9 years of in-relationship status with Hyperion :P ). In a complex Jedox application you certainly need to use custom PHP widgets which can be painful to maintain and support in a long run, whereas in Hyperion customized codes are limited and can be easily handover to support team.

Cost :

Jedox licences are much cheaper as compared to Oracle Hyperion licences. Overall Jedox product cost would be half as compared to Hyperion.

So, overall it’s not really possible to say one product is a clear winner. Both have pros and cons, both have strong points and weakness. Hyperion is much more matured and robust as compared to Jedox. Jedox is much faster and cheaper than Hyperion. Calculation capabilities of Hyperion are unparalleled; customization capabilities of Jedox are limitless. Depending upon requirements and situation any one of them can be a winner..

Entering TEXT data in Essbase using Text List

2011-09-28T01:06:00.000-07:00

Hi All,

In essbase 11 onwards there is an option to have planning smartlist like functionality in Essbase cube .. This new functionality is called Text List .. Just like planning smartlist, using essbase text list you can enter Text data in essbase also, you can restrict entries as in smartlist. Following is the process for having textlists in Essbase.

1. Enable type measures for essbase database : Go to Outline Properties and enable Typed measures.

Add caption

2. Creating Text List : Just like planning smartlist , create Essbase text list by going into Text List Manager Tab. In below screenshot I have created a text list for inserting ratings.

3. Apply data type as Text and assign TextList : In below example I have assigned Rating Textlist to Rating account.

Now your Essbase tasklist is ready for use .. You can use it just like Smartlist from smartview. Also, using excel ad-in you can simply lock n send text data into Essbase. For calculation purpose just like Smartlist you can use id value ..

Cheerz!
-Chinmay Joshi

Application Error in FDM , after loading maps having "&" or "@" in it ..

2010-10-30T05:02:00.000-07:00

Hi,

This is a strange and known bug in FDM ( All versions from 8 to 11) , if you load any map with having & in any source member name it just corrupts FDM location ... Root cause of this issue is all FDM maps are stored in RDBMS and for any RDBMS & or @ are special characters so, it creates problems !!!... This is very irritating thing especially when you have given access to business users to load maps ..

Solution
1) Open the FDM Workbench Client and login to the application
2) Choose Tools/Table Editor
3) From the drop down list select the tDataMap table
4) In the "Find" box enter the location id for the location where the
mapping template was loaded. Scroll down to the entries in the table with
the DimName 'Account'. In the SrcKey field you will need to locate any
entries that contain reserved database characters (&,@, etc.). You can
delete these rows by highlighting them and clicking the X icon.
5) Click the Diskette Icon to save the changes.

-Chinmay

Block creation Issue

2010-07-17T07:50:00.000-07:00

Hi All,

Many times while writing Essbase calc scripts you must have encountered an issue of block creation i.e. you are not able to see any results for your simple calculations !...

Essbase normally create blocks when data is loaded, during aggregation of sparse dimensions
and as a result of a DATACOPY command.

Essbase does not create blocks as a result of most dense member assignment calculations. For
example based on the Sample.Basic outline, assume that “Sales” is a dense dimension member
and actual is a sparse dimension member. The following formula will fail because it will not
create new blocks for Budget.
FIX (budget)
"Sales"="Sales"->"Actual"*1.1;
ENDFIX

So, in short if you are performing some basic arithmatic calculations, essbase won't create new block for sparse dimensions.. This is done by essbase to improve it's calculation performance but it is a headache for developer..

Ways to tackle this issue are:

1.DATACOPY into Sparse Member:
You can use the data copy command to create blocks in the same pattern as the actual
blocks. In above example you can do DATACOPY ACTUAL TO BUDGET prior to writing calc. command... It will first create a block for Budget and then will overwrite a calculated value into it.. You can also fix some combination and always enter some dummy data into it as a part of your essbase process and can use this combination for block creation.

e.g. You can always enter '1' in Actual->Test_Acc and can use it for all block creation datacopy commands..

2. CALCULATION COMMANDS TO ENABLE BLOCK CREATION
You can also use SET CREATEBLOCKONEQ and SET CREATENONMISSINGBLK commands for block creation. But these commands are bit heavy on your calculation and degrades calc script performance so for big calc scripts it is always advisable to use DATACOPY approach...

Cheerz!
--CJ

Hyperion HBR Run time Prompt (RTP) issue.

2010-03-06T23:21:00.000-08:00

Hi,

Issue:

In Planning webform HBR is attached , RTP are used and are set as "Run on Save" , "Use Member on form" and "Hide Prompt", but still when we hit save button a pop-up appears asking for RTP members.

Solution:

1. Make sure that RTP type is set as 'Member' and not 'Members' ... RTP with type as 'Members' will always give a prompt as it is used to pass more than one member of a dimension.

2. If still problem exists...

2.1. Delete the RTP from BR

2.2. Create Local Variable RTP

2.3. Remove security and save BR.

2.4. Assign security and Save BR again.

Cheerz! :)

-Chinmay-

Design Essbase ASO aggregation

2010-01-15T02:19:00.000-08:00

Hi,

ASO cubes are by default dynamic in nature i.e. in ASO all aggregations happen on the fly .. So data is stored only at Lev 0 .. For small ASO cubes it gives pretty good performance in reporting, but for huge ASO cubes ( Generally which is the case) report performance is a concern ..

'Design Aggregation' feature of ASO is a good option provided by Essbase .. In aggregation data is calculated at upper level and stored, so data retrieval becomes much faster.. Following are the steps for designing aggregation for ASO cubes

1. Enable 'Query Tracking' : Query tracking will track data combinations which have more data values and which requires Agg to improve performance..
e.g. If you have 2 parents with 100 children each, then Query tracking will keep track of which all children have data for some combinations and will suggest in future required aggregate views .

2. Go to 'Design Aggregation'

3. First select Use recommended views to materialize aggregation .. It will show all the views selected by system .. It is a good practice to include them first in Agg view definition ... Select all these views and save and materialize them .

4. Go back to 'Design Aggregation' and now select second option .

5. Select 'Select all recommended aggregate views' .. You can specify total storage space in this screen

6. Select 'Use query Tracking data during view selection' (Option present at bottom) and click on Start .. It will show all views tracked by system using Query tracking ..

7. Save and materialize views..

8. Repeat these steps once you load any new data and save new aggregate views in existing saved aggregation..

If you change any dimension name or change property of member like if stored becomes Label Only or calculated one , then entire Aggregation becomes invalid and you need to re-do this process..

-Cheerz -- :)

Error while connecting to essbase from FR

2009-07-16T21:57:00.000-07:00

Hi,

This is the error that me and and some of my friends faced while connecting to Essbase from Financial Reporting Studio, while creating grid... Logging into FR studio is working fine that means HSS is up and running but while creating a report in FR when we drag a grid and try to connect to some essbase server it is throwing an Error: " Can't connect to server" so, new server connection is not getting established. Here is the solution :

1. Check if you can connect to any other Essbase server from Studio. If yes, then check if you are using correct login credentials to connect to essbase. Also, try to connect to that essbase server using your login credentials from Excel Add-in or SmartView or AAS.

2. Check if all BI+ Services are up and running on Server.

3. Stop and Start BI+ services in the following order:
1. BI+ Core Services
2. Workspace
3. Financial Reporting Java RMI
4. Financial Reporting Print Server
5. Financial Reporting Report Server
6. Financial Reporting Scheduler Server
7. Financial Reporting Web Server

5. If still problem exists, run config utility for BI+, and re-configure Database with Drop all tables option.

Cheerz!
-CJ

Book on Essbase Implementation

2009-06-28T05:32:00.000-07:00

Hey all,

Check this : New book for essbase implementation:

For more info..Check this link :

http://www.packtpub.com/oracle-essbase-9-implementation-guide

A great new book by Joseph Sydney Gomez, Sarma Anantapantula on Oracle Essbase 9 Implementation .. Looks impressive.. I think it is first of it's kind implementation guide on Hyperion Essbase ... Must buy for Hyperion practitioners and people who wants to jump into Essbase Space ! :)

Cheerz!
-CJ-

User/Groups are not visible in Planning Webform and Dimension while assigning access.

2009-03-31T02:48:00.000-07:00

Hi All,

This problem has been faced by many folks..Many times when you click on Assign Access for webforms/Dimension Members. There can be many reasons for this.

1. Check all the services are running fine.. Hyperion services create problems most of the times.. So, just restart services in order, it works in most of the cases.

2. Some issue with RDBMS, so just catch your DBA to get work done.

3. Some mis-sync between LDAP - SS . So, Try going to http://localhost:58080/interop/framework/configLogin
Login
Configuration > Sync OpenLdap

4. Just check that users have access to planning app and users are planners and not Admins, as admins won't appear in the list (I know this reason sounds funny but one of my friend made this mistake and we tried a lot of things).

Cheerz!

--Chinmay

Update on Hyperion Planning dim deletion

2009-03-17T09:51:00.000-07:00

Hey!

One of my friend tried deleting Planning Dim using procedure given below on 9.3.1 , and it worked!!! :)

--Chinmay

How to delete dimension from Planning Application

2009-02-12T05:14:00.001-08:00

This procedure should only be performed by your SQL or Oracle DBA.

** ~~THIS PROCEDURE IS TRIED AND TESTED ONLY ON 9.2 VERSION~~

BE SURE YOU HAVE A BACKUP OF YOUR APPLICATION BEFOREATTEMPTING THIS PROCEDURE.

You will need to delete all the children first, then the dimension.

If you have the dimension in forms, you may also need to (after step 5) go into the hsp_formobj_def_mbr table and delete all references of that object ID. Then delete the dim id in thehsp_form_layout table. Recycle services of Planning.
Procedure: If you create a custom dimension in planning and wish to delete it, here is how you might remove it from SQL manually. We recommend that only someone familiar with relational databases attempt this.
The following assumptions are being made about the dimension: No forms have any references to thedimension. Any and all attribute dimensions have been removed from the dimension. Any and all members have been removed from the dimension. All security access has been removed from dimension. Any Alias associated with the dimension has been removed.

In this example we have created a dimension called DummyDimension.

1. Open the Enterprise Manager for SQL server
2. Open the database that has your planning application
3. Open the table HSP_OBJECT
4. You need to find the row that has the dimension name you want to delete:
5. Take note of the OBJECT_ID in my example it is50051, don't delete it yet.
6. Open the table HSP_MEMBER
7. Find and delete any rows that have a MEMBER_ID equal to the OBJECT_ID from step 5.
8. Close the Table HSP_MEMBER
9. Open the table HSP_MRU_MEMBERS.
10. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
11. Close the table HSP_MRU_MEMBERS.
12. Open the table HSP_DIMENSION
13. Find and delete any rows that have a DIM_ID equal to the OBJECT_ID from step 5.
14. Close the table HSP_DIMENSION
15. Also delete it's reference from the HSP_UNIQUE_NAMES table.
16. Delete the row in the HSP_OBJECT table that you found in step 4.
17. Close the HSP_OBJECT table.
18. Open Essbase Application Manager for the application and remove the dimension from the necessary Essbase outlines.
19. Restart the application server.

Now when you open the application in Planning the dimension will be removed. The next step is to perform a refresh to make sure planning and Essbase are in sync.

Committed access in Essbase

2009-01-27T00:25:00.000-08:00

Hi,

Committed access option provided by Hyperion essbase proves very helpful in many cases.First letz understand what is committed and uncommitted access... Committed access means while loading data into essbase , it first stores data in memory and once wait period is over it loads data into physical disk. It is synonymous to Commit access in SQL.Essbase works in similar fashion..You can set committed/uncommitted access in DB properties under transactions.

There are some real scenarios when data load if interrupted between needs to restart from beginning, in essbase we can achieve this by setting committed access and then click on "Abort on error" while data loading.

Restoring Data from Backups

2009-01-21T04:15:00.000-08:00

Restoring Data from Backups

To restore data from backup:
1.Stop OpenLDAP service or process.

2.Using a command prompt window, navigate to /server/scripts and execute the following command.

Windows:
recover.bat

UNIX:
recover.sh

In this command,
Path_backup_directory indicates the path of the directory where the backup is stored.

3.Monitor the utility to ensure that it runs successfully.

4.Start OpenLDAP.

5.Restart Shared Services.

Backing Up OpenLDAP Database

2009-01-21T04:08:00.000-08:00

Backing Up OpenLDAP Database

The OpenLDAP database must be backed up periodically to recover from loss of provisioning data due to media failures, user errors, and unforeseen circumstances.
There are two types of backups we can perform : Hot Backup and Cold Backup

Hot Backup
Regular incremental backups of OpenLDAP database can be performed without shutting down
OpenLDAP. Known as hot backups, they do not interfere with the availability of Shared Services.
Use
backup.bat
(Windows) or
backup.sh
(UNIX) to schedule daily hot backups. This
Hyperion-supplied backup file is stored in
/server/scripts
; for example
C:\Hyperion\SharedServices9\9.2\server\scripts
(Windows) or
/apps/Hyperion/
SharedServices9/9.2/server/scripts
(UNIX).
This procedure backs up Shared Services configuration files and OpenLDAP.

To run a hot backup:
1.Using a command prompt window, navigate to /server/scripts.
2.Execute the following command.

Windows:
backup.bat

UNIX:
backup.sh

where
backup_directory
indicates the path of the directory where the backup is to be stored.

3.Monitor the backup process to ensure that it runs successfully.

Cold Backup
Cold backups are taken after shutting down OpenLDAP.
Note:
Data in the OpenLDAP database is synchronized with the data available in the Shared Services
repository. Hyperion recommends that you back up the Shared Services repository along with the OpenLDAP database.

To back up OpenLDAP database:
1.Stop OpenLDAP service or process.
2.Copy into a secure location.

Synchronizing OpenLDAP Database with Shared Services Repository

2009-01-21T04:04:00.000-08:00

Synchronizing OpenLDAP Database with Shared Services Repository

The database configured with Shared Services stores product registration information, and the
OpenLDAP database contains provisioning data for Hyperion System 9 products. These
databases work in tandem to support Hyperion System 9 products.
Data inconsistencies between the databases impact normal operations. Inconsistencies could occur during manual database update, database upgrades, or in replicated OpenLDAP environments in which the OpenLDAP slave has taken over for a failed OpenLDAP master. To remove inconsistencies, the OpenLDAP database must be synchronized with Shared Services database. The synchronization process uses the Shared Services database as the master database to resolve data inconsistencies.
Use the OpenLDAP Sync utility in the following situations:

Product registration fails after the application was deleted from Shared Services
Shared Services database is recreated manually without recreating OpenLDAP, and Shared Services backup is not available
OpenLDAP database is recreated manually without recreating Shared Services database, and Shared Services backup is not available

The Sync OpenLDAP utility does not synchronize user and group provisioning data on Hyperion System 9 products.

To synchronize OpenLDAP database with Shared Services repository:
1.Log on to External Authentication Configuration Console as Shared Services Administrator.
2.Select Configuration > Sync OpenLDAP.
3.Optional: Click Refresh to update the status.
4.Optional: Click View Log to display Sync OpenLDAP Logthat details the operations that were performed
during the synchronization process.
5.Click Close.

Rules for Base and Attribute Dimensions and Members

2009-01-14T04:54:00.000-08:00

Rules for Base and Attribute Dimensions and Members

There are several important rules regarding members of attribute dimensions and their base
dimensions.
● You can tag only sparse dimensions as attribute dimensions.
● Before you can save an outline to the server, each attribute dimension must be associated
with a standard, sparse dimension as its base dimension.
● Attribute dimensions must be the last dimensions in the outline.
● Attribute dimensions have a type setting—text, numeric, Boolean, or date. Text is the default
setting. Although assigned at the dimension level, the type applies only to the level 0 members
of the dimension.
● If you remove the attribute tag from a dimension, Essbase removes prefixes or suffixes from
its member names. Prefixes and suffixes are not visible in the outline. For more information,
● A base dimension member can have many attributes, but only one attribute from each
particular attribute dimension.
For example, product 100-10 can have size and packaging attributes, but only one size and only one type of packaging.
● You cannot associate an attribute with an implied shared member the child of which is tagged as shared.
● Essbase does not support attributes for Hybrid Analysis-enabled members.
You can use attribute values in calculations in the following comparisons:
● > (greater than)
● >= (greater than or equal to)
● < (less than)
● <= (less than or equal to)
● = = (equal to)
● <> or != (not equal to)
● IN

Display Planning supporting details in FR

2009-01-11T08:40:00.000-08:00

Showing Supporting Detail for Planning
When using the Planning Details database connection, and selecting a row, you can display
supporting detail for a member. If supporting detail exists for one or more cells in the selected
row, additional rows are inserted to show the supporting detail. In addition, you can control
whether a page break is allowed within the rows of supporting detail.

➤ To show supporting detail for the Planning Details database connection:

1 Open a report and select a row in the grid that contains a member with supporting detail.
2 In the Row Properties sheet, select Display Supporting Details.
3 Specify whether to allow page breaks with the rows of supporting detail:
● To allow a page break within the rows of supporting detail, select the Allow Page Break
Within check box.
● To keep the parent member and the supporting detail on the same page, deselect the Allow
Page Break Within check box. If the supporting detail does not fit on the current page, the
parent member and supporting detail is moved to the next page.

Note:
If the supporting detail spans multiple pages, this option defaults to Allow Page Break
Within and page breaks are used.

4 Optional: To position the supporting detail before or after the parent member, select the Grid Properties
sheet, select the Position category and select an option in the Position of Supporting Detail box:
● To display supporting detail before the parent member, click Before Members.
● To display supporting detail after the parent member, click After Members. This is the
default.

5 Optional: To indent each generation within the supporting detail:
a. Select the heading cell of the member that is going to display the supporting detail.
b. Select Format > Cells > Alignment tab.
c. In the Indent Increases for Each Generation by box, select a positive number by which
you want to indent (to the right) each generation in the supporting detail list, or select a
negative number to indent in reverse (to the left) each generation in the supporting detail
list.

Fine Tuning Hyperion Essbase Cache Settings

2009-01-03T08:27:00.001-08:00

Fine Tuning Cache Settings

After using a database at your site with typical data, user access, and standard environment (including server machines, network, etc.), check to see how Essbase performs. It is difficult to predict optimal cache sizes without testing. You may need to adjust your cache settings.
Understanding Cache Settings

The sizes of the index cache and the data file cache (when direct I/O is used) are the most critical Essbase cache settings. In general, the larger these caches, the less swapping activity occurs; however, it does not always help performance to set cache sizes larger and larger. Read this entire section to understand cache size considerations.
Index Cache

The advantages of a large index cache start to level off after a certain point. Whenever the index cache size equals or exceeds the index size (including all index files on all volumes), performance does not improve. However, to account for future growth of the index, you can set the index cache size larger than the current index size. Because the index cache is filled with index pages, for optimum use of storage, set the size of the index cache to be a multiple of the size of the index page (8 KB). See Index Files for an example of estimating index size.
Data File Cache

If possible, set the data file cache to equal the size of the stored data, which is the combined size of all ess*.pag files. Otherwise, the data file cache should be as large as possible. If you want to account for future growth of stored data, you can set the data file cache size larger than the current size of stored data.
Note:

The data file cache is used only if you are using direct I/O.
Data Cache

The data cache should be about 0.125 times the data file cache. However, certain calculations require a larger data cache size. If many concurrent users are accessing different data blocks, this cache should be larger.

In general, if you have to choose between allocating memory to the data file cache or allocating it to the data cache, choose the data file cache if you are using direct I/O. If you are upgrading from a previous version of Essbase, see the Hyperion Essbase - System 9 Installation Guide.
Checking Cache Hit Ratios

Every cache has a “hit ratio.” The hit ratio indicates the percentage of time that a requested piece of information is available in the cache. You can check the hit ratio of the index cache, the data cache, and the data file cache to determine whether you need to increase the cache size.

* To check cache hit ratios, see “Checking Cache Hit Ratios” in Essbase Administration Services Online Help.

*

The cache hit ratio indicates the percentage of time that a requested piece of information is already in the cache. A higher hit ratio indicates that the data is in the cache more often. This improves performance because the requested data does not have to be retrieved from disk for the next process. A hit ratio of 1.0 indicates that every time data is requested, it is found in the cache. This is the maximum performance possible from a cache setting.
*

The Hit Ratio on Index Cache setting indicates the Essbase Kernel success rate in locating index information in the index cache without having to retrieve another index page from disk.
*

The Hit Ratio on Data File Cache setting indicates the Essbase Kernel success rate in locating data file pages in the data file cache without having to retrieve the data file from disk.
*

The Hit Ratio on Data Cache setting indicates the Essbase success rate in locating data blocks in the data cache without having to retrieve the block from the data file cache.
*

Check memory allocation. Add smaller amounts of memory at a time , if needed, because a smaller increment may have the same benefit as a large one. Large, incremental allocations of memory usually result in very little gain in the hit ratio.

Hyperion Essbase Caches

2009-01-03T08:20:00.000-08:00

Essbase uses five memory caches to coordinate memory usage:

Index cache

The index cache is a buffer in memory that holds index pages. How many index pages are in memory at one time depends upon the amount of memory allocated to the cache.

Data file cache

The data file cache is a buffer in memory that holds compressed data files (.pag files). Essbase allocates memory to the data file cache during data load, calculation, and retrieval operations, as needed. The data file cache is used only when direct I/O is in effect.

Data cache

The data cache is a buffer in memory that holds uncompressed data blocks. Essbase allocates memory to the data cache during data load, calculation, and retrieval operations, as needed.

Calculator cache

The calculator cache is a buffer in memory that Essbase uses to create and track data blocks during calculation operations.

Dynamic calculator cache

The dynamic calculator cache is a buffer in memory that Essbase uses to store all of the blocks needed for a calculation of a Dynamic Calc member in a dense dimension (for example, for a query).

HSS migration ( Export-Import utility by Hyperion)

2008-12-02T00:30:00.000-08:00

Steps to be followed

1. First we need to take backup of the security made in shared service through LDAP or external directories

2. Make a file importexport.properties file in the path D:\Hyperion\common\utilities\CSSImportExportUtility\importexport

3. write the following

importexport.css=file:/D:/Hyperion/deployments/Tomcat5/SharedServices9/config/CSS.xml
importexport.cmshost=localhost
importexport.cmsport=58080
importexport.username=admin
importexport.password=password
importexport.enable.console.traces=true
importexport.trace.events.file=D:/hyperion/common/utilities/CSSImportExportUtility/importexport/trace.log
importexport.errors.log.file=D:/hyperion/common/utilities/CSSImportExportUtility/importexport/errors.log
importexport.locale=en
importexport.ssl_enabled=false

# export operations
export.fileformat=xml
export.file=D:/Hyperion/exportNew.xml
export.internal.identities=true
export.native.user.passwords=true
export.provisioning.all=true
export.delegated.lists=false
export.user.filter=*@Native Directory
export.group.filter=*@Native Directory
export.role.filter=*
export.producttype=HUB-9.3.1
#export.provisioning.apps=(HUB=Global Roles)

Make the necessary changes in the above syntax like
export.user.filter=*@External Directory

4. Now check whether JAVA_HOME is mentioned in the environmental variable.

5. go to command prompt and go to the exact path where “CSSExport.bat” file is placed.Run this file with the following syntax

CSSExport.bat importexport.properties

6. Now check the file xml that is generated after the running of export utility.It should show all the users and groups
7. Now change the importexport.properties in the machine where you need to import the security with the following details.
importexport.css=file:/D:/Hyperion/deployments/Tomcat5/SharedServices9/config/CSS.xml
importexport.cmshost=localhost
importexport.cmsport=58080
importexport.username=admin
importexport.password={CSS}MRcYv323uzxGr8rFdvQLcA==
importexport.enable.console.traces=true
importexport.trace.events.file=D:/hyperion/common/utilities/CSSImportExportUtility/importexport/trace.log
importexport.errors.log.file=D:/hyperion/common/utilities/CSSImportExportUtility/importexport/errors.log
importexport.locale=en
importexport.ssl_enabled=false

# import operations
import.fileformat=xml
import.file=D:/Hyperion/exportNew.xml
import.operation=create/update
import.failed.operations.file=D:/failed.xml
import.maxerrors=0

8. Now run import utility
9. Go to command propmt and type

CSSImport.bat importexport.properties

Oracle Schema Query for creating Schemas for Hyperion Installation

2008-11-16T23:53:00.001-08:00

Hi,

Here is the query:

create user HSS identified by password;

grant dba to HSS;

create tablespace HSS
datafile 'D:\Oracle\hyperionfiles\HSS.dbf'
size 30M
Autoextend on
Extent Management local

/

alter user hyptt default tablespace HSS;

Hyperion Product PORTS

2008-11-12T00:35:00.000-08:00

Hi,

Below is the list of ports used by Hyperion.

Port Type Default Port Number Where Configurable

Shared Services Ports

Listen port 58080 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console.
Shutdown Port for Apache Tomcat 58081 Default ports are supplied by the application server. To modify, see the application server documentation.
AJP connector port 58082 Default ports are supplied by the application server. To modify, see the application server documentation.
Hyperion Remote Authentication Module 58000 Hyperion Remote Authentication Module installation program
OpenLDAP 58089
Hyperion License Server (lmgrd) 27000
Hyperion License Server (HYSLD) Dynamic

Analytic Services Default Service Ports

Analytic Services Agent 1423 Hyperion Configuration Utility
Analytic Integration Services Server 3388 /bin/ais.cfg
Add -Pportnumber

Analytic Administration Services Web Application Ports

Listen port 10080
SSL listen port 10090
Shutdown port for Apache Tomcat 10005

Analytic Provider Services Web Application Ports

Listen port 13080
SSL listen port 13090
Shutdown port for Apache Tomcat 13005

BI+ Default Service Ports

Foundation 6790 — 6810
Global Services Manager (GSM) 6800
Core Service 6801
Name Service 6798
Service Broker 6797
Job Service 6796
Event Service 6794
Repository Service 6795

BI+ Web Server Port

Apache and IBM 19000 /conf/httpd.conf
IIS 80 In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

Financial Reporting Web Application Ports

Listen port 8200 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 8201
AJP connector port 8202

Financial Reporting Default Service Ports

Financial Reporting Report Service Dynamic (2)
Financial Reporting Scheduler Service Dynamic
Financial Reporting Print Service Dynamic
Financial Reporting Communication Service 8299

Interactive Reporting Default Service Ports

Data Access Service (DAS) 6811, 6812
Interactive Reporting Service 6813, 6814
Job Service 6815
Log Service 6810

Web Analysis Web Application Ports

Listen port 16000 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 16001
AJP connector port 16002

Workspace Web Application Ports

Listen port 45000 Hyperion Configuration Utility
SSL listen port NA Configure manually using the application server administration console
Shutdown port for Apache Tomcat 45001
AJP connector port 45002

Financial Management Default Service Port

Financial Management Application Server 135 plus ephemeral high-range ports (1024–65536) Fix DCOM ephemeral ports in Windows settings. See the Microsoft support article describing how to set the ports used by DCOM: http:// support.microsoft.com. Search for "restrict DCOM port".

Financial Management Web Server Port 80 In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

Planning Web Application Ports

Listen port 8300 Hyperion Configuration Utility
SSL listen port 8303 Application server administration console
Shutdown port for Apache Tomcat 8301 Default ports are supplied by the application server. To modify, see the application server documentation.
AJP connector port 8302 Default ports are supplied by the application server. To modify, see the application server documentation.

Planning Default Service Port

Planning RMI Server 11333 /common/RMI/ HyperionRMIRegistry.properties

BPM Architect Web Application Ports

BPM Architect UI
Listen port 19091 (can be configured for SSL) Hyperion Configuration Utility
SSL listen port 19094
Shutdown port for Apache Tomcat 19092
AJP connector port 19093

FDM Web Application Ports

Listen port 135 plus ephemeral high-range ports (1024–65536).
SSL listen port
Shutdown port for Apache Tomcat
AJP connector port

FDM Default Service Ports

FDM load balancer 135 plus ephemeral high-range ports (1024–65536)
FDM application server 135 plus ephemeral high-range ports (1024–65536)
File sharing 137–139, 445
Firewall 135 plus ephemeral high-range ports (1024–65536)

FDM Web Server Port

80 (HTTP) or 443 (HTTPS) In Microsoft Internet Information Services (IIS) Manager Console, change the TCP port value setting.

Expandable Menu in IE 7.0 for Hyperion Workspace

2008-11-11T01:12:00.001-08:00

Hey All,

Many ppl are facing issues while viewing Workspace in IE 7.0. Expandable menus( Like Navigation, File) of Workspace don't work properly in IE 7.0.

Here is the solution :

Go to internet options > Security > (Internet or Local Internet, depending on how you are accessing workspace) > Custom Level > "Allow
scriptinitiated windows without size or position constraints" > Make sure it is enabled.

Restart your browser, log in again

Cheerz!
--CJ

Configuring FDM with Oracle Database

2008-10-26T01:36:00.000-07:00

Hey All,

I have started this blog for people working in Oracle Hyperion. In my blog I will write about some technical tips and stuff related to HYPERION.This is my first post..
I observed that many Hyperion guys are finding difficulty in configuring FDM with Oracle as a backend. People are facing errors like "Schema/user already exists".Also I noticed that in Hyperion guides there is no information available to configure FDM on oracle. I am giving detailed info. regarding creating DB/schema on oracle for FDM so that even a person with no/very less knowledge of Oracle DB can also create it. Here is the solution:

Following are the steps to create database on Oracle for FDM :

1) Create a general purpose database using create database wizard of Oracle.

2)Connect to SQLPLUS using system/oracle to Database ( Provide database name as a Host String in SQLPLUS Login screen)

3)Create a new user/Schema:
Syntax: Create user username IDENTIFIED BY password
Default tablespace users
Temporary tablespace temp;

4)Grant unlimited tablespace to new user.
Syntax: Grant UNLIMITED TABLESPACE to username;

5)Grant following accesses to new user

i. CREATE PROCEDURE
ii. CREATE SEQUENCE
iii. CREATE SESSION
iv. CREATE TABLE
v. CREATE TRIGGER
vi. CREATE VIEW
vii. QUERY REWRITE

Syntax: GRANT CREATE PROCEDURE to username;

6) Use this new user while creating a FDM application.

Cheerz!

---CJ

HYPERIONISM

Hyperion Planning + OBIEE v/s Jedox EPM/BI suite

Hyperion Planning + OBIEE v/s Jedox EPM/BI suite

1. Ease of Application Building/ Dimension building :

2.Calculation capabilities:

Customization of Look-n-Feel :

ETL capabilities:

In-Built planning/Budgeting features:

BI capabilities:

Server Maintenance/Installation :

Application Maintenance/Support :

Cost :

Entering TEXT data in Essbase using Text List

Application Error in FDM , after loading maps having "&" or "@" in it ..

Block creation Issue

Hyperion HBR Run time Prompt (RTP) issue.

Design Essbase ASO aggregation

Error while connecting to essbase from FR

Book on Essbase Implementation

User/Groups are not visible in Planning Webform and Dimension while assigning access.

Update on Hyperion Planning dim deletion

How to delete dimension from Planning Application

Committed access in Essbase

Restoring Data from Backups

Backing Up OpenLDAP Database

Synchronizing OpenLDAP Database with Shared Services Repository

Rules for Base and Attribute Dimensions and Members

Display Planning supporting details in FR

Fine Tuning Hyperion Essbase Cache Settings

Hyperion Essbase Caches

HSS migration ( Export-Import utility by Hyperion)

Oracle Schema Query for creating Schemas for Hyperion Installation

Hyperion Product PORTS

Expandable Menu in IE 7.0 for Hyperion Workspace

Configuring FDM with Oracle Database