To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Planning
Discussion List
-
Maximum number of dimensions in EPBCS OOB Reporting (ASO) cubeSummary: Hi There, @Stu G-Oracle @Venu-Oracle Based on OOB EPBCS for financial we are using 12 dimension, however for OOB Reporting cube we wanted to have 17 dimensions … -
Data Load Rule Not Picking Up Global Period Mapping Or Explicit MappingSummary: I have a data load rule that is Delimited - Numeric Data that is missing the period and year from the file and causing the below error. It doesn't make sense th…
-
Upgrading Essbase from 11.1.2.xx to 21.7.xxSummary: Hello, I am wondering what functionality changes I need to be aware of as our Essbase software updates this month, as well as how to check if anything will go w…
-
Smartview cell Blank in Ad hocSummary: Content (please ensure you mask any confidential information): Hi all We have an installation of SV 24.100 with Office 2019 on Windows 11 where the cells are bl… -
Ability to set access rights to alias tablesIs it possible to set access rights to the alias table? For example, the "default" alias table can be selected by all users, but the "Name1" alias table can only be sele…
-
Maximum Number of custom dimensions in EPBCS Hypbrid application.Hi Experts, We have created a EPBCS Hybrid application. The requirement is to have 9 custom dimensions in the application. What is the maximum number of custom dimension…
-
Issue with loading entity currency data to multiple currency for FCC to Planning integrationWhile loading data from FCC to Planning, we are receiving data from FCC for Entity Currency, but we want to load data into Planning by currency. We have a potential solu…
-
Set CAP on Tax Calculations in Business RulesSummary: Content (please ensure you mask any confidential information): I'm looking for an example of a calculation of taxes that has a yearly CAP amount. I need to set … -
How to run a rule after a smart push in a form?Summary: Hi All, What I try to achieve is the following: I have an input form for entering data in a certain cube, which triggers a few business rules upon save to have …
-
Business Rule: Error:Network error []: Connection has been closedSummary: Business Rule Runs into an Error "Error:Network error []: Connection has been closed" and I couldn't find where it goes wrong in the code. Content (please ensur…
-
Push Data Failed: Error - The member does not exist for the specified cube or you do not have accessDescription: Hello, I am encountering the following error when trying to push data from an ASO cube (source) to a BSO cube (target) in Oracle PBCS: Error: "Push Data fai…
-
FDMEE Query Result Limit OFC to PlanningSummary: Hello, I currently have a Data Integration between our OFC and Planning applications. This is something we've had setup for a long time and has worked without i…
-
Maximum number of Oracle Epm groups in EPBCSHello, In our EPBCS application, cost center hierarchy is very big. Client is saying as per their existing Planning budgeting system, they might need user security to be…
-
Data Exchange - 2 members accounts with smartlistGood morning everyone, I have a CSV file containing two member accounts with smartlists (Position and Scale). In my Import Format, I have the File Type set to "Multi Col… -
@RELXRANGE not working when argument is @XRANGE with cross-dim membersSummary @RELXRANGE not working when argument is @XRANGE with cross-dim membersContent Hi all, frustrated because @RELXRANGE not working as documented. From @RELXRANGE do… -
Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using GroovySummary: Copying a CSV file from Inbox/Outbox Explorer to Data Management Inbox using Groovy Content (please ensure you mask any confidential information): I want to Cop…
-
How to return text values from a Business Rule (without using Smart Lists)?Hi everyone, I’m trying to write a Groovy Business Rule in Planning (EPBCS) that returns or assigns a text value to a member. The requirement is to store a text string (… -
Moved: How to create custom Key performance index related to Project Schedule dates, Budgets and Ri…This discussion has been moved. -
Can an EPBCS application exist without service administrator at any point in time?Summary: Is it possible to have an EPBCS application without any service administrator but all power users at any point in time during the use of the application? Conten…
-
How will changes to the QUERYRESULTLIMIT and QRYGOVEXECTIME affect the system's performance?In our Essbase Cloud-based system, these parameters are currently set to 1 million cells and 30 seconds, respectively. When these limits are insufficient, which happens …
-
Custom Report for DM Tables in EPBCSSummary: Hello, I want to know if i can generate a report using custom query with a join between Datamanagement tables say AIF_BAL_RULE_PARAMS or AIF_BALANCE_RULES in EP…
-
Auto Predict Explain Predictions Not AvailableSummary: Auto Predict Explain Predictions Not Available Content (please ensure you mask any confidential information): Auto Predict Explain Predictions Not Available. Th… -
Still we cannot use Parent Members from ASO as source in Advanced Prediction?Summary: Has anyone been successful using Parent Members from ASO as source in Advance Prediction? Content (please ensure you mask any confidential information): When us…
-
Data load between EPM PBCS and FAWHi Team, need suggestions in data load from FAW into Oracle EPM PBCS - any reference of connections / blogs etc? Inbound integration into Oracle EPM (PBCS - Planning Bud…
-
Calculation Manager Errors and Considerations EnforcementSummary: In the August 2025 Monthly Update e-mail I saw this in Important Actions and Considerations: Calculation Manager Errors and Considerations Enforcement In a futu…
-
"Suppress Missing Blocks" occasionally becomes unchecked after the monthly patchSummary: We're receiving reports that "Suppress Missing Blocks" occasionally becomes unchecked after the monthly patch. I haven't been able to find any common details th…
-
Using Substitution Variables in CalcManagerCan I use substitution variables for variables that can be specified in CalcManager? Can I only use variables created in CalcManager? Can substitute variables be used in…
-
Dimension Hierarchy for Descendants in POVSummary: My question using the example below of Descendants of AllSegments: If we were to not use the Prompt function and instead select Descendants of AllSegements in t…
-
Report grid exportSummary: Need the option to export the Grid from Reports. we have recently migrated our reports from Financial Reporting Studio to PBCS Reports. Since then we are unable… -
Data retrieval time in SmartView for Level 0 member is worse than for its ancestorSummary: Say I have a retail operations database with an Employee Type dimension that has three children: Employee Type Customer-facing employees (CFEs) Back office empl…