Calc Manager
Discussion List
-
refresh DB ends in errorSummary: Hi Refresh DB Ends in error. We are getting the following error message, when trying to edit a member. You are trying to change data that has been changed by a …Lakshani Hettiarachchi 51 views 5 comments 0 points Most recent by Dan Gagnon - HyperionDan Planning -
Planning Provider Error occurance when linking Custom Measure and standarHi Oracle Support, We created a custom measure called "Current Target" under the Measure Dimension for sales planning. Our goal was to reference this standard measure us… -
Running Groovy rule; could not retrieve the rule execution statusContent Hi, I was creating a simple groovy script to select a list of accounts which have certain UDA. It's pretty much the same as the example shown in a blog. https://… -
Translate Trailing 12 Months CalcScript to MDXHello Hello experts, I have to create some new periods (dynamic calcs) in PBCS application to calc Last twelve months and I have to do with calc script and MDX (ASO cube… -
Move or Allocate by department and vendorSummary: Content (please ensure you mask any confidential information): I am trying to allocate or move some expenses based on two components: departments and vendors. I… -
DataGridBuilder errorSummary: Hi, Got a weird error when building a DataGridBuilder. Here's the code snippet: /*RTPS: {RTP_Year} */ String str_Year = rtps.RTP_Year DataGridBuilder gridbuilde…
-
Debug Groovy ScriptHi everyone, I've a groovy script based on depreciation and the logic its wrong, can i debug a groovy script?
-
Not possible to export data via business rule because of dynamic calc membersHello All, I'm trying to export the data from a cube via Essbase business rule, but I have errors because of dynamic calc members : I can't put "DataExportDynamicCalc to… -
Calc All in Free Form Planning CloudAll, I am pretty confused. I was tasked to move an existing BSO cube that we have on Premise (11.1.2.4 essbase) and place it in the cloud as BSO Free form cube. The chal…
-
Is it possible to update the OOTB right click rules (Transfer, Departure, Change Status)Summary: Is it possible to update the OOTB right click rules (Transfer, Departure, Change Status) to work on all Organization -Employee combination rather than on a sing…
-
Run Business Rule in Calc Script on calc managerHow to Run business rule in a calc script on calc manager? Hello Experts, Please, how should I create a business rule that is capable of executing another business rule … -
How to create a shared Member dynamically using groovySummary: I have created a groovy which will create a dynamic member under the parent A, and that is working fine. Now I want to create the same member as shared member u…
-
get attribute values associated with a member using groovySummary: I'm trying to get the attributes value associated with a member. But somehow I'm unable to make it work. I need the value to be stored in some variable for furt…
-
Course for Business Rule WritingSummary: Content (please ensure you mask any confidential information): I am looking for recommendations of courses which offer Calculation Manager training. I have a go…
-
Groovy - awaitCompletion - An error occurred while processing this page.Hi all, Hope you guys are doing well. We are trying to use REST API to trigger a data integration from Calc Manager (EPBCS application). We have created the connection, …
-
Block Creation issue when I used @prior functionSummary: Hi, Please help me in creating the block when I am using @prior function. Requirement is to add the data of previous period for two account and load to current … -
Rule Error status code [1042016]Hi, The Original script completes in a second(1sec) but once the rule is edited with a cross dimension ->"OWP_Existing Employees" the rule error out after 30 minutes Ori…
-
Business Rule not working for Scenarios other than OEP_PlanHello! Summary: I am creating a Business Rule to apply a Percent increase to the values from the previous year. The rule does not work for different Scenario other than …
-
Working functionality of LOOP/ARRAY in Business RuleSummary: Is there any way to use Loop or Arrays which will take multiple RTP variables as parameter and perform calculations for each RTP within the loop? Content (pleas…
-
Error using startsWith function in IF condition within FIX ENDFIXHello, I'm trying to put an IF condition within FIX ENDFIX in an EPBCS groovy script. Need to execute the set of statements if a Custom dimension member starts with a pa…
-
Fix inside if conditionSummary: Content (please ensure you mask any confidential information): Hi I have a rule which takes 10 min to run. Current setup : 16 Entities and Each of these entitie…
-
Smartlist issueSummary Content (please ensure you mask any confidential information): Hi, We had an issue with smartlist, not sure about the root cause. In business rule, we have a cal…
-
Remove shared members from XRANGESummary @REMOVE in @XRANGE not working as expectedContent Hi experts, we have the following custom calculation which counts the members of Period dimension in a given ra… -
Export Console REST API - generates all rules instead of single rule in params & Unzip using groovySummary: Export Console REST API - generates all rules instead of single rule in params Content (please ensure you mask any confidential information): Export Console RES…
-
Allocation ExampleSummary: Need to allocate by department from one entity to multiple others. Content (please ensure you mask any confidential information): I'm looking for a good example…
-
Convert value of SmartList to member to use in cross-dimensional (Non-Groovy)Hello experts, I have an account linked to smartlist where I have "account values" to choose in this smartlist, like this: For each entity (on columns) and dimension flo…
-
@CalcMgrSLMember not recognized?In the october update it brought 4 new functions : @CalcMgrLogMessageTrace: Adds custom messages to the Log Messages tab after launching a rule in Calculation Manager. @… -
Copy a dynamic calc parent member to a stored base level memberSummary: Need to copy a dynamic calc member to a stored base member Content (please ensure you mask any confidential information): I have a roll up (below) in a sparse d…
-
How to print or use substitution variables in Groovy for ASO cubeSummary: I had a requirement where I need to extract data from ASO cube montly, I created Sub Var in ASO cube for period and year trying to call those in groovy but scri…
-
Optimizing Allocate RuleHello experts, I have a doubt with a calc script doing an allocation. Type my code and explain if is possible optimize this code: FIX (&Act_Year,"Actual","EUR",@RELATIVE…