Calc Manager
Discussion List
-
Zip file not getting uploaded - data managementSummary: Content (please ensure you mask any confidential information): Hi I uploaded two csv files each in data management and it got uploaded successfully. Then i adde…
-
DTS Y-T-D Calculation on Stat AccountSummary: Cannot retrieve correct calc on stat account using DTS Content (please ensure you mask any confidential information): Two new stat accounts were created called …
-
New Hands-on Tutorial for Planning now availableWe are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set of tasks…
-
Essbase dense members don't calculate when crossing dynamic membersSummary: Content (please ensure you mask any confidential information): Hello, I have the following script and don't know why is not calculating. ********* FIX (sparse m…
-
How to create multiple members via Groovy ?Hello All, We are trying to create 50 members via groovy : from "Projet_1" to "Projet_50". For that I'm using this script (published by Shehzad KAZMI) : Instead of creat…
-
Prompts for Rules in PlanningSummary: I created a rule named Currency Convert USD to GBP AUD in planning and when users try and run the rule for Jan:Dec they are getting this error message. But when…
-
How to get a code of member from SmartList via Groovy?Hello All, We are trying to create members via groovy, and for that we created a webform with the Business Rule Groovy attached which creates members in a dimension and …
-
Unable to identify the Delete Project Rule in calc manager but can see it from PlanningSummary: In Projects Module Form Menu Delete Project Template is associated and can see it from Planning workspace but not from Calc manager. Also, I'm having administra…
-
Groovy with hyperion planning 11.2.xHello, Is Groovy supported with hyperion planning 11.2.x ? Some references say no : https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=459791523767627&id=…
-
Push Data failed.Message Error:Unable to load the form as the number of cells exceeded the thresholdSummary: I have trouble while running Calculation into the error below . Question 1 : there are message which said "The following members are excluded from the member se…
-
rule optimisationSummary: Content (please ensure you mask any confidential information): Hi need your suggestion on below rule and how to optimize its performance. SET UPDATECALC OFF; SE…
-
Can someone give me example of creating wizard using PBCS dtpCan someone give me example of creating wizard using PBCS dtp in Calculation Manager? I'm looking for something like, based on selection of prompts in current page shoul…
-
Consolidating FIX StatementsSummary: Content (please ensure you mask any confidential information): I have an out of the box/implementation rule that has multiple FIX statements. Can I consolidate …
-
Advice on flipping sign on large historical data set?Summary: I am looking for advice on flipping the sign of a very large historical data set within our application (likely many millions of blocks). Content: We have an in…
-
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u…
-
How to clear an account before xwriteSummary: Content (please ensure you mask any confidential information): I have about 10 accounts in our planning cube that we populate from workforce using XWRITE. I wou…
-
Export Datagrid to flat file that doesn't use a comma delimiterSummary: I am trying to export data from the Capital Projects reporting cube to a text file, using a DataGrid. The groovy operation to do so is operation.exportDataToFil…
-
[ASO MDX member formula] Trying to use AVG depending on PTD/QTD/YTDSummary: Working with an ASO cube, I am trying to develop a member formula to calculate the average of another stored Account across the appropriate periods My goal is a…
-
ScenarioSummary: Content (please ensure you mask any confidential information): Hi I have an issue where i need to allow user to enter payments for a loan schedule for all perio…
-
[Business Rule] Adding IF statement to rule causing significant performance degradationSummary: I am trying to add an IF statement to handle cross-year Actual & Forecast situations. However, adding the IF statement causes the rule to increase in run time f…
-
Groovy BR REST API Send Email v2 AttachmentsSummary: Groovy business rule to send email using v2 is working except attachments. Content (required): Cannot seem to get the parameters syntax correct. Version (includ…
-
append to a csv file.There was an error rendering this rich post.
-
Groovy Rule: Submit Date TypeSummary Submitting values to an account of date type rejectedContent In a groovy rule, using a DataGridBuilder, values submitting to an account of Date Type are being re…
-
Update Valid Intersections Rules via GroovySummary I want to create valid intersections rules or conditions via groovy while creating a new memberContent Hey all, I have a situation where the client has several v…
-
Adding FIX on bottom level of large sparse dimension causes DATACOPY and CLEARDATA commands to long?Summary: I am working with a fairly large application with a sparse dimension containing over 50,000 bottom level members. I am trying to improve performance of our busi…
-
createRowData in PBCS groovy throws - An error while processing pageI am attempting to use Groovy to create a RowData object as part of an data import process. However, I am encountering an error message that states "An error occurred wh…
-
Does ISACCTYPE work for ASO?Summary: We are hoping to leverage the ISACCTYPE function as a member formula. We are looking to leverage the Acct Type to "flip" signs and/or aggregate as needed in Fre…
-
less powerful role to create rulesSummary: Content (please ensure you mask any confidential information): Hi Apart from giving service admin directly, is there any less powerful role which we can given t…Lakshani Hettiarachchi 22 views 3 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Is there a way in Groovy to getEvaluatedMembers / get ancestors with Administrator permissions?Summary: Would like to know if there is a simple way of using getEvaluatedMembers (or similar) with admin permissions, to pull back names of members in the hierarchy des…
-
copy data from many POV to one POV.Hi, I need to right a business rule function to change the 9 accounts with currencies to no Currencies, its similar to datacopy @RELATIVE("Input Currencies",0) To "No Cu…