SmartView
Discussion List
-
Remove ASCII characters from text data in Data Management (EPBCS)We are getting "XML Load Error: Invalid Unicode Character" error while refreshing Text data in SmartView for ASO cube as there are ASCII symbols in text data which got l… -
ASO Cube - Drill Down Vs Refresh of BottomSummary: I'm facing a weird use case with our ASO reporting Cube. Our Reporting Cube is very sparse and we have 2 big dimensions : 1 emplyee dimension (around 80k member… -
SmartView Crashes or hangs indefinitely(EPBCS applications).We are using MS Office 365 and SmartView version 22.200 and at times, the excel hangs indefinitely(mostly while refreshing the forms) and then, there is no option to clo…
-
HsAddin.dll is not a valid Office Add-inContent Hi, The Excel in my new laptop crashed with Smartview yesterday. I disabled it, thinking that I could enable it easily later. However, after numerous uninstall, … -
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
See Report Books in SmartViewSummary: Content (please ensure you mask any confidential information): I have a number of FR Reports books that I have in PBCS. However, I am unable to see them when I … -
SmartView for non office 365Summary: The customer has a standalone, non-365 version of Microsoft Office suite Content (please ensure you mask any confidential information): Do we have SmartView set…
-
Remove User Permission to Save Forms/Grid into LibrarySummary: Content (please ensure you mask any confidential information): I have users that have been saving ad hoc grids as forms in the library. However, I cannot find a…
-
How do you install a previous version of Smart ViewSummary: Content (please ensure you mask any confidential information): I have one user whose excel crashes whenever they try to refresh a workforce employee roster form…
-
Unable to connect to SmartView with same credentials as web accessSummary: I could previously connect to Smart View via both shared and private connection, but after the epm login page changed, I am no longer able to connect to Smart V…
-
PBCS Offline formsHey, I'm unable to connect the Offline forms through SmartView More option. For this issue, I had reviewed Oracle Documentation, there I have found this Note: Offline fu…
-
Excel formulas in Strategic Modeling Freestyle reports randomly not sticking in the modelsWe are creating freestyle reports in Strategic Modeling containing a few basic Excel formulas for subtotals or simple calculations. It works most of the time but in some…
-
Retrieve Parent of member in SmartView / HSGetHello Experts, Is there any way to retrieve the parent of a member in Excel? I have a file that uses HSGet (it was a necessary evil to achieve the layout i needed), and …
-
Smartview handled unknown exception thrown by Microsoft office.Summary: I received a message every time I open Excel. The message is: "Smartview handled unknown exception thrown by Microsoft office". Has anyone encountered this befo…
-
Changing Smartview settings via scriptSummary: I had the issue - SR 3-34040867641 : FR - Report doesn't show the arrow - similar to "+" - indicating that the member has children. - and the solution is to cha…
-
How to identify if a user has been connected : via Web or SmartView ?Hello All, Is it possible to identify how a user has been connected : via Web or via SmartView? Today, we can see if a user put the data in adhoc or directly in a form..… -
Connection Refused Error in Smart ViewSummary: Some users are experiencing an intermittent Connection Refused error in Smart View when attempting to refresh or login. What are some possible reasons for this …
-
Submit data using VBA macros from a hidden worksheetSummary: I'm trying to submit data from a hidden worksheet. I don't want to use HypMenuVSubmitData as it will require unhiding the worksheet. I can't use HypSubmitData a…
-
Bursting DefinitionSummary: Bursting Definition with Library option enabled. Content (required): Hello Experts, I have created a bursting definition with library option is enabled. I want …
-
Custom or Module-based EPBCS business processSummary: Hello, As I am fairly new to EBCS, did the high-level design with Oracle in 2016-2017 but only recently have started to implement it for a client, I decided to … -
SV: Getting an error when selecting user Variable for forms in SmartviewSummary: Content (please ensure you mask any confidential information): Getting the below error when selecting a member which is part of the user-defined variables. This… -
Planning Ad Hoc Analysis: when we remove a member from the analysis to affect data at parent levelSummary: Content (please ensure you mask any confidential information): Hi all We have a request from one of our clients that when they analyse data via Planning Ad Hoc,…
-
Are there any connectors available for PowerBI/Azure we can pull the data from our cubes?Summary: Are there any connectors available for PowerBI/Azure we can pull the data from our cubes? We would like to be able to pull the finanical data we have in our cub… -
New Hands-on Tutorial for Planning now availableWe are pleased to announce the availability of the following new Hands-on Tutorial. Hands-on Tutorials provide step-by-step instruction on how to complete a set of tasks… -
Is there anyway to find the username and the last updated date of a form or a value in the form?Is there anyway to find the username and the last updated date of a form or a value in the form via SmartView?
-
Smartview (v910) Error: "Screenshot Captured"Summary Smartview (v910) Error: "Screenshot Captured"Content I installed the new version of SmartView (11.1.2.5.910 (Build 172)) and now I am constantly receiving the er… -
Smarview Private connection URLs to be clearedSummary: In the process of testing different applications and enviornment, a number of URLs have been added to the smartview prviate connection. Now, I have a problem in…
-
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 … -
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…
-
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 …