Calc Manager
Discussion List
-
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…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
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…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
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, …
-
Dynamic calc members crossing dim with smart list member does not calculateSummary: Content (please ensure you mask any confidential information): Hello, I have the following calculation Sparse_DimA = @MEMBER(@CONCATENATE("HSP_ID_",@HSPNUMTOSTR… -
Functions Not Supported for Hybrid AggregationHello! I've been reading the below document and it confuses me Does it means that any of this functions are not allowed if Hybrid is enabled? I've performed some test wi… -
Currency conversion rule not working for certain currenciesSummary: Multi Currency Planning application has been set up and up until now, the currency conversions have been working fine for all scenarios. Now there is a new scen…
-
I am trying to use Groovy scripting to return the current user name for an account within Planning.Summary: In Planning, I am trying to return the logged user name (full name if possible) for an account which shows the initiator of the process. For example, if I log i… -
Business rule is not executing for selected members and not working when the calc block has logicSummary: We have encountered an issue with a newly created business rule where the if condition and fix statements do not execute as expected. The problem manifests as f…