Creating a Sample HPCM application


Creating a sample HPCM application is fairly easy, Oracle has provided the complete information on the same. All you need to do is to go to the below location and follow the read-me.
<MIDDLEWARE_HOME>\EPMSystem11R1\products\Profitability\samples\

At above location you can find the metadata, data, rule files etc for both simple and detailed HPCM applications. I have followed the process to create a simple HPCM application and documented it for all of us. Once you will navigate to above location on the server where HPCM is installed you will find the following zips.


All of these zips are important and contains respective information, we need to begin with the EPMA zip. Lets copy the EPMA zip to import_export folder for performing LCM import for out Sample Application.





Once the import is successful you will get the sample application created in the EPMA application library. 

Now, lets deploy this application.


After deploying you will be able to see a blank HPCM application in the workspace


Now we need to go to shared services again for importing the metadata for the blank HPCM application which we have just deployed.




After the successful execution of LCM we can see the artifacts created in our BksSP82 application.


Its time for creating Essbase Base and Reporting Application:



After deploying you will get a job id which can be tracked



Once this deployment is finished you will see two Essbase applications created in EAS, now lets unzip the Essbase sample HPCM file and paste it under Essbase application folder

With this you will get sample data files files for loading All data, one for the Base cube and other one for the reporting cube.




Load and verify the data. Once the data is loaded in Essbase you can see below data for Stage Balancing.




Here is your sample HPCM application, happy learning.

Cheers..!!!
Rahul S.

PS: You may get data buffer and member not found error while loading data in the reporting cube, you have to take care of that.

Comments

  1. akkApril 23, 2015 at 10:27 AM

    Hi, my apology to sounds newbie, I work mostly on the infrastructure side and only helping a friend to get the sample application working.
    You specified an error regarding the data buffer and member not found. I am receiving the same error, I am wondering how you resolved it.

    Thanks!

    ReplyDelete
  2. Rahul S.April 23, 2015 at 7:13 PM

    It was long back, honestly I don't remember what the issue and the solution, I have to replicate that. See if this reply from John resolves the issue:
    https://community.oracle.com/message/13023724

    ReplyDelete
  3. akkApril 24, 2015 at 8:07 AM

    Hi Sharma,
    It was actually my post on the forum, I haven't gotten the chance to try it yet, will try it and let you know.
    Thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

Multiple Navigation Flows are Active

Image
We have witnessed an issue where application migration or sometimes service restart in PBCS/EPBCS activates multiple navigation flows.  If multiple navigation flows are active you wont be able make changes in any of them, because in order to make change in navigation flow you have to make it inactive. Typically you may end up in following situation:  Solution is pretty simple: 1. Create a copy of any of the existing navigation flow:  2. Give it any desired name:  3. Now, you will see one additional navigation flow, with inactive status: 4.  Make it active: 5.  At this point of time you will have one active navigation flow and two inactive  6. Select the additional navigation flow you have created and delete it  7. Now you are back in business: Rahul S.
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y
Read more