EPBCS
Discussion List
-
Different Merit month per employee in OOTB workforceSummary: Merit should apply based on joining month In one of our projects, the requirement is to have increment/merit based on employee's joining month. When I entered M… -
$value is being considered as variable in REST API get method (SharePoint Integration)Hi guys, I am trying to get data from a CSV file which is uploaded in SharePoint to EPBCS application. From Sharepoint REST API, using the following Source URL GET https…
-
Checking for NULL in getattributeValue in Groovy EPBCSSummary: we are trying to check if attribute is attached with dimension and if attribute is tagged then users should get a custom message and script execution will stop.…
-
How to find orphan member in EPBCS dimension?Summary: 'Error:Unable to resolve duplicate member name [CC_4504500001] on line [105] Rule" How can I find and delete Orphan members in EPBCS (Planning)? Content (requir… -
OOB Rolling Forecast (Financials + Workforce Question)Background: Client is enabling OOB Financials & OOB Workforce. The client wants to enable a 6 quarter rolling forecast (for OEP_FS). Issue: When we enable Rolling Foreca… -
How to use Groovy and REST API to filter and execute datamap, and set substitution variablesSummary: I want to find out if you can set dimension parameters when running a datamap using a REST API call in Groovy, in PBCS calc rules. Secondly, I want to know if s…
-
Formatting in FormsSummary: Hi - how do I format rows and columns in Forms? Just simple stuff: bold, underline, italic is all I need. It doesn't seem to be in the Segment properties? Conte…
-
Reporting on FCCS cube in EPBCSSummary: Hi all, Is it possible to draw up a report (or rather a grid in a report) in EPBCS with FCCS as the selected data source? I know it is possible to do so in Narr…
-
SmartView VBA Functions to execute datamapsHello, I'm using HypExecuteCalcScriptEx function to execute some business rules using a macro, I was wondering if there is any exiting function similar to this to execut… -
Are there any connectors available for PowerBI/Azure we can pull the data from our cubes?Summary: Are there any connectors available for PowerBI/Azure we can pull the data from our cubes? We would like to be able to pull the finanical data we have in our cub… -
Deleting Files from Inbox in EPBCS using REST APISummary: we need to delete files from inbox using REST API which will be executed through groovy. we are able to make it work if we have to delete snapshots using delete…
-
Is there a way to delete existing members in Planning using a DM integrationSummary: Is there a way to delete existing members in Planning using a DM integration. In Data Management, when we build a Metadata Integration is there a way to delete …
-
Transferring a file from Inbox/Outbox Explorer to Data management using GroovySummary: Need to transfer file from Inbox/Outbox Explorer to Data Management using groovy in EPBCS. Content (required): Hi . I have a file in Inbox/Outbox Explorer as be…
-
For WF to FS: Can you recreate the functionality as an XWRITE code or map to an additional dimensionIn our app we have two dimensions: Cost Center (CC) and Department (DP). Workforce has Cost Center, and Financials has both Cost Center and Department. The DP and CC hie…Peter Joelson 11 views 12 comments 1 point Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Adding a custom dimension to Planning does not show in the Planning Admin extensionSummary: When I add a custom dimension, either through DM or manually, the added dimension does not show in the Planning Admin Extension in Smartview under dimensions. I…
-
Need to connect an On Prem Source to EPBCS using OICSummary: Need to connect an On Prem Source to EPBCS using OIC. Couldn't find much help online but wanted to understand that since we will be using REST API for the conne…
-
Can you bring back your annual Budget to both your Primary GL Legal Entities as well as your GL ConsSummary: Hi Oracle EPM Guru: We are on both Oracle ERP Cloud as well as EPM cloud. We have 5 different Oracle GL Primary Legal Entities. 1 is our US and 3 are non US leg…
-
How to maintain a single drop-down option(page dimension) for multiple grids in HFR?Summary: We have created a HFR report with three grids. Each grid has the same dimension in page POV with same range. Is there any option which will allow us to have a s…
-
Smartlist Members are showing junk values on parent level in reporting cubeSummary: Smartlist members showing Junk values at Parent level in Reporting cube. Looking for a technical solution to curb aggregation of Smartlist members across dimens…
-
Saved Linked Objects in Management ReportsA question to the community - does anyone know when management reports in Planning Cloud will support adding saved linked objects like we can in FR? We have a customer w…
-
FR Report Que : Display Yeartotal on FR report and allow user to expand only if rqdSummary: We want to develop FR report in excel format such that the report opens at Yeartotal level and then allow the user to expand to month level only if the user wan…
-
Is EPBCS, workforce, Capex and Project modules supporting Rolling Forecast option?Summary: Is EPBCS, workforce, Capex and Project modules supporting Rolling Forecast option? I see that these three modules are not supporting this. Content (required): I…
-
Unable to push data from WF to Fin Cube using OOB Data Maps for Non Comp AccountsSummary: Unable to push data from WF to Fin Cube using OOB Data Maps for Non Comp Accounts. The data maps is only letting us push the Data to a single Account in Fin Cub…
-
Netsuite to PBCS interface custom transaction typeSummary: Custom transaction type records are not included in saved search import in DM Content (required): We are trying to import data from a saved search from Netsuit …
-
EPM Cloud - Backups to EPM CloudSummary: Hi All, I want to take the backups of the entire EPM cloud (Planning) application and store it for N number of days. I know and have a script that invokes EPM A…
-
Best practice for Shared Connections URL Change in Smart View?Summary: We have upgraded our subscription from Standard to Enterprise and will need to update the Shared Connections URL in a lot of Smart View queries in saved Excel w… -
In EPM Planning Financials module, need to have cash flow impact assumption as specific dateSummary: Currently in EPM Financials, when selecting cash flow assumptions for 'cash flow impact' only available options are 'current period',30 days,60 days and 90 days… -
WFP to Financials Compensation data push for flexible accounts needs customisation.Summary: We have this requirement from client where 'Total compensation' value should be pushed from WFP to FIN cube. Right now its working on default OutOfBox members, …
-
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 …