Calc Manager
Discussion List
-
EPBCS - @return function is not returning anythingContent Hi all, In EPBCS OEP_FS cube I wrote a custom script in order to validate my start/end month prompts, please see below. When I run it, it does not return anythin… -
Update Substitution variable using GroovyContent Team, Is there a way to override the substitution variable values (OEP_CurMnth & OEP_CurWeek) for a specific rule set to execute without impacting other processe… -
Sharing Info: How to view Substitution Variable values in Debug mode - Cal ManagerSummary How to view Substitution Variable values in Debug mode - Calculation ManagerContent Hi All I found something interesting and want to share with all of you. If we… -
Groovy error: calc script too longContent I'm trying to run a Groovy script to execute a calculation but the calc script is too long: The Groovy script failed to compile with internal error: Compile Erro… -
Calc Manager - With Multiple Rules Opened, opening a new rule sometimes opens and shows code from aContent I've noticed this happening ever since the new year. I wonder if this is because of the Java discontinued. When I open an existing rule in Calc Manager, but I al… -
Will running multiple Business Rules (in BSO cubes) with an Aggregation component at the same time sContent Will running multiple Business Rules with an Aggregation component at the same time slow down performance significantly? What about where multiple rules are run …
-
Groovy Grid Iterator/cell.updated doesn´t work sometimesContent Hi all, In a few processes we use the Grid Iterator in Groovy to check if a cell was updated in order to just recalculate that specific point of view. in 99% of …
-
Modify Module RTP Text LabelSummary Want to change the text for "LABEL_ASSET_RATE" for the AssetRate RTP TextContent We want to present a different text for the RTP AssetRate. Presently, it is set … -
Scenario Based BudgetingContent Hi This is with regards to both financials and strategic modelling in EPBCS. We have created a chart of accounts (around 3000 accounts) and around 40 rules to ca…
-
Referencing a Member Range within a Groovy Script VariableContent Hello There! I'm trying to create a dynamic data push after running a data load within my BSO cube. The data load can load multiple periods ie from Jan - Mar or …User_2025-01-31-02-27-25-352 89 views 7 comments 0 points Most recent by User_2025-01-31-02-27-25-352 Planning -
Member name beginning with $Summary Member name beginning with $Content We have a few member names beginning with $ in Planning. The system allows creating the member name but throws an error when …
-
EPBCS: Block creation issue in allocation LogicContent Hi All, I am having a block creation issue in allocation logic. I need to do the project allocation from No Projects to Level 0 of All Projects. I tried to use @…
-
Rule takes 30 min to runContent Hi I have attached a calculation script which takes 30 min to run in total. We need to reduce the time taken to run the rule. Please share any suggestions. Thank…
-
@CREATEBLOCK function not creating blocksSummary Trying to use the @CREATEBLOCK function to create blocks, but it isn't doing it.Content I've used this function a number of times. I recall that sometimes it has…
-
What's New in 20.12?Summary Wrap-up for a Strange YearContent Well, this concludes a strange year (to say the least) but one with lots of new features. We've snuck several more for this mon…Mark Rinaldi-Oracle 224 views 5 comments 6 points Most recent by User_2025-02-08-03-53-41-891 Planning -
@CALCMODE dependency in dense dimensionContent Hi all, We have a complex calculation with a dependency in one of the dense dimension, therefore we use @CALCMODE(CELL) in the script. This slowed down the calcu…
-
IF for multiple conditions.Summary IF to be used for multiple condtions and if they are TRUE only for it to workContent Hi I have a case where im using a formula to calculate values based upon two…
-
smart list id not generatedContent Hi I have created a period smart lists by selecting the option "create from members" and "automatically generated id" as well. But no smart list id is generated.…
-
planning year functionsContent Hi All, I am trying to use planning functions getstartyear and getendyear in EPBCS WF cube, It gives me error Error parsing formula for [FIX STATEMENT, at or aft…
-
BSO to ASO transfer : Level 0 dataContent Hi I have a question. When transferring from BSO cube to ASO cube using data management or any other option, does level 0 data only get imported from BSO to ASO?…
-
Passing a SmartList Value to a MemberSummary Question about IF calculationContent Hi everyone, I tried to pass a smartlist value to a member using these functions but it doesn't work. "Version" = @MEMBER(@C… -
Strange Behaviour on Business RuleSummary Question on block creationContent Hi everyone, I noticed a strange behaviour while writing a business rule that made me question my knowledge on the concept of s…
-
Essbase function to get a summation of all branchesContent Hi We are transferring our data from BSO to ASO cube for aggregation. However there is a requirement to have a interim aggregation in the BSO cube, for a certain…
-
Copy data from BSO cube to ASO cube in EPBCSSummary Need to transfer data from OEP_FS to EPBCS cube in EPBCS application Content Hi I need to transfer data from OEP_FS cube which is the BSO Cube in my application …
-
Aggregation performance issue in Hybrid BSOContent Hi everyone, I have experienced calculation performance issues related to Hybrid BSO (when comparing to on-prem) when formulas rely on attribution associations a…
-
Rule Sets with Variables stopped workingContent Hello everyone! Almost all of our Rule Sets that use Replacement Variables stopped working after the 20.11.62 update. The prompt to set the Rule Set variables is…User_2025-01-28-02-48-16-296 47 views 6 comments 0 points Most recent by User_2025-01-28-02-48-16-296 Planning
-
MDX - Clear with nested accounts and exclude dyn calc membersSummary Nest multiple rollups of accounts dim in a clear scriptContent I have a clear script and this code works for all Balance Sheet accounts. This is part of my cross… -
Need an calculation command/essbase function which calculates the number of days for a monthSummary Need an calculation command/essbase function which calculates the number of days for a monthContent Hi This is with regards to rolling budget in Planning. We are…