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
-
Drill Through Source Data That Is Displayed Does Not Equal To The Amount Displayed on Data FormSummary: Content (please ensure you mask any confidential information): Hi, We have Drilled through on an amount on a data form. When the Source Data came up, the total … -
Can we update Query in Data Exchange dynamically?Hi , We have a direct integration with a database to pull data using a View. The database query is something like below. select account,period,platform,product,profit_ce…
-
Which role is required to add the parameter for the process "Compute Users with Large ACL"?Summary: We have an specific person for scheduling processes, but he is unable to enter the parameters for the process. Which permission/privilege or role is missing? Wi…
-
Need a way to set Date Value in a Flex Form with an After Load Groovy RuleSummary: Hi, We are designing a Flex Form that displays in SmartView the current value of a Date field, taken from a different POV. To do so, we implemented a groovy rul…
-
SmartView for Google SheetSummary: When setting up the SmartView for Google Sheets , following the below mentioned doc https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-comm…
-
REPORT: In smartview when we Open a "fully formatted Reports" it opens into a new worksheetSummary: Content (please ensure you mask any confidential information): Hi all How can we avoid that when we open a REPORT: In smartview as "fully formatted Reports" it … -
How to affect UDA to members in account dimension ?Hello, We need to affect UDA to members in account dimension thanks to the webform, where : a user can input value "1" in a particular cross of dimensions, including mem… -
Script analysis throwing an error with substitution variableI'm attempting to make a business rule quicker, so I'm doing a script analysis on it. The rule validates and functions with no errors; however, when I try to do a script…
-
EPM Pipeline: Running a business rule with runtime prompt type SmartlistSummary: Hi, I'm trying to execute the BR: "OWP_Process Loaded Data" as part of a pipeline. I want to pass the variable "OEP_FcstMnth" as the RTP 'Month'. However, Month…
-
SmartView Grid not Displaying Data when Copying a Sheet or POV to new tabHello Everyone - I am noticing an issue with SmartView when copying an ad-hoc query or POV to a new excel tab. It appears I can connect to the DB, but no data is returne…
-
Shared Account Dimensional Member 445 Properties IssueProblem with setting an account flag to '445' for distributing the entered value. In the system there is a 'never shared' type account which does not have the flag set t…
-
Groovy to transfer data between cubeSummary: I planned to transfer headcount data between cubes by using groovy. Content (please ensure you mask any confidential information): I have tried to use datagrid … -
how to add two sum rows in a single pdf page for two accounts - in PBCS/EPBCSHi Folks, When we select parent hierarchy for account, we will get two or more accounts in the rows for a report. earlier we have SUM for all the accounts which will be …
-
Make forms read only just for a specific group of usersSummary: Is there a good way to make a set of forms (I have about 15 in a folder) to display as read-only for a specific group of users. Content (please ensure you mask …
-
How does "Not set" Essbase Dimension Hierarchy type works?Summary: In Essbase Dimension member Hierarchy type we have 1 . Not Set 2. Dynamic 3. Multiple 4. Stored ,how does "Not Set" type works. Content (please ensure you mask …
-
Business Rule Performance Question Datacopy vs FormulaSummary: After reading some posts that have been circulating here and on other media, I decided to try and optimize a script formula, but I'm not getting expected result…
-
Error Status When Run Integration in Export ProcessWhen run integration import project from ERP Fusion to EPM EPBCS, log status for export process is error. Although the status show error, the status detail for export pr…
-
Groovy Dataexporter is not exporting Dynamic Calc membersSummary: Hi, I need to export data from EPM Planning BSO cube with "Alias". So I need to use Groovy Rule because Data Export Calc command BR create Member Name in file. …
-
In New migrated Reports reference Prompt is not working with IntersectHi Team, We have migrated FR to Reports. In many of our FR reports, we used a prompt for the entity and referred to the same prompt with level 0 in the next row using th…
-
How to run uploadFile as a user with the “User” roleSummary: How to run uploadFile as a user with the “User” role Content (please ensure you mask any confidential information): I would like to know how a user with the rol… -
File-based Integration unexpected behaviorHello everyone, We are using File-based integration to load data from a file to PBCS. However, we meet unexpected behaviors. We created a file with two rows for testing;… -
Is there any way to view report usage in Planning?Summary: My organization is interested in seeing how many times the reports we have developed have been run. Is a there any way to view this data? There doesn't appear t… -
Smart view(24.2) native to standard in Planning applicationSummary: We have the below year dimension hier in planning application, alias given in the bracket. Year FY23 (2023) FY24 (2024) When switched from native the standard, …
-
Predictive Planning not functioning well in Form 2.0Summary: Content (please ensure you mask any confidential information): Hi, We just noticed that Predictive Planning is not functioning well in Form2.0. After run the pr…
-
Member formulas for Qs and YTD calculationsSummary: We have a Account that is taking Account: "flighthours"/ Account: "count" and are trying to get the member formula to work for Quarterly and YTD. Content (pleas…
-
Budget Writeback Error : User does not have access to control budgets for the entered parametersSummary: We are facing error while writing budgets back into control budgets. Primarily, It looks like USER security is updated and the user doesn't have access to any d…
-
Has anyone encountered this error when trying to funds check a budget revision?Summary: We are configuring out of the box Budget Revisions. When attempting to run a funds check I receive the errors below. I have never seen these and there is not mu…
-
Org Hierarchy Restructure/Changes Affect on Archived DataSummary: Has anyone had experience with org restructure/changes that have affected historical archived data? We need to make a few changes to our org structure but we ar…
-
When is the next 2025 version of SmartView planned to be released?Summary: We are working with our very controlling IT department to upgrade our SmartView from 21.200 to the newest version. Before we do, we were curious if there are pl… -
employee dimension load - only active employeeswe have built an integration to load employee dimension masterdata from BIP report to EPM cloud planning BSO custom cube. how in this integration can we only allow ACTIV…