Calc Manager
Discussion List
-
Prompt to display user name after a rule is ranHi There, I am trying to create a rule which will display the scenario, version, date and user name which the rule is ran for. The section of the rule that does this: FI… -
Need to remove a value from RTPSummary: Need to remove a value from RTP Content (please ensure you mask any confidential information): Hi We need to remove a value from RTP, pls help. Ex: There is a v…
-
Groovy DataExporter DataImporter issueSummary: What's wrong with the below code for DataExport and Import using Groovy Content (please ensure you mask any confidential information): I am unable to get the be…
-
Clearing of partial data failed ASO cube with groovySummary: Clearing of partial data failed: Syntax error in input MDX query Content (please ensure you mask any confidential information): hi all, trying to clear partial …
-
How to reference an Attribute dimension member in a Member Formula in ASOSummary: Trying to reference an attribute member in a member formula in an ASO cube but database refresh is failing. Content (required): I have an attribute dimension 'C…
-
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 …
-
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…