Calc Manager
Discussion List
-
Results of Groovy Script Validator BlankSummary: For a number of applications, all of which have Groovy code in place, the Groovy Script Validator Report is not producing any results where we were expecting th…Evan L 111 views 5 comments 0 points Most recent by Ujwala Maheshwari-Oracle EPM Platform and Freeform -
Deleting file from Inbox/Outbox Explorer using REST APIHi all, We are trying to delete a csv file from Inbox/Outbox Explorer using the below REST API https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co… -
How to move bulk files from DM Inbox to EPM inbox using Groovy in Planning appsSummary: How to move bulk files from DM Inbox to EPM inbox using Groovy in Planning apps. Can anyone help us with syntax? Content (please ensure you mask any confidentia…
-
Groovy: Essbase Error(0) Invalid member nameHi all, I am trying to retrieve the date from a combination using DataGridDefinitionBuilder and extract year, month and day from it. The approach might be a bit long but…
-
Is it possible to assign different Admin users to 3 different cubes in the same application?Summary: Content (please ensure you mask any confidential information): Hi all I have doubt. Is it possible to give access to different ADMINS access to different CUBES … -
help with @Sumrange across two dimensionsI have an existing formula that looks like this: Fix(Dim1_member, Dim2_member) AcctX = @PRIOR(AcctX→noDept→TotalDim1→TotalDim2) Endfix What I'd like to do it change the …
-
EPBCS Essbase Member formula NOT workingThis is so weird. Let me explain. I want to pull "Salary_By_Steps_WFP"→"Year3" value, which is $100. Assigning this code to dynamic calc member formula works perfect: "S…Ravinder Singh-63390 21 views 4 comments 1 point Most recent by Ravinder Singh-63390 EPM Platform and Freeform
-
When converting a calc script to business rule, are commands can be used to enhance performanceSummary: While converting calc script to business rule in EPM cloud, I found that CACHE HIGH command is not accepted on cloud. Are there other acceptable ways to enhance…
-
Data Exchange error Log failing on Export: ERROR [AIF]: Database "null" does not exist.Summary: Trying to Load data from an FCC instance into Planning via Data Exchange. Getting this in the error log, never seen this before: ERROR [AIF]: Database "null" do…
-
Business Rule in Pipeline Executes Only for One Year Instead of All Years in RangeSummary: We configured a Data Integration pipeline to run over multiple years (e.g., FY23 to FY25) with a Business Rule job type that runs a Calculation Manager rule. Ac…
-
ChatGPT API IntegrationSummary: Posting a small groovy snippet to allow chatGPT API integration. This is meant as a bit of fun with no practical applications at the moment. You will need to ge…
-
Run More Than One Calc Script in Groovy ScriptSummary: I am trying to run multiple pieces of calc script from one groovy script. It is executing the first piece essCalc1 and then the data push that is after essCalc1…
-
What is the OOTB rule applicable for balance sheet planning?Summary: I'm developing a B/S planning sheet using OOTB forms in EPBCS. Please let me know which rules need to be run to generate forecasts for B/S. For I/S, I ran the "… -
3 Month Moving Average - Multiple YearsSummary: Content (required): I am trying to calculate the average for the last 3 months and would like it to be a rolling average across years. I would like to add this … -
Cannot see Log Messages tab in Calc Manager after running a groovy rule?Summary: When I run a groovy rule in calc manager I am not getting the Log Messages tab pop up but would love to be able to see these sorts of statistics. Content (pleas… -
Not able to Hide Prompt when a Ruleset consists of two business rules from different cubesSummary: Though all the "Hide Prompt" properties are ticked still the user gets the prompt when executing from the actions menu Content (required): We have a requirement…
-
Using Groovy to update a member property for Storage, individual cube properties aren't updatingSummary: A Groovy script that builds a map to create a member in a hierarchy is not properly updating member properties Content (please ensure you mask any confidential …
-
Business rule default values are not showing in the run-time prompts all the timeSummary: When a form is initially opened, running a business rule correctly displays its default values in the run-time prompts. However, if multiple business rules are …
-
How to check last execution time for business ruleSummary: Hi, Is there a way to check when was the last time a business rule was executed? I understand there is a way we can export the job console logs but that would g…Neha_R 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
EPCMCS-CALL GROOVY SCRIPT via EPM automateSummary: Call Groovy rule for EPM automate Hi All, I created one groovy rule in my EPCMCS instance. when I call the rule via EPM automate command i.e runBusinessRule. It…Avtar 12 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
@allocate is not parsing a value in basisMr parameterHi , I am trying to run an allocation to emulate a copy for performance issues. This is the command: "OEP_Plan"= @ALLOCATE("No Consolidado","2.2.1. PROFESOR HORA",1,,mul…
-
Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dyn parentSummary: Not able to get the values in Hybrid BSO (Freeform) using @calcmgrSLMember for multiple dynamic parent Content (required): we are trying to make the code dynami…
-
epmautomate exportEssbaseData is it same as calculation manager export data>Summary: epmautomate exportEssbaseData is it same as calculation manager export data> Content (please ensure you mask any confidential information): hi All, We were eval…
-
Suggestion to update entity-currency mapping automaticallySummary: What is the best way to update Entity-Currency mapping automatically in the form. Smart list has been created from currency dimension. Is there any way to updat…
-
Groovy - Download and Upload file to other environmentSummary: Download File .csv in Source Environment and then Upload file to Target Environment - Planning EPBCS Content (please ensure you mask any confidential informatio… -
@SPARENVAL did not workHello everyone, I am having trouble with @SPARENTVAL and need help from you. Thanks in advance. I have an alternate hierarchy with the WI_AD_PRO_EXP as the parent of the… -
EPM planning business rule runs multiple timesHi, There used to be an issue like this decades ago, but I am getting the same behaviour in PBCS. After saving a form, and the business rule runs, if I leave the form sa…Mark Matson-Oracle 181 views 4 comments 0 points Most recent by Abhijeet Panchgam EPM Platform and Freeform
-
How to call an existing member within the @SLN function for the "lifeMbrConst" parameterHello everyone, I am trying to leverage the @SLN function within a member formula, and want to use an existing account member as the selection for the lifeMbrConst param…