Calc Manager
Discussion List
-
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…
-
@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… -
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).…
-
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…
-
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…
-
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…
-
How to re-calculate YearTotal based on requirement when it is dynamic memberHello everyone, I am trying to calculate the % of net sales for my GL accounts. All my GL accounts are setting Account Type is Expense/Revenue and Time Balance is flow: …
-
@ALLOCATE did not workHello everyone, I am trying to use @ALLOCATE function to allocate from the parent to the children (children are shared members). My rule here: SET UPDATECALC OFF; SET AG…
-
Ruleset and RulesSummary: Content (please ensure you mask any confidential information): Hi Probably a stupid question. When a rule is deployed in multiple rulesets, once I updated the r…
-
Is there a way in Groovy to throw an error based on certain validations and close the prompt screen?Summary: Hi Experts, Is there a way in Groovy to throw an error based on certain validations and close the prompt screen? In my current application, I am using throwVeto…