Calc Manager
Discussion List
-
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… -
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…
-
Sharing Info: String Compare in Planning - @CalcMgrCompare functionSummary Execute a set of statements based on the Variable/Prompt Value (String Compare)Content Hi All I found something interesting and want to share with all of you. We… -
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 …
-
@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…
-
Unable to access groovy script type in Calc ManagerContent I'm unclear on availability of Groovy scripting. I don't have the ability to edit/create groovy scripts. I opened a ticket with oracle and they said Groovy only …
-
Updating Substitution Variables using a Business RuleSummary Trying to update the substitution variables using groovy ruleContent Hi, I'm developing a pbcs application that has a great amout of substitution variables. I wa…
-
What's New in 20.01?Content Welcome to 2020! Do I even have to explain this isn't the start of the new decade but the last year of the decade? Once again, I'm sure you've already read and m…
-
Block Creation AdviceSummary Tested a number of different ways to create blocks and the least desirable - SET CREATENONMISSINGBLK - seems to be the only option.Content Hi, apologies if this …
-
Calc Mgr ADF Issue in Chrome post 19.12 PatchSummary Encountering a fatal ADF error in Calc manager in ChromeContent G'day guys, just want to confirm if anyone else is seeing it before I raise an SR Post the Test P…
-
Smartpush Database SuppressionSummary Sparse Dynamic calcs still getting pushed in Smartpush with database suppression onContent G'day Guys, just seeing some interesting behaviour with a smartpush. W…
-
Error when try to select Designer Mode in Calc MgrSummary When I open rule in Calc Manager, if it is in "Edit Mode' and I try to change it to "Designer Mode" I get an error message: An error occurred during conversion.{…
-
Replace data with #missing in ASOContent Hi Gurus, I am aware after going through the posts that, in ASO we cant replace data with #missing. For example I am calculating units as below: units = product …
-
Custom Business Rules in EPM Standard Planning ApplicationSummary Features of EPM Standard Planning ApplicationContent Hi All, Can we create custom business rules in a EPM Standard Planning Application. If yes, will it impact o…
-
Using Groovy to integrate data between differrent PBCS applicationsSummary Is it possible to use groovy to integrate data between PBCS applications?Content We are planning to migrate several Planning applications from on-premise to the …
-
Planning in EPM Cloud: Free hands-on Groovy training in San Francisco BaySummary Planning in EPM Cloud: Free hands-on Groovy training in San Francisco BayContent The San Francisco ODTUG / Oracle EPM Meet-up group is sponsoring a free hands-on…