Calc Manager
Discussion List
-
ASO calculations do not work when converted from Designer to Script mode in GroovyService:Enterprise Performance Management Enterprise Cloud Business Process:Planning Version:25.03.60 ISSUE: Trying to convert an existing Designer template for a MDX co… -
@ATTRIBUTE and @WITHATTR in @SUMRANGE FunctionCame across something interesting and wondered if anyone else has experienced this. I'm working on an allocation model based on headcount and leveraging attributes to ta… -
Currency Conversion Not Working on New CurrencySummary: Content (please ensure you mask any confidential information): I have recently added EUR to our currencies. It is set up like USD as a reporting currency. I tri… -
Deploying business rule using REST APIHi all, Just wanted to know if there is any REST API to deploy a business rule in Essbase Script for EPBCS so that we can automate the rules deploy for a specific plan t…
-
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… -
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 32 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 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…