• Smart View Add-in For Excel 2013 Download
• Download Smart View For Excel

I haven't seen any showstoppers with Office 2013 and 11.1.2.5.200. I believe that all the problems I've run into are just generic SV behavior rather than linked to Office 2013 specifically. And it's supported, so you can at least raise tickets if you see problems.

Hello I just installed smartview 11.1.2.5.720 (build 119) on windows 7 with Excel 2013 and the options are not saved. Have you encountered this bug?

• Smart View provides a common. Import, manipulate, distribute and share data in Microsoft Excel. Ability to create data perspectives for end users called Smart.
• Selection of software according to 'Smartview compatibility excel 2013' topic.

Mixed results reported with the legacy Add-In, e.g. I definitely know of users who had fresh installs of Office 2013 unable to get it working. I personally wouldn't advise upgrading users to Office 2013 without a 'Plan B'! Scoring disabled. You must be logged in to score posts.

Jeff McAhren 63.108.38.204 Re: Excel 2013 No score for this post November 17 2014, 4:01 PM. All Smartview users on Office 2013 that I've seen suffered from horrible flickering issues. Looks like Excel stops redrawing the screen whenever you change something on the retrieve sheet or do a refresh, but it's still much slower than the equivalent retrieve on Excel 2010, and sometimes flickering happens for no apparent reason. It was bad enough that users asked to be rolled back to Office. Of course YMMV, but if I were you I'd set up a test PC and test the hell out of it, just to be sure. Scoring disabled.

You must be logged in to score posts. Pete N 120.149.88.86 Try turning off graphics Acceleration No score for this post November 25 2014, 4:03 PM.

Running Excel 2013, latest smartview (11.1.2.5.210) - it's as smooth as silk. Cannot replicate any flickering, even with massive retrieves. This is a rather powerful machine, with a very up to date graphics card. When doing big pivots etc, I can see a fair hit of activity on the graphics card. It may just be that lower power machines are struggling with the graphics requirements. Ps: Yes, I am aware how stupid it sounds to be talking about 'graphics requirements' with Excel!

Scoring disabled. You must be logged in to score posts. Do you have the POV bar 72.177.123.167 Not graphics related - what's the difference?

No score for this post November 27 2014, 11:11 AM. Create a workbook with three or four worksheets, each of the worksheets have a smartview grid. When switching between the worksheets, the pov bar dances up and down the screen x times (x=the number of dimensions on the POV bar, between one and eight in my case). The duration is one to two seconds, which doesn't seem long, but it's very distracting, especially if you use the keyboard (CTRL+PgUp/PgDn) to move six worksheets to the left, that takes 12+ seconds with a lot of flickering, which used to be instant. Big step backwards for users. If you don't see that issue on your machine, what is the difference? My machine is also precision quality with high end discrete gaming graphics and high end processor, and this issue and performance is identical on this machine as to my test machine which is a low end i3 commodity desktop with integrated graphics.

Scoring disabled. You must be logged in to score posts. Pete N 120.149.88.86 Retest No score for this post November 27 2014, 3:33 PM. I didn't have POV on (too much classic add-in still in me) Let me retest. I flick between tabs, there is a soft fade in (maybe 0.2 secs) of the POV bar, but it definitely doesn't flicker. This is a completely fresh install: - Win 7 64 bit (default settings) - Office 2013 64 bit (default settings) - Smartview 11.1.2.510 (build 042) (Only setting change is set column width) Hmmm.If I start abusing the POV bar (like putting IDescendants of a 7000 member account dim in it) it maybe gets a little slower to fade in with maybe the 'faintest' of flickers.

But we're talking 0.25 secs here, not the 8-12 secs you're seeing. I'm guessing you're on the latest smartview version? I'm on a reasonably old provider version (11.1.2.2.102) If you want I can throw some data against sample basic over the weekend and throw up a video on youtube. Definitely be interested in working this out, we've got a few clients planning a move to excel 2013 soon. Scoring disabled. You must be logged in to score posts.

Smart View Add-in For Excel 2013 Download

Raj 198.241.217.15 Office 2013 and Smartview 11.1.2.5.216 No score for this post March 10 2015, 4:15 PM. Raj, I am still recommending that users stick with Excel 2007. Some users have moved to Excel 2010 as a stopgap, which seems to be working fine. The problem with 2010 is that my enterprise skipped that version, so now we have three versions in the wild here, which makes support more difficult (Office patches, service packs, etc). To complicate matters, we're using MS 365 for Exchange hosting, and that, as well as some sharepoint features require Office 2013. Having multiple Office versions on a workstation is possible, but it introduces a whole new set of issues to work around. Thanks for posting your list of Oracle suggestions.

Have you tried this one: 1. Open the 'Ease of Use Center' (Windows+U, or type 'Ease' in the start menu search bar). Choose 'Use the computer without a display'. Place a check next to 'Turn off all unnecessary animations' I need to log another Oracle SR for this so we can get this addressed. Hopefully everyone who is dealing with this does the same so that Oracle will acknowledge this as a high priority defect with the software.

Smart View is the main interface for the EPM apps, and it isn't working very well! Even if MS caused this issue, Oracle needs to address it. Scoring disabled. You must be logged in to score posts. Raj 198.241.217.15 Re: No, but. No score for this post March 10 2015, 7:12 PM. I tried both option but still no luck 1) Instructions are to press Win+U (launches the ease of access center), click Use Computer Without a Display, then check Turn Off All Animations.

2)To improve user experience, you may disable Office Animations for 2013 by adding a key to the Windows Registry. To do this, create the Graphics and Disable Animations key. ◦Key Name: HKEYCURRENTUSER Software Microsoft Office 15.0 Common Graphics ◦Key Value: 'DisableAnimations'=dword:00000001 Scoring disabled.

You must be logged in to score posts. Justin 66.241.32.158 POV Flickering No score for this post April 14 2015, 11:08 AM. I don't think is is 'unpublished', but rather that it was just created. I was copied on the same email as Cameron as were quite a number of other people inside and outside of Oracle. The document is dated April 2015 and it is my guess that it just hasn't make it through the mechanism to be posted to the support portal. I think the email was intended to get the information distributed as soon a possible.

Tim Tim Tow Oracle ACE Director Applied OLAP, Inc Scoring disabled. You must be logged in to score posts. Pete 120.149.88.86 Re: Unpublished? No score for this post April 19 2015, 5:32 PM.

As an Oracle Hyperion and Oracle consultant for nearly a decade, I grew up with the Excel Add-In. I have used it on a daily basis for my entire career, and consider myself one of its most loyal devotees. I loved that it was simple to install and easy to learn. I have also appreciated the blistering speed and efficiency one could achieve after learning the keyboard shortcuts (Alt-X-S will bring up all of the shortcuts in Office 2007+). But as they say, all good things must come to an end, and that end came via Oracle Support Document ‘ID 1466700.1’: “As of January 1, 2013, Oracle Essbase Spreadsheet Add-In will no longer be available for general distribution with new releases of Oracle Essbase. Releases prior to January 1, 2013 should be considered a terminal release for Essbase Spreadsheet Add-In and customers should make preparations to migrate to for Office.” For years, Oracle Add-In loyalists like me feared this day of reckoning.

I had given Smart View a try in the early 9.x releases in 2007-ish. I was intrigued by the promise of further Office integration beyond Excel and hopeful for fixes to long-time Add-In annoyances like orphaned EXCEL.exe processes and the universally adored “disabled add-in” issue. Well, the grass is not always greener, and Smart View included a whole new host of annoyances to meet and greet (Let’s hear it for KeepAliveTimeouts and registry edits). It’s been about 6 years, and that is plenty of time for Oracle to improve Smart View, but I remained hesitant to give up my beloved Add-In. Then along came the 11.1.2.3x release that launched this past spring. Along with this update came something called the ‘Planning Admin Extension for Smart View’, which ended up being the catalyst for my switch.

While I love the Add-In, the opportunity to manage Planning hierarchies via Excel seemed too good to pass up. I find the process of manually adding members to Planning via the Web to be tedious and error prone, so significant improvements in this area was an offer I could not refuse.

Hyperion Planning Admin Extension Anyone who has added SUI Rates to Workforce Planning knows how brutal that process can be via the Web Client, so I wanted to see if Smart View made that process easier (it absolutely did). When you add a new member to Planning, the Web Client screen isolates you from other nearby members. This can make it difficult to keep Planning properties consistent as you need to constantly update myriad dropdowns, not to mention the annoyance of constantly changing the ‘Data Storage’ property inherited from the parent.

In the example below, it would be very helpful to see what property settings the other SUI Rate accounts have for comparison. Smart View makes this a lot easier.

Firstly, you can see the properties of nearby members and even copy/paste properties amongst members. You can also use Excel formulas to quickly concatenate new member names and even use freeze panes or auto filter functionality. In the example below, I can quickly create SUI accounts and easily paste all of the account properties from a previously created member to ensure they are all in sync. If you collect taxes in 50 states, this will save a significant amount of time compared to adding accounts via the Web Client.

Also, changes are highlighted in yellow and are not pushed to Planning until you hit ‘Submit Data’, which adds a level of comfort when making significant changes. I can even refresh Essbase via Smart View: If you are currently managing hierarchies manually in Planning, this will be a huge win and an efficiency boost to your process. I found it to be a massive time savings and less tedious process as compared to the Web Client. The newest Smart View versions are a game changer for anyone using. The ability to Plan in Excel while still leveraging Planning Security, Forms, Smart List drop downs, Task Lists, etc. Significantly improves the Planning experience for users.

Finance lives in Excel, and now we can bring Planning to them in their preferred medium. In the example below, we are looking at a Workforce Planning input form and can see the Task List in the panel on the right. Smart View even has the capability of running business rules and supporting user prompts, allowing the user to never have to leave the comforts of Excel. In the example below, we are adding a ‘to be hired’ to Workforce Planning which has a series of prompts and a corresponding business rule. All of these prompts are supported in Smart View as well as the ability to execute a discrete business rule. I have even found that large forms load faster via Smart View than the Web Client, but that may not be true for everyone.

When upgrading from prior versions of Planning, take time to see if Planning in Excel via Smart View might address pain points in your current process. In my experience, users love the Smart View Excel planning functionality. Essbase From an Essbase standpoint, Smart View achieved functionality parity in the long anticipated 11.1.2.1.102 release.

One of the best features is the new Ribbon with large buttons for different functions. This is a big win for the non-hot key crowd.

Download Smart View For Excel

Another big change is the beloved ‘Lock and Send’ has been replaced with the ‘Submit Data’ button. One cool new feature is that Smart View for Essbase keeps track of what cells are changed by turning them yellow (similar to Planning), which makes it easier to keep track of data changes before submitting.

In a touch of irony, I really do not have a lot more to add on the Essbase experience in Smart View, and that is a good thing. It replicates 99% of the Add-In experience, which is exactly what I was hoping it would do. Sure there are small changes here and there, and while I miss my hot keys, it replicates what people love about the Add-In, and a lot more for other products like Planning. Back to the Future In summary, I am now fully converted to Smart View.

I’ll miss the Add-In and look back fondly on our time together, but is the future: “Oracle Hyperion Smart View for Office is the strategic Oracle direction for office add-in for EPM & BI.” Well, I guess there is only one thing left to do POSTED BY: Patrick Caruso. Toan, The Add-In and Smart View fundamentally differ in how they communicate with Essbase. There is always a level of variability in performance from environment to environment, but there are certain settings you might want to try out in a development/test environment to address the large queries.

I would start with the following general troubleshooting steps to isolate the problem: -Is performance stable across multiple PCs in the same location? -If not, are they on different versions of Windows, Office, hardware? -Is one particular location performing poorly? -If so, does that location have worse bandwidth? Are intranet sites rendering slowly as well? -Are particular queries running poorly?

-If we re-create from scratch in a new workbook, are they faster? -If we split a large workbook into multiple smaller workbooks, do they speed up?