Calc Manager
Discussion List
-
@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…
-
XREF and mdshiftSummary: Hi I have a BSO and ASO architecture in the application, where BSO is used for data consolidation from different applications and ASO is used for aggrgation/rep…
-
Business Rule/Groovy Scripting to remove data in ASO at a specific intersectionSummary: Trying to determine if there is a way to create a business rule or groovy script which would clear data in ASO at a specific intersection utilizing members deri… -
Retrieving Base currency tagged to an Entity in EPBCS using groovyHi all, I am trying to retrieve Base currency tagged to level 0 entities in EPBCS application using groovy. As shown in the below image, for the respective level 0 entit…
-
@XRANGE not work properlyHello everyone, I am using XRANGE function in my rule to calculate the average amount. Under my Period dimension, I have YearTotal hierarchy and YearTotal_Input alternat…
-
Sharing Info: String Compare in Planning - @CalcMgrCompare functionSummary Execute a set of statements based on the Variable/Prompt Value (String Compare)Content Hi All I found something interesting and want to share with all of you. We… -
Automation of user variable limits/definitions?Summary: Is it possible to automate additions of new members in user variable definitions? Content (required): We have a number of user variables to assist in the limita… -
Use Workforce OOB template/BR with RTPs and DTPs in a custom groovy scriptI have requirement where I need to Transfer bulk employees in the OOB WF module (Using the OOB BR OWP_Transfer, or the included OOB templates OWP_Transfer_T, & other 2).…
-
Error while executing rule "Cannot complete operation: insufficient aggregate storage cache size"Summary: Hi, I am trying to run calculation manager custom script but getting error : Cannot complete operation: insufficient aggregate storage cache size. If i execute …JyotiSharma 143 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Can Run-Time Prompts be set to Ignore Valid Intersections?Summary: Run-time prompts are restricted by valid intersections. But we would like to disable this as needed. Content (required): We need to be able to run some rules th… -
The best way to get scenario start year for certain module by using groovySummary: I want to get Scenario start year & end year for workforce module by using groovy Content (please ensure you mask any confidential information): Hi All, I would… -
How to kill every session in PBCSHello everyone, I am facing problem that I cannot refresh the database, and it shows the error: Cube refresh failed with Essbase Cube: CDGInput, Error code: 1013132, Mes…
-
How do i check the value of a run time parameter in a business rule?Hello, I need to check the value of a run-time parameter for the Period dimension in the EPM Planning Calc Manager (Calc script, not Groovy) and need help with the synta…
-
Trying to list Base members using WITHATTR functionSummary: I am trying to allocate the expense for 2 different projects based on a input project entered by user. Here is my logic. Logic validates fine and it runs withou…
-
Copy No_Currency data to Local Currency based on Entity base currencySummary: Is there a way to copy No_Currency data to the respective Entity base Currency with out using UDA's or Attribute assignments Content (required): In a Simplified…
-
Viewer role to launch BR for intersections they have access?Summary: Could a Viewer role launch BR for the intersections they have access to? Do not want to go by a named connection / Pipeline BR with Admin Cred Content (please e…
-
The following value is not valid for the runtime promptHello everyone, I am facing with stupid error. I have a ruleset and attached it to the form for running after save. However, when I clicked on the Save button, the runti…
-
How to sum the data of alternate hierarchy?Hello everyone, I have one question about the function for sum data of alternate hierarchy. I have Hierarchy which is like this: And member A4 appears under both hierarc…