Calc Manager
Discussion List
-
Add dynamic member and its alias by using business ruleHello everyone, I have one question about create dynamic member in the business rule. I am using business rule to create member. I can name for the member but how can i … -
Assign smart list entry name to text memberSummary: Content (please ensure you mask any confidential information): Hello, is there any way to reach out the idea I mentioned on the tittle? So, I have 2 members: Ac… -
Can we compute data at a Parent level with same formula as child level member?Summary: Need to calculate Parent member with the same formula as its Child member. Default behavior populates the parent with the summation of child members (Aggregatio… -
How do I extract a label from a Smart List and load it as a text value into a text account?Summary and Content: Using a Smart List, I want to be able to extract the label for a given Smart List value and load the Smart List label as a text value into a separat… -
message to launch ruleSummary: Content (please ensure you mask any confidential information): Hi Is there a way to prompt a message in the form informing a user to run a rule. not an error me…
-
How to launch a ruleset in calc manager?Gurus, there seems to be no button to launch a ruleset inside calculation manager like launching a rule. Is that so? Or did I miss something? If that's the case, a rules… -
Calling another Business Rule within a RuleHello, We understand there's an option to call another business as subprocess within a rule using following syntax. %Rule(name:="Rule to be called",application:="EPBCS",… -
CONCATENATE and PARENT function not workingHello Experts, I'm trying to do a calc combining CONCATENATE and PARENT function and is not working. This is my code: FIX(&Act_Year,"Real","V0_Input","Dim1","Dim2",@RELA… -
use of subs var in rulesSummary: Content (please ensure you mask any confidential information): Hi I have written a script as below Where always the first variable takes value from best estimat…
-
Is it good idea making all Dimensions Dynamic calc for Freeform application (Hybrid BSO)Summary: Is it good idea making all Dimensions as Dynamic calc(Parent members) for Freeform application (Hybrid BSO). Single BSO cube application. We have one large cust…
-
Time difference for rules in test and prodSummary: Content (please ensure you mask any confidential information): Hi i have a rule which i improved performance in test from 5 minutes to 1 minute. But in prod, it…
-
how to export and import using groovy scripHi eveyone, I'v 2 cubes, ASO and BSO, for dense dimensions, to ASO its Account and to BSO its Period, can i use groovy to Export and Import with this case?? I mentioned …
-
Optimizing coydata ruleHello experts, I have a rule that is working but I have to update manually if user want to change behaviour of some group accounts: In Driver_Version user should type di…
-
Run of Merge Slices Job via Business Rule on Form-Level Action Menu - EPM Automate/GroovySummary: I am attempting to run a merge slices job as part of a ruleset that is triggered via a form-level action menu. The script shown below works perfectly when run d… -
Sort Pipeline GET responsesSummary: Pipeline returns DM Process IDs in unsorted manner, would like to sort this Content (please ensure you mask any confidential information): Am trying to sort the…
-
When I run the rule, the system prompts an error, but when I run it a second time, the error disappeThis is a rule written by "groovy". Groovy acts like a rule set that calls rules and gives some parameters. The JOB status is “completed with Erros” . Details content of…
-
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg…
-
Are there new changes for creating blocks in business rules?Hello, we noticed that some of our calculation logics do not work anymore as expected and are wondering whether some updates from Oracle to the database could be the rea…
-
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
assiging values to rtpSummary: Content (please ensure you mask any confidential information): Hi I have written the below script, but it does not work. basically i want the rule to run only i…
-
Execution of the specified job type Merge Data Slices is not supported by this method.Hi Folks, I'm trying to call merge data slices through groovy and it throws error "Execution of the specified job type Merge Data Slices is not supported by this method.…
-
Integration of data between cubes.When integrating Quota Planning with Advanced Sales Forecasting to transfer the target value from the OEP_QTP cube to the OEP_GSP cube, we execute the "Push Data" rule f…
-
Base Forecast Push FailedAfter Finalizing the Target from quota planning we wanted to push it to advanced sales forecasting So we followed the below steps : When the quota plan is complete, an a…
-
Groovy script with comand epmautomate after save data formSummary: Groovy script with comand epmautomate after save data form Content (please ensure you mask any confidential information): Hello, I need to align data from one i…
-
DataGridBuilder security issueSummary: Hi, We have a rule using DataGridBuilder to do some calculation and save data back. When the rule is executed by users, data didn't get saved back. Then we figu…
-
Is it possible to display a custom message when saving on a form?Summary: I would like to display a custom message after saving the form that notifies users that they need to run another step. Content (please ensure you mask any confi…
-
24.06.70 Patch - can not deploy a rule in TESTHi Patch 24.06.70 in TEST looks to have broken the ability to deploy a rule - has anyone else come across this / know if a workaround? When I try to deploy a rule (ASO a… -
Groovy MDX script to get HTD valueHi Folks, Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value. Below script is throwing error: A method called by the script…
-
Planning Provider Error occurance when linking Custom Measure and standard measure in Measure DmHi Oracle Support, We created a custom measure called "Current Target" under the Measure Dimension for sales planning. Our goal was to reference this standard measure us…
-
refresh DB ends in errorSummary: Hi Refresh DB Ends in error. We are getting the following error message, when trying to edit a member. You are trying to change data that has been changed by a …Lakshani Hettiarachchi 51 views 5 comments 0 points Most recent by Dan Gagnon - HyperionDan Planning