Calc Manager
Discussion List
-
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 147 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…
-
Error while converting RTP To Smartlist ValueSummary: We have a requirement where we're updating smartlist values based on form POV through RTP using function : "Tgt_Dept1" = @CalcMgrDoubleFromString(@SUBSTRING(@AL…
-
Templates should restrict users from performing executions.Summary: In business rules, there is a functionality that prevents users from executing the rules unless they are the current owner of the specific entity, as defined by…
-
Data Copy Calc ScriptTrying to run a simple data copy from one account to the other and can't figure out why it's not working the member I am copying from (Monthy Net Charge Offs) is a dynam…
-
Currency Conversion in ASO (Freeform Planning)Content Hi, I am currently working on the Currency Conversion on Cloud, we are using ASO in Free Form Planning. So for Currency Conversion in ASO, i have written a Groov…
-
We are trying to write a calculation referring FCCS_YTD member but its not workingSummary: Hi Team, We are trying to write one calc script using FCCS_YTd data but rule gets stuck whenever we try to run it. This is working fine when we run it with "FCC…JyotiSharma 82 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
OEP_FS Not taking Member Formula that ASO cube doesI have written this code for a member formula to take monthly values of an account with a running yearly total. CASE When (Is([Period].CurrentMember,[Jan])) Then ([15526…
-
SAP ERP to Oracle EPM MappingsSummary: Content (please ensure you mask any confidential information): Hi We have below scenario with a client. Client is using SAP as its Core ERP. and we are extracti…
-
member formulaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…