Calc Manager
Discussion List
-
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… -
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 …