Calc Manager
Discussion List
-
Deploying one or more business rules take too long timeSummary: I have an issue with deploying business rule(s). It takes unlimited amount of time to deploy Content (required): This is something that started happening recent… -
When lauching a rule via Rules I get an errorSummary: Hi everyone, When launching a rule from Rules I get following error: the dimension Year is invalid. However it is successful when launching it via calculation m… -
Set Text Account with Attribute ValueSummary: Is there a way to assign a Text Account with an Attribute Value? I'm trying to use a regular rule but it is not working. A couple examples of what I tried below…
-
How to use and optimize perfomance when using dynamic member in calculationHello everyone, I have trouble with dynamic members in my calculation rule. My member "PROFIT" is a parent and dynamic member under the Account hierarchy. When writing t… -
The latest EPM updates issue: rule launch without messageSummary: The latest EPM updates seem to have introduced an issue: After clicking "Launch" for a rule, no message appears confirming that the rule has been launched. Norm… -
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…
-
Unable to launch business rule from RulesSummary: Hi all, I created a rule to copy data from one year to another year, the rule is successfully validated, saved and deployed. I can also launch it from the Calcu…
-
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…
-
Script doesnt work as expectedHi we want the aggregation of a different dimension eg row 6 and 7 needed to be summed up in row 11 ie where ever the functionl area = Room Sales_FA it need to summed to…Althaf Abdullah 31 views 2 comments 0 points Most recent by Lakshani Hettiarachchi EPM Platform and Freeform
-
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…