Calc Manager
Discussion List
-
How to unlock locked rule in Calc Manager?Summary: I cannot find the unlock option by right click the rule to unlock it. Content (please ensure you mask any confidential information): Version (include the versio… -
Checking null attribute in calcscriptHello experts, I have a calc script that I have to check if attribute of specific member is null or not, this is my code but is not working: FIX(@RELATIVE("Entity",0 )) … -
Top Down/ Bottomup calculation question in business ruleSummary: Hi Experts, Recently, there was a discussion about the SET FRMLBOTTOMUP ON command, which should enforce bottom-up calculation even for complex formulas, such a… -
EPM Rulescript - DataCopy FunctionHello, I have a rulescript that copies a version to another version for our Budgeting Process which first sits in "Department Requested" tab and changes the status of th…
-
Performance issues - EPBCS enabled app Upper level Sparse dynamic calc membersSummary: Allocation requirement is to fetch total numbers at aggregate level members (Begbalance, Year Total, Top level dynamic calc sparse members for 3 dims) and distr…
-
Upper level member for calc script & IPM insightSummary: IPM insight selection cannot be dynamic parents. Content (please ensure you mask any confidential information): Dear experts, I am trying to use the IPM insight…
-
run on saveSummary: Content (please ensure you mask any confidential information): Hi I want a rule to run in a form once user saves it. Rule has 3 RTPs that is scenario, version, …
-
Need to re-deploy rules after new release?Summary: In the calc manager we see that all our rules have the red cross indicating its not deployed. We think this is only since the new update of Feb 25. Is this expe…Pieter-Jan Vandendriessche 31 views 3 comments 0 points Most recent by Pieter-Jan Vandendriessche Planning
-
@COUNT WITH SKIPNONE AND @XRANGE unexpected behaviourHello everyone, I am using the @COUNT to calculate the count for the number of months from Jun-FY22 to Sep-F23 : OFS_Calculated= @COUNT(skipnone, @XRANGE( FY22->Jun,FY23… -
Tp-EndDate is acting like Tp-Date and is breaking our Start Date calculationsSummary: After numerous tests, I can prove that the TP-EndDate member, though when retrieved is one value...when it is in IF statements it is another value Content (requ…
-
Conditional Groovy in a form comparing two accountsHello experts!! I have a requeriment to do, I have this form: And with Groovy I should get a validation in BALANCE row. My requeriment is if BALANCE is equal to C1290_CA…
-
Calculation of percentile / quantileSummary: How to calculate percentiles / quantiles in EPM Planning BSO without considering #Missing Content (please ensure you mask any confidential information): In my c…
-
Unable to run a ruleset from RulesSummary: Content (please ensure you mask any confidential information): I'm trying to run a ruleset from Rules in the Tools section of Navigator (screenshot 1 below). Ho… -
groovy script syntax , getdata but for string ?when performing a data cell interator. One of my account is of type String (Text). how to i get this cell value ?? the getdata method seems to only return integers. If i…
-
Dynamic Substring Function - Essbase Equivalent of FIND/SEARCH Function from ExcelSummary: We have a need to perform dynamic member name lookups with member names that are varying lengths (something outside of our control as they come from a source sy… -
Non-Groovy: Transfer of Member into Smart Lists created from MembersHello everyone, I have a smart list called TransactionCompany created by @ILvl0Descendants(TransactionCompany) member. And I have a dimension called "Company". Now, I wa…
-
Need help for block creation issue in business rule for Hybrid BSOSummary: Can anyone help us for block creation. Other than below 4 options do we use any other set command or function to create block for hybrid BSO cube. So that Block…
-
summing does not occur as expectedSummary: Content (please ensure you mask any confidential information): Hi I need to get the sum of all the level 0 accounts, level 0 cost centers, where a member is tag…
-
Issue while running business rule - An error occurred while running the specified calc scriptSummary: Issue while running business rule - An error occurred while running the specified calc script Content (please ensure you mask any confidential information): We …
-
SET CREATEBLOCKONEQ does not open the blockHello everyone, I wrote a business rule with SET CREATEBLOCKONEQ to open the block. But it showed strange behavior. I fix from FY25 to FY28, BUT it did not open the bloc…
-
Getting Error while using [[PlanningFunctions.getUserVarValue("xyz")]]Summary: we are using [[PlanningFunctions.getUserVarValue("OEP_Scenario")]] and [[PlanningFunctions.getUserVarValue("OEP_Version")]] in business rule, we have user varia…
-
Assign UDA Using GroovyHello everyone, I want to update the UDA of a member list based on the smartlist selection. Ideally, the calc would create the grid, read the value, and assign the UDAs.… -
How to get the first member of a substitution variable?Hello everyone, I am trying to get the first member of a substitution variables. I created a substitution variable called "YearRange" and set it is "FY24:FY28": So my qu…
-
How to use Datacopy in If statement?: EPM Buisiness ruleI wrote a buisiness rule which copy data from a version to another version. In the rule, I want to use 'Datacopy' in 'If' statement but the following error is displayed.…
-
Changing background color to cell in data froms using GroovySummary: Requirement to change the background color for a data cell based on certain condition Content (please ensure you mask any confidential information): Hello, We n…
-
Ruleset variable questionSummary: Content (please ensure you mask any confidential information): Hi, Got a question about Ruleset variables. I have ruleset_1 with 2 rules which have common RTP o…
-
Ruleset parallel execution issueSummary: Content (please ensure you mask any confidential information): Hi, I got a weird issue when running a ruleset with parallel execution enabled, and want to seek …
-
Calculation for Employee that Terms Mid-MonthSummary: In our Workforce cube/module, is it possible to calculate partial month data for an employee that terms mid-month Content (please ensure you mask any confidenti…
-
Error When Saving DataGrid in Production - "An error occurred while processing this page"Hi Folks, I have encountered an issue when calling the saveGrid() method to save a DataGrid in the production environment, which works fine in the cloned environment. He…
-
info about calculation manger related to latest feb release.with February release the web interface of Oracle will change a lot! in particular Calculation Manager is accessible from “rule” tab. From our knowledge users should not…