HyperionSolutions

So this is a published bug in EPMA for Hyperion Financial Management Version 11.1.2.3.500 and later only, However, I have experienced this issue to be coming up in Planning applications. SYMPTOMS In Enterprise Performance Management Architect (EPMA)  if you move or include an existing parent member as a shared member underneath a different or new parent then the children rolling up to the first parent will not be shown. If Parent member is shared in an hierarchy, all levels below that shared level can not be found while using "Find Members" through Smart View neither can be drilled down through Smart View. Search member result is "No member found", although this member is part of the Hierarchy. CAUSE EPMA is behaving as expected. SOLUTION When we drill the Shared Member we are unable to see the level0 members in the template in generic.  However, if we change one of the MEMBER OPTIONS of retrieval in our Smart View -> Options ...

So I haven’t written to my blog since long and that’s just because I just did not find anything worthwhile all these days. Today I encountered a strange issue. So I thought to share with you guys. We had a Planning web form set to input data. No Business Rules or calc scripts attached. Just an input form. The issue : Every time any user enters the data into the form it says the data is saved but does not show up the data. Causes: Probably one would think this might be a simple case of Implied Sharing or usage of a label only parent member with one of the single child only hierarchy in the form.. sure thing .. SO DID I!! Its simpler than that! Another weird behaviour: data is saved and reflects in the web form when I enter and submit through the Smart View Planning add-in So what is the issue: the layout of the web form! The data form was designed to check data values at CurrYr and NextYr. However the current year and next year were both set to the same value. ...

While running an Aggregation process or a restructure in essbase have you ever encountered either of these: EAS quits accepting logins Essbase going down time and again. Failed Data load / Failed Data Export / Failed Level 0 export All of the above together :) In all these cases, there is a huge possibility that you are facing creation of tmp files issue on your Essbase Server, specifically if you are on Linux The Temp directory contains mostly files that are required temporarily. Many programs use this to create lock files and for temporary storage of data. Do not remove files from this directory unless you know exactly what you are doing! Many of these files are important for currently running programs and deleting them may result in a system crash. Usually it won't contain more than a few KB anyway. On most systems, this directory is cleared out at boot or at shutdown by the local system. In MS-Dos  and Windows , the temporary directory is set by the environment ...

Below concepts involve Data Blocks in some way or the other, so to understand how Data Blocks behave it’s good to understand these concepts: Let's Begin!! Compression Clean and Dirty Blocks Fragmentation Restructure Compression: When Essbase stores blocks to disk, it can compress the data blocks using one of the following compression methods, this is based on the type of data that is being loaded into the Essbase database. Essbase provides several options for data compression: 1. Bitmap compression : This is the default compression method. Essbase stores only non-missing values and uses a bitmapping scheme. A bitmap uses one bit for each cell in the data block, whether the cell value is missing or non-missing. When a data block is not compressed, Essbase uses 8 bytes to store every non-missing cell. 2. Run-length encoding (RLE): Essbase compresses repetitive, consecutive values --any value that repeats three or more times consecutively, including...

O2B Utility There are  times when we have to query the Hyperion Planning Application's relational database to get the Auditing reports, alas! we don't have an option to get them from our Planning interface. Many times we have wondered how to get the list of dimension members, data forms, there layouts, users security reports, task list status, supporting details, account annotations etc. What if there is a web based utility to take care of all this and more....!! My good friend, Rahul Sharma has taken the effort to design this utility .. Pleased to share the details on my blog: Let's start working on O2B Utility: http://hyperionplanningandmore.blogspot.in/2014/09/lets-start-working-with-o2b-utility.html What is O2B and How its useful to me ??? http://hyperionplanningandmore.blogspot.in/2014/09/what-is-o2b-and-how-its-useful-to-me.html How to deploy it to Weblogic: http://hyperionplanningandmore.blogspot.in/2014/09/deployment-of-o2b-on-webl...

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 bloc...

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.     ...

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...

Hello friends, I faced this issue today which I would like to share with you all, it shows how simple manual mistakes can sometimes cause crucial errors. Goal: I was trying to launch one of the Calc All scripts for my production application which failed with an error saying "Failed to execute the Calculation script" Issue: When I went through the logs ; I find the following issue: java.io.IOException: Server returned HTTP response code: 503 for URL: http://<servername>:19000/eas/eas The issue is when the script is run from 19000 port it fails with the above error in the logs but at the back end if you rectify the process is still running and the .pag files will be building as expected. So you do not see any difference at the process end except for this error. However, it is ideal to run the process through the correct port that is the 10080 port, which will not throw any error. Its a small error but can be misleading sometimes .. hope this po...