Calc Manager
Discussion List
-
Can not use rankOrderType within @RANK on PBCSSummary: Can not use rankOrderType within @RANK on PBCS Content (please ensure you mask any confidential information): This is Syntax of @RANK (rankOrderType, SKIPNONE |… -
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…
-
DATAEXPORT is missing implied sharesSummary: We are using DATAEXPORT in an EPM Cloud Planning application for bulk data exports. When Accounts dimension is not specified in the containing FIX, implied shar…
-
Rename Snapshot - GroovySummary: Trying to Rename Snapshot using a Groovy BR , The URL for EPM as a connection for mandates '/HyperionPlanning' and Other web service provider does not mandate t…NarayananS 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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… -
Simple logical calculation of budget transferThe below code is supposed to run in a second or two but it's running for 20-30mins and giving wrong results. It's filling all the cells. I checked and we have 10 dimens…
-
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…
-
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…
-
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…
-
Issue with dynamic calc parentHello experts, I have issue doing a dynamic calc in PBCS: The calc is very easy: "Final Balance Typ2" / "Final Balance Typ1"; At level 0 from Entity I can see correct da… -
DTP Prompts are not coming up when saving a formHi guys, I am very new to DTPs and trying to study its behavior trying different scenarios. One of the scenario that I am testing is that "User will select company from …
-
Prior balance (Spanning in years and months)Summary: Content (required): Hi I need to do the following scenario, where i need to get the prior month balance + current month balance. but when it spans over the next…
-
If condition for variables.Summary: Content (required): Hi i have an account with date format where we enter the loan start date. for ex : 1st may 2020. Then i pass the loan fixed rate which user …
-
Any reason why the BR/template disappear from the action menu in EPBCSSummary: BR/Template disappear from the action menu Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Copying data for period rangeSummary: Content (required): Hi I need to copy data for a period range as below. Ex: i have a loan start date : 01-may-2020. and loan end date as 31-apr-2026 (72 no of p…
-
date in calc managerSummary: Content (required): Hi I want to copy a certain to a specific month and year, based on the date entered by user in "loan start date" (MM/DD/YYYY Format) For ex:…
-
Groovy - Using getEvaluatedMembers with Shared MembersSummary: I am attempting to generate a custom metadata export file using Groovy to feed into some reporting solutions. We want to be able to generate a clean csv that ha… -
Is it possible to invoke rest from a groovy template?Summary: I have done an api call from a groovy business rule and it works fine. If I use the same code within a template, it gives me 403 forbidden error. Is there a lim…