Enterprise Transformations, It's all About Performance Management

If you are using On Prem FDMEE to connect with PBCS/EPBCS you may run into the issue where ASO cubes are not showing up in On Prem FDMEE. In order to solve this issue you have to go to PBCS Data Management and create a ASO Target Application. Once this application is created, ASO cube should show up in On Prem FDMEE. 1. Go to Data Management in PBCS 2. Click on Add, select Local  3. Select Essbase from the drop down 4. ASO Cubes will show up with "A" and "A_ "  prefix  5. Save the ASO Target Application, you should see it as essbase application 6. Now login to On Prem FDMEE , you should see ASO cube in the list now: Rahul S.  

We will talk a little about what we need to ensure for data spread to work. For the sake of this discussion, we are assuming our application is set for 445 Distribution. We have many time balance properties, Flow, First, Balance, Average, Weighted Average (Actual and 365), you can read about them in Planning guide. The account we have taken for this example is set to Flow. You need to select either Idecendants of YearTotal or any of the quarters for period selection. Ex:  @IDESC("YearTotal") or @IDESC(<Qtr Member>) . Here is one sample data form: Entered 300 at Q4, values are distributed in 445: However, if you just select yearTotal and months, spread will not work. YearTotal is readonly! Even if you take descendants of any Quarter your spread will work fine. Now, One of the issues we faced: Issue: Data spread was working for every user in planning web, however, when they were trying to spread data t...

On Prem, PBCS, EPBCS Here are some frequently asked questions: Q 1.  Can we create multiple applications? Ans:  In On Prem you can create as many applications as you want, but in case of PBCS/EPBCS, it's limited to One application per environment. If you want more you may have to buy a new pod, per app. Q 2: How many environments we will get? Ans: In On Prem, you can have any many environments as you want. Typically, Dev, Test/QA, Prod. However, Oracle provides two instances Dev and Prod. Q 3: Can I delete application in PBCS/EPBCS environment or we need to reach out to Oracle? Ans:  Yes, you can delete application and create a new one yourself. Q 4:  What options are available for metadata integrations? Ans: For On Prem: FDMEE, metadata integration offered for EBS, People soft etc., Outline Load, ODI Adapter for planning, EPMA, Smart View Admin Extension.        For PBCS/EPBCS: EPM Automate Utility, Smart View Admin Extension Q ...

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

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