Calc Manager
Discussion List
-
Unable to copy data from set of combination to another set of combinationContent FIX( "Annual Salary", "Entity_01", {Org_Name}, @LEVMBRS("Entity",0), @CHILDREN("Total_Job"), @CHILDREN("Total_Employees"), @UDA(C3,"Newhires_Staff") ) DATACOPY "… -
Need Help! Building a Dynamic Calc Currency Translation in PBCS BSOSummary I'm trying to build a dynamic calc currency translation member that works on parent membersContent I'm trying to build a dynamic calc Scenario member to do curre… -
Synchronize Default rule running long in Workforce Module of EPBCSSummary Synchronize Defaults run for 2.5 to 3 hours in WorkforceContent Hello Experts, We have configured Benefits/Earnings/Taxes using the Out of the Box framework avai…
-
rule performanceSummary Rule terminates without executingContent I have 3 dimensions built as a flat hierarchy, When I run a rule for forecast which includes all the dimension it isnt e…User_2025-02-04-12-31-54-073 38 views 15 comments 1 point Most recent by User_2025-02-04-12-31-54-073 Planning
-
Can we use substitution variable for ASO cube Business Rules in a Formula component?Content I tried using sub var in formula component in Rules iin planning application for ASO cube but it's not working.Any response will be much appreciated.Regards,Nrup… -
Strategic Modeling Live: Defined. Discussed. Demonstrated.Summary We are hosting a Live Workshop on Strategic Modelling where we are showing how you can take a current forecast, use it as a base scenario in Strategic Modelling … -
Code snippetSummary Essbase script for turning #MISSING driver values into 1Content Hello everybody, Would someone please be so kind to provide me a Essbase code to change #MISSING …
-
SV: The Launch tab remains open after calculation completesContent Hi all Is there a way to automatically close the calculation window in Smartview when a calculation manager script with runtime prompt variable completes? We see… -
What's New in 20.05?Summary ... a really good feature, IMO!Content Here we are again.... given the current, worldwide situation we all find ourselves, I'll share a quick update that someone…Mark Rinaldi-Oracle 171 views 6 comments 16 points Most recent by User_2025-02-06-11-55-10-982 Planning -
Question for Adobe Flash de-support in Calc MgrContent Hi, I have a question for de-support of Adobe Flash in Calc Mgr. We have many custom rules built with Graphic that currently can only be open with Flash. With th…
-
Fix on DenseSummary Fix on DenseContent Hi All, I got a lot of mixed response on Fixing on Dense. If you Fix on all Sparse, and if you Fix on a Dense Member, does it reduce the numb…
-
Experiences with Hybrid Cubes in Planning in 11.1.2.4Summary What issues are encountered when enabling Hybrid for Planning 11.1.2.4Content Hello Everyone, I understand that this forum is dedicated to Planning Cloud; howeve…
-
EPBCS - ASO GUI Rule is running for a long timeContent Hi, We have created a Clear Rule in ASO Reporting Cube using GUI. It's taking 44 mins to clear targeted data for 1 Year but takes the same amount of time even wh… -
Can a FIX statement pull in Metadata from a Member Name?Summary Metadata in a FIX statement?Content Hi, I have a parent in my Account Dim named: POVLoadMo It has one child named: POVApr I'm trying to Fix on the 'Apr' part of …
-
PBCS - Possible to Aggregate Single Period and Year based off SmartList?Summary Trying to dynamically bypass SubVars in Aggregation script - PBCSContent Hi Experts, So a co-worker of mine needed to clear data in a current period and year via…
-
What's New in 20.04?Summary ... at least a few topics many of you have been asking for are here!Content Well, it's that time again and I hope this post finds you safe and healthy. I'm sure …
-
Currency Conversion- Business Rule CreationSummary In the past when using the Currency Conversion wizard, a rule would be created that could be viewed in calc manager, now when new currency conversion rules are c…
-
Load Account Source Value to 2 different Target Accounts with “Data Load mapping”?Content We are currently loading data with “Data Load Mapping” to a Custom Cube. Based on Account/CostCenter combination data is loaded to certain accounts. Is it possib…User_2025-01-28-23-21-57-917 40 views 4 comments 0 points Most recent by User_2025-01-28-23-21-57-917 Planning
-
Create a Attribute member via groovy or REST APISummary Trying to use a groovy rule to update the attribute dimensionContent Hey, I want to update my attribute dimension in order to add more members. Can i do it via g…
-
Forcing Dataform Refresh via Groovy ruleSummary Forcing Dataform Refresh via Groovy ruleContent Hi all, I know this topic sounds stupid, but i have an issue where i have updated a userVariable via groovy rule …
-
Updating User Variables Via Groovy ruleSummary Updating User Variables Via Groovy ruleContent Hey all, Can i update a user variable via groovy rule? Any help will be appreciated, Version 20.01.33
-
Projects - Add and Delete Project RulesSummary Groovy templates - set up as rules attached to Action Menu - Not appearing for usersContent OPF_Add Project is a groovy template but is attached to the Project A…
-
What's New in 20.03?Summary ... a lot of things that make your life and my life easier!Content Oh my, it's time for another installment of the What's New post. As always, I plagiarize the o…
-
Unable to aggregate actual dataSummary Unable to aggregate actual dataContent Hi I have enabled finance module in planning(EPBCS) and loaded metadata and data. I am able to see the data at children le…
-
How to delete OOTB Rule/ Template that got migrated from Test to Prod before being formally releasedSummary An OOTB rule deployed in Test got migrated to Prod before it got release to Prod. Now I can't delete it manually.Content Hi All, Wanted to know if there is quick…
-
LOOP and QUIT optionSummary Loop command and trouble to quit itContent Hi I'm trying to compute some DIO account. I'm using a LOOP ENDLOOP command in a calc manager rule. A summary of the c… -
Why Period dimension with Dynamic Calc storage property has edit mode in the form ?Content Hello All, I am new to EPBCS and wanted to understand the concepts from scratch. I have seen in my form ( Grid ), my 'Period' dimension has been set as 'Dynamic …User_2025-02-05-07-43-41-391 45 views 4 comments 2 points Most recent by Mark Rinaldi-Oracle Planning
-
@RELXRANGE not working when argument is @XRANGE with cross-dim membersSummary @RELXRANGE not working when argument is @XRANGE with cross-dim membersContent Hi all, frustrated because @RELXRANGE not working as documented. From @RELXRANGE do… -
Groovy: Get the memberName of a SmartlistSummary Trying to use a groovy rule to get the memberName of a Smartlist entryContent Hey all, I am trying to create a member on the outline via BR using groovy calculat…
-
Running a rest api on business rule returning errorSummary I am trying tu invoke a API from a Business rule and it is returning a errorContent I am trying to run a business rule calling a api, I have created an named con…