Featured post

General Ledger Revaluation

General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...

Showing posts with label Smart View. Show all posts
Showing posts with label Smart View. Show all posts

Monday, 30 January 2017

SMART VIEW SUPPORT MATRIX AND COMPATIBILITY

1. What is the current version of Smart View?

Current version of Smart View is 11.1.2.5.510, released in October 2015.

2. In the release compatibility tab of the support matrix, what does Smart View 11.1.2.5+ mean?

It means Smart View 11.1.2.5.000 and higher.  Any release of Smart View 11.1.2.5.000 or higher is supported with the data source provider mentioned in the release compatibility matrix.  The latest release on the code line is recommended for customers.

3. Does the latest version of Smart View support 11.1.1.x releases of EPM suite (Planning, HFM, etc.)?

Smart View releases beginning with 11.1.2.5.000 support EPM 11.1.1.4.x.  Earlier versions of EPM are not supported.  Customers need to upgrade to a higher version of EPM suite, preferably 11.1.2.3.500, the latest.

4. Does Smart View support Internet Explorer 10?

Smart View 11.1.2.5.000 (and higher) supports IE10, as long as the underlying product or provider supports IE10.  For example, HFM 11.1.2.3.500 supports IE10 so Smart View supports IE10 in that context.  For older versions of HFM, IE10 support is not certified.

5. Does Smart View support Internet Explorer 11 against HFM?

IE11 is currently certified only with products in EPM System 11.1.2.4. In this release of EPM System you must use Smart View 11.1.2.5.400.
There is a limited support for IE11 with EPM 11.1.2.2.500 and 11.1.2.3.500.

6. Does Smart View Support Office 2013?

Yes.  Smart View Release 11.1.2.5.000 onwards supports Office 2013.

7. Does Smart View support Office 365?

Smart View is ONLY supported for Desktop versions of Excel, Word, PowerPoint and Outlook included in any Office 365 plan and which are locally installed on any supported Windows Operating System.
Office 365 is a subscription-based online office and software-plus-services suite which offers access to various services and software built around the Microsoft Office platform.  Other services include Lync web conferencing, Exchange online, Sharepoint, SkyDrive and Skype.  The licensing determines what component or service is included as part of a bundle.
Microsoft Office Web Apps are a part of most Office 365 plans. Office Web Apps allow users to open Word, Excel and PowerPoint documents, among others, using a web browser.  However Office 365 on the web is intended for reading (full fidelity) and limited editing.  Office Web Apps do not have extensibility (add-in) model and there are no plans for one. Smart View is NOT supported for Office Web Apps which are part of Office 365.
Office 365 was made available in 2011 when Microsoft Office 2010 was the latest Office Suite.  Smart View supports Microsoft Office 2010.  Microsoft Office 2013 is supported starting with Smart View Release 11.1.2.5.000.

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

8. Which versions of Oracle Business Intelligence Enterprise Edition (OBIEE) does Smart View support?

COMPATIBLE OBIEE SERVER RELEASE
SMART VIEW RELEASE 11.1.1.7.011.1.1.7.1 (NO PATCH)11.1.1.7.10 (FA-REL8)11.1.1.7.140527 11.1.1.7.15012011.1.1.9.0
11.1.2.2.310YesNoNoNoNoNo
11.1.2.3.000YesNoNoNoNoNo
11.1.2.3.000 PSE_16909989YesYesNoNoNoNo
11.1.2.5.000YesYesNoNoNoNo
11.1.2.5.200NoYesYesNoNoNo
11.1.2.5.210NoYesYesYesYesNo
11.1.2.5.215NoYesYesYesYesNo
11.1.2.5.400NoYesYesYesYesNo
11.1.2.5.410NoNoNoNoNoYes
11.1.2.5.500NoNoNoNoNoYes
11.1.2.5.510NoNoNoNoNoYes
 9. Does Smart View Support Google Docs?
Smart View is a COM add-in for MS Office Suite of products and as such, cannot not have any integration, with Google docs.  Google Docs (includes Docs, Sheets, and Slides) is a free, web-based office suite offered by Google within its Google Drive service.
In order to provide functionality similar to Smart View a new application will have to be created possibly using Google Apps Script.  Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.
It is to be noted that Google docs does have limitations such as:
  • Sheets – 200 sheets per workbook, with 400,000 cells in all
  • Docs – 1,024,000 characters, regardless of the number of pages or font size
  • Slides – Presentations created in Google Slides can be up to 50 MB – about 200 slides.
These are practical limitations for Smart View users who have a large number of cells in a typical workbook.  In some cases the number of sheets in a workbook does exceed 200 or documents can have more than 1,024,000 characters in a document, which is not allowed in Google Sheets and Google Docs respectively.
Once these limitations are addressed and if Google Apps Script (or newer technology) is able to provide the same rich functionality that COM add-ins such as Smart View provide, Oracle will re-visit this topic for consideration.

Sunday, 29 January 2017

SMART VIEW ERROR “CANNOT CONNECT TO THE PROVIDER. MAKE SURE IT IS RUNNING IN THE SPECIFIED HOST/PORT. ERROR(503) ” WHEN OPENING HYPERION PLANNING CONNECTION.

WHEN ATTEMPTING TO CONNECT FROM SMART VIEW TO HYPERION PLANNING THE FOLLOWING ERROR MESSAGE IS DISPLAYED:

Cannot connect to the provider. Make sure it is running in the specified host/port. Error(503)

This occurs due to The OHS server Timeout for APS is set too low. In configuration file mod_wl_ohs.conf the values for  “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” are too low and the connection to Smart View is timing out.
  1. Shutdown the Essbase Server service or process.
  2. Backup the mod_wl_ohs.conf configuration file. The file is found in the following location on your APS server:
    C:\Oracle\Middleware\user_projects\epmsystem\httpConfig\ohs\config\OHS\ohs_component
  3. In mod_wl_ohs.conf increase the timeout in seconds for the “WLIOTimeoutSecs” and “WLSocketTimeoutSecs” properties within the location section for APS:
    SetHandler weblogic-handler
    WeblogicCluster :13080
    WLIOTimeoutSecs 1800
    WLSocketTimeoutSecs 1800
  4. Save the modified mod_wl_ohs.conf file.
  5. Restart the Oracle HTTP Server and the WebLogic Managed server service or process for APS.