Calc Manager
Discussion List
-
Groovy - Issue passing environment variable to calc script templateSummary Environment variable defined in groovy script is not passing over to calc script templateContent Hello, We are defining an environment variable in our groovy tem… -
2 RTP one should flow from web form, one promptwe have a requirement, in the business rule where we have 2 prompts for Sceanrio dimesnion member. The rule is attached to a data form. Prompt A - should flow from the W…
-
how to refer period dimension member from datein EPM cloud planning, business rule, I have a date captured in planning (Type Date). I am trying to refer the month in my business rule from the month captured in the e…
-
Add Different parents in List of getEvaluatedMembers in GroovyHello experts, I have a doubt developing a groovy script. I need to get a list of Cebes but in this case I need to take different parents at the same time. I'm using thi… -
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 21 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…
-
Not able to Hide Prompt when a Ruleset consists of two business rules from different cubesSummary: Though all the "Hide Prompt" properties are ticked still the user gets the prompt when executing from the actions menu Content (required): We have a requirement…
-
epmautomate exportEssbaseData is it same as calculation manager export data>Summary: epmautomate exportEssbaseData is it same as calculation manager export data> Content (please ensure you mask any confidential information): hi All, We were eval…
-
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…