Calc Manager
Discussion List
-
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…
-
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 …
-
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…
-
Drill through regions stop workingSummary: Drill Through Definitions stop working randomly and need to be "refreshed" and I can't figure out why or how to fix this. Content (required):We have defined Dri…
-
amortisation schedule scriptSummary: Content (required): Hi I'm trying to build a loan amortization schedule in OEP_FS, with opening balance, repayments, interest and closing balance. Does anyone h…
-
Can you copy supporting detail and comments using calc manager or groovySummary: Can you copy supporting detail and comments using calc manager or groovy Content (required): Hi Everyone, is there a way to use calc manager or groovy to copy s…
-
Why is the Log Messages tab in Calculation Manager not visible to me?Summary: When I launch a business rule in Calc Manager, I receive the confirmation message indicating that the rule ran successfully. However, I'm not seeing a Log Messa…