Category 101
Discussion List
-
How to ignore the negative amounts in the outbound data management Interface?Summary: We are extracting a data from EPBCS cube to a flat file. But, it contains the negative amounts in it. Is there any way to ignore these neagtive amounts? Content… -
@CalcMgrExcelXIRR with @XRANGESummary: I am trying to implement excel's XIRR function using @CalcMgrExcelXIRR. When I run this function within the year (using XRange) it works fine but XRange across …
-
PBCS Form, change order of Form Formula calculationHi, I have a form with Period across and Account down, I need to add some months up, I am using formula column to do this. I then need to divide a couple of the accounts… -
[Data Integration Files] Is there a way to automatically purge the outbox of exported files?We recently have been creating a variety of data exports via Data Integration. Some of the output files are large (upwards of 80mb), and these extracts are running every… -
EPM Integration Agent - stops "completing" the polling calls & how to monitor?My client has two different agents running on the same staging server, one for ARCS and one for Planning. ARCS has been running very smoothly for ~6 months. Planning has…
-
How to install EPM Books in Smart ViewSummary: I'm unable to install the EPM Books feature in Smart View Content (required): When I try to download the smart view updates, it recognizes the EPM Books feature… -
Groovy code questionSummary: How can I test for a value in one column in a grid and retrieve the value of the second column if it passes the test? Content (required): I have a grid iterator…Sabrina Greensea-166456 61 views 6 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Use of cross dimensional operator in the FIXSummary: Use of cross dimensional operator in the FIX Content (required): Hi i need to give a range of specific month and years in a fix. what im expecting to pick using…
-
How to get attribute like functionality for Accounts?Summary: In a planning cube (BSO) how do I get attribute like functionality to use in Reports for the accounts dimension? Since Account is always mostly dense and we can…
-
Data Export to File Pivot: Columns missing due to no data for the specific memberIn Data Management/Data Integration, I have a data extract process that utilizes the Data Export to File method to pivot Accounts as column headers (5 Accounts in total)…
-
2 new Hands-on Tutorials for Capital PlanningWe are pleased to announce the availability of the following 2 new Hands-on Tutorials for Capital Planning. These Hands-On Tutorials provide step-by-step instruction on … -
New Hands-on Tutorial for Predictive PlanningWe are pleased to announce the availability of the following new Hands-on Tutorial for Predictive Planning. This Hands-On Tutorial provides step-by-step instruction on h…
-
Is it possible to have an audit for FR reports?Summary: Customer wants to know if by any way we can get usage statistics for FR reports from system. They have a bunch of legacy FR reports and want to know which ones …
-
PBCS/Essbase: Problem to calculate some members, because a block is not created.Summary: Content (required): Hello experts, I have written the following code to copy the Close Balance of the previous year December into the Open Balance of the curren… -
NetSuite dashboards not working in NSPBSummary: One can set-up links in NSPB that opens up NetSuite dashboards and reports. This link is currently not working Content (required): Link to the NetSuite dashboar… -
Substitution Variable error in ASO RuleSummary: Need solution to pass Period range to ASO rule Content (required): We have an ASO Rule where we pass a variable &ActualsRange for period and the rule complains …
-
NetSuite Planning & Budget Data Integration helpSummary: NetSuite Planning & Budget (NSPB) uses saved searches to import data and metadata from NetSuite into Planning. Saved Searches are part of a bundle. I have used …
-
Data Management error: "Current polled process status is: RUNNING".Summary: Content (required): Hello Folks, While executing a Data Management rule to pull the data from PBCS to PCMCS, I have observed that the rule getting errored after…Chiranjeevi Naragani 66 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Planning
-
Missing Personnel Cube Tasks after CloneSummary: Content (required): Hello: Our IT cloned our Prod PBCS to our test environment; data looks good, except we are missing the Personnel Admin & Personnel Planning …
-
Get SmartList Label in a PBCS non-Groovy calc scriptSummary: Is there a way to return the SmartList label in a PBCS non-Groovy calc script? Content (required): I am able to get the SmartLIst ID using the following code sn…
-
Duplicate an existing Planning Cloud cubeSummary: Duplicate (copy + rename) a Planning Cloud cube and related artefacts. Content (required): Hi, For development and maintenance purpose can we duplicate (copy + … -
Can we create hierarchies in the Years dimensionSummary: We want to create 2 hierarchies in the years dimension - 1) original FY hierarchy and 2) another one with AY prefix. Is it possible? Content (required): Version…Gaurav Saraf 41 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Planning