Calc Manager
Discussion List
-
Currency conversion rule not working for certain currenciesSummary: Multi Currency Planning application has been set up and up until now, the currency conversions have been working fine for all scenarios. Now there is a new scen… -
I am trying to use Groovy scripting to return the current user name for an account within Planning.Summary: In Planning, I am trying to return the logged user name (full name if possible) for an account which shows the initiator of the process. For example, if I log i… -
Business rule is not executing for selected members and not working when the calc block has logicSummary: We have encountered an issue with a newly created business rule where the if condition and fix statements do not execute as expected. The problem manifests as f…
-
Simple Calc Script QuestionI'm coming in on the tail-end of an EPM implementation. We're about a year into the process, and I don't have formal training, so I've been attempting to reverse enginee…
-
ASO GROOVY Script to export data to a file for a specific scenario excluding the shared membersSummary: Hi All, Im trying to write a calc manager groovy script to export the data out of ASO reporting cube for specific scenario to a file which excludes the shared m…
-
Unallowed commands on BRHello everyone! I'm migrating a planning application from on-premise to EPBCS cloud. I'm aware that there are not allowed commands on EPBS such a "SET CACHE HIGH" and si… -
Copy amount to many different combinationSummary: Hi, I need some ideas for my case. So, in my case, I want to copy the amount from the specific combination to many combinations (Entity-Division-Account level),…
-
How to Extract Shared Parent member name for a member in a shared hierarchyWe have an alternate shared hierarchy in the Account dimension. We want to extract the shared parent member name for a given Account in the alternate shared hierarchy. I… -
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to know CECOs and Accounts that have in different formsHello Experts, I have an assignment to do, in planning process we have all the accounts and all de cecos covered by different forms. I have maybe 50 forms with different… -
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…