Category 101
Discussion List
-
PBCS Hyperion scripting update for the business ruleHello, From the functional side, when an end users is entering an additional resource request in PBCS, and they attach a document - the document does not 'follow' the re… -
Cannot calculate. Essbase Error(0): Data cache is full.Dear everyone, I am using @ALLOCATE function to allocate data. However, the calculation failed, and it showed "Cannot calculate. Essbase Error(0): Data cache is full. Pl… -
Business rule resulting in network error and crashing entire applicationSummary: I am working on an ad hoc data copy rule to make it easier for administrators to copy data (I know that there is Copy Data functionality, but the rule will make… -
Can anyone explain why the 'Saving Intergration' always hangs in Data Exchange?Hi, It's so frustrating and cannot figure out why at certain points(seems random) that Data Exchange will not save the integration. It just hangs on this screen. Anyone …
-
Is it possible to use a planning function as the argument for a DTP?Summary: Can the output of a planning function be used in a design time prompt? Content (please ensure you mask any confidential information): I think the answer is no, … -
exclusion not working alternate hierarchyI am trying to exclude certain accounts but the exclusions are not working. Total - Income and Total - Expense are alternate hierarchies in my account dimension. I can o… -
EPM ReportI created a report where I put in a formula in the cells to pull data from Grid 2. Example: "Grid 2".[A,1]+"Grid 2".[B,1]. I want to make the report dynamic to where whe…
-
Skip first row Data ExchangeHi, I have skipped my first row with a mapping. But I want to know how in Data Exchange you can accomplish this without a mapping? I vaguely remember in old FDMME this w…
-
Possibility to have a Read Only Administrator in Data Exchange Integration setupSummary: When registering an EPM Cloud application in Data Exchange, is it possible to have an account that only has read access to the application. We want to avoid usi…
-
EPM Cloud Environment has Huge Essbase Data SizeSummary: EPM Cloud Environment has Huge Essbase Data Size over 3TB(backup database included). Does this have any problems for my system? What is the best solutions for i…
-
Predictive planning calculation principles (accuracy, risk, growth rate)Summary: Dear all, we want to use Predictive Planning and properly explain the given information to our users. Specifically, we want to explain (either calculate for ill…
-
Filter User Var Options Based on Selection of Other User Var (Valid Intersections)Summary: When selecting members from user variable drop downs, valid intersections does not seem to apply Content (please ensure you mask any confidential information): …
-
Adding member dynamically under a parent in specific order using groovyHi Folks, Using groovy, I'm able to create new child member under a specific parent but I want to create these children in a sorted order. Let's say I have following pro…
-
Oracle cloud applications readiness custom reports Excel file corrupt for 25.04 downloadSummary: We are unable to open the downloaded file for the 25.04 update details from the Oracle Cloud Applications Readiness Custom Reports. Oracle Cloud Applications Re…
-
Manage / Automate Valid Intersections with Groovy (Solution)Hi - The below post from @JeremieR-Oracle gave the inspiration to get over the hump on how to update Valid Intersections completely in the cloud inside of EPM. Hopefully…
-
ASO calculations do not work when converted from Designer to Script mode in GroovyService:Enterprise Performance Management Enterprise Cloud Business Process:Planning Version:25.03.60 ISSUE: Trying to convert an existing Designer template for a MDX co…
-
Creating Instances After March 31, 2025 Without MyServicesSummary: I recently logged into MyService and saw that there was an announcement that after March 31, 2025 MyService will no longer be available and that we need to sign…
-
Issue with Forecast Data Integration Between EPM Planning Project and Project Portfolio ManagementSummary: We are implementing an out-of-the-box (OOTB) EPM Planning solution using the EPM Planning Project module, while our client also utilizes the Oracle Project Port…
-
"Essbase could not get a lock in the specified time." errorDear everyone, When we executed the ruleset in PBCS, sometimes we encountered the error "Essbase could not get a lock at the specified time," but most of the time, we di…
-
How to upload files on Planning and deploy them to end usersQ: We currently envision the following operation for customers implementing Planning, in which end users are asked to download files. We would like to know about alterna…
-
If MFA enabled - will REST API and EPM Automate work in same manner?Summary: We are using non SSO accounts obviously for REST, if we enable MFA will this continue to work in same manner OR what else should we consider before enabling thi…
-
@ATTRIBUTE and @WITHATTR in @SUMRANGE FunctionCame across something interesting and wondered if anyone else has experienced this. I'm working on an allocation model based on headcount and leveraging attributes to ta… -
Trying to list Base members using WITHATTR functionSummary: I am trying to allocate the expense for 2 different projects based on a input project entered by user. Here is my logic. Logic validates fine and it runs withou…
-
Google Sheet Smart View Feedback and QuestionsWe recently introduced G-Sheet Smart View to our FP&A users, and based on their feedback, we’d like to confirm whether the following are system limitations or if these c… -
Currency Conversion Not Working on New CurrencySummary: Content (please ensure you mask any confidential information): I have recently added EUR to our currencies. It is set up like USD as a reporting currency. I tri… -
FCCS Groovy: How to properly write CSV files to outbox?Summary:I'm trying to write a Groovy script for FCCS that retrieves data from an external API and writes it to CSV files in the outbox, then triggers a data load rule. I…
-
Deploying business rule using REST APIHi all, Just wanted to know if there is any REST API to deploy a business rule in Essbase Script for EPBCS so that we can automate the rules deploy for a specific plan t…
-
Epmautomate unable to reset passwordSummary: Hello, We have EPMAutomate jobs that are failing because of an expired EPMAutomate PW. When we try to reset the PW, this message appears How can we release the … -
Did Feb-25 Update Break Datamaps in Pipelines?Hi All, All jobs in Prod post Feb-25 update on Friday 3/21 now fail once it hits the DATAMAP jobs. I tried re-creating a new DATAMAP and continues to fail. Anyone else s…
-
@REMOVE(@SHARE did not workHello everyone, My hierarchy has 1 GL_accounts hierarchy as the root hierarchy and 1 GL_accounts_Share as the alternate hierarchy for business grouping purposes. However…