Calc Manager
Discussion List
-
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…
-
SET HYBRIDBSOINCALCSCRIPT FULL; IssueSummary: Content (please ensure you mask any confidential information): Hi we encountered an error when using SET HYBRIDBSOINCALCSCRIPT FULL; Just wanted to know why it …
-
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… -
Business Rules getting auto launched multiple timesSummary: Did anyone face issue with business rules getting auto launched multiple times, the behaviour is not very consistent and hard to understand and debug as there a… -
What causes a 'read' on a block calculation in the logs?Summary: What would constitute a Block Sparse Calculation Read in the calculation logs? Content (please ensure you mask any confidential information): I am working on so…
-
Value kept adding/subtracting when form is saved even when the input isn't changedSummary: Hey All, in our WF module, I have built a form that lets the users adjust the headcount of employees to consider those employees transferring to another departm…
-
can i give a message in oracle hyperion planning business rule to wait for another rule in onpremisewhenever we are running the ruleset one user will run one rule ,second user will run another run ,Third person will run another rule at the same time .so whenever other …
-
Business Rule/ Datamaps error code Network error [104]: Failed to receive dataSummary: Network error [104]: Failed to receive data Content (please ensure you mask any confidential information): Hi All, I am facing this error: "Network error [104]:…
-
Business rule resulting in network error and crashing entire applicationSummary: I am working on an ad hoc data copy rule to make it easier for administrators to copy data (I know that there is Copy Data functionality, but the rule will make… -
How to Allow Non-Admin User to Execute Groovy Rule Changing Dimension Member ParentSummary: Hi, have a groovy rule that updates a members parent member to move from one parent to another. It works for admin users but doesn't work for the non-admin busi…
-
Cannot calculate. Essbase Error(0): Data cache is full.Dear everyone, I am using @ALLOCATE function to allocate data. However, the calculation failed, and it showed "Cannot calculate. Essbase Error(0): Data cache is full. Pl…
-
Is it possible to use a planning function as the argument for a DTP?Summary: Can the output of a planning function be used in a design time prompt? Content (please ensure you mask any confidential information): I think the answer is no, … -
Adding member dynamically under a parent in specific order using groovyHi Folks, Using groovy, I'm able to create new child member under a specific parent but I want to create these children in a sorted order. Let's say I have following pro…