Calc Manager
Discussion List
-
adhoc analysis - member selection aliasSummary: Content (please ensure you mask any confidential information): Hi i have an issue related to smart view adhoc analysis. When using an adhoc analysis and i go to… -
Alternative to LOOPSummary: Content (required): Hi There is a rule which is taking around 5 minutes to run, only because of LOOP(12) i have inserted in the script. PFA. Version (include th…
-
Store daily level data in one cube and post monthly aggregated data to anotherSummary:Looking for a solution to store daily level data into one planning cube and post monthly aggregated data to another cube Content (please ensure you mask any conf…
-
Ruleset doesn't show accurate status when rules within complete with errorSummary: We have a ruleset that runs every night. When a rule within the ruleset completes with an error the ruleset is showing a status of completed normally. This is n…
-
level 0 blocks increasedSummary: Content (please ensure you mask any confidential information): Hi For a specific rule we created block size was increased from around 320,000 to 2100,000. and b…
-
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 …Lakshani Hettiarachchi 11 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…