Calc Manager
Discussion List
-
What's New in 20.08?Summary ... some exciting stuff, as usual!Content Okay, so I'm about a week late with this post this month. I hope you haven't been having withdrawals, pacing your home … -
Alternative to LOOP or any other improvementsSummary: Alternative to LOOP function is needed. Content (required): Hi Attached rule is taking 15 minutes to run. it is taking that much of a time because of the LOOP. … -
getPassword() not working what i am doing mistake here.Summary: Trying to get username and password and want use for epmautomate but getting error for getPassword() Content (please ensure you mask any confidential informatio…
-
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
maximum number out of a listSummary: Content (please ensure you mask any confidential information): Hi im trying to use @max essbase function but it is erroring out with this message. Cannot calcul…
-
Essbase Calculate Script: How to define the prompts in a specific order (Moved to Essbase Category)Can the order of the prompts in this calc script be defined in a specific order? Specifically, how to arrange the prompts so that the Source Version prompt selector is p…
-
Essbase copy version script: define the source and target parameters in a specific orderWhen creating a Calculate business rule in Essbase, is it possible to define preferred order (From as the first parameter and To as second parameter)?
-
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 12 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Can Run-Time Prompts be set to Ignore Valid Intersections?Summary: Run-time prompts are restricted by valid intersections. But we would like to disable this as needed. Content (required): We need to be able to run some rules th… -
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…
-
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…