Smart View Integration with Oracle Cloud ERP and EPM

What is Smart View?

It is a tool through which a user can view, import, edit, modify data and meta data in Excel. The objective of Smart View is to integrate EPM and BI data directly from the data source into Office applications such as Word, PowerPoint, Excel, and Outlook.

Its significance for business users

SV acts as bridge to enable the business user with non-technical background to handle the cloud applications with ease and without hustle. With the help of this tool the user can navigate through the data and meta data and can do whatever he wishes to in MS-Excel without navigating the application directly, provided he has proper rights to access the data/ metadata.

How to download the Smart View and relevant add on applications?

We can download the application from this link: https://www.oracle.com/middleware/technologies/epm-smart-view-downloads.html

Once the file is download you need to run the file and install the application. While installing the application make sure that all MS office applications are closed.

Step wise process further:

  1. SmartView Ribbon will be displayed once the application is installed as displayed in the picture
  2. Click on the options and navigate to advanced tab
  3. Enter the URL of the cloud application you wish to connect with Excel
  4. Now click on the Panel
  5. Select shared connection from the menu which popped-up on right hand side
  6. You need to enter username and password of the application
  7. Now select the application in that menu and select the desired field

Smart View Panel

From the Smart View Panel, you can manage data source connections, access data and task lists, and create reports.

You can also open Oracle Crystal Ball Enterprise Performance Management workbooks if you are licensed for Crystal Ball EPM or related products.

The Smart View Panel, opened from the Smart View ribbon, is displayed by default on the right side of the Microsoft Office application. You can move, resize, or close the Smart View Panel from the down arrow in the title bar.

The Smart View Panel contains the following panes:

Homeโ€”A panel that displays links to Shared Connections and Private Connections as well as a list of recently used itemsโ€”ad hoc grids, forms, and tasksโ€”that you can click to establish a connection.

Shared Connectionsโ€”A drop-down menu of available connections from Oracle Hyperion Shared Services and a tree view of the contents of the currently selected connection.

Private Connectionsโ€”A drop-down menu of available connections saved on the local computer and a tree view of the contents of the currently selected connection. You can also enter a URL to connect directly to a data source here.

Task Listsโ€”A tree list of tasks from which you can manage your tasks. This pane opens only when you select a task list from Shared Connections or Private Connections.

Action Panelโ€”A list of operations available based on the selection in the shared connection. private connection, or task list tree list.

Document Contentsโ€”A task pane in the Smart View Panel that provides a view of the connections and content existing in the current Office document.

Ad hoc analysis

  1. As the name itself explains that we can do any ad hoc analysis in excel using this tool. We can select any dimension/ members/ data and do our own set of analysis
  2. To open this user need to click on โ€œAnalyzeโ€ icon under FCCS tab
  3. User can do slicing and dicing and play around the data as per his requirement
  4. User can zoom in to next parent/ child member
  5. User can select the rows and columns we required and hide the other line items using keep only and remove only options
  6. User can change the alias we need and submit the data directly to application from excel itself.

Member Selection

A user can select the dimension member directly using the Member Selection option in FCCS Ad Hoc Tab.

This allows the user to select the required intersection/ combination to retrieve the required set of data/ metadata and do random analysis with the data.

Author
Pranshu Dharmawat
Consultant, Fusion Practices
LinkedIn

Similar Posts

22 Comments

  1. Generally I don’t read post on blogs, but I would like to say that this write-up very forced me to try and do it! Your writing style has been amazed me. Thanks, very nice post.

  2. Good โ€“ I should definitely pronounce, impressed with your web site. I had no trouble navigating through all the tabs and related info ended up being truly easy to do to access. I recently found what I hoped for before you know it in the least. Quite unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Nice task..

  3. Its such as you learn my thoughts! You seem to understand so much approximately this, like you wrote the e-book in it or something. I think that you simply could do with some to power the message house a little bit, but instead of that, this is magnificent blog. A great read. I’ll certainly be back.

  4. Thank you, I’ve recently been looking for information approximately this subject for ages and yours is the greatest I’ve discovered so far. However, what in regards to the bottom line? Are you certain about the supply?

  5. Hey there I am so excited I found your blog page, I really found you by error, while I was researching on Digg for something else, Anyhow I am here now and would just like to say thanks a lot for a incredible post and a all round entertaining blog (I also love the theme/design), I donโ€™t have time to read it all at the minute but I have book-marked it and also added your RSS feeds, so when I have time I will be back to read a great deal more, Please do keep up the great job.

Leave a Reply

Your email address will not be published. Required fields are marked *