Calc Manager
Discussion List
-
Is there a way to get the Process ID of data management job and pass it in the business rules?Summary: Is there a way to get the Process ID of data management job and pass it in the business rules in data integration ? we are not looking for rest api option. Cont… -
Groovy doesnt recognise StringasNumber RTPSummary: Hi There, I am trying to convert a script into Groovy, which returns an audit stamp for the time, date and the user when the rule was ran. While everything is w…
-
General Tips for Improving Retrieval Performance for BSO cube?Summary: Need to restructure dimensions for optimal retrieval performance in reports, smartview, etc. Content (required): Need to restructure dimensions for optimal retr…
-
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… -
A validation error was received from the Planning server.Hi, I receive the bellow error when validating my script. DATACOPY &OEP_CurMnth->&OEP_CurYr->"OEP_Actual" TO "OEP_Yearly Plan"->(@ismbr(@MEMBER(@shiftsibling(&OEP_NextYe…
-
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… -
Calc Manager "Errors and Warnings" tab not displaying the actual blocksSummary: When executing the "Warnings and Errors" check against any rule it reports 0 Actual blocks. This used not to be the case, the report would identify the potentia…Luis Autrique 11 views 1 comment 1 point Most recent by Stephanie Gianetti-Oracle EPM Platform and Freeform -
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. …
-
Effect of removing a Service Administrator from EPM Planning Cloud who currently owns artefacts.We want to remove a former EPBCS/Planning service administrator from our Identity Domain, and consequently Planning. The individual is currently the owner of a number of…Alan Turnbull 31 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
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…