Calc Manager
Discussion List
-
Error with Next month function in business rule by using "@MEMBER(@NEXTSIBLING([[getStartMonth({ScenSummary: Hi, I am trying to get the next month in business rule by using "@MEMBER(@NEXTSIBLING([[getStartMonth({Scenario})]]))". In the period dimension the hierarchy is… -
Planning forms, rules and runtime prompts to use members on formSummary: Content (please ensure you mask any confidential information): I have a form that has a calc script set to run on save and the "user members on form" option set…
-
Dynamic Calc Member not workingSummary: I have a dynamic calc member I created for one of the reports my client asked for. The calc member works fine when I run the report at bottom levels for this pa…
-
Allocation EquallySummary: Content (please ensure you mask any confidential information): Hi I have 10 entities, and 4 sectors. For ex Entity A Sector 1 Entity B Sector 1 Entity C Sector …Lakshani Hettiarachchi 11 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
How to check if member exists in Account dimensionHello experts, I have a requeriment to do. In my account dimension I have two hierarchies. First one has nevershare members like this: 600001 / 600002 / 600003 / 700001 … -
XREF function summarizing store membersHello experts, I'm using XREF function in calc script and I need to get information from other dimension cube that member is "Dynamic Calc". This is an example: Imagine …
-
Is the number of cubes restricted to 8 in the calculation manager system view list?Hi All, I am using a module-based Planning application, where I have 6 cubes (module based), 1 ASO cube 1 more BS0 cube - total 8 cubes. I recently added a new cube, cal…
-
Zip file not getting uploaded - data managementSummary: Content (please ensure you mask any confidential information): Hi I uploaded two csv files each in data management and it got uploaded successfully. Then i adde…
-
DTS Y-T-D Calculation on Stat AccountSummary: Cannot retrieve correct calc on stat account using DTS Content (please ensure you mask any confidential information): Two new stat accounts were created called …
-
New Hands-on Tutorial for Planning now availableWe are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set of tasks… -
Essbase dense members don't calculate when crossing dynamic membersSummary: Content (please ensure you mask any confidential information): Hello, I have the following script and don't know why is not calculating. ********* FIX (sparse m… -
How to create multiple members via Groovy ?Hello All, We are trying to create 50 members via groovy : from "Projet_1" to "Projet_50". For that I'm using this script (published by Shehzad KAZMI) : Instead of creat… -
Prompts for Rules in PlanningSummary: I created a rule named Currency Convert USD to GBP AUD in planning and when users try and run the rule for Jan:Dec they are getting this error message. But when…
-
How to get a code of member from SmartList via Groovy?Hello All, We are trying to create members via groovy, and for that we created a webform with the Business Rule Groovy attached which creates members in a dimension and …
-
Unable to identify the Delete Project Rule in calc manager but can see it from PlanningSummary: In Projects Module Form Menu Delete Project Template is associated and can see it from Planning workspace but not from Calc manager. Also, I'm having administra…
-
Groovy with hyperion planning 11.2.xHello, Is Groovy supported with hyperion planning 11.2.x ? Some references say no : https://support.oracle.com/epmos/faces/DocContentDisplay?_afrLoop=459791523767627&id=… -
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…
-
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…