SmartView
Discussion List
-
Smart View Submitting Zero Instead of Missing into ASOSummary: Need to clear an ASO cell (submit missing) via smart view ad hoc - presently is submitting zero Content (required): With a smart view ad hoc, we are submitting … -
Please suggest SmartView link that can be used to connect/test to PCMCS OCI temporary URLs.Summary: SmartView link that can be used to connect/test to PCMCS OCI temporary URLs provided by Oracle to validate the env before migration. Content (required): PCMCS U…Shipra Jain 12 views 2 comments 0 points Most recent by Shipra Jain Profitability and Cost Management -
Trailing Twelve Month (TTM) in SmartviewSummary Is there an easy way to get Trailing Twelve Month (TTM) in SmartviewContent Is there a way to easily let Smartview calculate the Trailing Twelve Month Revenue? S… -
Are Smart View Admin Extensions available for PCMCS?Summary Are Smart View Admin Extensions available for PCMCS?Content Are Smart View Admin Extensions available for PCMCS? I am able to use it when connected to a Planning…LindaR 40 views 3 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Can you use HypCreateConnectionEx() to see forms in a EPBCS app private connection?Summary: In Smartview 11.1.2.5.900 and Planning 11.1.2.5 we could use the HypCreateConnectionEx() function to create a Planning app private connection. In that Planning …
-
Is there a member cell information equivalent in Smartview VBA for EPBCS Planning connections?We recently implemented EPBCS and for one application we shifted from an ASO Essbase application to an EPBCS Planning ASO Plan Type. In Smartview with Essbase connection…
-
Support of Smart View - 23.100Summary: Support of Smart View - 23.100 Content (required): We would like to know if we could install Smart View version 23.100 on Citrix VM within VMware to connect to …Sunil Yerramsetti 51 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle General Ledger & Intercompany
-
Does adding cell comments on multiple cells work only on a single column at a time in Smart View?The Smart View feature of adding cell comments on a range of cells works only if the range lies in the same column. Is this an expected behavior. Also, deleting cell com… -
HSGETVALUE() error with URL but not private connectionHi All hoping someone can help with the below: I was able to use HSGETVALUE on a private connection and use the "Build Function" to successfully get a retrieve. But I wa…
-
Smart View - Submit Zero'sToday we were testing out submitting data in Smart View and even with the "Submit Zero" setting unchecked, 0's were still being submitted to the application. I thought h… -
Disabling 'Submit zero' is not workingSummary Disabling 'Submit zero' is not workingContent Disabling 'Submit zero' is not working - When I open a data form, under Data Option, submit zero option is disabled…
-
Which privilege in role setup allows drill through access to the General Ledger via Smartview?Which privilege in role setup allows drill through access to the General Ledger detail balances via Smartview?luke.syv8 91 views 5 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany
-
Is there a way to update the default POV for a new Ad Hoc Analysis in Smart View in Excel?Summary: Is there a way to set the default POV when adding a new Smart View Ad Hoc Analysis to a tab in Excel? Currently, the POV lists the dimension names. It would be …
-
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 77 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 221 views 4 comments 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany