Calc Manager
Discussion List
-
Value kept adding/subtracting when form is saved even when the input isn't changedSummary: Hey All, in our WF module, I have built a form that lets the users adjust the headcount of employees to consider those employees transferring to another departm… -
can i give a message in oracle hyperion planning business rule to wait for another rule in onpremisewhenever we are running the ruleset one user will run one rule ,second user will run another run ,Third person will run another rule at the same time .so whenever other …
-
Business Rule/ Datamaps error code Network error [104]: Failed to receive dataSummary: Network error [104]: Failed to receive data Content (please ensure you mask any confidential information): Hi All, I am facing this error: "Network error [104]:… -
Business rule resulting in network error and crashing entire applicationSummary: I am working on an ad hoc data copy rule to make it easier for administrators to copy data (I know that there is Copy Data functionality, but the rule will make… -
How to Allow Non-Admin User to Execute Groovy Rule Changing Dimension Member ParentSummary: Hi, have a groovy rule that updates a members parent member to move from one parent to another. It works for admin users but doesn't work for the non-admin busi…
-
Cannot calculate. Essbase Error(0): Data cache is full.Dear everyone, I am using @ALLOCATE function to allocate data. However, the calculation failed, and it showed "Cannot calculate. Essbase Error(0): Data cache is full. Pl… -
Is it possible to use a planning function as the argument for a DTP?Summary: Can the output of a planning function be used in a design time prompt? Content (please ensure you mask any confidential information): I think the answer is no, … -
Adding member dynamically under a parent in specific order using groovyHi Folks, Using groovy, I'm able to create new child member under a specific parent but I want to create these children in a sorted order. Let's say I have following pro…
-
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 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 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…