Calc Manager
Discussion List
-
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…Sabrina Greensea-166456 30 views 6 comments 1 point Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
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… -
Groovy Rule: Submit Date TypeSummary Submitting values to an account of date type rejectedContent In a groovy rule, using a DataGridBuilder, values submitting to an account of Date Type are being re…
-
@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 m…
-
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…
-
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… -
Error with SET commands when validate a business ruleSummary Some validation error message is showing on my all business rules unexpectedly, weeks ago was working fineContent Hi, I'm getting this Warning message when valid… -
Write either cell history or cell note via Business Rule?Summary Is there any way to write to either cell notes or cell history via business rule?Content Hi, With PBCS, we are finding that the Cell History is very useful for t… -
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…
-
Faster method for Aggregation in EPBCSSummary Need a faster method to aggregate values in epbcsContent Hi This is with regards to aggregating values in EPBCS application. We have enabled financials and using…
-
Planning REST API calls which are allowed from Groovy Business Rule ?Summary Planning REST API calls which are allowed from Groovy Business RuleContent Hi All , The intention is to write a Groovy Business Rule ( triggered by the Administr…
-
Can Somebody Explain me the issue with this BR and why its working if I add @CurrMbrContent Hi. I have got a BR as follows:- FIX ("CVR Amount",&CurrentYear, "CVR",&CurrentMonth,{CVR_CostCenter},{CVR_Projects}, "No Company", {CVR_SBU}, "No Intercompany",…User_M88TN 37 views 11 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
How to access attribute of member selected on formSummary Need to use attribute of member selected on form to perform actions on all other members with the same attributeContent Does anyone know how we can use the attri…
-
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…
-
What's New in 20.10?Summary Many things but especially another long-awaited enhancement...Content Wow, this crazy year keeps flying by. We've got another great update this month. As always,…
-
Accessing User Variable using Planning Formula expressionSummary We are trying to access User Variable using Planning Formula expression but are facing issueContent Hello, We are trying to access the Planning user variable usi…
-
Error with Groovy to get Sub Var ValueSummary Works for some SubVars but not othersContent Hi All, I'm experiencing what I would consider as odd behaviour when using Groovy/REST operation.application.getConn…
-
Recomendation: Best way to optimize this allocation of expensesSummary Discuss how is the best way to write an allocation in a business rule with this business case.Content Hi everyone, I'd like to share with you a business case of …
-
Reallocate an account on shared member.Summary I want to go through siblings of a shared memberContent Hello Experts,I have a difficulties to realize a client's request in a financial project in PBCS.the requ… -
What's New in 20.09?Summary ...Some cool stuff!Content Well, here we are again. Another monthly release with lots of exciting updates. As always, please be sure to read the official What's …