Calc Manager
Discussion List
-
hide rows in a pbcs formHello Experts! I have a form that I would like to supress rows that contains "almost" zero. I click on option supress missing / zero rows but in my example doesn't work … -
How to run the calculation in detailed logging mode?Summary: We are running into errors like "Error executing formula for [StaffEntry] (line 764): attempt to cross a null member in function [@X]" Found Doc ID 2191610.1. I… -
Hybrid cube business rule optimizationIs there any documentation on business rule optimization for a BSO hybrid cube. We converted our BSO cube to hybrid and started noticing efficiency issues with some busi…
-
EPM Automate login using Connections in Groovy instead of using epw password fileSummary: Is it possible to use EPM Automate in Groovy BR for login? Am trying using getUserName(), getPassword() instead of using epw password file. Defined the connecti…NarayananS 132 views 7 comments 1 point Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
Convert to MDXHi, I have tried all kinds of iterations to convert this BSO calc to MDX. Any ideas/help? The Subvar &Prior_Year_1 is set to 'FY23'. I need it to return numeric value of…Hyperion_Junkie 31 views 2 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
Not able to read data using Groovy Data Grid Definition BuildersSummary: Hello Experts, our requirement is to read the smart list data from the grid and for that we have created grid using the "Grid Definition Builders". below is the…
-
How to troubleshoot Crossjoin in Groovy (ASO) - and if NonEmptyTuple is possible to useSummary: Struggling to find what could be missing/wrong in a Groovy ASO Script leveraging Crossjoin Also wondering if NonEmptyTuple can be leveraged Content (required): … -
-
How does Populate Header Descriptive Details work?I'm having some issues with budget revisions, and it seems to go back a rule that is attached to a form that runs on a save. However, this rule ( OEP_FS - Rule - Populat…
-
Member names only showing in rtp dialoguesSummary Only member name being shown when member selected (would like to see the alias)Content Hi, has anyone been able to surface an alias in an rtp when running a rule… -
Error in Groovy Script while calling Change Status for ApprovalSummary: Hello Experts, I am trying to call change status via groovy script by building the connection through other web services functionality in PBCS. Below is the err…
-
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…