Posts

Showing posts from April, 2017

PBCS ASO Cubes are not Showing up in On Prem FDMEE

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

Smart View Spread From yearTotal/Qtr to Months Is not Working

Image
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 throu

On Prem, PBCS, EPBCS: Questions Answered

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 5: What options are available for D