Calc Manager
Discussion List
-
General aggregation questionI was curious as to what might be causing an aggregation to take significantly longer when run for a different fiscal year, all other things being equal. Each fiscal yea… -
@count usage in a divisionSummary: Greetings, I'm using @count in a rule file in Planning to get the number of records for a particular intersection. Works well, the result comes back correctly. …
-
Error in groovy, The following Date is Invalid: .Hi all, we are trying to retrieve data from multiple projects in EPBCS in ASO cube we are using datagriddefinitionbuilder to read the data from the above accounts as bel…
-
Essbase cache data is fullHello experts, I have a problem with essbase cache. In production environment it works fine, but when I copy the snapshot to test and execute rule I have this problem: H… -
Possible to derive the start month of prior sibling of selected Scenario in RTP?Summary: Hi there, We have our regular scenarios and we have created Staged Scenarios for each of them. These Staged scenarios deal with the periods prior to the open pe…
-
How do I use @ATTRIBUTE in business ruleSummary: Need a business rule using attributes to breakout costs into another entity/account Content (please ensure you mask any confidential information): I've used @AT… -
Securely storing a client secret for REST API OAuth2 Authentication in Groovy ruleSummary: Where can I securely store a client secret token for use in a REST API call in Groovy. Content (please ensure you mask any confidential information): I need to …
-
groovy assign variable value to rtpSummary: Assign variable value to rtp for essbase calculation part Content (please ensure you mask any confidential information): Hi All, I have retrieved the prevData v… -
Passing all Dimension value to a single intersectionHi, We need to pass all values in a particular dimension(Functional Area) to a dummy account Eg Dummy accounts created. Amortisation of Intangible assets_Dummy Lease Dep…
-
Groovy - The form GroovyDataGrid is Invalid when DataGridDefinitionBuilder is usedHi all, In an ASO cube, we are using CsvWriter and DataGridDefinitionBuilder to iterate through each account to generate a CSV file in Inbox/Outbox Explorer. while using…
-
What is the Maximum Calcparallel Setting Recommended (limit)Summary: I'm trying to find out what would be the maximum recommended setting that calcparallel could be set at in EPBCS. Is there any documentation about the limit of t…
-
Script DesignHi, We have a requirement when a smartlist value is selected for a particular intersection, we need to identify all other intersections that use the same smartlist value…
-
Create or Update All Substitution Variables Defined for the ApplicationHello, I am trying to leverage "Update Substitution Variables " REST API and below is the code: Through Postman it is working fine. I am trying to execute it as I did fo…
-
Is it possible to have a specific message show when throwing veto exception on a form rule?Summary: If a rule has a veto exception triggered when launched on save of a form it doesn't show the message on the pop up on the form, just that the rule failed. Conte…
-
Download CSV file from EPBCS inbox using GroovySummary: We are looking for a groovy code to download a file from epbcs inbox/outbox explorer to local machine. Unfortunately, we can't use epmautomate. Content (please …
-
How do I fetch salary rates by Pay Type on new requisitions in Oracle Planning (EPBCS)?Summary: We added Pay Type (Exempt/NonExempt) to our Salary Grades table in Workforce Planning; We're no longer able to pull the new rates when using the Salary Grade op…
-
Is it possible to force a line on a form to read only by row/column vs by cell using Groovy?Summary: I would like to have a groovy business rule set security on an entire column or row to read only vs having to do it by cell. Content (please ensure you mask any…
-
Can we display member alias instead of member name after selecting the members in Business Rules RTPSummary: Can we display member alias instead of member name after selecting the members in Business Rules RTP's in Forms. Currently system is displaying only member name…
-
@remove not workingSummary: Content (please ensure you mask any confidential information): Hi We need to clear all accounts value, except a few. But when launched it is deleting all data. …
-
Business rule execution timed out. Please increase the Batch Timeout and execute the process.Summary: I am running an integration to load TB data and I have added a post-load rule business rule which is doing aggregation at the total level. The rule is failing w… -
Groovy Rule using Substitution variable for colouring forecast monthsHi, Can we color forecast months using substitution variables (Jul to Dec)? Let's suppose I have Substitutions variable FCSTMonths (Jul to Dec). Is there any way to colo…
-
ASO Copy data from one member to anotherSummary: How to copy data from one member to another Content (please ensure you mask any confidential information): Hi All, I am trying to copy data from one member to a…
-
ASO Calculation Script Very Slow!Hi, We have an ASO Freeform application and I am trying to calculate prior year retained earnings using the formula template using the following script, but it is taking… -
EPBCS Datamanagement groovy rule - with Json loopSummary: Hi Expert, I'm trying to call a groovy rule which will execute Data integration , changes source filter based on subvar for ent1 and ent2, First ent1 filter sho…
-
run scripts parallelySummary: Content (please ensure you mask any confidential information): Hi is there a way i can tell the system to run the highlighted in yellow color scripts - to run p…
-
Populate a Smart List with a Parent of a value from another Smart ListSummary: I have two Accounts, ProjectChild & ProjectParent. Both have Data Types of Smart List and both Smart Lists are referring to Dim members in the Entity Dimension.…
-
Security for Funds Reserve menu item?I am wondering how we can view and modify security on the Funds Reserve menu item in the Revision Management action menu. I've tried a few different things, but nothing …
-
How can move Artifact Snapshot from instance to other instance by scheduleHello everyone, I have one question. I need to move the artifact snapshot from the Production instance to the Test instance automatically. How can I do it without using … -
Is there a way that Supplemental calculation can pick up the shortness from the Regular calculation.Summary: Hi All, The payroll calculation set up for Regular paycheck and Supplemental paycheck are default to calculate separately. In the case of low regular earning, s…Eswar Kishore 11 views 0 comments 0 points Started by Eswar Kishore Payroll and Global Payroll Interface (GPI)
-
How do i create a member formula to pull for children as wellI would like to create a scenario member with a member formula that will calculate the variance between two columns in my management report. Then when I drill into the, …