Calc Manager
Discussion List
-
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 …Lakshani Hettiarachchi 12 views 1 comment 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Groovy Scripting in EPBCS ASO CubeSummary: Hi Guys, Have a requirement to do Currency Conversion(USD to CAD) within the reporting cube(ASO) of EPBCS. Currency Conversion should happen once the Data get l…
-
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…