HyperionSolutions

An Essbase outline has a number of dimensions.  The number of dimensions can range in quantity and size, but each dimension is identified as a dense or sparse dimension.  As we understood the concept of Dense and Sparse in our last discussion, let’s begin with the cocept of data blocks now. To understand this, let’s carry forward our hierarchy of 5 dimensions in a test application in my previous post.. We have 3 dense and 2 sparse dimensions each with 3 stored members. So let’s begin: Number of Existing Blocks = (potential number of blocks) * estimated density= 9 Block Size = Dense Stored * Dense Stored * Dense Stored * 8 bytes = 3*3*3 *8 = 216 Potential number of blocks = Sparse Stored * Sparse Stored = 9 If all dimensions are assigned as Dense, Number of Existing Blocks = (potential number of blocks) * estimated density= 1 Block Size = Dense Stored * Dense Stored * Dense Stored * 8 bytes = 3*3*3*3*3 *8 = 1944 Potential number of blocks = Spar

So what is Dense and Sparse Dimensions?? Essbase outline has a lot of components. One of the most important components is Dimension. Dimensions are the representations of business components and might be of standard or attribute types. Standard Dimensions are basically of two types: Dense & Sparse. So basically by oracle documentation, “A dense dimension has a high probability that one or more cells is occupied in every combination of dimensions.” “A sparse dimension is one with a low percentage of available data positions filled.” However, the above definition is valid only with reference of data positions or data cells filled or not. What about the case when we do not have any data. How does Essbase identifies whether the added new dimension is a Sparse or Dense.. To understand that I did a simple test. We create an application from scratch with just some random dimensions “A”, “B”, “C”, and “D” without any children. Then we check how Essba

A garbage collector is responsible for • allocating memory • ensuring that any referenced objects remain in memory, and • recovering memory used by objects that are no longer reachable from references in executing code. Objects that are referenced are said to be live. Objects that are no longer referenced are considered dead and are termed garbage. The process of finding and freeing (also known as reclaiming) the space used by these objects is known as garbage collection. Garbage collection solves many, but not all, memory allocation problems. You could, for example, create objects indefinitely and continue referencing them until there is no more memory available. Garbage collection is also a complex task taking time and resources of its own. The precise algorithm used to organize memory and allocate and deallocate space is handled by the garbage collector and hidden from the programmer. Space is commonly allocated from a large pool of memory referred to as the heap.

Objective:  The idea of the post is to automate the updating of Registry Entries required to increase the Timeout for Smart View. IE7 and IE8 & IE9 have a 30-second timeout when waiting for communication from the server. When adding form data, Smart View can take longer than 30 seconds to get confirmation from the Planning server that the changes were made and saved. A similar constraint exists for Essbase data. Pre update registry Settings: Open the command prompt window by clicking the start  button   >Search bar >Key in regedit navigate to the below path and check the existing settings you might not have” KeepAlive,ServerInfo & ReceiveTimeout” HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\InternetSettings Automated Resolution Steps:      Create a file called “smartviewfix.reg”      Edit the file in notepad.      Add the below to the file   to update the timeout to 15 min

In Oracle Hyperion EPM 11.1.2.3, Life Cycle Management (LCM) will now give you the ability to run a report to see what artifacts have changed, when it was changed, and who made the change, including security.  You can run the report on any artifact type or granularity, you can even export it to an excel and use it for business information. Login to Workspace, Administration -> Shared Services Console In Shared Services, go to Administration -> Artifact Change Report. Select the application you want the report for with the Start Date and the end Date for the period of change of Artifacts and click on Create Report. This will generate all the artifacts, including security changed during that period in a tabular format. Now you can export this to a CSV in excel or Print as per requirement.

To change the settings for the Planning Java heap size for Web-logic , when Planning is run as a service or when Planning is started in a command window. Changing the heap for Planning as a Windows Service: There are two ways to set the java heap settings for the planning server depending on whether Planning is run as a service or run in a command window. Changing the heap for Planning as a windows service For planning run as a service you need to do the following: 1. Start -> Run -> RegEdit -> Enter. 2. In the registry look for the HKEY_LOCAL_MACHINE->Software->Hyperion Solutions->HyperionPlanning>HyperionS9Planning. 3. For this node you should see several keys, several are JVMOptions. 4. Locate the Xmx and -Xms which are the maximum and minimum heap respectively. 5. These can be changed by right-click-> and select modify. 6. The recommended settings are 512, and 1024m respectively. 7. Exceeding 1024 is not recommended. Unless you are ve

Application Cloning utility can be used to clone entire applications.This utility can be very useful for logical restore and backup. 1. EPMExportAll - clones all the application in an environment under one folder. 2. EPMImportAll - imports all the applications cloned into EPMExportAll folder into another environment. **Note :Does not import artifacts for HPCM and HFM. Create a .properties file named input.properties with the following text. User=<username for LCM export> Password=<password for LCM export> Save it as input.properties Browse to D:\Oracle\Middleware\user_projects\epmsystem1\bin Run : “epm_cloneexport.bat input.properties” Press Enter!! Browse to : D:\Oracle\Middleware\user_projects\epmsystem1\import_export You will find a folder created : EPM_CloneExport Inside this all the applications backup, EPM Architect, Essbase Cluster, HSS, HFR all the artifacts that can be imported through LCM can be found & imported. For importin