Calc Manager
Discussion List
-
How to know what is the data input and what is the calculated data?Hello everyone, I have one question about the business rule calculation functions. Can any calculation function be used in business rules to extract only inputted data? … -
Block Creation in EPBCSHi, I have a below Business rule having a block issue, I tried @createblock and Set commands Still not able to resolve it, your advice is appreciated. SET FRMLBOTTOMUP O… -
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…
-
Salary web form calculation issue when changing versionsHi, I have come across an issue with a salary web form. When entering a salary line with a start date and no end date salary is calculated for not just the current finan…
-
Dynamic Calc members are not aggregating when CALC DIM is used onceHi all, We have a sample hierarchy as below. Below are the member properties. Net Sales: Store, Two Pass Calculation - Enabled Gross Profit: Store, Two Pass Calculation …
-
Member selection restriction in run time promptWe have run time prompts for Scenario, version and Entity for a business rule. When I select the Actual scenario in RTP for scenario, I dont see the alternate hierarchy …
-
TODATEEX Calc Function supports only till 2037Summary: TODATEEX Calc Function supports only till 2037 and any reason behind this? Content (please ensure you mask any confidential information): TODATEEX Calc Function…
-
DLR isn't working because of business rulesHello All, We try to launch Data load Rule which has business rules affected afterload. But DLR gives error at export stage because in the log it displays rules that doe… -
Where can I find the cube alias to use in XREFSummary: Content (please ensure you mask any confidential information): I am trying to reference a number in a business rule from our plan cube into our workforce. But I… -
What is the Difference between AGG and @idescendantsHello everyone, I saw in many codes someone uses @idescendants, and someone uses AGG. Both will give the same result. As I read the Oracle doc, I really dont know the ex…
-
Update Member Alias by end userHi, I am looking for an option where an end user (not admin) can update the alias of a member. I have explored couple of options: > EPM Automate doesn't have any such co… -
True up Fforecast Bonus to a Yearly TotalSummary: Content (please ensure you mask any confidential information): I have created a business rule that will true up our forecast bonus to a yearly total. I have the…
-
Merit/Raise Member Formula Not Working for All EmployeesSummary: Content (please ensure you mask any confidential information): We have a member formula for Merit/Raise. However, it doesn't seem to be working for all employee…
-
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…