Enterprise Transformations, It's all About Performance Management

Background: We had a dynamic calc member with a member formula but it wasn't getting calculated automatically. We had to aggregate account dimension in order to calculate dynamic calc values. This defeats the purpose of having a dynamic calc member.  After researching further we got to know the reason of the issue and a solution.  Here is how we can replicate the issue: Create  a TestMember, which Never Share or Store property: If you will go  to the member formula tab, data storage for default cube and OEP_WFP cube will be Never Share:   Let's edit this member and change the storage property to Dynamic Calc: You will notice data storage will change for the Default Cube: But if you look further data storage will still be never share for OEP_WFP cube. For us, initially when we loaded some members, we had the storage property as Never Share, which we later changed to Dynamic Calc, but internally it was still Never Share at th

Smart View: EPBCS / PBCS Drill Through is not Working If you have enabled Drill though in FDMEE and its working from Planning Data forms and but it’s not working through Smart View, then this post will save some of your time. In my case when I was trying to drill down from Smart View it was taking me to Cloud Planning instead of Drill through landing page.   A little background: When you try to click on drill through in it uses drill down aif, in within GET request it passes the application and member combination against which you are drilling though. A sample query is: <WorkspaceURL>?aif.drilldown&attribute=system.ds.planning&attribute=app.ds.<AppName>&attribute=<Dim>.id.<MemberName>&… Example: http://MyServer:19000/workspace/index.jsp?module=aif.drilldown&attribute=system.ds.planning&attribute=app.ds.MyApp&attribute=cluster.ds.PLANNING_LWA&attribute=database.ds.OEP_WFP&attribute=Period.id.Jan&

Unable to Open Form in Smart View: Error: oraclesv: While using chrome if you try to open data form in Smart view , this will take you to a next tab and that tab that will be blank and will have a url oraclesv: Its a known internal bug, currently worked as an enhancement request: Bug 24686182  - PBCS:OPEN IN SMARTVIEW NOT WORKING IN SIMPLIFIED INTERFACE FROM CHROME Workaround is to use either Firefox or IE for this. If you are using Firefox you have to enable smart view extension: 1. Go to setting and click on Manage Add ons 2.  Enable Smart View Extension ( you may want to enable FR extension as well) and restart browser 3. This should allow you to open data form in smart view. We still have to wait to do this in Chrome. Cheers..!! Rahul S.

When you perform a regular export of dimensions you won’t get a lot of member properties, by default, you will get Member, Parent and Data Storage listing. This is a known behavior listed here . CHANGE OF BEHAVIOR: METADATA EXPORT Metadata exported from Enterprise Planning and Budgeting Cloud will no longer contain any property information for factory metadata. Properties such as member formula and data type are suppressed; only the parent and data storage columns are exported. Customizations made to factory members are tracked and exported separately to the customization file of the applicable module. If you migrate an application that contains customizations in multiple stages, for example, migrate one dimension at a time, you must export and import the following: Metadata of the dimension Customizations from the customization file   If you want to export these custom properties you have to use LCM. LCM will generate a Module Customizatio

We have an option to use OnPrem FDMEE to connect with Cloud instance. If you planning to go that route there are some prerequisites which you need to perform on on-prem FDMEE instance to ensure its connectivity with cloud instance.  Prerequisite: ·          FDMEE should be patched: 11.1.2.4.200 ·         Configure SSL certificate in Web Logic Server (WLS) : o    Importing EPBCS SSL Certificate to WLS o    Update the hostname verification setting to configuring WLS to support wild cards in host name o    Enabling WLS with JSSE SSL, this is to support Java version of SSL o    Oracle documentation:  http://docs.oracle.com/cd/E57185_01/AGFDE/configure_ssl_certificate__102xf468157d.htm ·         Checking Cloud Connectivity: o    Retrieving application detail in FDMEE o    Oracle documentation:   http://docs.oracle.com/cd/E57185_01/AGFDE/erpi_reg_target_app.htm#AGFDE-epmi_target_app_2 If you don’t import certificate you will run into: We followed above

We have an option to use OnPrem FDMEE to connect with Cloud instance. If you planning to go that route there are some prerequisites which you need to perform on on-prem FDMEE instance to ensure its connectivity with cloud instance.  Prerequisite: ·          FDMEE should be patched: 11.1.2.4.200 ·         Configure SSL certificate in Web Logic Server (WLS) : o    Importing EPBCS SSL Certificate to WLS o    Update the hostname verification setting to configuring WLS to support wild cards in host name o    Enabling WLS with JSSE SSL, this is to support Java version of SSL o    Oracle documentation:  http://docs.oracle.com/cd/E57185_01/AGFDE/configure_ssl_certificate__102xf468157d.htm ·         Checking Cloud Connectivity: o    Retrieving application detail in FDMEE o    Oracle documentation:   http://docs.oracle.com/cd/E57185_01/AGFDE/erpi_reg_target_app.htm#AGFDE-epmi_target_app_2 If you don’t import certificate you will run into: We followed above s

I ran in to this issue a couple of times, every time the reason was different and the solution was different. We get this error when we try to take LCM export of the application from Hyperion Shared Services. When shared services try to connect to Hyperion Planning, it internally calls the following servlet: http://<Server>:<Port>/HyperionPlanning/servlet/HspLCMServlet You may get this error when this call fails, it can be because of: 1. Time out the request, 2. Something is blocking this url, 3. Wrong server or port information in the EpmSystem Registry, 4. Because of an internal bug, 5. Something else! :) Here I will be talking about point 3. Situation: My OHS was configured to direct all the traffic using 19000 base port,  its the default port for OHS for EPM system. Because of some reasons I have to reconfigure OHS to 19001 and I have reverted it to 19000. Every thing else was working fine, I can access HSS, Planning Application, Essbase application, r