Calc Manager
Discussion List
-
Groovy Business Rule - crossDimCell across Multiple Dimension Members (Account and Scenario)Summary: We are attempting to use Groovy to assist with custom validation rules to run prior to save on forms in our application. However, the form in question uses the … -
Error:Error parsing formula for [FIX STATEMENT] (line 9): expected [(] found [@_AT] after function nSummary: Content (required): Hi All we are seeing this error under the PROD server. Works fine under the TEST server. ---------------------------------------------------… -
Calculation Manager differences between test and ProdContent (required): Hello, i'm trying to optimize a business rule in Calculation Manager. I noticed that there are some differences in Error & Warnings section. When I a… -
Calc Command/Function to pick strings from right of a memberSummary: We have a requirement to pick member names from a concatenated member from the last. Need command/function which can be used in calc script to achieve this. Con…
-
Essbase calc - shorter way to write a script based on Prior PeriodsSummary: Content (required): I'm working on a rule that requires the cumulation of prior month values (tax in this case) to be calculated into the current forecast month…
-
ASO Dynamic Calc Member MDX ConversionSummary: We are in the process of setting up an ASO cube. I have 1 account that doesn't seem to work. Currently in the BSO cube I have the following: if (@ismbr("Jan"));…
-
[Integrations & REST API] Struggling with updating Source Filters via REST APISummary: I am trying to create rules that utilize the REST API to override source filters when running integrations in Planning. Unfortunately, I cannot seem to get the … -
How to Groovy for copying data in PlanningSummary: Trying to create a script in Groovy to copy data from one scenario to another, so far unsuccessful Content (required): I am running Planning Cloud. For various …
-
AggregationSummary: Content (required): Hi We have a plan element called "Adjusted total" which has a formula as below. "OFS_Direct Input" + ("OFS_Direct Input" * "OFS_% Increase/(…
-
Failed IF condition is still producing a value that is used by a subsequent ELSEIF functionSummary: I am using IF/ELSEIF within a fairly tight FIX. The logic is as follows: FIX(&PeriodVar) IF(@ISMBR("Jan")) perform X calculation in Jan ELSEIF(@ISMBR("Feb")) pe…
-
Period dimension Mapping DMSummary: Content (required): Hi I want to use OEP_Yearly Plan to upload annual figures to each year. We need to use this in data management. How to do this? OEP_Yearly P…
-
Issue in Calculating Accumulated Depreciation for New AssetsSummary: Accumulated Depreciation not calculating for New Assets Content (required): Hello All, I'm trying to add a new Tangible Assets, calculate Depreciation for the A…
-
Generating a sequential, unique ID for a record/tuple?Summary: Generating a sequential, unique ID for a record/tuple? Content (required): I need to generate a sequential number for a field to have a unique ID for a record. …
-
Display Data of type text and copy using business rules (Version bottom up)Summary: Looking for some best practice using members of type text in combination with Version Bottom up Content (required): We set some accounts (dense dim) to type tex…
-
How to uncheck "Apply values to the rule" checkbox a business rule with RTPI have a business rule for which I have 2 variables as RTPs, when I validate or run I get the attached pop-up, I chose "Apply values to the rule" once and saved it, from…User_2025-03-10-22-57-31-218 51 views 5 comments 0 points Most recent by Suruchi S-Support-Oracle Planning
-
Using a Groovy template can you reduce Member DTP scope in 2nd step from Member DTP in 1st step?Summary: I have a dimension hierarchy with multiple levels. I have a Groovy template and created a Member DTP in step one, where a parent level is selected using a formu… -
Can you use a cell string value in RSIBLINGS rule calc to make it dynamic off user input?Summary: I am working on a custom cube that allows us to track type of employee additions/reductions/promotions, transfers easily for our planning cycle. I am trying to …
-
Groovy Code to Determine Valid IntersectionsSummary: We have a valid intersection to define the business unit for each department (every department belongs to only one BU). To make business rules more efficient, w… -
Triggering an event scriptSummary: Can someone share point me to how to create an event script in data management? I am looking to execute a clear prior to export data from DataManagment into Pla…
-
Adjust Merit Month in Workforce (OWP_Merit Month)Summary: Our Merit is loaded per employee in our ePBCS cube, we load OWP_Merit Month as Apr and we would like to modify it to Jul. I'd like to create a calc instead of r… -
Sandbox enabling,and Plan1 cubeSummary: Sandbox enabling,and Plan1 cube purpose. Content (required): Hi I read regarding sandboxes, and im having some issues related to it. and im strictly speaking fo…
-
How do you surface the currently running business rule's Job ID?This should be really simple but I can't seem to work it out. I initiate a business rule which uses REST API calls to kick off multiple child jobs. At the moment, these … -
How to get @PARENTVAL on Sparse Dimension working in Hybrid BSO?Summary: We need to use @PARENTVAL for our calculation, we have checked the documentation it is not supported for Hybrid BSO. Documentation also mentions that if these f…
-
Calculation Manager - Explanation for Summary in the Errors and Warnings tab neededSummary: I'm trying to find an explanation for the Summary section in the Errors and Warnings tab in Calc Mgr Content (required): I've searched all the guides and have c…
-
Weekend / Weekday Segregation in EPBCSSummary: Weekend / Weekday Segregation in EPBCS Content (required): Hi We have a requirement of weekly planning which the feature is available in EPBCS. But there is fur…
-
Script Suggestion to reduce timeSummary: Script Suggestion to reduce time Content (required): Hi Attached script is taking 15 min to run. Any suggestions that can be provided to reduce time? Applicatio…
-
Groovy - Accessing Attribute Dimension MembersHi, We were doing some testing today and were trying to use .getEvaluatedMembers to access attribute dimension members (similarly to accessing dimension members using th… -
Best practices for hotel and leisure industry.Summary: Best practices for hotel and leisure industry. Content (required): Hi We are implementing EPBCS for hotel and leisure industry. I'm looking for EPM Best practic…
-
Compare Aliasname with a Textcell for a large memberrange - [[PlanningFunctions.getIdForStringSummary: to perform a selective datatransfer (@Xref logic) from source to target cube (where the location information is in a textcell in the source cube compared to mem…
-
IDESCENDANTS in AGGSummary: Content (required): We have an aggregation as part of our calc people plan rule using just an agg function. This doesn't seem to work unless @idescendants is in…