Calc Manager
Discussion List
-
3 Month Average Using &OEP_CurMnthSummary: I'm trying to extend OOB functionality by creating a 3 month average driver. I'm working on a calc script to test functionality. I currently have the substituti… -
Recursion limit [128] reachedHi everyone ! I've deparing with this error while running a rule, according to some searchs i found it; !!Also i already fixed it!! Then the script was composed by Accou…
-
not accurately summingSummary: Content (please ensure you mask any confidential information): Hi We need to sum one dimension based on its value, adding all level 0 members of other dimension…
-
groovy data grid multi dimensional mapping possible?I use DataGridDefinitionBuilder to power the data movement from one plan type to another and use a Map variable to do some member replacements. It works great but now I … -
QUERYRESULTLIMIT in new reporting (NOT FRS)Summary: Content (please ensure you mask any confidential information): Hi we are getting the below error when tried to launch the report The number of query result cell…
-
how can i extract the text value from a account stored as text via groovy?I need to retrieve the text info from a cell stored as text. But this code only retrieves values 0. What am i doing wrong? // Get the grid from the operation DataGrid cu…
-
Length of substitution variable valueSummary: Need to know the length limit of substitution variable value Content (please ensure you mask any confidential information): Hi, Does anyone know the length limi…
-
Does @XREF work in Hybrid BSO?Summary: Does @XREF work in Hybrid BSO? Hi. We just enabled and converted an old BSO application to Hybrid BSO and now have a business rule that uses the @XREF function …Peter Doyle - Equator EPM 25 views 4 comments 0 points Most recent by Dan Gagnon - HyperionDan Planning
-
Rule take a long time to completeThe Below rule takes 5 minutes. STI Provision"->"OWP_Expense Amount"=(@XREF(EPBCSREPCube,"No Job","No Employee","No Component","No Cost Center","No Functional Area","No …
-
SmartPush with Groovy failed and very slow. Error Threshold: 500000Hello experts, I have a form with moreless 400 rows, and user should inform these 400 rows with different values. in Rows I have four dimensions with different combinati… -
FCCS : executeCalcScript(java.lang.String) is not allowed RuleSummary: Groovy function to executeCalcScript is not working in FCCS Content (please ensure you mask any confidential information): getting below error while trying to e…
-
Evaluate a account defined as TEXT data typeSummary: hello, I have one member in the Account dim (dense) defined as a text. I need to evaluate the content of that member in a business rule. I'm hoping with yoru in…
-
how to run REST API ADD_USERS_TO_GROUPGroovy is undoubtedly a wonderful tool, it has allowed me to run jobs through REST API export and import data, metadata, security, mass rename members, form operations a…
-
Groovy-Randomly receiving "The form GroovyDataGrid_# is invalid" error that works perfectly on rerunSummary: We have rules that will occasionally fail with the above error but work perfectly when rerun with no changes. Content (please ensure you mask any confidential i…
-
Best way to move data bso to aso for level 0 dynamic calc members in account hierarchyIn epm cloud planning, how to move data between data from bso to aso for a dynamic calc account dimension member with formula as below? @@SUMRANGE("I_4-7",@INTERSECT(@AT…
-
Groovy - how to print real-time log message in job console?Summary: Hi, I have a Groovy rule with long-running processes, for example the process needs to be iterate through 100 times for different combinations. I need to watch …
-
Debugging Rules in EPM planningWe have few Rules in EPM planning and budgeting - Profit cube which calculates the costs/revenue based on few allocation account drivers and then it allocates them acros…
-
Groovy setSuppressMissingSuppressesZero never workSummary: Hi, With a groovy rule to build a grid like below for reading data FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder() gdb.setSuppr…
-
General aggregation questionI was curious as to what might be causing an aggregation to take significantly longer when run for a different fiscal year, all other things being equal. Each fiscal yea…
-
@count usage in a divisionSummary: Greetings, I'm using @count in a rule file in Planning to get the number of records for a particular intersection. Works well, the result comes back correctly. …
-
Error in groovy, The following Date is Invalid: .Hi all, we are trying to retrieve data from multiple projects in EPBCS in ASO cube we are using datagriddefinitionbuilder to read the data from the above accounts as bel…
-
Essbase cache data is fullHello experts, I have a problem with essbase cache. In production environment it works fine, but when I copy the snapshot to test and execute rule I have this problem: H…
-
Possible to derive the start month of prior sibling of selected Scenario in RTP?Summary: Hi there, We have our regular scenarios and we have created Staged Scenarios for each of them. These Staged scenarios deal with the periods prior to the open pe…
-
How do I use @ATTRIBUTE in business ruleSummary: Need a business rule using attributes to breakout costs into another entity/account Content (please ensure you mask any confidential information): I've used @AT… -
Securely storing a client secret for REST API OAuth2 Authentication in Groovy ruleSummary: Where can I securely store a client secret token for use in a REST API call in Groovy. Content (please ensure you mask any confidential information): I need to …
-
groovy assign variable value to rtpSummary: Assign variable value to rtp for essbase calculation part Content (please ensure you mask any confidential information): Hi All, I have retrieved the prevData v… -
Passing all Dimension value to a single intersectionHi, We need to pass all values in a particular dimension(Functional Area) to a dummy account Eg Dummy accounts created. Amortisation of Intangible assets_Dummy Lease Dep…
-
Groovy - The form GroovyDataGrid is Invalid when DataGridDefinitionBuilder is usedHi all, In an ASO cube, we are using CsvWriter and DataGridDefinitionBuilder to iterate through each account to generate a CSV file in Inbox/Outbox Explorer. while using…
-
What is the Maximum Calcparallel Setting Recommended (limit)Summary: I'm trying to find out what would be the maximum recommended setting that calcparallel could be set at in EPBCS. Is there any documentation about the limit of t…
-
Script DesignHi, We have a requirement when a smartlist value is selected for a particular intersection, we need to identify all other intersections that use the same smartlist value…