#How to add smartview to excel ribbon how to#
#How to add smartview to excel ribbon update#

A Data Form (Hyperion Planning, (e)PBCS, and HFM-presumably-I have not tested).You have three options to create what is referred to in Smart View as a 'function grid'. The first thing you will need to decide is how you are going to link your source data to your ppt. I suggest using this latest version of Smart View since it has some fixes in it specifically associated with PowerPoint.

#How to add smartview to excel ribbon how to#

In this tutorial, I am going to walk through how to create interactive Smart View objects in PowerPoint. In my effort to communicate useful EPM tips across various mediums, this seemed like a good topic for a blog post. Besides having some fun trying to convince our panel of investors (see the Photoshop pics at the end of this post) while the audience watched, we wanted to convey the very real message that you can do some interesting things in PowerPoint with Smart View. Gary and I figured we could use our Smart View skills to create some really slick ppt slides to convince the investors to help us save this favored institution that had been around since the Arbor days. Of course I am referring to the fabled bottling company made famous by the Essbase Sample Basic database. If you don't know what The Beverage Company is, your Essbase street credit is going to take a serious hit. We did a Shark Tank style pitch to 'investors' on why they should help us 'Save The Beverage Company'. While the Power Point and Word functionality are not 100%, they have come a long way and with some patience you can make some really nice PowerPoint slides that are interactive with your underlying EPM data sources.ДЄt Kscope18 I did a presentation with fellow Oracle Ace and GE colleague Gary Adashek. Smart View has had the functionality to work with the MS Office suite for some time, but frankly the functionality outside of Excel has been limited and challenging to work with at times. Well, did you know Smart View for Power Point does all of that? That's right I said Smart View for PowerPoint Smart View is not just for Excel.

#How to add smartview to excel ribbon update#

Do you get tired of recreating the same PowerPoint decks each month when your numbers change? Wouldn't it be great if you could just push a button and have the numbers in your ppt slide update to what is in the database? Wouldn't it be even better if the data was used in visually rich MS Office objects such as tables and charts? And, wouldn't it be awesome if you could interact with the data in real time during your presentation?