Calc Manager
Discussion List
-
MDX Calculations with Custom Groovy Scripts In ASO Cubes.I want to write a Groovy Script in ASO cube, that should execute complex calculations involving multiple operators across various dimensions. Can anyone provide any sugg… -
Are there new changes for creating blocks in business rules?Hello, we noticed that some of our calculation logics do not work anymore as expected and are wondering whether some updates from Oracle to the database could be the rea…
-
EPBCS groovy CustomCalcParameters script syntax issueHi All, I'm struggling with MDX syntax to calculate actual to Date using groovy CustomCalcParameters. Although when I use RHS part of the script Sum(TupleRange(([FY20],[…
-
assiging values to rtpSummary: Content (please ensure you mask any confidential information): Hi I have written the below script, but it does not work. basically i want the rule to run only i…
-
Execution of the specified job type Merge Data Slices is not supported by this method.Hi Folks, I'm trying to call merge data slices through groovy and it throws error "Execution of the specified job type Merge Data Slices is not supported by this method.…
-
Integration of data between cubes.When integrating Quota Planning with Advanced Sales Forecasting to transfer the target value from the OEP_QTP cube to the OEP_GSP cube, we execute the "Push Data" rule f…
-
Base Forecast Push FailedAfter Finalizing the Target from quota planning we wanted to push it to advanced sales forecasting So we followed the below steps : When the quota plan is complete, an a…
-
Groovy script with comand epmautomate after save data formSummary: Groovy script with comand epmautomate after save data form Content (please ensure you mask any confidential information): Hello, I need to align data from one i…
-
DataGridBuilder security issueSummary: Hi, We have a rule using DataGridBuilder to do some calculation and save data back. When the rule is executed by users, data didn't get saved back. Then we figu…
-
Is it possible to display a custom message when saving on a form?Summary: I would like to display a custom message after saving the form that notifies users that they need to run another step. Content (please ensure you mask any confi…
-
24.06.70 Patch - can not deploy a rule in TESTHi Patch 24.06.70 in TEST looks to have broken the ability to deploy a rule - has anyone else come across this / know if a workaround? When I try to deploy a rule (ASO a… -
Groovy MDX script to get HTD valueHi Folks, Can you please help me writing MDX script in groovy to calculate HTD value or at least YTD value. Below script is throwing error: A method called by the script…
-
Planning Provider Error occurance when linking Custom Measure and standard measure in Measure DmHi 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…
-
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…Subhojyoti Chakraborty 231 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…