PBCS
Discussion List
-
Working functionality of LOOP/ARRAY in Business RuleSummary: Is there any way to use Loop or Arrays which will take multiple RTP variables as parameter and perform calculations for each RTP within the loop? Content (pleas… -
How to get JOB ID to use it for REST API to extract role assignment reportHow to get JOB ID to use it for REST API to extract role assignment report?
-
List the user in the JobsSummary: How do I show the user on a Job Content (please ensure you mask any confidential information): In the Jobs recent activity list, can I set it to show the user? … -
support for EPM automate and Integration Agent in 3rd Party Virtualized EnvironmentsSummary: Hello we're going to install EPM automate and Integration Agent to arrange data exchange with our EPm Cloud (Planning) on Microsoft Windows 2019 or 2022. Do you…
-
Allocation ExampleSummary: Need to allocate by department from one entity to multiple others. Content (please ensure you mask any confidential information): I'm looking for a good example…
-
Convert value of SmartList to member to use in cross-dimensional (Non-Groovy)Hello experts, I have an account linked to smartlist where I have "account values" to choose in this smartlist, like this: For each entity (on columns) and dimension flo… -
Copy a dynamic calc parent member to a stored base level memberSummary: Need to copy a dynamic calc member to a stored base member Content (please ensure you mask any confidential information): I have a roll up (below) in a sparse d…
-
CurrentPOV not AvailableSummary: Content (please ensure you mask any confidential information): In Reports, I don't see CurrentPOV in the function list. Is there some setting I need to turn on?…
-
Drill through from planning to ERP cloud GL balances failingSummary: When trying to drill through to source, either from a data form, workbench or smart view, I'm only getting a blank browser page. Content (please ensure you mask… -
EPBCS time balance property not working on dynamic calc parentHi All, I have a balance sheet account(level0 stored) in OOTB financials module with properties = (Account Type: Asset, Time Balance: Balance, Skip: Missing) From Plan E…
-
Why does @parentVal return #MISSING?Summary: Can someone help me understand why @parentVal("Period", "Working") returns #MISSING for the sample code below? Content (required): I have set up a simple exampl…
-
Data Erased by Hierarchy Change?Summary After adding a roll up to existing members all level 0 data for those members was erasedContent We added 3 new roll ups to our existing Finance and Facilities co… -
How to print or use substitution variables in Groovy for ASO cubeSummary: I had a requirement where I need to extract data from ASO cube montly, I created Sub Var in ASO cube for period and year trying to call those in groovy but scri…
-
Ledger Id Missing When Trying to Write Back ActualsSummary: Getting the following error when when trying to write back actuals to ERP, it is happening on the Import Journals job in ERP. "Warning: Ledger Id can not be emp…
-
Optimizing Allocate RuleHello experts, I have a doubt with a calc script doing an allocation. Type my code and explain if is possible optimize this code: FIX (&Act_Year,"Actual","EUR",@RELATIVE…
-
Member Selection in a Business Rule Shows Account List Not HierarchySummary: Would like to have the member selection show as a hierarchy, not a list Content (please ensure you mask any confidential information): We have a prompt to selec…
-
Planning PBCS: Intercompany Elimination best PracticesSummary: Developing in Planning an Intercompany Elimination process. Content (please ensure you mask any confidential information): Hi, We are developing an intercompany…
-
Do your data forms with year-to-date view work as expected?Summary: We have always used year-to-date view in data forms and reports. We normally use the member formula on member VS_YTD, as posted on the Oracle documentation, SUM…
-
How to display top n customers by revenue in data forms in planning cloudSummary: How to display Top n customers in data forms in Planning Cloud by Net Revenue or Gross Revenue. Customer is a dimension. Content (please ensure you mask any con…
-
hide rows in a pbcs formHello Experts! I have a form that I would like to supress rows that contains "almost" zero. I click on option supress missing / zero rows but in my example doesn't work …
-
Can we connect REST API to PBCS ApplicationSummary: we have requirement to extract data from PBCS Application using REST API, is there possibility for the external tools like Talend or BOOMI to connect to the Dat…
-
How to run the calculation in detailed logging mode?Summary: We are running into errors like "Error executing formula for [StaffEntry] (line 764): attempt to cross a null member in function [@X]" Found Doc ID 2191610.1. I…
-
[Integration] Error in the Pipeline and unable to edit/save the pipeline changesSummary: I am currently encountering 2 issues in Pipeline Pipeline Substitution variable is not working Pipeline settings is not editable Content (please ensure you mask…
-
Management reports - function which Allows to check if Text Values in two Columns is the sameSummary: There is presently no function within management report which allows us to Compare two Text Values in different, cells, columns or rows Content (please ensure y…
-
New Redwood Differences Between Planning and EDMWith the 2024.04 update live in test pods over the weekend, we can see the new Redwood updates with the compact cards. We did notice that the Planning test environment n… -
Currency Conversion PBCS ASO cubePBCS application has 2 BSO plan types and 1 ASO plan type. Custom calculations are run in BSO cube via business rules and data is pushed to ASO plan type for reporting u…
-
ad hoc grid can not be opened as there are no valid rows of dataSummary: Smartview Zoom in Bottom Level seems to be throwing error Content (required): In SV, I am suppressing No Data/Missing and Zero. I have Suppress Missing Blocks u…
-
Multiple Burst DefinitionsSummary: Content (please ensure you mask any confidential information): I have 20-30 books that I would like to send via email through bursting. Currently, I have a burs…
-
-
Feb Release Announcement: Forced Upgrade to Hybrid BSO - is Legacy PBCS affected?Summary: Forced Update to Hybrid BSO in next 3 months is announced in February Release Update (2024) - are Legacy PBCS environments affected? Content (please ensure you …