Calc Manager
Discussion List
-
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…
-
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr…
-
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…
-
Business rule resulting in network error and crashing entire applicationSummary: I am working on an ad hoc data copy rule to make it easier for administrators to copy data (I know that there is Copy Data functionality, but the rule will make…
-
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 21 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…
-
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 …Lakshani Hettiarachchi 31 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
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…Patrick Northcraft - Dropbox 517 views 3 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning