SmartView
Discussion List
-
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 51 views 4 comments 0 points Most recent by User_2025-03-10-22-57-21-810 Planning
-
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 …
-
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…
-
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…
-
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 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…
-
Auto Data submission via smart view formsSummary: Auto Data submission via smart view forms Content (required): Need to submit data via planning forms(forms has rules to run) for a series of products. Form is i…
-
Smart view suppress missing rows option in adhoc queries - applicable to all users centrallySummary:Smartt view suppress missing rows option in adhoc queries - applicable to all users without doing in individully one by one in smart view. We tried in user inter…
-
Disable member indentation in Smart View for flex forms?Summary: Is it possible to disable member indentation for flex forms? If I use "Suppress Hierarchy" within the form setup, it works when opening the form, but any refres…
-
Do 11.x versions of Smart View need to be uninstalled before installing 23.1 version?Summary: I am curious if older 11.x versions of Smart View need to be manually uninstalled by users before they install 23.1 version. Content (required): We are putting …
-
SmartView Setting/ formatting to highlight not existing blocks / missing blocksSummary: We believe there was a formatting option years ago in SmartView Adhoc mode to highlight/format not existing blocks / missing blocks. Can somebody kindly give a …
-
Is it possible to rename folders like "Library", "Reports"It's a silly question because these are standard folder but still I would like to know if there is a way to rename "Library", "Reports", it's mainly for the users becaus…User_2025-03-10-22-57-31-218 61 views 9 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning
-
Maximum number of functionsHello, I've got an Excel spreadsheet with a lot of sheets. When I refresh one by one it does not give any error. However, when using "Refresh all Worksheets" it gives th…
-
Shared connections XML file for PCMCSHi Team, For Shared connections XML file, it works for PBCS / FCCS, i am trying to set it up for PCMCS, and it doesnt work. Is there some documentation around it? If som…
-
Import SmartView Report with Drill ThroughSummary: When viewing a report in the web UI, I am able to drill into account groups by using little arrows (see image in summary). However, the zoom in feature does not…
-
SheetInfo is displaying html tags popup firstSummary: SheetInfo is displaying html tags popup first and the details of the html output later. Content (required): Is there a fix to avoid the html pop and see the out…
-
Can you create a group or parent across several dimensions?Summary: Is it possible to create parents or groups involving multiple dimensions such as a "Gift Card" parent containing ("Account 1, Region 1, Dpt 1" and "Account 2, R…
-
Anyone use the HsGetVariable in Smart View??Content G'day, all! I had a request to make Smart View Ad hoc reports used in reference doclets for Narrative Reporting more dynamic. So my thought was to add substituti…
-
Open a WRS from Excel with POVSummary: hello experts, I have some reports (WRS) that I want to open via excel, I can do with shared connections Reporting Settings. In each tab I have a report (I have…
-
"Reports" in smartviewWhen opening new generation "Reports" in Smartview, in the prompt for selecting dimensions, there is no search option, how do you all manage if the dimension has 1000 me…User_2025-03-10-22-57-31-218 51 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Planning
-
Excel Smartview with VBAHello experts, Can I open an excel with user/pass hardcoded in VBA code and avoid HTML window to sign in the application. I try to create a sub when workbook is open wit…