Calc Manager
Discussion List
-
Essbase variables are slower than direct referenceHi All, Can some one examine my two scripts carefully and help me understand why using Essbase variable is slower than direct reference of the cross dimension. Please no…
-
Delete data except shared memberHello experts, I have an account dimension (dense dimension) that I have a hierarchy with 1000 members, this hierarchy has shared members and store members. I would like…
-
Calculation manager access defined at cube levelSummary: Is it possible to define security by cube in calculation manager? My user who was previously working on Essbase on cloud wants access to business rules to view …
-
Is there functionality in EPM to create a relative timespan?Summary: Looking for a way to have reports, automations and various other processes run based on a relative timespan. The goal of this would be to not require updating s…
-
Drill-through set up to other cubes and/or applications?Summary: Is it possible to set up drill-through definitions to drill-through to other cubes and/or applications? Content (please ensure you mask any confidential informa…
-
PBCS DATACOPY expected behavior.Hi Guis, Can someone please confirm below cases are as expected with DATACOPY command. case #1: SET COPYMISSINGBLOCK OFF; Source has block but copy intersection has #Mis…
-
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 12 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…