Smartview.bas file download

Very interesting blog to read and to share, thanks for sharing such a good blog. Post a Comment. December 13, When working with Hyperion systems, Smart View is a key tool used for reporting, as well as inputting data. It provides a valuable link between Hyperion and Excel, which allows users to retrieve data from the database straight into Excel with ease. Occasionally, it is necessary to perform Smart View functions behind the scenes using VBA code, rather than manually using the Smart View toolbar.

For example, a spreadsheet which will refresh all the Essbase retrieval sheets on opening, so that users can view the most up to date data, without having to remember to refresh each of the retrieval sheets themselves. There are a couple of things which must be set up before Smart View functions can be called using VBA code. The first is that Smart View must be installed on the local machine which will be use to run the VBA code.

This must be done in every excel file which will be referencing Smart View functions. This command is the equivalent of using the Refresh button on the Smart View Excel toolbar. The refresh function will use the last connection details that were used on that sheet and will ask the user to enter their login details for the first retrieval.

Once a user has logged in, retrievals can be performed on multiple other sheets without having to login again. Before the sheet can be refreshed using the HypMenuVRefresh function, the retrieval sheet must be set to visible it is not possible to refresh a hidden sheet and it must be the active sheet in the workbook.

The last thing is to make sure that no ranges of cells are selected as this brings back an error. To do this, select a specific cell on the sheet e. In the above code, if the refresh was unsuccessful, the status sts variable will return an error code and display an error message. If it was successful then the status is equal to 0. Tuta 30 September at If you load a folder with multiple files, you can organize them in a list or in thumbnail view, easily delete items from the list, or add any items to a custom playlist.

Another great feature is that it supports external subtitles. Stream multimedia content from Samsung devices directly to a support Smart TV including videos, pictures and audio content.

Features and highlights Easy to setup and use User-friendly GUI Includes the essential player controls to manage media content Control your Samsung Smart TV even without a remote control Connect your mobile with the TV and select videos, pictures, or even music. Your content will instantly play on the TV Create personalized playlists to access all of your favorite videos, photos, and music in one place Add content files or even a whole folder from your PC into Smart View Enjoy content from all the devices connected to the TV as the source Samsung Smart View 1.

Samsung Smart View 1. Download Samsung Smart View 1. We have tested Samsung Smart View 1.