Calc Manager
Discussion List
-
Using Groovy to update a member property for Storage, individual cube properties aren't updatingSummary: A Groovy script that builds a map to create a member in a hierarchy is not properly updating member properties Content (please ensure you mask any confidential … -
Account in @REMOVE is being ClearedSummary: Content (please ensure you mask any confidential information): I use the below business rule to clear expense accounts before loading a new employee roster and … -
(Please ignore the post) Calc Mgr error validating @ISMBR functionSummary: Content (please ensure you mask any confidential information): Hi, Just in a sudden, a business rule that previously validated and deployed successfully now got…
-
Business rule assignment to the planning formsWas there any easy way to search business rule and assign to the planning forms , Currently i am scrolling down through the 100's of rules to find a business rule and as…
-
Can you create folders in calculation manager?Summary: Content (please ensure you mask any confidential information): In our calculation manager, we have a lot of custom rules that were created during implementation…
-
Script analysis throwing an error with substitution variableI'm attempting to make a business rule quicker, so I'm doing a script analysis on it. The rule validates and functions with no errors; however, when I try to do a script…
-
Sharing Info: String Compare in Planning - @CalcMgrCompare functionSummary Execute a set of statements based on the Variable/Prompt Value (String Compare)Content Hi All I found something interesting and want to share with all of you. We… -
Business Rule Performance Question Datacopy vs FormulaSummary: After reading some posts that have been circulating here and on other media, I decided to try and optimize a script formula, but I'm not getting expected result…
-
Hide Columns validating a condition through groovySummary: I would like to validate a condition of row member and hide columns which does not satisfy that condition. Content (required): Looking for a groovy logic to see…
-
Validation not working in Calc ManagerSummary: One of my business rules is failing for validation. I have 3 members which have had names changes, and wondering if, although the refresh of the Planning Outlin… -
How can I convert a member to a string to populate a Smart List value?Summary: I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension. Content (required): Below is an example …
-
Groovy Dataexporter is not exporting Dynamic Calc membersSummary: Hi, I need to export data from EPM Planning BSO cube with "Alias". So I need to use Groovy Rule because Data Export Calc command BR create Member Name in file. …
-
How do I use an attribute in a workforce business ruleSummary: Content (required): When we copy data from workforce to the plan cube, we need to break out the employees by Class. We do not have Class in the Workforce cube, …
-
Member formula for opening balance calculationSummary: Content (please ensure you mask any confidential information): I seem to be experiencing what looks like a circular reference in a member formula for a BSO cube…
-
Issue with getEmailAddress() Method in Oracle EPM Groovy: "Email Doesn't Exist" ErrorHi Folks, I'm encountering an issue in Oracle EPM when using the getEmailAddress() method of the User class in Groovy. When I call operation.user.getEmailAddress(), I re…
-
Find a substring in an Alias and compare to textSummary: We have a standard PBCS license (so no Groovy Scripting) and I am trying to analyse member aliases on the Entity dimension to see if there is a matching substri…
-
Dynamic Children and Groovy saveMember questionSummary: Content (please ensure you mask any confidential information): Hi, With Dynamic Children enabled for a "Dynamic Calc" parent, and use Groovy(non-REST API) to ad…
-
How to know what is the data input and what is the calculated data?Hello everyone, I have one question about the business rule calculation functions. Can any calculation function be used in business rules to extract only inputted data? … -
Block Creation in EPBCSHi, I have a below Business rule having a block issue, I tried @createblock and Set commands Still not able to resolve it, your advice is appreciated. SET FRMLBOTTOMUP O…
-
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…
-
Salary web form calculation issue when changing versionsHi, I have come across an issue with a salary web form. When entering a salary line with a start date and no end date salary is calculated for not just the current finan…
-
Dynamic Calc members are not aggregating when CALC DIM is used onceHi all, We have a sample hierarchy as below. Below are the member properties. Net Sales: Store, Two Pass Calculation - Enabled Gross Profit: Store, Two Pass Calculation …
-
Member selection restriction in run time promptWe have run time prompts for Scenario, version and Entity for a business rule. When I select the Actual scenario in RTP for scenario, I dont see the alternate hierarchy …
-
TODATEEX Calc Function supports only till 2037Summary: TODATEEX Calc Function supports only till 2037 and any reason behind this? Content (please ensure you mask any confidential information): TODATEEX Calc Function…
-
DLR isn't working because of business rulesHello All, We try to launch Data load Rule which has business rules affected afterload. But DLR gives error at export stage because in the log it displays rules that doe… -
Where can I find the cube alias to use in XREFSummary: Content (please ensure you mask any confidential information): I am trying to reference a number in a business rule from our plan cube into our workforce. But I…
-
What is the Difference between AGG and @idescendantsHello everyone, I saw in many codes someone uses @idescendants, and someone uses AGG. Both will give the same result. As I read the Oracle doc, I really dont know the ex…
-
Update Member Alias by end userHi, I am looking for an option where an end user (not admin) can update the alias of a member. I have explored couple of options: > EPM Automate doesn't have any such co… -
True up Fforecast Bonus to a Yearly TotalSummary: Content (please ensure you mask any confidential information): I have created a business rule that will true up our forecast bonus to a yearly total. I have the…
-
Merit/Raise Member Formula Not Working for All EmployeesSummary: Content (please ensure you mask any confidential information): We have a member formula for Merit/Raise. However, it doesn't seem to be working for all employee…