SmartView
Discussion List
-
NEW Reports module open on a different Smartview workbook instead of under a new Excel TabSummary: Content (required): Hi All It seems that the new REPORTS module opens reports on a separate WorkSheet every time we open new Fully formatted reports. We want th… -
How to isolate natural account when selecting descendants on account member selection in Smartview?Summary: I am creating a Smartview report and selecting account member from member selection. I want the last level to be displayed without the hierarchy string, so I se… -
What are "invalid form error" causes and it's resolution in SmartView?Summary: Getting "Invalid form error" in SmartView while refreshing. Content (required): Version (include the version you are using, if applicable): Code Snippet (add an…
-
Smartview Hierarchies - Member Selection & naming ConventionsSummary: Using Smartview for Essbase and wondering if naming conventions can be changed and how hierarchy displays are determined. Content (required): In the Member Sele…Delaney Wastler 31 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Excel SmartView login popup (After OCI2 Migration)Hello experts, after oci 2 migration done this 2023 I have checked that when users try to input login via smartview always appear a popup during they are typing user/pas… -
Is there any way to integrate Oracle/EPBCS with Google Sheets?Summary: Is there any way to integrate Oracle/EPBCS with Google Sheets? I would love to be able to build SmartView queries in Google Sheets. Any ideas on whether that's …
-
What's New in 20.11?Summary Cool Stuff including a big Projects enhancement!Content Well, here we are again. Another month, another monthly update! The year is rapidly coming to a close, so… -
Enabling Job Console or NotificationsSummary: Content (required): Is there a way for non-admin users to know when a business rule completes? I saw some information on the Job Console in SmartView but I don'… -
Question on Smart view Zoom InSummary: Smart view zoom in with Suppress No data/zero's in Rows and Columns is not working when we drill down Dense Dynamic calc parent member in Rows or columns. Its t…
-
Unable to make changes on flex formSummary: User gets an excel message every time he tries to change rows in flex form. Content (required): Hi, one user is getting a message from excel when he tries to ch… -
On OCI Gen2, when Using Okta to sign in to SmartView, users get Script ErrorSummary: On OCI Gen2, when Using Okta to sign in to SmartView, users get Script Error 'Unable to get property 'open' of undefined or null reference'. After clicking Yes …
-
Smart View Error While using 'Working With Adjustments' Version.Summary: Smart View is throwing an error 'Ad hoc grid cannot be opened as there are no valid rows of data' error while using 'Working With Adjustments' Version and the '…User_2025-03-10-22-57-21-810 72 views 4 comments 0 points Most recent by User_2025-03-10-22-57-21-810 Planning
-
Can someone help us on how to properly install SmartView to office 365?Summary: All users have recently been upgraded to Microsoft Office 365. As a result their Smartview has been unable to be installed to it. This is causing a major issue …
-
What could cause partial refresh of the totals (in SmartView)?Summary: I (and our users) have noticed that sometimes when we use SmartView to access our PBCS, we get one set of #s, and we know they are incorrect. If we refresh our …
-
How to retrieve data from GL Cube?Summary: How to retrieve data from GL Cube? Content (required): The link below provides some information about the GL Cube (Overview of Oracle General Ledger Balances Cu…RS_CSAA 222 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Supporting Details in PBCSSummary: Supporting Details is very cumbersome to use through the UI. Is there an easier way for a user to build their budget/forecast by line item? Is there a way to in…
-
Groovy: Script to make data bold in SmartviewSummary: Content (required): Hi all We are trying to use Groovy to ensure that data for Total cells is bold. Does anyone know of a script for that? we have noticed that …
-
How to resolve SmartView Script Error? - Object doesn't support property or method 'find'Summary: Get script error when trying to connect to planning via SmartView in Excel. The error message is Object doesn't support property or method 'find'. Selecting Yes…
-
PCMCS Query - Exporting data using epmautomate with "," as delimiterSummary: Exporting Data from PCMCS using epmautomate exportQueryResults Content (required): Hi, I am trying to export data from PCMCS using a query using epmautomate exp…Amit Agarwal-158816 61 views 7 comments 0 points Most recent by Amit Agarwal-158816 Profitability and Cost Management -
Best way to copy data to avoid user overheadSummary: Currently copying data using business rules which are attached with screens. Business rule is executed while pressing Data Save button. It takes little longer t…
-
Can we load numbers into EPM with excel formulasSummary: We would like to know if there would be any issues if they load numbers this way and any suggestions or settings to be used if they are loading numbers using fo…
-
Is there a way to update metadata in multiple files?Let's say I have a SmartView report with twenty different tabs, all connected to the same server, and I have ten servers, and I need maintain the same set of reports, bu…
-
Getting an error when using HypModifyConnection to update the report connectionSummary: Trying to use HypModifyConnection but getting this error message: Code Snippet (add any code snippets that support your topic, if applicable): Private Declare P…
-
Security featureSummary: Privilege(s) is/are required for making smartview work Content (required): Can you please tell us what privilege(s) is/are required for making smartview work ? …Shubhojit 11 views 2 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
SmartView: Display Parent Value Above Child ValueSummary: Hi All, I am trying to create a report in Smartview and even when i select the SmartView option for anchestor postion as TOP. still my parent account always dis…Prasanthkothurii 144 views 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle General Ledger & Intercompany
-
Data pulled from Fusion ERP through Data Management is in Data Workbench but not in the OEP_FS Cube.Summary: Using Data Management, we tried to pull actual data from Fusion ERP. The data rule ran successfully without any errors, and we could see the data in the Data Wo… -
Does Scheduled Process Validate and Upload Budgets cause a GL Balances Cube update, impacting users?Summary: Users in Smartview and General Accounting UI Inquire and Analyze Balances received error messages and lost connectivity to GL data (cube) unexpectedly around th…Carol Fergusson 32 views 1 comment 0 points Most recent by MariCostache-Oracle General Ledger & Intercompany
-
Smart View v 23.1Summary: Will the new features in Smartview v 23.1 be available for ERP users? Content (required): The new Smart View features in version 23.1 show as applicable only fo…
-
Does Oracle have plan to have Smart Forms be supported for Standard-mode?Summary: Currently, the smartview option is set to Standard, so there is no possibility to use Smart Forms, the client doesn't want to change to Native since it is known…