Calc Manager
Discussion List
-
Groovy rule to get user's group and prevent that group modify data row in a formHello everyone, I have one question about groovy rule. If a have 4 users : U1, U2, U3, U4 and (U1,U2) are in group A, (U3, U4) are in group B. Now I have a form that bot… -
dynamic calc member takes timeSummary: Content (please ensure you mask any confidential information): Hi There are so many formulas where i have referenced as below example, and rule performance is l… -
How To Create New Alias or Make Modification to Existing Value in EPM CloudHI Oracle Community, I am trying to figure out how to create a new location alias in Oracle EPM Cloud. I was able to accomplish this easily in previous version by going …
-
Business Rules suddenly go haywire -> @LIST with @UDA behavior has changed?Summary: The FIXes in my business rules suddenly resolve differently due to a change in behavior when using @LIST(@UDA(Dim,UDA)) Content (please ensure you mask any conf…
-
Year Reference in Member FormulaSummary: Would like to make this formula dynamic Content (please ensure you mask any confidential information): I have an account with a member formula that rerefnces th… -
How to Extract Shared Parent member name for a member in a shared hierarchySummary We have an alternate shared hierarchy in the Product dimension. We want to extract the shared parent member name for a given product in the alternate shared hier…
-
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…