This content has been marked as final. Show 9 replies
So because I have Smart View (since I have the Hyperion menu available in Excel, but not the Essbase menu), I cannot use the Excel Add-in? Can I switch, because all the guides I have been following, as well as a book about learning Essbase, have referenced the Spreadsheet Add-in and walked through scenarios of things to do with the Add-in, not the Smart View. I am a beginner with Essbase and trying to learn what it does, so following simple tutorials and walkthroughs, like the one with The Beverage Company, are very helpful in my learning process.
I have seen some users do some things to make them both work on your machine.
If you want to keep it simple, go to Add/Remove programs and uninstall Hyperion Smart View. Then re-install the Essbase Client. Once that is completed you can open Excel and go find the Add In using the path mentioned above.
If you have the time Smart View has so much more functionality and is easier to use once some of the basics are set up.
user3x3 wrote:In addition to this file, you will also need:
- The Essbase Runtime Client
- An environment variable named ARBORPATH pointing to the the EssbaseClient directory; on my machine it is pointing to C:\Hyperion\products\Essbase\EssbaseClient.
- Your PATH environment variable needs to have %ARBORPATH%\bin in it.
You can have both the classic Excel add-in and Smart View installed simultaneously. You probably wouldn't want to use both simultaneously.
Applied OLAP, Inc
Issue with Excel add-in.
When i am trying to Add-in essxleqd and essexcln files to access Essbase through spreadsheet it is throwing an error as:
Excel Experienced a serious error the last time when the add-in 'hyperion essbase query designer was opened'
Please help me in resolving this error.
Edited by: user10720012 on Jan 27, 2009 6:22 PM
Till Jan 20th I worked on it and it was working fine, By then I have installed just Hyperion Analytic services, Client and Administration console of version 9.3.1.
On Jan 23rd I unistalled everything related to hyperion an installed freshly step by step to make planning work on my system which is having MS sql server 2005 and Windows XP as operating system. installing hyperion 9.3.1version
5.Reporting and analysis
After installing this, the essbase is working fine, but MAXL, ESSCmd and Spreadsheet is not working. I installed yesterday MS office 2003 and tried its giving me the same error. I have configured planning successfully but still the workspace is not showing the planning.
I uninstall 2007 ms excel.
lot of issues.. Pls sugget me anything else I need to do to make my system work fine, So that I can learn as much as possible.