Calc Manager
Discussion List
-
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…
-
EPBCS : API call to Run Rule not fetching parametersWe have two Rules. Groovy_Rule1 should run on form save. Should pick Run time prompts and pass it to API call which will call Groovy_Rule2 to run a Data Map. Issue: For …
-
Invalid IntersectionSummary: Content (please ensure you mask any confidential information): Hi I want the Last Column : SAP Master Report —all rows to be valid. These rows could be getting …
-
Hybrid mode calcs, FRMLBOTTOMUP, and NONEMPTYTUPLEThis isn't really a question, more of a PSA! I found a unique relationship between Hybrid mode in calc scripts, FRMLBOTTOMUP, and NONEMPTYTUPLE when working with complex… -
PLAN: Unable to amend TASK Parameter content when referencing a Business RuleSummary: Content (please ensure you mask any confidential information): Hi all We have notified that when we have a TASK referencing a Business Rule with a Prompt, we ar… -
How to prevent users from running the ruleHello everyone, I am using PBCS, which does not support Groovy. I am trying to prevent users from running the datacopy rule when the Version is approved. My business rul…
-
Why is Incremental Process Data with Synchronize Defaults only allowed to be run by admins?Summary: Why is Incremental Process Data with Synchronize Defaults only allowed to be run by admins? We would like users to be able to change their hiring requisitions s…
-
The dependence in the calculationHello everyone, I have one question about the dependence on the business rule. In the FIX statement, I fix 3 years FY26 vs FY27, FY28. FIX(FY26,FY27,FY28) OFS_Calculated…
-
The dependence in the calculationI have one question about the dependence on the business rule. In the FIX statement, I fix 5 years FY26 vs FY27, FY28, FY29, FY30,. — FIX(fix statement 00) DATACOPY to o…
-
Question on HYBRIDBSOINCALCSCRIPT Log MessagesHi All, I was recently testing a calc script in a Hybrid BSO cube, and saw some interesting results around sparse/read writes when using the HYBRIDBSOINCALCSCRIPT comman… -
Member Name contains comma for Data IntegrationSummary: Account name contains comma Content (please ensure you mask any confidential information): Hi All, I am performing an ASO to ASO cube data transfer using Data I…