Untitled Document

Website	gr8 website jonno, love it
Re: Website	hear hear! what happens now?
Re: Website	Thanks guys, the next task on the project plan is to recruit a few more Hyperion experts prior to the launch on 15/9.<br /><br />We have a few moderators lined up as well as a few already registered. Hopefully we can recruit a few more CHPs before the Go-Live date.<br /><br />Thanks again for signing up!
Re: Website	Why not post on network54?  Great board.
Re: Website	I agree Aleck, the Network54 sites, especially the Essbase forum have immense traffic. Yet to see what the search and navigation is like here, but first impressions are that this is long overdue - especially for people who are looking to monitor multiple applications.<br /><br />It would be great to see if we can entice discussion on how people are deploying cross products (and 3rd party non Hyperion), as well as getting Hyperion to offer advise and next generation options to assist in deployment decisions.<br /><br />Noel
Re: Website	Thanks for the feedback NG. My thoughts exactly. The HYPEd team believe in providing a free and general facility that would help users:<br /><br />-seek help<br />-retain knowledge<br />-interact<br />-enhance use of Hyperion products<br /><br />It's still early days yet and the layout/lookf-feel of this forum is by no means complete. But I guess a line in the sand has been drawn and we'd sure like to see if we can complement HDN as well as Network54 - it's not a competition. All three forums are great places to read up on Hyperion and all have their own unique strengths and weaknesses. <br /><br />Welcome aboard!<br /><br />Cheers,<br />Jon
Re: Website	I'd like to offer my own humble opinion on two things that were suggested on another forum (regarding this one).<br /><br />1) That it takes too many clicks to get to a message.  This is complete nonsense.  The format of network 54 would simply not be appropriate here.  The ability to quickly narrow your search down to a specific subset of messages is well defined here, and poorly defined there.  In both cases, you can do a search, but in this forum, you have the ability to wade through a significant number of categories and track issues of interest -- without wading through all those that are not of interest to you.<br /><br />2) That the site is too "colorful".  Again, complete nonsense.  A spreadsheet sitting on any analysts desktop will at various times be more bright/colorful than this site is.  However, I do agree that the selection of colors for 'solved' threads could use a little tweaking.  Toning it down wouldn't be a bad idea, I suppose.<br /><br />My question about #2 -- is it possible to leave the topic text the same and change just the title bar color?  If so, I'd say a slightly darker blue would be good, along with the "thumbs up", you have enough of a signal to "highlight" the thread.  I don't know if this is possible, though.<br /><br />The bottom line is that I like this format much better than HDN and Network54.  They all have their good points, but in terms of thread organization, this one is easier to navigate [i]in a useful manner[/i].<br /><br />-Doug<br />
Re: Website	I like the fact that there are other Hyperion products listed.  Even though people say Network54 is for all the Hyperion products, in my opinion, it's all about Essbase..
Re: Website	Thanks guys.<br /><br />First things first - I've amended the 'topics solved' background colour to an unobtrusive lavender(?I'm no graphic designer). Let me know what you think. That bright green was quite a shocker I must admit (it was the default setting) - not good for hangovers at all. Will see what I can do with the header and thumbsup gif.<br /><br />Thanks for the feedback on search and categorisation. We humbly concur. The criteria we used to determine forum software, style and all the touchy-feely stuff were:<br />- coverage for all Hyperion products (recognising that all requests for help are weighted equally and not biased by number of licenses or age of product)<br />- search functionality (as much as possible, allow users to quickly narrow down on product)<br />- cheap to run (obviously)<br />- easy to maintain/administer<br />- affords a few bells and whistles like Topics Solved and Applaud/Warn<br /><br /><br />The bottom line, however, is that all Hyperion forum users usually do so from work and as such have considerations such as firewalls, webpatrols and bandwidth. We thought that between the three or four forums already available for Hyperion, we could add a few more options so that any Hyperion user anywhere, can still seek help regardless of setup restrictions.<br /><br />Our thinking was always to co-exist. It's not about being better or worse, it's really about whether requests for help are answered and problems are solved.<br /><br />Love to hear more feedback.<br /><br />Jon
Re: Website	The multiple sections for different Hypeiron products was long overdue. This looks great!<br /><br />The only comment from my side will be, if it is possible to disable all the smilies and other formatting but only show up as text (i.e.) SMILIES...click on that all smilies will pop-up in a new window and so on. Since many contractors if they want to post and the smilies make it look like we are chatting, but that might just be @ my place. Anyways...if it is possible to add this option then that would be an great add-on....great job folks! :)
Re: Website	Thanks hypess. (btw I've updated your profile - thanks for your email)<br /><br />Will see what we can do with the forum software re emoticons. garycris was of the same opinion but we're a little hamstrung on tweaking this annoying little feature.<br /><br />I've re-ordered the categories placing BI before Apps as it seems the bulk of posts at the moment are in the BI section. Saves you from having to scroll down [u]although [/u] if you click on the arrowhead next to the Category header (twice) you can bookmark the resulting URL so it takes you there straightaway at launch. (how's that for a tip?)<br /><br />Appreciate all the support and feedback from the guys that have come over from Network54 to help out. We can only aspire to building a forum of such content quality.<br /><br />Don't forget to surf the posts for cries of HELP!
Re: Website	This change is really good as I feel that at any given time at least two-third's or more number of posts will be essbase centric. Also IMHO I thing the idea of separate sections for Analyzer, Reports, Visual Explorer, SQR and other reports based apps is a littkel too congested. If we can combine the reports forum into one and based on the volume of posts in the next three months you can decidee whether there is a need for separate forum or they can stay at one place. I like the idea of separate sections for every app, but I believe it is a little too congested. Just my 2 cents!<br /><br />Thanks Admin for the profile change. :)
Re: Website	Big day today....<br /><br />The HYPEd dashboard says:<br />7 new posts<br />12 new members<br />26 users online today<br /><br />[color=Orange][url]http://hyped.biz/community/index.php?action=stats;expand=200509#200509[/url][/color]
New section	Hi<br /><br />Can I suggest that a new board for scripts or downloads be made available?
Re: New section	I concur.<br /><br />The existing downloads section doesn't split out by product/purpose/type.  It would be nice to have a section that allows people to look for, say, MAXL scripts, or such.  There is also a big difference between a download section for utilities (like the stuff I tend to focus on), and downloads for patches and the like.<br />
Re: New section	OOps - sorry Dougware. Missed this post. Happy to re-structure the Downloads section. As the reigning 'Don of Downloads', you should have the major say in how you'd like to see it laid out.<br /><br />Let me know, and if the forum software allows it, then consider it done!<br /><br />Cheers
Newbie	I'm a newbie to Hyperion products having worked more with Oracle Financials. My introduction was to Essbase which I find a very good product.<br /><br />I like HDN but find the interface a little unfriendly so I am looking forward to making this my new Hyperion tech home  ;D<br />
Essbase vs Cognos	How does Essbase stack up against Cognos? (esp with their new reportnet product - has anyone used it?)
Re: Essbase vs Cognos	I've used contributor (cognos) and i find it a little clunky
Re: Essbase vs Cognos	i saw the demo from cognos (for powerplay and reportnett) - pretty good i think. quite flexible. commentary is easy to add
Re: Essbase vs Cognos	The two products exist in slightly different spaces within the B.I. architecture.  Cognos does overlap a lot with what Essbase offers, and so a comparison isn't completely out of the question, but most of the time, the full needs will determine which one is more appropriate.<br /><br />For instance, if you use an existing tool for data warehousing, and want a report tool that can handle multiple layers within an environment, Cognos is a slightly better fit.  On the other hand, if you have a lot of incoming data from various places, and need to give analysts write-back capability with less extensive reporting needs, Essbase is a better fit.  When you want "best of breed" in any one category, Essbase provides this within the analytical and consolidation stages, but leaves gaps on both ends that have to be filled.<br /><br />In the end, most companies will find Essbase to be more adaptible to analytical needs, and cognos more adaptible for reporting needs.  The current market favors Essbase because the gaps are easier to fill than overcoming the lack of a solid write-back capability.<br /><br />The question really isn't about which tool, but what the company is trying to use it for (where's the pain at?).  Knowing this, you can target the tool to the need, and then deal with the problem as a whole instead of as a selection of elements.<br /><br />Political issues can also weigh more heavily than technical choices.  Taking the "single supplier" approach has merit, leaving Cognos a bit short in comparison.  On the other hand, if you are a true blue "Microsoft shop", Cognos may be easier to slap into existing applications.  So no matter how you look at it, the answer isn't a slam dunk one or the other.<br /><br />However: with 2/3rds of the top 100 U.S. companies using Essbase, and a much smaller number using Cognos, you have to consider Essbase ahead on the popularity poll.  :)<br />
Re: Essbase vs Cognos	Did you guys read the article in the news box (top-right of screen) - Hyperion Essbase named as top ten technology innovation of the decade?
Re: Essbase vs Cognos	How about pricing ? <br /><br />I mean generally speaking !<br /><br />
Cancelled queries	We've just installed Essbase at work having migraetd from another tool - so we are all newbies. If a user closes the excel spreadsheet after kicking off a big query, will essbase know to cancel the query request?
Re: Cancelled queries	afraid not - the query will keep on running in the background even after Excel has been closed. If the query is a big one you might want to kill the request at the server end.<br /><br />hope it helps.
Re: Cancelled queries	A quick add-on to dummyhalf's post.  Essbase is a client-server configuration.  Users initiate from the client but the work is done on the server.  So if a user kicks off a query/report, calc script, or something like that, they can turn off their machine and go home while the process runs.  If you want to kill the request, you need to do it from App Manager or EAS (server side)<br /><br />Regards,<br /><br />Gary Crisci, C.H.P.<br />Senior Consultant<br />Pinnacle Group Worldwide<br />gcrisci@pgww.com<br />www.pgww.com<br />AIM: GaryPGWW<br />(800)403-0795 x8734<br />
Re: Cancelled queries	In order to prevent queries from running forever, there are configuration settings in the Essbase.cfg file - one of  them is QRYGOVEXECTIME - it allows you to set a maximum query duration.  You can also kill queries using EAS or MaxL, if one is running past a certain time.<br /><br />Hope That Helps.<br /><br />Jade
Re: Cancelled queries	Thanks everyone I will pass on all your comments to my team.
Error msg	"Analytic Services timed out while trying to perform an operation"<br /><br />this error happens every second or third day and is not consistent<br /><br />HELP! ???
Re: Error msg	This one could be a number of things:<br />- network issues<br />- installation/configuration<br />- bad data<br /><br />Have you any more information? Was there a recent software/hardware upgrade? etc?
Re: Error msg	It seems to occur on one particular workstation albeit in a random pattern. PC is running the SOE without any strange additional software that I can see.<br /><br />We can probably rule out data corruption as other workstations can access the reports/data.<br /><br />Thanks for the tip re network issue - never occurred to me. Will run some tests in this regard.<br /><br />THANKS!
Re: Error msg	Have a look at this link:<br />[url]http://essbase.com/techdocs/essbase/essbase_71/Docs/errmsgs/erhelp.htm[/url]<br /><br />It might be your NETDELAY and NETRETRYCOUNT settings, but the article has a few other suggestions.
Re: Error msg	thanks dummyhalf
ETL functionality in Essbase?	our company got taken over recently and in the resulting integration, essbase was picked as the reporting tool-of-choice. it currently sources its data from our largish sales datamart via our existing (shonky)proprietary reporting tool. does essbase have any ETL functionality that we might be able to use and so bypass our in house tool?
Re: ETL functionality in Essbase?	Well, load rules have limited ETL capability, but Essbase is not an ETL tool.  They can do character replaces, change case, do basic sorting, but that is about it.  Depending on what kind of data manipulation you are needing, you might have to look at using a staging database or some other ETL products like Informatica, etc.<br /><br />Most ETL processes can be handled using SQL and perhaps even other scripting languages like Perl, but some of the ETL products out there make it a lot easier.<br /><br />Regards,<br />Jade
Re: ETL functionality in Essbase?	There are a couple of options.  <br />Essbase uses load rules to take text files from any source and manipulate them to be loaded into your cube.<br />There is an SQL interface that lets you query SQL databases and load the results directly into your cube.<br />Hyperion offers a data integration connector for SAP, but this requires you use Essbase Integration Services as well, so that starts to get into a really large initiative.<br />Then there is Hyperion Application Link (HAL) an add-on product that uses adapters to link data from multiple sources to Essbase.<br />Lastly, there are third party solutions such as UpStream that will do this for you.  UpStream happens to be an excellent product.<br />Your best bet is to discuss with your sales rep or a qualified consultant to determine what best fits your needs.<br /><br />Hope that helps<br /><br />Gary Crisci, C.H.P.<br />Senior Consultant<br />Pinnacle Group Worldwide<br />gcrisci@pgww.com<br />www.pgww.com<br />AIM: GaryPGWW<br />(800)403-0795 x8734<br />
Re: ETL functionality in Essbase?	Thanks guys - that's a great help. I apologise JCole, for not being able to Accept both replies(!)<br /><br />We have a guy on the team that is keen on Informatica given his background with it but I think Architecture might dictate we keep everything 'integrated' ie. minimise vendors and customisations. But I will also investigate using PERL/SQL. But thanks for that.<br /><br />Garycris - thanks for the tip on HAL. this might end up being the most politically correct choice if it's not too hard to implement.<br /><br />.....many more questions to come.......<br />
Essbase Helper	[b]E[/b]ssbase [b]H[/b]elper ([b]EH[/b]) is a supplemental add-in for Hyperionâ€™s Essbase add-in for Excel. Its primary function is to enhance Essbase connectivity by managing connections transparently (while navigating around your workbooks).Â <br /><br />Templates with multiple retrievals are made "safer" and easier to use because [b]EH[/b] will ensure that you never erroneously perform an operation against the wrong database, such as when a previous connection times out at the server and another current connection is substituted without your knowledge.Â <br /><br />Besides managing the connectivity to the appropriate database, [b]EH[/b] manages multiple template areas within a single tab, and ensures that each area be dealt with without having to manually select the range of cells to act against.Â In addition, each area can be flagged as read-only, and also remembers its own individual Essbase settings.<br /><br />Additional features include the ability to automatically locate the current member when you open the member selection dialog (a mild but common pain when making selection changes), and the ability to disable Essbase menu items that represent inappropriate operations (ie, the lock/send functions when the active area is defined as read-only).<br /><br />[b]EH[/b] was designed for the userâ€™s convenience, and can be fully operated via a simple toolbar, the Essbase menu, and (in the fully registered version) programmatically via a fully documented VBA object model. The key benefits of this add-in are in the simplicity it offers to the user, reducing time, errors, and maintenance effort.<br /><br />[b]NOTE: [/b] The current version has a cosmetic bug in the installer, which causes the documentation file icon to launch the configuration tool instead.Â An updated version will be forthcoming soon.<br /><br />-Doug<br />
Re: Essbase Helper	Great app DougWare!
Re: Essbase Helper	I have had this app for a little while now (from Hyperion forum) and I think it's very good. Love your work.
Re: Essbase Helper	Thanks guys, feel free to let me know what you think about the others.  I take constructive criticism well, so don't hold back.  :)<br /><br />There are a couple of fixes needed in HE, but mostly cosmetic (like errant notices that an area overlaps when it doesn't).  I'm also tempted to roll Zoomer into HE entirely, since Zoomer is such an simple item.  Alas, my evenings and weekends are already too busy for making many changes on these tools (mostly writing game add-ins in small).<br /><br />-Doug<br />
Essbase Zoomer	Essbase Zoomer is a simple add-in that augments the Essbase addin for Excel.  It expands the Zoom menu to allow you to choose the level you are zooming, as well as changing zoom-related toggles -- without going in and out of the Essbase options dialog.<br /><br />For serious ad-hoc operations, Zoomer will allow you to navigate without wearing your finger out (via constant double clicking), making it faster as well as easier.<br /><br />-Doug.<br />
DougB's Outline InfoTool	This is a simple workbook which makes it easy to extract outline information.  No magic, just easy to use convenience.<br /><br />-Doug<br />
Re: DougB's Outline InfoTool	I tried this utility but kept getting outline errors.  Is there a different instruction sheet available?
Re: DougB's Outline InfoTool	I'm pretty sure this utility won't work with V7.x outlines (saved via EAS, at least).<br /><br />I don't have access to the V7 api yet, but when I do, I'll upload a new version for V7 (I don't know if any new functionality will be added -- it all depends on what changes were made in the API).<br /><br />Sorry -- I was really looking forward to V7, but it's certainly not being kind to me.  ::)
Security Workbook	This is a relatively simple workbook with code to automate retrieving and updating Essbase security information.Â It's very good for documenting the current security state, and even at realligning users and groups.<br /><br />[color=Red]Caution[/color]: Use at your own risk.Â I say this not because it's a risky tool, but because it can be mis-used too easily.<br /><br />-Doug<br />
Re: Security Workbook	It has come to my attention that one of the references to the version above may cause it to not work well on some versions of Office.  The version attached here should remove that issue (please let me know if otherwise).<br /><br />-Doug<br />
Re: Security Workbook	You've been a busy boy dougware!<br /><br />Great output.
Re: Security Workbook	<br /><br />We got error while using this vba application -- 'esbapin.dll can not be found'.  esbapin file is found under hyperion\essbase\bin folder. Wondering if this can be fixed.<br /><br />Thanks a lot.
Re: Security Workbook	sounds more like a local problem than something Doug has done. <br /><br />Check that the X:\hyperion\essbase\bin directory is in your path ... and that system variable ARBORPATH is set ... <br /><br />
Essbase and Adobe compatibility	Has anyone experienced any compatibility issues between the Excel add-in and Adobe add-in? One of my users complains of mysterious machine locking and the only difference I could find in the PC image was Adobe. I have not been able to replicate on another machine and it does not happen 'on-demand'.<br /><br />Thanks in advance.
Re: Essbase and Adobe compatibility	I've run the Essbase addin v6.5 through v7.1.2 with Adobe Acrobat 5 and 6 and haven't had any problem.<br /><br />I can't say it is not responsible for the problem you are having, but I figured I would mention it hasn't been a problem for me.<br /><br />Best of luck trying to resolve.<br />
Re: Essbase and Adobe compatibility	We had users who could not view large pdf docs off the web using adobe.  They were getting the reports from Hyperion Reports, but the problem turned out to be a modification to the windows registry on every machine in the corporation that limited the bandwidth usage of each machine.  <br />This resulted in the PDF not displaying on the user's machine as desired.  It may "look" like a computer lock up situation , but the user could do other things just fine, it's just the PDF never displayed.<br />The fix of course was to remove the windows registry change from their computer so they could view larger PDF documents via internet explorer.<br />Otherwise, our users have used Adobe and Hyperion for years without any conflicts.
Re: Essbase and Adobe compatibility	Thanks very much for your replies. I will definitely try the registry suggestion.
Introduction to Hyperion: Article	Introduction to Hyperion <br /><br />* What is "Hyperion"?<br /><br />Hyperion(r) is the global leader in Business Performance Management<br />Software.Â More than 9,000 customers â€“ including 91 of the Fortune 100<br />â€“ rely on Hyperion software to translate strategies into plans,<br />monitor execution and provide insight to improve financial and<br />Operational performance. Hyperion combines the most complete set of<br />Interoperable applications with the leading Business Intelligence<br />platform to support and create Business Performance Management<br />Solutions. A network of more than 600 partners provides the company's<br />innovative and specialized solutions and services.<br /><br />Named one of the FORTUNE 100 Best Companies to Work For 2004, Hyperion<br />employs approximately 2,500 people in 20 countries. Distributors<br />represent Hyperion in an additional 25 countries. Headquartered in<br />Santa Clara, California, Hyperion generated annual revenues of $622<br />million for the 12 months that ended June 30, 2004.Â Hyperion is<br />traded under the NASDAQ symbol HYSL.<br /><br />For more information, please visit www.hyperion.com,<br />www.hyperion.com/contactus or call 800 286 8000 (U.S. only).<br /><br />Please visit: http://www.hyperion.com/company/overview/<br /><br />* What is BPM?<br /><br />Business Performance Management is one of the fastest growing and most<br />strategic categories of enterprise software today.<br /><br />A category of technologies and practices that enables organizations to<br />translate strategies into plans, monitor execution and provide insight<br />to improve financial and operational performance.<br /><br />* What Is Business Intelligence?<br /><br />Business intelligence is a category of software that enables companies<br />to access, analyze and share information to understand how their<br />business is performing. Business intelligence provides individuals<br />with access to historic information from a wide variety of sources and<br />tools for analysis and statistical predictions. The result is improved<br />decision making, leading to better operational performance.<br /><br />__Please visit: http://www.hyperion.com/products/bpm_suite/glossary.cfm<br /><br />________________________________________<br /><br />* Business Info: Hyperion Solutions Corp. (HYSL)<br /><br />1. CBS MarketWatch (HYSL)<br /><br />http://www.marketwatch.com/tools/quotes/quotes.asp?symb=HYSL%20&siteid=mktw&dist=mktwqn&cbsReferrer=www.answers.com<br /><br />2. CNBC MSN Money (HYSL)<br /><br />http://moneycentral.msn.com/scripts/webquote.dll?ipage=qd&Symbol=HYSL<br /><br />3. CNN Money (HYSL)<br /><br />http://money.cnn.com/quote/quote.html?shownav=true&symb=HYSL<br /><br />4. Yahoo (HYSL): Quotes Info<br /><br />http://finance.yahoo.com/q?s=HYSL&d=v1<br /><br />5. Hyperion Jobs Average Salary & Contractor Rates <br /> <br />http://www.itjobswatch.co.uk/skills_and_rates/hyperion.do<br /><br />___________________________________________<br /><br /><br />* Hyperion News:<br /><br />1. Business Directory<br /><br />http://www.business.com/directory/computers_and_software/software_applications/enterprise_resource_planning_erp/hyperion_solutions_corporation<br /><br />2. Google Latest News<br /><br />http://news.google.com/news?q=Hyperion+Solutions+Corp.&btnG=Search+News&hl=en&edition=us&ie=UTF-8&oe=UTF-8<br /><br />3. Market Watch<br /><br />http://aolpf5.marketwatch.com/tools/quotes/profile.asp?<br /><br />_____________________________________<br /><br /><br />* Hyperion Products:<br /><br />A.HYPERION BI PLATFORM<br /><br />1. Hyperion Analyzer<br />http://dev.hyperion.com/products/analyzer/<br /><br />2. Hyperion Application Builder<br />http://dev.hyperion.com/products/application_builder/<br /><br />3. Hyperion Application Link<br />http://dev.hyperion.com/products/application_link/<br /><br />4. Hyperion Essbase<br />http://dev.hyperion.com/products/essbase_analytic_services/<br /><br />5. Hyperion Master Data Management Server<br />http://dev.hyperion.com/products/mdm/<br /><br />6. Hyperion Metrics Builder<br />http://dev.hyperion.com/products/metrics_builder/<br /><br />7. Hyperion Objects<br />http://dev.hyperion.com/products/objects/<br /><br />8. Hyperion Performance Suite Intelligence, SQR<br />http://dev.hyperion.com/products/performance_suite/<br /><br />9. Hyperion Reports<br /> http://dev.hyperion.com/products/reports/<br /><br />10. Hyperion HUB<br />http://dev.hyperion.com/products/hub/<br /><br />B.HYPERION APPLICATIONS<br /><br />1. Hyperion Pillar<br />http://www.hyperion.com/products/applications/planning_budgeting_forecasting/pillar/<br /><br />2.Hyperion Planning<br />http://dev.hyperion.com/products/planning<br /><br />3. Hyperion Financial Management<br />http://dev.hyperion.com/products/financial_management/<br /><br />4. Hyperion Enterprise<br />http://www.hyperion.com/products/applications/consolidation_reporting/enterprise/<br /><br />5. Hyperion Business Modeling<br />http://dev.hyperion.com/products/business_modeling/<br /><br />6. Hyperion Business Rules<br />http://dev.hyperion.com/products/business_rules/<br /><br />7. Hyperion Performance Scorecard<br />http://dev.hyperion.com/products/performance_scorecard<br /><br />8. Hyperion Strategic Finance<br />http://dev.hyperion.com/products/strategic_finance<br />_________________________________________<br /><br /><br /><br />Thanks to:<br /><br />My Family members<br /><br />Jon HYPEd administrator <br /><br />Kimberley Bermender<br />Sr. Manager, Marketing<br />Hyperion Solutions<br /><br />John Kopcke<br />CTO Hyperion Solutions<br /><br />Adam Souza <br />HDN Hyperion Solutions<br /><br /><br />Note: "Portions provided by Hyperion Solutions Corporation are<br />Copyright 1996 to 2005, and are used with permission of Hyperion.<br />Hyperion, the Hyperion "H" logo, and Hyperion product names are<br />Trademarks of Hyperion.Â The views expressed in other than Hyperion<br />Provided materials are not necessarily the views of Hyperion."Â <br /><br />About me:<br /><br />Iâ€™ve Bachelorâ€™s Degree in BS (Computer Science).<br /><br />I've Experience with Hyperion Products Essbase Planning Analyzer HAL Reports HFM etc.<br /><br />Iâ€™m Hyperion Tech Author.<br /><br />Hobbies:<br /><br />Writing Hyperion Tech Articles Yoga Writing Stories PoliticsÂ Â Loving NewEngland PatriotsÂ Cartoonist.<br /><br /><br />
Download Hyperion Technical Documentation	Hyperion provides technical documentation for a number of their products through their developer's website.  Click on the following link to browse the different products and download installation guides, administrator guides, technical references, etc.<br /><br />[u][url]http://dev.hyperion.com/resource_library/technical_documentation/[/url][/u]<br /><br /><br />If you don't find what you are looking for there, post a request and if we have it, we'll forward it to you.<br /><br /><br />Regards,
Problem attaching files/downloading attachments	Hi All,<br /><br />dougware and garcris was kind enough to drop me an email saying that some user groups on the forum did not have permission to view/attach files. I have since found the setting at fault and rectified. Please let me know if there are any other teething problems - great to flush out before official launch!<br /><br />Thanks guys!<br /><br />Jon
Re: Problem attaching files/downloading attachments	Hi there<br />Yesterday I had no problems downloading utilities, but I am having a particular problem downloading Essbase Zoomer today. I log in as normal, and just before clicking on the download file I can see my login name at the top of the screen, so I know that \|I am successfully logged in. As soon as I click on the download file, I get taken to a screen where it asks me to log in again. <br /><br />Regards<br /><br />matthu
Topic solved : the mysterious green color	Query re the mysterious green background on certain posts. 'Topic solved' is functionality that is available on this forum (most boards other than general discussions etc). If you start a new topic in a tech board, you have the option to nominate whether or not a reply has helped fix the problem described (signified by a tick image on your original topic that only the topic starter can see). Once topic has been deemed 'solved' the poster with the most relevant reply will have that post highlighted in green and the big thumbs up icon will show at the board index level.<br /><br />thanks for the query garycris - i see you have a thumbs against your posts already. well done and thanks for helping out!
Essbase as a datasource	Hi,<br /><br />Our reporting setup is DBs = Sybase + mainframe, ETL = Informatica, BI = Business Objects. We have been asked to extend our reoprting framework to include another part of the business that uses Essbase.<br /><br />I was wondering if we can use Essbase as a datasource.<br /><br />thanks
Re: Essbase as a datasource	Is this what you had in mind?
Re: Essbase as a datasource	Perfect!<br /><br />thanks
Apologies for site downtime	The webhost had to reboot the server.<br /><br />Apologies for the inconvenience caused.
Downloads enable/disable	Sorry dougware,<br /><br />I had the master 'attachments' setting set to "disable".<br /><br />Please try again.<br /><br />Apologies for the runaround. We'll get this site running right eventually!!!!<br /><br />Jon
Hyperion Essbase Auto-Processor (HEAP)	Background: <br /><br />One of the departments here runs 3 calc scripts in succession for each organization that updates data, but needs to define substitution variables that are specific to each run.  The need is known up front, but varies in a way that makes it difficult to 'bake' the business logic into an independent process.  As a result, they have to perform as many as 160 seperate manual steps (set variables, run calcs, repeat type stuff).  This process was not just manually exhaustive, it was error prone and time intensive (sometimes spanning 16 hours of effort or more).  To top this off, they needed to run this cycle multiple times each month!<br /><br />HEAP was designed to automate this long sequence of steps.  It was not meant to be a full automation tool, just a client utility to make variable and alias dependent calc scripts easier to manage.  Although this tool was developed rapidly (less than 10 hours, including the instructions and demonstration), it proved to be invaluable to the department mentioned above, saving a significant amount of time as well as effort.<br /><br />Will this benefit your organization?  Possibly, but it's probably more likely to be a good example of how a rapidly developed tool can benefit your own specific needs.  Even though I spent less than a day in coding, it's very well designed and commented, so if you're just getting your feet wet into Essbase automation, it's also a good start.<br /><br />Then again, you may find a good use for it as it is.  :)<br /><br />-Doug<br />
Re: Hyperion Essbase Auto-Processor (HEAP)	Thanks - it's a great case study in scripting an automation function.
Best practice on cube development	We're getting our first few development requests from our users and are looking at building a few cubes. I was wondering if there are any best practice guidelines on:<br />[list]<br />[li]size of cubes[/li]<br />[li]number of dimensions[/li]<br />[li]number of members[/li]<br />[li]any other performance considerations[/li]<br />[/list]
Re: Best practice on cube development	Hi There,<br /><br />That is quite a big question to answer.  We were there about 9-10months ago and there's still plenty to learn.  Is it possible for you to go on a course do you have any manuals?<br /><br />If not go to the Help dropdown and select on the Administrator Guide, this should get you started.<br /><br />As Confucius said....."Every journey starts with a few small steps!"<br /><br />Good luck<br /><br />Mark
Re: Best practice on cube development	Ahh, the perennial question ... one closely related to how long is a piece of string â€¦ and the lack of an answer is precisely what keeps many of us employed. <br /><br />The motherhood replies are along the lines of <br />[list]<br />[li]As small as you can get away with[/li]<br />[li]As few as possible[/li]<br />[li]Ditto[/li]<br />[li]Yes, plenty[/li]<br />[/list]<br />respectively.<br /><br />I often find that a large part of my job is simply to reduce the number of dimensions from what the users initially believe is necessary. To some extent this need has been lessened since attribute dimensions came along, but it still basically holds true.<br /><br />The measurable elements we know improve performance are:<br />[list]<br />[li]block sizes between 32k and 64k (max 128k) bytes[/li]<br />[li]â€œhour glassâ€ dimension order from largest dense to smallest dense, smallest sparse to largest sparse, then the flat sparse dimension like scenario, version, etc, and finally the attribute dimensions[/li]<br />[li]Dynamic calc within blocks and for all non level 0 members of dense dimensions[/li]<br />[li]As few as practicable cross dimensional calculations[/li]<br />[/list]<br />There are many more hints and clues but youâ€™d be better served to ask more specific questions<br /><br />But, it really does depend upon your businesses requirements. Then the bigger task of performance tuning really is an art â€¦ and something for another timeâ€¦<br /><br />It you insist on some hard numbers (and no science) then ...<br />[list]<br />[li]keep the fully populated cube size below 100Mb[/li]<br />[li]"real" dimension to 4-6, "flat" dimensions to 1-3, as many attribute as you want[/li]<br />[li]accounts dimension to up to 500 pysical members[/li]<br />[li]most other ("real") dimensions to less that 100 members[/li]<br />[/list]<br />But I've also had 50Gb cubes with 12 dimensions and 500,000 members in one of them! You do what is necessary.<br /><br />And as mentioned elsewhere ... read the manuals because some of the content is actually quite good. And consider other training or involving experienced help ... a little spent now may save a lot in the future. Good luck.Â :)<br /><br />(There's a term for what I'm calling "flat" dimensions - can't think of what it is.)<br />
Re: Best practice on cube development	Good stuff - it took me a long time to understand why a lot of those points are important.<br /><br />One excellent resource I found early on was IBM's Redbook on DB2 OLAP (DB2 OLAP is the IBM-branded version of Essbase) at [url]http://www.redbooks.ibm.com/abstracts/sg246138.html?Open[/url].  It covers a lot of the points Chris raised, plus it has some moderately interesting examples and case studies.<br /><br />BTW, Chris: I think the term you're looking for for "flat" dimensions is "non-aggregating" -- that's what it's called in the training anyway :)
Re: Best practice on cube development	Granted, this is just one caveat of an almost infinite list, but I found this particular one to be often over looked, so I thought I'd use it to make a point.<br /><br />An alternative view on the dynamic calc statements above may apply in several situations (balancing disk size/calc requirements along with retrieval, for one).  Instead of (or in addition to) making all dense dimension roll-ups D-C, you can focus on the smallest dimensions (both sparse and dense).  Typical (if there is such a thing) calc requirements in large dense dimensions, coupled with typical smallest sparse dimension layout, often makes it advantageous in terms of both calc time and disk space.  Then, depending on the largest dense dimension, you might benefit some by keeping it stored.  <br /><br />To understand why this is so, you only need to picture a relatively "ideal", but also somewhat typical, case:<br />  - Dense Dimension 1: 900 Level 0, 90 Upper Level members<br />  - Other dense dimensions<br />  - Sparse Dimension 1: 30 Level 0, 10 Upper Level members<br /><br />The increase in block size (discarding compression) for making the switch is at most 10%, while the overall decrease in page file size (again, discarding compression) is very nearly proportional (or about 25%) to the reduction.  The increase in page size also has much less impact on calc time compared to the sparse reduction, making a similar reduction in calc time (not 25%, but a fairly good proportion of it).  On top of this, the larger dimensions (dense especially) tend to have more complex requirements and calculations tied to them (in particular to the upper level members, or D-C candidates), in my experience, anyway.<br /><br />To summarize, there are no hard and fast rules, and I agree with everything said so far -- the caveat above is only one of a very large number of things learned through hard found experience, which is one good reason why forums on Essbase (in particular) are so popular.<br /><br />Just one side note, then I promise to shut up.  I once had a database that was optimized in such a way that optimum performance was obtained with a layout that did [b]not[/b] follow the "hourglass" layout, and to top it off, it had a block size well over 1 Meg.  All attempts to reduce the block size or reshape the cube caused a significant reduction in performance.  Don't read this as a violation of the "optimum" block size guideline, only that once again, there are really no hard and fast rules for all situations.  In the case of block size recommendations, however, the exceptions are very rare indeed -- but they do exist.<br />
Excel performance enhancement tips	We have been handed this task of optimising the performance of an Excel/Essbase workbook that was built by a power-user from the finance dept (who has since left - sound familiar?) and it's a beast. Multiple worksheets, charts, links, links to links, macros, and calculations.<br /><br />Short of rebuilding it fom scratch, are there any performance enhancement tips? (We run Excel2003)
Re: Excel performance enhancement tips	HDN has an article on optimising calculations:<br /><br />http://dev.hyperion.com/resource_library/tips_faqs/client_and_server_calculations/essbase_optimize.cfm
Re: Excel performance enhancement tips	I have always found charts reduce performance. If there was any way to quarantine the presentation layer type stuff then it allows you to segment the core processes.
Planning/Essbase on Unix/Solaris	Does anyone have Essbase running on Unix/Solaris?<br />We have managed to get Essbase installed and running, but not successfully been able to create applications. This will be the production environment for Essbase and Planning databases.<br />Cameron suggested it could be a permissions issue, but so far nothing has been proven despite multiple cheks.<br />TIA<br /> ???
Re: Planning/Essbase on Unix/Solaris	Its working.<br />We needed to add a pile of variables, which unfortunately were not requested!<br /><br />This was added over what had defaulted:<br />ODBCINI=$HYPERION_HOME/common/ODBC/Merant/4.2/odbc.ini <br />export ODBCINI <br />ESS_JVM_OPTION1=-Xusealtsigs <br />export ESS_JVM_OPTION1 <br />ESS_CSS_JVM_OPTION1=-Xusealtsigs <br />export ESS_CSS_JVM_OPTION1
Re: Planning/Essbase on Unix/Solaris	Care to share? It's an unusual configuration
Re: Planning/Essbase on Unix/Solaris	Have you checked the extra environment variables listed in $ARBORPATH/hyperionenv.doc have been set, and that they point to the right locations?  Has $ARBORPATH/bin been added to the PATH variable for the user that runs the ESSBASE executable?<br /><br />(ODBC is a whole other adventure, but I don't think that ODBCINI value looks right -- you're supposed to write your own odbc.ini to include the data sources you want to have available to Essbase, and the supplied one is just an example.  It shouldn't stop the applications from starting though - you just wont get any data sources listed in the rules file editor after choosing "Open SQL".)
Excel Right Click Cell Menu	please find attached an xla (in the zip) that adds a right click cell menu to excel.<br /><br />needs standard essbase add in and you need to turn of right click in essbase/options.<br /><br />this is a cut down version of a working xla I have which does far too much (specific to clients) to post it all here ... but this is one of the more useful bits. If there are problems please let me know.<br /><br />should work on any V5 or later version of essbase.<br /><br />Chris
Re: Excel Right Click Cell Menu	Thanks for sharing.Â This should really help navigate Excel with Essbase. :D
Re: Excel Right Click Cell Menu	It works great but I do not see a big advantage in comparisment with the Essbase toolbar button. Takes as many clicks as it does with the plug-in you made and has almost the same options. I rather have a small toolbar at the bottom of my excel workbook with some recognisable buttons.
Re: Excel Right Click Cell Menu	Mate, you're missing the point (and I'm trying not to take this personally) <br /><br />1) If you can do the variety of drill options in as many clicks be my guest; <br /><br />2) I'm a big user of the right mouse button and, at least till v7, the essbase addin wanted hold of the mouse too much for my liking<br /><br />3) The code is open - modify it to be whatever you want it to be - like I said this is cut down from the original. It could be used to create a toolbar like you suggest rather than a menu - the code ain't that different.<br /><br />Use, Change, Experiment and if you get stuck or need help ... ask.Â :)
Re: Excel Right Click Cell Menu	Crist,<br />this right menu is interesting option. Is it posible to have both functionality - your right menu and Hyperion functionality?<br /><br />I would like to have your option on right mouse click, but for example pressing Ctrl+right click it would enable Hyperion functionality - pivoting and drill up.<br /><br />So my question: is it posible to have both options?<br /><br />Thanks,<br />Grofaty
Re: Excel Right Click Cell Menu	I don't think so, no.<br /><br />The code is not capturing the right click itself so much as changing the menu Excel dispays when it captures a right click in a cell.<br /><br />And I'm not sure if the right click action also passes a control key value, but I think it would be vastly more difficult than what is here. <br /><br />But my code is not protected ... so if you solve it I'm sure others would be interested.<br /><br /> ;) <br />
Outline Comparison Tool	This creates an Excel workbook that shows detail changes between two outlines.  The outlines may be stored anywhere (locally or on any server) to be compared, and it does a very thorough job of listing changes.  <br /><br />This is a "somewhat" matured utility -- I would still like to add the ability to skip specific checks (like comparing formulas, storage attributes, etc.), and add the one "missing piece" to the comparison (it only compares the default alias table, not the others).  But I could probably use some feedback before investing any time on this tool.<br /><br />-Doug<br />
Re: Outline Comparison Tool	Seems to have a problem with Attribute dimensions:<br /><br />A1234567 "Changed """" Attribute:<br />Old Value: ""Function F""<br />New Value: ""Company C"""<br /><br />A1234567 "Changed """" Attribute:<br />Old Value: ""Region R""<br />New Value: ""Company C"""<br /><br />A1234567 "Changed """" Attribute:<br />Old Value: ""Area A""<br />New Value: ""Company C"""<br /><br />A1234567 "Changed """" Attribute:<br />Old Value: ""No Line""<br />New Value: ""Company C"""<br /><br />Each of these are different Attribute dimensions (Function, Region, Area, Line, Company) associated with the Organization dimension in my outline.
Re: Outline Comparison Tool	I'll check this one out tonight -- obviously it's missing the attribute dimension name (in the empty quotes), so it's comparing each attribute to the same one.  I probably did something to it last night when I tried to make it work with all alias tables (and got too tired to finish, so I ended up commenting a lot of it out).  <br /><br />Anyway, thanks for the heads up.<br />
Re: Outline Comparison Tool	Thanks for the quick response. Looks very nice and has already answered a question I had on a particular database today.<br /><br />Do you make your source available also? Not trying to compete with you, just trying to learn more about api coding. No biggie if not, just checking.
Re: Outline Comparison Tool	For a lot of my code, I allow people to use it for their own purposes.Â This isn't to prevent them from modifying it to their needs, but to keep warring versions from existing through derivative releases.Â In other words, don't let me catch blame for changes made by others, or let others take credit from the original work done by me.Â Simply put: for personal use only, and sharing is limited to your organization.<br /><br />Some of my code I protect somewhat more.Â The outline comparison "core" is one of these, as there is a whole lot of effort that goes into some of the obscure aspects (for instance, recognizing situations were a member was renamed by matching the alias up).Â It looks simple in english, but the actual logic is anything but.<br /><br />If you are looking for a simple comparison, you could easily modify the code in the Outline Info Tool to do this.Â It's not what I refer to as a "signature tool", so the code is open (although the version available here is slightly dummied up for that purpose, it has what you need to create an OtlComp "light").<br /><br />I created another tool similar to this (OtlSync), which replicates hierarchy changes from one outline to another.Â It uses coded UDA's to allow exceptions for every imaginable situation.Â This tool isn't quite ready for exposure to the public yet, but I may upload it sometime down the road.<br /><br />Yet another "signature tool" is actually a built in utility menu that operates like a DBA "swiss army knife" -- and it contains almost all of the stuff I've uploaded here, and more.Â I'd like to make this available, but it needs a lot of redevelopment for this to happen.Â Still, I tend to let people I trust use it.Â Some of it's functions:<br />Â Â - Display Server/App statistics<br />Â Â - Display Server loading<br />Â Â - Edit server substitution variables<br />Â Â - Display access statistics (from log file, broken down and categorized)<br />Â Â - Display calc statistics (similar to above, different details/focus)<br />Â Â - Display database statistics (this is a summary of database settings)<br />Â Â - Display optimum calc cache size (simple calc from outline)<br />Â Â - Compare outlines (same as this tool)<br />Â Â - Create security dump (similar/more complete than the security workbook)<br />Â Â - Restore security dump (uses output from above)<br />Â Â ... and some misc. toggles and such<br /><br />So although I wouldn't give you the full source code to [color=Blue]otlcomp[/color], there are a lot of tools I've done over the past 10 years that I don't mind people getting the code for -- assuming you promise that it's for your own use.<br />
Re: Outline Comparison Tool	Fully understand. I have not pulled down the Outline Info tool yet, so did not know code was visible. I am not so much looking for the internals of the comparison logic; more interested in seeing examples of good Essbase api coding. I have done a little myself (for example wrapped Essmaxl.dll for Python as I don't care for Perl), and have seen some of the stuff from Solutions, but always nice to learn from the work of others who have gone deeper.
Re: Outline Comparison Tool	I've tried to replicate a situation similar to what you've reported, and couldn't (it worked as expected on multiple attributes defined).<br /><br />Is it possible this was a one time glitch (some possible error that didn't get trapped, perhaps)?<br /><br />Also, did you use outlines from client, server, or one of each?<br /><br />Finally, which version are you using?Â (I tested this on 5.1 and 6.2 so far).<br /><br />Thanks again,<br /><br />-Doug<br />PS: I've confirmed the code in the outline info tool is not locked.
Re: Outline Comparison Tool	Server outlines, Essbase 6.5 Patch 6 on Windows 2000. All of the Attribute dimensions are Text attributes. They are the only Attribute dims in the database and all are associated with the Organization dimensions. Seems to be repeatable.
Re: Outline Comparison Tool	Would it be possible for you to send the outlines to me for debugging/testing?  <br /><br />My (anti-spam mangled) email address is [color=Blue]dbliss (at) wide open west (dot) com[/color].<br /><br />Just do the obvious -- remove the spaces and replace the (at) and (dot).<br />
Re: Outline Comparison Tool	Doug,<br /><br />Would it be possible to get some of those tools for use here at my organization. I am not a consultant, just a squirrel trying to get a nut.<br /><br /> :-*<br /><br />Thanks<br /><br />Sal
Re: Outline Comparison Tool	I don't want to make this sound like a big deal -- but I'm reluctant to send it to anyone I don't really know.  I've seen people get in trouble when their company finds out they have "unsupported software" installed, and depending on the company and software, it can become an issue.  Most of these utilities are well beneath the radar for all but the most uptight IT policies, but the utility workbook by it's very nature is a bit more of a problem.<br /><br />If you feel this isn't an issue for you, send me an email (address is in another response above), let me know where you plan on using it, what your role is (dba, analyst, developer...?), and I'll send you a copy.<br /><br />Like I said, it's not a big deal, just a little extra caution on this particular tool.<br />
Re: Outline Comparison Tool	Hey Doug,<br /><br />Does this utility work on v7.1.2 outlines?  Does the ESSLANG setting matter?<br /><br />I'm having trouble getting to work trying to compare two client based outlines.  I run the exe, I input the path for the outlines, click OK and nothing happens.<br /><br />Thanks,
Re: Outline Comparison Tool	Thanks for the heads up.<br /><br />I can't be positive that it's not a version issue.  I know that there are differences in the OTL structure that cause problems with downward compatibility, but my tests were done against outlines that were saved with a V6.2 client against a V7 server (our clients can't migrate until all servers are migrated).<br /><br />Since I'm stuck using a V6 client API for the time being, I don't know when I'll get the chance to migrate any of my utilities to V7.  And, with EAS available, I figured the benefit the tool provides is significantly reduced, so I didn't pay much attention to the need to upgrade it.<br /><br />Nonetheless, I'd like to discuss this with you in more detail some time, I'll send you a note (although I'd recommend you not make your email address quite so public, as spambots have been known to scan this site).<br />
Re: Outline Comparison Tool	Not sure if this the problem, but rumor has it that a lot of API programs are breaking when moving to 7. I am still happily cranking along in 6.5.6 so cannot confirm.
Re: Outline Comparison Tool	[quote author=garycris link=topic=27.msg136#msg136 date=1126189022]<br />Hey Doug,<br /><br />Does this utility work on v7.1.2 outlines?Â Does the ESSLANG setting matter?<br /><br />I'm having trouble getting to work trying to compare two client based outlines.Â I run the exe, I input the path for the outlines, click OK and nothing happens.<br /><br />Thanks,<br />[/quote]<br /><br />I was thinking I had the same thing here but it just took a minute or 5 to finish what it was doing. Now I have a beautifull overview of my changes. The attributes are a mess, thats a shame, but the rest I can check verry easily now. :)
Linking Spreadsheets in different Reports	I have one problem, maybe it is simple to solve:<br /><br />How can one link all(!) dimensions of two spreadsheets in different reports?<br />I want to give over all member selections of a spreadsheet in one report to<br />a spreadsheet in another report.<br /><br />Environment: Hyperion Analyzer  7.2.1.1.03053<br /><br />Best regards and thanks in advance!<br />Michael
Re: Linking Spreadsheets in different Reports	Not positive on this one, but here's my best guess:<br /><br />Create a separate frame with the controls to do the member selections, and link each of the existing reports' selections to those controls.  Changing one should then change all, no matter where it's changed -- in theory.  If I'm way off on this one, forgive me, I haven't worked with Analyzer in a long time (I'm more of an API/utility kind of guy).<br />
Re: Linking Spreadsheets in different Reports	This does also not work, objects of different reports are independent  :(.<br />I also spoke with someone from Hyperion, it is not possible to pass the<br />dimension selections of one whole spreadsheet (rows, columns, filters, pages)<br />over to another spreadsheet in a different report. This is already an <br />enhancement request.<br /><br />Thank you for your help, especially for the very quick response!  :D<br /><br />Kind regards<br />Michael<br />
Error 429 - ActiveX component can't create object	Hello,<br /><br />after successfully configuring Hyperion Business Rules (available in EAS), I get the Error Message "Error 429 - ActiveX component can't create object" when I try to open the business rules graphical designer.<br /><br />Please help me out!<br /><br />Best regards and thanks in advance!<br />Michael
Re: Error 429 - ActiveX component can't create object	This is an indication that you are misssing a component that is expected.<br /><br />So either the install didn't quite go to plan (not unusual), or some common (Microsoft, most likely) component is expected to be present.<br /><br />Try reinstalling. I assume you rebooted after the install?<br /><br />Sorry, can't be more help than that...<br /><br />Chris
Re: Error 429 - ActiveX component can't create object	Since I'm not familiar with HBR, I can't help on the specifics for installing/configuring, but I can confirm that error 429 is a very common automation error associated with a missing or misconfigured ocx/dll somewhere. Â Is it possible you did the install without full admin rights?<br /><br />There are other reasons why an ActiveX component would fail to be created, and manual fixes for ocx/dll issues, but it's probably better to uninstall/re-install HBR (ensuring admin rights, etc.).<br />
Re: Error 429 - ActiveX component can't create object	Thank you both for the quick help.  :)<br /><br />I will reinstall HBR this weekend on my<br />local server image and report on installation.<br /><br />Kind regards<br />Michael
Re: Error 429 - ActiveX component can't create object	[quote author=michaelmasa link=topic=29.msg68#msg68 date=1124967123]<br />Hello,<br /><br />after successfully configuring Hyperion Business Rules (available in EAS), I get the Error Message "Error 429 - ActiveX component can't create object" when I try to open the business rules graphical designer.<br /><br />Please help me out!<br /><br />Best regards and thanks in advance!<br />Michael <br />[/quote]<br /><br /><br />Make sure you have the Essbase Runtime client installed...  You need it to use HBR.<br /><br />Eric
Re: Error 429 - ActiveX component can't create object	We had the same problem.  Tried to reinstall and it worked  ;D<br /><br />
Re: Error 429 - ActiveX component can't create object	Make sure you have the MSJVM (it comes with the Planning install) installed.  Reboot and then reinstall Business Rules.  This should fix it..
Word Wrap	Have a long alias name as a column - is there a way to wrap the column name?  Reports is trying to put it as one string across, need to it to wrap based on the size of the column.<br /><br />Any help is appreciated
Re: Word Wrap	Hi There,<br /><br />Just wondering which version your running with?  We're using Ver7 and it seems to wrap automatically.  Just tested it, can't see any setting to switch in on/off.<br /><br />In the HTML view our column headers do not wrap, but they do in the PDF view.  The Row headers wrap.<br /><br />Bit confusing why there's a difference between the HTML & PDf views.<br /><br />Not too sure whether this has helped, but if you find anything let us know - ta.<br /><br />Mark
Re: Word Wrap	Thanks!  We're on 7.0.1.  In PDF, it cuts the name to the length of the column.  In HTML no wrapping but it autofits to the name.  <br /><br />Weird...  If I find out anything, I'll let you know..
Use of @SUBSTRING	I've had an "interesting" >:( experience with the use of @SUBSTRING function in a member formula.<br /><br />Essbase 7.1.3<br />9 dimensions, only two valid for this demonstration<br /><br />For the purposes of this item the entity dimension may be considered of fixed levels, and repetitive in nature.<br />Basically it is made up of Branches at Gen6/Lev1 and Plants at Gen7/Lev0, and of conveniently named members where various characters mean something, it looks like the following:<br /><br />....<br />\|-2201 <br />Â \|-220101<br />Â \|-220102<br />Â \|-220122<br />Â \|-2201I <br />\|-2204 <br />Â \|-220401<br />Â \|-220410<br />Â \|-220423<br />Â \|-2204I <br /><br />Note that each branch (the 4 character members) has an input child member.<br /><br />Okay ... here's the fun I had ... there is an account (Tonnes) that exists in the input member of each branch, and needs to be referenced from the plants members (i.e. from 220101, ... , 220423 above). I created a member formula on a dynamic calc account that went like:<br /><br />IF( @ISGEN( "Entity", 7 ) )<br />Â "Input Tonnes" = "Tonnes"->@MEMBER(@CONCATENATE(@SUBSTRING(@NAME(@CURRMBR("Entity")), 0, 3 ), "I" ) );<br />ENDIF;<br /><br />In member 220101 this should translate to <br />Â "Input Tonnes" = "Tonnes"->2201I<br />In member 2201I this should translate to <br />Â "Input Tonnes" = "Tonnes"->2201I (it is [i]not[/i] an issue that this is self referential)<br />In member 220423 this should translate to <br />Â "Input Tonnes" = "Tonnes"->2204I<br />and so all is well in the world ...<br /><br />IT DIDN'T.Â ???<br /><br />Working through this I was able to isolate the @SUBSTRING as the culprit. Has anyone else struck issues with this function? <br /><br />[I was able to achieve my result by using the following: ;)<br />Â "Input Tonnes" = "Tonnes"->@MEMBER(@CONCATENATE(@NAME(@ANCEST("Entity",6) ), "I" ) );<br />but somehow I don't consider it quite as elegant a solution]<br /><br /><br />
Re: Use of @SUBSTRING	I believe the issue may lie with your "end position" parameter (3).Â It should be "4".<br /><br />The docs state this in a somewhat confusing manner, as it says "The first position past the last character to be included in the substring", so if you want chars 0-3, you put in 4.<br /><br />As is, you were getting results like "220I" instead of "2204I".<br /><br />Hope this helps.<br />-Doug<br />
Re: Use of @SUBSTRING	[quote author=DougWare link=topic=31.msg83#msg83 date=1125024309]<br />As is, you were getting results like "220I" instead of "2204I".<br />[/quote]<br /><br />Of course -- I'm working with Chris and just came across the same point about the third argument, but we couldn't figure out why that wasn't causing the calculation to abort.  Your reply made it click: in this database both "220I" and "2204I" happen to be valid member names, so there was no error message reported.<br /><br />The example in the 7.1.3 docs therefore has an error.  It shows this:<br /><br />[code]@SUBSTRING ("200-21",0,2) "200"[/code]<br /><br />But should read:<br /><br />[code]@SUBSTRING ("200-21",0,2) "20"[/code]<br />
Re: Use of @SUBSTRING	Thanks. It works now. <br /><br />Guess painful experience should have told me the documented samples were wrong ... but one does live in hope! <br /><br /> ;)<br /><br />"Normally" Essbase spits the dummy if you reference a member that doesn't exist which is why I was fooled into thinking I was right! And in [b]this[/b] structure member "220I" [i]does [/i] exist! Which I stupidly neglected to consider...
Re: Use of @SUBSTRING	I've submitted it as a documentation bug to Hyperion support.
Re: Use of @SUBSTRING	Topic solved? Chris, you should be able to see a 'tick' symbol - which you can allocate to dougware's post.<br /><br />Cheers
Re: Use of @SUBSTRING	I've learned to pretty much ignore document samples for such reasons -- like many examples, it was more confusing than helpful.<br /><br />The other aspect of this is [i]why[/i] do they use such a strange parameter in the first place.  Every programming language I know of would use either a length or an inclusive end position (usually the former).  It almost seems like they go out of their way to add confusion.<br /><br />Gotta take the bad with the good I suppose.<br />
Re: Use of @SUBSTRING	For what it's worth, Java's String.substring() function has the same strange arguments, which is probably the only reason why I didn't immediately think the documentation contained a typo.
Spam bots	Just a quick note to warn all users re posting email addresses and having your email addresses in your signature: there have been a couple of nasty spam bots that have trawled through this forum (from what I can tell from the server log). These things harvest email addresses for the purposes of spamming and other undesirable practices. Whilst you are free to do so, you may wish to reconsider email disclosure.<br /><br />Cheers
Workspace Availability	Has anyone been able to resolve this:<br />Workspaces marked as private are available to the user who saves them.<br />However, this is case sensitive. ie if logged on as joe, any workspace is visible, but, if logging on as JOE (a valid account and accepted by HFM), the Workspace is denied to the user.<br />However, if linked to by Favorites, they are visible under any combination. ie, joe; JOE; Joe;  etc....<br /><br />Useful to know for any user calling re missing Workspaces. We are on v4.0.1sp2, but the same exists in v3.5 as well
Re: Workspace Availability	We have had to train our users to use all lower case.  Why you ask?  We have implemented single-sign-on from HFM to reports.  And reports is case sensitive, so if they don't want to log in again, they have to use all lower case.  All the id's are created lower case in both HFM and Reports.<br /><br />This doesn't solve the defect but it might be a workaround.
Re: Workspace Availability	Thanks Aleck, Yes, we did the same, but users being users, and unintentionally, they use variations. Not something we can control, and also has the impact as you mention with Reports.<br />I will post any response I get from Support.
RSS feed	Hi,<br /><br />Firstly congratulation for the forum, wishing it a long life.<br />Concerning the feature that could be implemented is an RSS feed for each technology and utilities/freewares.<br /><br />Best regards,<br /><br />SR - PCF
Re: RSS feed	I'm not sure if this has been advertised, but this forum software does happen to provide RSS feeds:<br /><br />For example:<br />[url]http://hyped.biz/community/index.php?action=.xml;type=rss[/url]<br /><br />To check just one board, like the Essbase board, check the number that appears in the URL when you enter that board, for example:<br />[url]http://hyped.biz/community/index.php?board=19;action=.xml;type=rss[/url]<br /><br />Sorry if I'm preempting anyone - I was playing with various different forums a while back and most work that way  :)
Re: RSS feed	Great stuff!
Re: RSS feed	Unfortunately it looks like this has stopped working - there's now only one entry in the feed:<br /><br />[code]Re: Clustering question<br />http://hyped.biz/community/index.php?topic=163.msg532#msg532[/code]<br /><br />Any idea why?  Could it be because of the new requirement to log on to view forums?
Re: RSS feed	[quote author=Ben White link=topic=34.msg553#msg553 date=1136964038]<br />Any idea why?  Could it be because of the new requirement to log on to view forums?<br />[/quote]<br /><br />Answering my own question  :)  I did some digging and yep, that's it.  If you use Live Bookmarks in Firefox it works (as long as you're logged on to HYPEd.biz so that Firefox's logon cookie gets used), and if your RSS reader can use cookies it still works too.<br />
Re: RSS feed	Sorry Ben - I think you're right. My little bit of digging also came to the same conclusion. Will see if they have a mod that might fix it up for us.<br /><br />Cheers (and HNY!)<br />Jon
Re: RSS feed	(HNY to you too!)<br /><br />Might be hard to fix though -- if you're requiring a logon to view posts, then providing a RSS feed anonymously would be a bit of a security hole.<br /><br />Any reason why logons are required now, btw?
Best Practice â€“ Updating between Environments in Planning	Here's the Scenario:<br />Planning Application that has a Dev and Test environment on one server and one Essbase server, and a Prod environment on another server with a separate Essbase server.<br /><br />So what is the best practice in updating Planning and Essbase between Dev to Test, Test to Prod (not to mention the occasional Prod to Dev)?<br /><br />The somewhat clunky method of backing up (relational) database and restoring over new environment, "refreshing" Essbase, and modifying planning security tables is, well, it's kind of unprofessional.<br /><br />Anyone got anything better?<br />
Re: Best Practice â€“ Updating between Environments in Planning	Chris:<br /><br />In the "clunky" method, are you performing a true Migration of the Essbase database from within EAS?  <br /><br />Assuming the domain name and users are the same for both servers, the Migration of the Essbase App and the restore of RDBMS is actually pretty straightforward.<br /><br />If you are moving between Domains, its a much different story. In this case, I have used Remote Authentication Module to assist in moving apps between our servers and our clients servers.  Since RAM allows you to search LDAP for 2 domains, you can have user chris@ourdomain.com  and user  chris@clientsdomain.com both setup in Essbase/Planning Security.  This allows you to log on from both domains and/or move the app between domains (using migration in EAS).
HFM Clustering and Connections	HFM with two servers one cluster.  Have noticed that when we open an app, can see where it starts the HSVdat.exe on both servers, can see the connections into the repository, but when we log off, those HSVdat's do not go away.  However, we have another HFM server, no clustering, when we open an app, can see where it starts the HSVdat.exe, can see the connections into the repository, when we log off, those HSVdat's do go away and so do the connections.  <br /><br />Is anyone else seeing anything similar?
Re: HFM Clustering and Connections	Aleck,<br />        The first time i have to open the App is to register the cluster (Server Name) and then it shows the App. The first time you open the App it asks to save it a folder or workspace.... i made a new folder under c:/hyperion/hfm/folder name. I have not come across such a problem..... about the cluster as you have mentioned. <br /><br /><br />Thanks,<br />Hypercube
User Alias tables	Currently it is not possible for users to dynamically change the display of aliases or member names in webforms.<br /><br />Currently it is [b]not [/b] possible for users to dynamically change the display of aliases or member names in webforms.<br /><br />Also, is it possible for an Administrator in Planning to apply different aliases for the same dimensions on a form by form basis. ie. 2 forms, both have same dimensions, but the administrator can set a different alias in each form?<br /><br />This is on Planning v4.0.1<br /><br />TIA
Re: User Alias tables	If I understand the question correctly, the answer is no.  Aliases are set under user preferences.  The admin can designate which alias table is the application default (not necessarily the default alias table) Then users can go into preferences and choose to use the application default or another alias table.  Either way this is set at a high level and cannot be modified on a per form basis.<br /><br />HTH
Atlanata Users Group Meeting	The next Atlanta HUG will be at Mirant - 1155 Perimeter Center West, Atlanta Georgia 30338
Re: Atlanata Users Group Meeting	I am interested to hear people's experiences with user groups. I think they are an excellent idea but have never attended myself.<br /><br />Are they of any benefit?
Re: Atlanata Users Group Meeting	I think so.  We have a "no Hyperion fluff rule" which works out well.  Also, it's a great way to network.
Re: Atlanata Users Group Meeting	Up here in Michigan, HUG-MI (catchy name, no?) does tend to lean towards the fluff a bit, but this is easily overlooked when you consider the [i]networking[/i] and [i]staying current on new products[/i] aspects.<br />
Re: Atlanata Users Group Meeting	Aleck,<br />Â Â Â Â Â Please let me know when this meeting will be in Atlanta. You didn't mention the date ?<br /><br />Thanks,<br />Hypercube
Re: Atlanata Users Group Meeting	It's Wednesday, November 16th from 12-4, outside of Atlanta in the Mirant office building.  The address is 1155 Perimeter Center West, Atlanta GA 30338.<br /><br />HTH!
NEW DATE: Atlanata Users Group Meeting	The Atlanta user group meeting has been moved to December 14th.  Same place different date!
Deleted report still visible in view pane	Hello,<br /><br />again one problem which sound to be solved simply:<br /><br />I have deleted one Analyzer report, but it is still visible<br />in the view pane. How can I remove it from there?<br />"Delete" doesn't work.<br /><br />Thank for help in advance!<br /><br />Best regards <br />Michael
Project Avalanche	Anyone got any gossip on Hyperion's Project Avalanche and likely release dates?
Re: Project Avalanche	The beta is supposed to start this week.  We're participating in it.  Will keep you in the loop as more info becomes available.
Re: Project Avalanche	Any news would be great - there's been much hype (no pun intended) at our work for a while around this new single platform approach.
Re: Project Avalanche	That's the old name! it is now being marketed as 'System 9', the initial release is due for the end of September (the 4.1 release) - I'll try to get an exact date. onceptually, the direction is right, and this is aligning the BI tools and App suite, by beginning the process of reducing the number of moving parts, single point of access, unified install, security module etc...<br /><br />There is a lot of marketing started, don't be surprised if your accoutt manager calls:) and the Solutions conventions will be doing demo's etc. The first being Barcelona 6 - 8 November.<br /><br />It is going to be an interesting upgrade for those of us already on the treadmill!!
Re: Project Avalanche	We had a brief into to system 9, and have a demo/sales pitch coming, but I wasn't sure it was the same thing (never heard of it as "Avalance" before).<br /><br />My understanding is that it's more of a marketing package than a technical enhancement.  Obviously, changes were made to bring the components into a single framework, and that by itself is worthy of interest.  Beyond this, I would only HOPE that they haven't tried to make too many changes to the underlying technologies themselves.<br /><br />
Re: Project Avalanche	The BI market is certainly heating up. I was given a demo on the beta for SQL Server 2005 - which is tipped for release in Nov. Very impressive. They have certainly moved towards, not only integrating the ETL/DW/BI functions, but also wrapped in up in a BI development studio - so it's like having one IDE to do it all. All this prepackaged with SQL server.<br /><br />It will be interesting to see how Hyperion, COGNOS and BO (as the heavyweights) respond.
System 9	System 9 will combine Hypeiron Reports, Analyzer and PM into one reporting solution.  Hyperion also introduced in Hyperion Shared Services (HSS - which is the old HUB) user provisioning.  The concept is you register all your products with HSS and all your users are maintained in HSS.  So, for reporting - System 9, you would pick your users out of HSS.  Nice feature.  Also, you can have multiple grids with different data sources in the same report.  <br /><br />Spoke with our sales rep yesterday - there is going to be a "migration cost" associated with it but was not able to give me a quote.  Also, this is considered a new product and will be priced accordingly.
Lock Manager errors	I have a user that reports the following error:<br />"1014028 Transaction transactionHandle is waiting for transaction transactionHandle"<br /><br />I searched HDN:<br /><br />[i]"Possible Problems<br />Essbase cannot complete the transaction because the current transaction is waiting for a deadlocked transaction. <br /><br />Possible Solutions<br /><br />Make sure that two users are not performing calculations on the same blocks at the same time. <br />If this error happens frequently, have spreadsheet users clear the Update Mode check box in the Mode tab of the Essbase Options dialog box. See the Essbase Spreadsheet Add-in User's Guide for more information."[/i]<br /><br /><br />I have cleared the check box as suggested and re-tested when there were no other users but no luck.<br /><br />I was wondering if anyone had experienced anything similar OR have any suggestions.<br /><br />Thank you!<br />
Re: Lock Manager errors	Might be a silly question but did you check the database locks before re-testing, Essbase may have not released the lock when you tried again.<br /><br />Regards<br />David
Re: Lock Manager errors	The obvious (which hasn't been explicitly said yet): To resolve the deadlock, abort any stalled calculation processes.  Then you can recalc (one at a time, please).<br /><br />The less obvious: If users are running calcs against the database, it's usually a good idea to ensure that these calcs do not overlap (in terms of at least one sparse dimension).  This will ensure they don't go into deadlock.  When this isn't feasible, you might try setting up a server side process that they can queue the calcs against, or set up some kind of calc schedule instead of letting them run them at any time.  In the long run, the effort needed to do this is likely to be recovered in troubleshooting/repair time and database availability.  If the app isn't mission critical, then present the data owner with the options and let them live with their decision.<br />
Analysis Tools Manager	Hi all,<br /><br />I have a typical problem with Analyzer 7.2. <br /><br />Whenever i click on Analysis Tools Manager it hangs up and never comes back up.  Did any one have this kind of problem.<br /><br />I know 7.2 latest version is with lot of bugs but, is thre any particular reason causing that?<br /><br />Any suggestions in this regard will be a great help<br /><br />Thanks in advance :(
Calling Report Script using MAXL	Hi There,<br /><br />Just created what appears to be some simple MAXL code to run a Report Script and export to a file.Â It all runs successfully, but I can't find the export file.Â Bit frustrating!Â Anyway here's the code:<br /><br />Â Â Â Â [color=Blue]login 'hypeadmin' 'hyp3admin' on 'stacshyperep01';<br /><br />Â Â Â alter application 'ManAcs' load database 'MAv10';<br />Â Â Â Â export database 'ManAcs'.'MAv10' using server report_file "Act04" to data_file "c:\\MYFILE.txt";<br /><br />Â Â Â logout;[/color]<br /><br />Thanks in advance<br /><br />Mark<br /><br />PS I like this site
Re: Calling Report Script using MAXL	Not sure if this is the situation you are in, but this might help.  When you run MaxL scripts, it runs from the perspective of the Essbase server, not the client you are working from.  So in your case, if you are running this script from a client machine and looking for the export on the C: root of the client machine, the export is not going to be there.  Instead, login to the Essbase server and look for the export file off the C: root of the server.<br /><br />Hope that helps.
Re: Calling Report Script using MAXL	Hi Gary,<br /><br />Sorry about the slow reply, done some digging and still couldn't find the file - frustrating.Â I think this is because I don't have write access to the server, which is strange because some of the other EAS functionality lets me write to it.<br /><br />Tried pointing the extract to another location using some of the syntax in the examples, but still no joy.Â When I get back to work with a clear head I'll keep it another go.Â On holiday at the moment - this Essbase thing - strangely addictive!<br /><br />Thanks<br /><br />Mark
Re: Calling Report Script using MAXL	Are you getting output messages scrolling up the screen at all?<br /><br />When you use the export statement with a report script using essmsh.exe or the API, the filename you specify is on the local machine (as opposed to calling it without a report script, where the file ends up relative to the server's essbase\app directory), so you [i]should[/i] find the output in your c:\ directory, assuming there are no strange file permissions problems.<br /><br />On the other hand, if you're running it on Essbase Admin Services, EAS temporarily saves the output of the report on the server somewhere (somewhere like eas\server\client) before copying it to where you specified in the MaxL statement.  I've had problems in the past when for some reason EAS hasn't had permission to write to that temporary directory, but from memory it did at least give a useful error message.
Re: Calling Report Script using MAXL	Hi Ben,<br /><br />Yep, I get the success messages scroll at the bottom.  I'll check the rest of your suggestions when I get back next week.  It'll give somewhere else too look and fingers X'd I might find the missing file.<br /><br />Ta<br /><br />Mark
Re: Calling Report Script using MAXL	Hi Ben,<br /><br />Finally got round to your suggestion and ran it using ESSMSH and the file exported to where I expected - great!<br /><br />Just wondering, how did you manage to change permissions in EAS so that the MAXL script can be run from the Server?<br /><br />Many Thanks<br /><br />Mark
Re: Calling Report Script using MAXL	In my case it was trying to create a temporary directory on the server (as eas\server\client\temp or some-such), but it wasn't able to write to the parent directory.  I created the temp directory as an administrator on the box itself and everything started working.  There was a reasonable error message in the EAS console at least, however.
Essbase Log Reconciler	PLEASE SEE BELOW FOR VERSION 1.6<br /><br />[u]Essbase Log Reconciler[/u] is a compiled PERL script which reconciles or reformats selected Essbase logs. <br />My objective was to generate a clean log file in order to open it in a spreadsheet for filtering or to insert it in a relational DB for further analysis.<br /><br />By Essbase logs I understand any Essbase log format, such as classic Essbase logs (v.5 to v.7) or advanced Essbase logs (~^*&: delimiters as defined by DELIMITEDMSG in Essbase.cfg).<br /><br />[u]How to use:[/u]<br />1. Copy and unzip to any directory<br />2. Execute EssLR_v1.exe<br />3. Drag & drop Essbase .log file to reconcile or manually input Essbase .log full path (ie. x:\...\app\demo.log) and then [ENTER]<br />4. Output is generated in EssLR_v1.exe current directory<br /><br />[u]Performances:[/u]<br />On my laptop it takes less than 7 seconds for a 20 MB log file.<br /><br />[u]Note/Disclaimer:[/u] <br />Even if stable and tested, use at your own risk!<br />You will be solely responsible for any damage to your computer system or loss of data that results from the download or use of the following script.<br /><br />If feedbacks, requests, comments or questions please feel free to reply!<br /><br />PLEASE SEE BELOW FOR VERSION 1.6<br /><br />SÃ©bastien Roux<br />_______________________________<br />Partake Consulting France<br />49, avenue Hoche <br />75008 Paris - France<br />E-mail: sebastien.roux@partake.com<br />URL:Â Â www.partake.com<br />_______________________________
Re: Essbase Log Reconciler	Thanks for contributing -- the more the merrier!  :)<br /><br />Does it do anything besides convert the format?<br />
Re: Essbase Log Reconciler	Not at the moment! I wanted something really quick when you have to audit/analyse logs bigger than 100 mb.<br /><br />2 points I'm thinking in:<br />- generate stats about the selected log<br />- insert data directly in a specific DB<br /><br />However do not hesitate to give ideas!<br /><br />Regards,<br /><br />Sroux
Re: Essbase Log Reconciler	Excellent Utility!  Very useful!<br /><br />Thanks for posting.<br /><br /><br />
Essbase Log Reconciler 1.6	Dear all,<br /><br />Here's a new release of Essbase Logs Reconciler a.k.a EssLR (please refer to the first post for further description).<br /><br />The script is coming back with improvements and some few minor fixes.<br /><br />Release notes:<br />-------------------<br /><br />version 1.6 - 20/11/2005<br /><br />- Corrected - filtering mechanism when a description only appears in log files<br />- Added - Replacing multi-space by single space<br />- Added - Deleting tab<br />- Added - Deleting eol tab/space<br />- Added - Message type/category column, as specified in Hyperion Essbase error messages <br />documentation with the following categories:<br />    <br /> Error code Message type/category<br /> ---------------------------------------------<br /> 1003000 to 1003040 Data Load<br /> 1006002 to 1006051 Data Cache<br /> 1008001 to 1008152 System Call<br /> 1012000 to 1012750 Calculation<br /> 1052001 to 1054030 Agent<br /> 1014004 to 1014043 Lock Manager<br /> 1019002 to 1019054 Database Objects<br /> 1040002 to 1042025 Network<br /> 1120000 to 1120002 Grid API<br /> 1130203 to 1130613 Miscellaneous<br /> else Other<br /><br />Usage: EssLr_v1.6.exe switch inputfile outputfile<br />  -h  specify headers<br />  -n  specify no headers<br />No more drag and drop!! Please refer to ReadMe.txt for further explanations.<br /><br />And remember even if stable and tested, use at your own risk!<br />You will be solely responsible for any damage to your computer system or loss of data that results from the download or use of the following script.<br /><br />If feedbacks, requests, comments or questions please feel free to reply!<br />I am looking for a way to obuscate pl script source in order to post EssLR.pl for Unix - thanks for helping me!<br /><br />For information, I'm using the current script (.pl) on my customer's Unix AIX environment, once the logs are reconciled (really quick) I load them in Oracle with sqlldr command and I analyze them in a web frontend (dynaSight).<br /><br />SÃ©bastien Roux<br />_______________________________<br />Partake Consulting France<br />49, avenue Hoche<br />75008 Paris - France<br />E-mail: sebastien.roux@partake.com<br />URL:    www.partake.com<br />_______________________________
Metro NY - Hyperion User Group Meeting	The next meeting for the Metro NY HUG is on September 15, 2005.<br /><br />Please visit [url=http://www.metronyhug.com]www.metronyhug.com[/url] and register for the meeting if you are interested in attending.<br /><br /><br />Best Regards,
http spreasdheet addin / deployment services	We have a full http environment - ie, no users able to connect to the server domain, as all connection is intranet. This has us snookered in direct access to the Essbase Sreadsheet Add-in.<br /><br />I am informed that Hyperion Deployment Services with Essbase Spreadsheet Service is the way out of it.<br /><br />Anyone got any experience with this?<br /><br />Noel
Re: http spreasdheet addin / deployment services	I used it in test environment, never in production.  It works pretty nicely.  Basically it's the same as the regular addin, except it allows you to connect to a server via http.<br /><br />Another option is Analyzer, which is web based...
Essbase Integration Services	hi friends,<br /><br />We are implementing EIS and i am very clueless where to begin with. we have all the required softwares installed. can anybody please suggest me where to begin ?? i have gone through the PDFs for EIS. but am still a little confused. <br /><br />Simply Stupid.
Re: Essbase Integration Services	I have the same problem with you ,and i am going through the demos .
Re: Essbase Integration Services	Sorry I can't help much on this, but did want to point out that Hyperion has a three day course specifically for EIS.<br /><br />Here's the course description if you are interested.<br /><br />Abstract:  <br />This course uses Hyperion Essbase version 7.0. All course exercises and demonstrations use the Essbase Administration Services interface. In this course you learn to convert relational data into multidimensional data by using Essbase Integration Services. You also learn the principal techniques for data denormalization and for the creation of online analytic processing (OLAP) models. You create fact tables and complete OLAP models from an existing relational store. The course describes the creation of multidimensional database outlines and data loading by using Essbase Integration Services. You also learn to enable hybrid analysis reporting functionality. Upon completion of the course, you should be able to explain the relationship between data warehouses and OLAP systems and be ready to implement techniques that leverage data warehouse and data mart investments into an OLAP solution. The course provides extensive exercises to reinforce the covered topics. <br /> <br />HTH
Re: Essbase Integration Services	i just read help information,practice with demos
Formatted Excel Export	Hello there,<br /><br />three problems, dealing with the excel export of spreadsheets:<br /><br />- I have defined various formats in a spreadsheet (bold, percentage sign, etc.) <br />  But when I choose the formatted Excel export, the Analyzer exports the data<br />  like it is stored in the database. I know that a complete formatted export is<br />  possible! Do I have to change some settings elsewhere?<br /><br />- We have users in Germany and in USA. The export for the users in USA works<br />  fine, they get the data like it is stored in the database. But the german Users<br />  have to switch the decimal separator and the separator for the thousands in<br />  the Excel options although the Analyzer is the german version. How can I avoid this?<br /><br />- When I define formatting settings e.g. for the measures when I establish the <br />  database connection, no formatted export is possible! What could be the cause<br />  for this?<br /><br />Thanks for help in advance!<br /><br />Michael<br />
Shooting in the dark (Network Connection dropping Issue)	Network Error [10061]: Unable To Connect To [MHC007M:1423].  The client timed out waiting to connect to the Essbase Agent using TCP/IP.  Check your network connections. Also please make sure that Server and Port values are correct<br /><br />sts = 1042006 CalcObject = CalcAll<br /><br />Command Failed. Return Status = 1042006<br /><br /><br /><br /><br /><br />Essbase 7.1.3, Windows 2000 server.<br /><br />Esscmd scheduled script.  Reset db, reload db, recalc db.  During the calc it looses its TCP/IP connection.  For less than a minute.  Than it is fine again.<br /><br />Every couple of weeks this seems to happen.  However always almost at exactly the same time (1:00 am).<br /><br />Then the problem goes away for a couple of weeks.  Only to magically return when I become complacent.<br /><br />Since it seems to be happening on such a regular basis, I assumed that it was related to the network/box/hardware or some IT scheduled process. However my IT department states that there is nothing going on from their side.<br /><br />This is currently the only app on this particular essbase box.  A planning app.<br /><br />Could it be related to the size of the log file.  I have noticed that the log file on my planning app grows rapidly in size.  When this problem occurs I have been clearing my log file for the app (soley because I have on those occasions noticed the size of it.)  Could the large size of the file  (130 meg +) be causing the delay in communication?<br /><br />Any other ideas. <br /><br />I think I understand that the Esscmd Client communicates with the Essbase Server Agent via TCP/IP even though they are both on the same box.  (the esscmd is being run from the same box that the Essbase server is running on.)  That it is this communication that is becoming messed up for some reason.
Re: Shooting in the dark (Network Connection dropping Issue)	I don't think that the problem is related to the log file; I had the same problem in an application after a long incbuilddim and i solved the problem stopping the application after the data load and restarting before to run calculation.<br /><br />Stefano
Re: Shooting in the dark (Network Connection dropping Issue)	This problem is tricky because it can be caused by multiple factors all acting at the same time.<br /><br />Check these..<br /><br />Is Hyperthreading enabled on the server?Â If so, try disabling it in BIOS and see if the problem goes away.<br /><br />Also, compare the dimensions in the Essbase Outline to the Dimensions in the Planning Dimensions Editor to ensure thatÂ 1) the dimensions are in the same order and 2) that the members in the dimensions are in the same order.Â Â The order of dimensions and/or members has been known to change during a refresh.<br /><br />Assuming that they are OK, be sure that the Outlines for all PlanTypes are each correctly optimized (must optimize from within planning, not Essbase), and that your Index Cache, Data/DataFile Caches are correctly optimized<br /><br />Finally, you may want to play around with NETDELAY and NETRETRYCOUNT, although they usually dont make that much of a difference.<br /><br />Hope that helps.<br /><br />C. Logan<br />InterTech Solutions<br />clogan@intertech-solutions.com
Programmatically creating reports from Essbase cubes -- need options	I need to automatically create a set of reports from data stored in essbase cubes. I have manually created those reports using the Excel plugin.  I would like to automate the reports.  I have a couple of questions and am also looking for options/suggestions.  <br /><br />My questions:<br /><br />1. Can saved queries/reports created from the plug-in be called programmatically from visual basic or do I need to use the standard visual basic functions?<br />2. Can an ODBC connection be created for an essbase cube?<br />3. Are their any inexpensive access tools that interface with essbase that could be used to create simple reports?<br /><br /><br /><br /><br />
Re: Programmatically creating reports from Essbase cubes -- need options	From your note I gather that an off the shelf solution isn't an option?  As there are several available, the decision to "roll your own" solution comes with consequences.  However, rather than point out the obvious, I'll assume you've already explored those options and have decided on what can be done in house.<br /><br />I'll also assume you are triggering the process directly and can monitor it, so you don't need special treatment for exceptions.  What you are then left with is the automation of the retrievals.<br /><br />In a word - K.I.S.S. should apply.  Keep it Stupidly Simple (or something similar ;)).  Design the reports independently of the automation, and create the macros that open the workbooks, do the retrieves, publish the results, and save/close the workbooks.  This way, you will be able to expand it with less coding and can isolate the impact of code changes from the templates (which may be handed off to key users for designing, etc...).<br /><br />Use meta-data in your code workbook that can easily be updated.  For instance, use a tab with columns for the workbook, server, app, db, (user, password), worksheet, and range to retrieve.  Treat each entry as an independent request for simplicity (the overhead associated with opening, connecting, retrieving, disconnecting and closing each one are minor compared to the benefit of keeping it simple).  hiding or encrypting the password from casual observance is easy enough.  Leaving a cell blank should indicate the previous entry (row or column) applies, etc...<br /><br />In fact, I considered adding this type of processing to H.E.A.P. in the past, but decided against it at the time (for simplicity, as it wasn't needed by the user).  However, I've already got most of these functions in other utilities (defined retrieves, create and republish HTML objects, mostly).  I could probably add this to HEAP in a couple weekends (depends on when I start, though).  I already planned on providing connectivity metadata to it (so it isn't tied to a single app/db or get timed out waiting for a start time).  Yeah, HEAP 2.0 sounds like a plan -- but as it probably won't be finished for a while, I'll wish you luck on your version, and encourage you to post it to the downloads section for the rest of us when you complete it.<br /><br />HTH<br />
Re: Programmatically creating reports from Essbase cubes -- need options	I am currently attempting to automate Excel using the .NET objects. However, the Hyperion Objects are poorly written and even more poorly documented. The ExcelGrid11() class simply crashes and does not populate.<br /><br />If anyone could get that class to work, you could automate the entire process from a .NET app. Using Excel alone to automate report generation may be the only method of automation at this time.
Re: Programmatically creating reports from Essbase cubes -- need options	By the way, just in case anyone can actually use the object class, in theory it should work like this:<br /><br /><br />GridExcel11 essGrid = new GridExcel11();<br /><br />essGrid.Workbook = excelWorkbook; //predefined Excel workbook<br /><br />EssbaseOperation.Grid = essGrid;  //uses established EssbaseOp class<br /> <br />this.EssConnect(); //custom func that connects<br /><br />EssbaseOperation.Retrieve();<br /><br /><br />
Re: Programmatically creating reports from Essbase cubes -- need options	I remember that using the Query designer in excel add-in saves the definition in a report file that can be re-used. I haven't had the need to use something like this so I do not know how it would help you in this case but just wanted to throw it out....
UK User Group	The next meeting for the [b][glow=blue,2,300]UK HUG [/glow] [/b]is on September 26, 2005.<br />For more details please contact the chair person. Details on: http://www.hyperion.com/uk/usergroup.cfm
Bitmap Mode message	The following message appears in the application log:<br />[Tue Sep 13 12:34:32 2005]Local/Europe/Main/jrector/Info(1012682)<br />Multiple bitmap mode calculator cache memory usage attempted to cross limit of [4] bitmaps. To ignore limit, do not set MultipleBitmapMemCheck to TRUE in essbase.cfg.<br /><br />In the Essbase.cfg file, I have set MultipleBitmapMemCheck = TRUE <br /><br />What causes this message?<br />Is there anything that can be done to eliminate it(db setting, outline change, etc)?<br />Does it affect calc or retrievel performance? <br /><br />Regards,<br />Tom M.<br />tmonahan@hotmail.com<br />Essbase 6.5.4<br />
Re: Bitmap Mode message	Simply put, your calc cache setting allows for 4 bitmaps to be retained in the cache, and you need more than this.  This can happen either because you added new shares (which can increase the number of bitmaps needed), or you added enough members to increase the size of each bitmap and thus decreased the number that can fit.  <br /><br />This situation only affects calcs, but because it may be possible to run multiple calcs in parrallel, being too aggressive on your calc cache setting can be risky (it can reduce performance significantly if you push the limit too far).<br /><br />Option 1: Remove the settings as indicated in the message.  The additional bitmaps will be allocated from heap memory.<br /><br />Option 2: Increase the calc cache so more bitmaps will fit (see comments above).<br /><br />Option 3: Decrease the number of bitmaps needed (this is only realistic if the additional shares are caused from implied shares in the outline, generating more than 3 virtual parents for a single member).<br /><br />HTH.<br />
Re: Bitmap Mode message	Thanks for the input.  I'll start looking in detail at some of the options.<br /><br />One thing that we have been noticing, is alot of dropped connections since this particular application went live and the Bitmap message started appearing:<br />Network error: The client or server timed out waiting to receive data using TCP/IP.  Check network connections.  Increase the NetRetryCount and/or NetDelay values in the ESSBASE.CFG file. Update this file on both client and server.  Restart the client and try again.<br /><br />Is it related?
Re: Bitmap Mode message	It's all relative, to one degree or another.<br /><br />It may be that your server is reacting slower now due to maxing out on either memory or CPU availability.  If so, the dropped connections may be attributed to your settings.  I doubt it though.<br /><br />What's more likely is that your network is experiencing a higher percentage of packet collisions, due to higher traffic than before.  The availability of the new database might have brought new users accessing it?  Or it could be something totally unrelated (well, a few additional degrees of separation, perhaps).<br /><br />For instance, we recently migrated to Windows XP in our department.  Along with this migration somebody got the great idea to map everyones "My Documents" folder to SAN storage, instead of on the local hard drive.  The merits of this idea are an issue for another discussion entirely, so I'll continue.  For several weeks after the upgrade, you could at any time of the day press a key or click a mouse, and take the next 30 seconds as a break hoping your system didn't actually lock up this time.  Eventually, they figured out the settings necessary to make this less painful from a type/click perspective.  However -- we are definitely experiencing a significant impact on our network timeouts -- they used to happen once or twice a day, now it's a lot more more of a coin toss for some user groups, and our customers (I'm in a support group) are taking it out on us.  The increase in network traffic has obviously been significant, and our Essbase servers are not even on the same network segment as the SAN that is responsible for the bulk of it.<br /><br />Bottom line: the network error is an indication that a key message between the client and server was dropped, and it happens all the time for one reason or another.  Usually, retries deal with this adequately enough, but not always.  If your network bandwidth is saturated enough, you could retry till the cows come home, but at some point in time, you need to beef up the infrastructure to really deal with the issue.<br /><br />Here's an interesting irony -- this morning I got an email requesting that although I already gave a technical explanation (similar to this one) to one user group concerning our inability to address our own "network error" issue directly; he's requesting that we "revisit the issue" here, and I'm not quite sure how to respond to him yet!  (No, I don't plan on telling them to take it up with the network infrastructure group... at least not impolitely).<br /><br />Back to the "Bitmap Mode" message aspect -- it's generally a good idea to set MultipleBitmapMemCheck = True, but not doing so is not quite as evil as some people might suggest (I saw the post on HDN).  Allocating memory from the heap isn't risky apart from the possibility that it becomes paged to disk when your server runs low on memory.  It won't cause issues beyond performance when this happens, unless there truly is a bug that I'm unaware of.
How to configure default POV for all users	Hi!<br />We have a situation where we need to hide on of the currency members from users in Hyperion reports because it only confuses them.<br /><br />Is there a way to adjust this for all user instead of just letting all user change their user pov?<br /><br />Can this be done in a way in the database by altering data in the tables?<br /><br />Thanks for any advice,<br />Erik N
Re: How to configure default POV for all users	Can you change you report format?  Are those members set up as rows or columns?
Re: How to configure default POV for all users	Can't think of anything that woud do what you are looking to do at a database level.  I think Analyzer would do something like that, but not reports.<br /><br />What you can do is use a grid point of view in your reports.  Place Currency in the Grid point of view, select the currency you want and then hide the grid point of view.  Users won't even know the dimension is there and the report will always run on the currency you want without anyone having the ability to change it.  The only set back is it needs to be on a report by report basis.<br /><br />HTH.
Re: How to configure default POV for all users	Hi!<br />Thanks you all - think I got the answers I was afraid of.<br /><br />The problem in this case is that the currency dimension contains three members, Local, SEK and USD. Local and SEK are always the same in this Planning APP so we just want to remove the SEK from (since it has to be calculated) the POV but still have the possibility to choose USD and Local. The grid point of view is unfortunately not an option both layout wise and in terms of configuration.<br /><br />BUT - an answer I would like to get is how the User POV are stored in the SQL server? Knowing this this could be centrally administrated for all users just changing data in the SQL server database.<br /><br />Erik
Re: How to configure default POV for all users	Could you insert a prompt for Currency and limit the choices list to just Local and USD?Â It's a little annoying because they get a screen to set their POV and then another for the prompt but it would limit their selections.<br />Good luck!!<br />Jen
Solutions 2005, Hyperion International Conference	Solutions 2005, Hyperion International Conference<br />6-8 November, 2005<br />Palau de Congressos de Catalunya<br />Barcelona, Spain<br /><br />For more information, go to [glow=black,2,300]www.sol2005intl.com[/glow]
Re: Solutions 2005, Hyperion International Conference	Ditto for the pacrim region<br /><br />ANZ Solutions 2005<br />13 -14 October, 2005<br />Sheraton On The Park<br />Sydney, Australia<br /><br />For more information, go to www.hyperion.com/au/solutions2005.cfm<br /><br />Anyone going to this one?
Re: Solutions 2005, Hyperion International Conference	I went, I drank and more importantly I remembered!!!(well some of it)
Solutions 2005, Hyperion International Conference	Yes, that seems to be the common theme.<br />The feedback forms have been sent, and I am sure there will be a very positive tone. System 9 very much the main theme, and a lot more depth to the breakouts than last year.
Planning Spreadsheet User Guide	Does anyone have a Spreadsheet user's guide in soft copy?
Re: Planning Spreadsheet User Guide	Do you need the Planning addin doc (pre version 4.0)<br />The Smartview doc (version 4.0+, Smartview replaced the Planning addin)<br />Or do you need the Essbase spreadsheet addin doc?<br /><br />I have the Essbase and the Smartview, can probably dig up the old Planning doc from version 3.5.1.  Let me know along with your email and I will forward to you.<br /><br />Regards,<br />
Re: Planning Spreadsheet User Guide	I have the Essbase add-in already. What I dont have is the 3.5* or the smartview. If you can email that that would be great.<br /><br />Thanks<br /><br />[email]Sal_Rapacciuolo@liz.com[/email]
How to / can I	Is it possible to have a report with a combox where I select a month<br />and a graph linked to the combox but instead of seeing the selected month in the graph I would see its children (the corresponding days).<br /><br />
Re: How to / can I	The answer is yes.  When you connect your combo box to your data source, the Select Members box opens.  Click 'Add' and the Months Browser will open showing your Time Dimension in the left pane.  Select the months you want by clicking on the check box next to the member name.  The member will now appear in the right pane.  Right click the member in the right pane and select "Also Select Children".  Repeat this for each month.  Click Ok.  In the Select Members box, be sure the "Dynamic" option is NOT selected.  Click ok and go to report view.  Be sure your months dimension is either a row or column dimension.  When you select the member in the combo box, the member will be returned along with it's children.  If you do not want to see the member and only the children.  Use the Show/Hide functionality.<br /><br />HTH
Re: How to / can I	Thank you for your detailed answer.<br /><br />Does it mean I will have to update the combo box manually every time I have a new month in my outline?<br /> :(
Re: How to / can I	Using this solution, yes you would have to update anytime you added a new member.  You could consider using substitution variables.  Build the combo box to work off the subvar and then change the subvar when you add the new member to the outline.  Not sure if that's much better, but it's an option.  Best bet would be to add 2 years or so to the outline upfront, define the combo boxes and then not worry about it for two years.  Things will probably change by then anyway!<br /><br />Best of luck.
Make dependent	Hi,<br /><br />Lately I'm "playing" with Analyzer 7.2.1, didn't touch it since 6.X.<br />I'm trying to implement the "make dependent" functionality with 2 subscription objects (comboboxes), and nothing happens in the 2nd combo when selecting a member in my first combo. I followed the help doc procedure but nothing happens...<br /><br />Help would be appreciated.<br /><br />Best regards,<br /><br />SRoux<br /><br />Win2000 SP4, SQLServer 2000 sp4, Analyzer 7.2.1, Tomcat 4.3.1, Java Client
Re: Make dependent	Hi, <br /><br />when you create the 2nd combo box and the "Select Data Source" dialog comes up, you select "Make dependent". You then get a list of all available reporting components and you can select the objects <br />from which your box should be dependent from.<br /><br />Hope this helps!<br /><br />Michael
Re: Make dependent	Thanks but Indeed this is what I did, did you check if your result was ok? Because mine is empty! i'll try again just in case... and post a prtscr in case it still dead!<br /><br />regards,<br /><br />SR
Re: Make dependent	I tried it out and it works! Maybe you choose level 0 members in the first box?<br />Don't know how I can help you :(<br /><br />Best regards<br />Michael
Re: Make dependent	Hey! Thanks for insisting, Finally I made it works rebooting a few times my tomcat application server and re-creating the combos and dependence link...<br />I'll be a bad boy on this one, but do you know if is it possible to set/configure the zoom behavior (which is currently an @CHILDREN()) or is it another BORN DEAD stupid function applicable on one out of 1000 cases..? <br /><br />regards,<br /><br />SR
Re: Make dependent	Yes it is such a function..it could be enhanced by Hyperion. Try and play around with the "Also Select Subset" option together with "Dynamic" and then link two boxes, maybe with this it is possible to realize what you want! I can not try it out, because I now go on holiday for the next week  :) <br /><br />See you later!<br />Michael
Re: Make dependent	Thanks for the info I'll make the try and keep you aware, <br />and have a nice holiday by the way  ;)<br /><br />Regards,<br /><br />Sebastien Roux<br />_______________________________<br />Partake Consulting France<br />49, avenue Hoche <br />75008 Paris - France<br />E-mail: sebastien.roux@partake.com <br />URL:    www.partake.com<br />_______________________________<br />
ANZ Solutions 2005 - Sydney, Australia	ANZ Solutions 2005<br />13 -14 October, 2005<br />Sheraton On The Park<br />Sydney, Australia<br /><br />For more information, go to [url=http://www.hyperion.com/au/solutions2005.cfm]www.hyperion.com/au/solutions2005.cfm[/url]<br />
Re: ANZ Solutions 2005 - Sydney, Australia	So where's the HYPEd.biz after-party going to be?  ;D
Re: ANZ Solutions 2005 - Sydney, Australia	not a bad idea at all.....
Outline Migration from 6.5 to 7.1	HI  All-<br /><br />I am relatively new to Hyperion,<br /><br />Is it possible to migrate outlines from 6.5 to 7.1?<br />If Yes,what all needs to be migrated?<br />How do we go about doing it?<br /><br />Please help.<br /><br />thanks in advance,<br />venkat
Re: Outline Migration from 6.5 to 7.1	Taken literally to "migrate outlines" you just save them to a V7 server ... <br /><br />But ... I think your question is about [i]far[/i] more than the outline files so you'll have to elaborate to get more specific answers.<br /><br />
Re: Outline Migration from 6.5 to 7.1	Chris,<br />Thanks for the reply .To eloborate my question:<br /><br />1.Are there any implications in migrating outlines from 6.x to 7.x? (I mean will outline get affected ? Like the formula's,property ot storage type etc)<br /><br />2.When we migrate will all the files also be migrated ? (Like the ..RUL,.SEC,.REP,.CSC...ETC)<br /><br />THANKS in advance.<br /><br />jeeva
Re: Outline Migration from 6.5 to 7.1	Depends entirely on how you do the migration.
Using the @RANGE function with a multidimensional range	Here's hoping someone here can put me out of my misery.  :)<br /><br />I need to generate a multi-dimensional range of members to pass to another function (actually a custom-defined function).  The @RANGE function can generate a one-dimensional range like so:<br /><br />[code]@RANGE("Available Machine hours", @CHILDREN(@CURRMBR("Entities")))[/code]<br /><br />The documentation for this function suggests that instead of a single member-set function (like @CHILDREN) as the second argument, you can use a "list of [...] range functions", which sounds a lot like what I want to generate, like this:<br /><br />[code]@RANGE("Available Machine hours", @CHILDREN(@CURRMBR("Entities")), @CURRMBRRANGE("Time Periods", LEV, 0, -3, 0))[/code]<br /><br />This validates, but during execution the following error occurs:<br /><br />[code]Error executing formula for [Product Volume] (line 27): invalid range[/code]<br /><br />If I use SET MSG DETAIL, I can see that it occurs as soon as Essbase encounters a member of the Entities dimension that actually has children (ie, where the @CHILDREN function doesn't return an empty list).<br /><br />Has anyone else used two (or more) range functions in the @RANGE function successfully?
Re: Using the @RANGE function with a multidimensional range	Have you tried nesting the @RANGEs ... [u]IF[/u] that makes sense ... I can confirm it validates but I've not had time to test if it works!Â :-[<br /><br />Concur that the help files does seem to be saying what you've interpreted it as ... the "help" files strike again!<br /><br /> ;)
Re: Using the @RANGE function with a multidimensional range	Thanks boss :)<br /><br />I've tried nesting like this:<br /><br />[code]@RANGE(@RANGE("Available Machine hours", @CHILDREN(@CURRMBR("Entities"))), @CURRMBRRANGE("Time Periods", LEV, 0, -3, 0))[/code]<br /><br />But @RANGE expects a single member as its first argument, so the outer @RANGE function fails at runtime too.  What I really need is something like this:<br /><br />[code]@RANGE("Available Machine hours", @XRANGE(...))[/code]<br /><br />which isn't really a solution anyway (@XRANGE expects hard-coded arguments that point to the "corners" of the range, not range functions like @CHILDREN and @CURRMBRRANGE).  Plus, @XRANGE can only be used in a small collection of functions like @SUMRANGE, etc., but not @RANGE.<br /><br />I reckon @RANGE can only deal with a set of members from a single dimension as its second argument, which may be built up from several range functions, but not if they return members from multiple dimensions.  I'd love to be wrong, though.
VALIDATION ERROR MESSAGE: MEASURES NOT DEFINED.	Hi All-<br /><br />I am using EIS to build the Outline,but when I try to save the Metaoutline I get an Error message as <br />MEASURES NOT DEFINED.(I also get a message as you can still save the Outline but cannot do a member or a data load)<br /><br />I have these dimensions in my Metaoutline:<br />Measure : Accounts - Dense<br />Period:Time - Dense<br />Scenario - Dense<br />Company - Sparse<br />Type - Sparse<br /><br />Please help to overcome this error.<br /><br />thanks in advance.<br /><br />Jeeva
Planning New App Setup	Hi All  :),<br /><br />            I need to know the best practice to create a Planning App. For example, i need to know that do we build the outline in Essbase and then transfer it to Planning through HAL? or is there is another way to do too. Please let me know what is the way to create the App from the beginning.<br /><br /><br />Thanks,<br />Hypercube
Re: Planning New App Setup	The scope of your question is too grand for a user forum to effectively address.  Your best bet is to contact a qualified consulting firm, or take a class with Hyperion to learn moe about Planning.<br /><br />Hyperion training can be found at http://www.hyperion.com/services/education_services/<br /><br />If you need a consultant, please feel free to contact my company www.pgww.com.<br /><br /><br />Best Regards,
HAB - any takers?	Does anyone have any HAB implementation stories?  It seems to have a lot of potential as something like Alphablox for developing web-based interfaces that talk to OLAP and RDBMS data sources.  At least in my own experience, a lot of Planning work seems to be getting very close to the point where the pain of supporting custom interfaces is less than the pain of shoehorning certain types of complex applications into the standard Planning framework.<br /><br />But it doesn't seem to be getting much love.  Anyone know if it's worth a look?
Re: HAB - any takers?	Ben - I have experience with HAB since version 2.0 (current version is 7.1X - they skipped some release numbers).<br /><br />From my experience, if you need to go down the custom route to deliver the full requirements of an application, HAB is a solution.  It is an unconstrained development environment using Java and J2EE technologies.  It has some similar functionality as AlphaBlox but also has a different approach towards application development.  AB development was typically done using DHTML technologies, although you could develop applications directly with Java.  The downside of developing applications with Java and AB is that if the underlying classes change (which they did a lot), your code would not compiled when you upgrade.<br /><br />With HAB, they address this by providing a framework towards Java development within HAB.  That framework is the Web Application Architecture (WAA) that sits on top of the Analytic Data Model (ADM) API.  Within WAA, HAB provides a set of tag libraries with reusable objects (Grids, Charts, Drop Downs, etc).  The key is that Hyperion provides the entire WAA source code. This provides a good approach to properly extend their platform to build your own reusable tag libraries.  If you don't like the Grid that HAB comes with, you can build your own set of features on top of the ones that already exist.  You need to do this with Java, which depending on the capabilities of your development team, may or may not be easy.<br /><br />I have been involved with probably 10 different applications built with HAB.  They have mostly been either custom dashboard applications or "commentary" based applications that could not be done with packaged tools like Analyzer or Planning.<br /><br />Hopefully that helps.
Re: HAB - any takers?	Thanks - that sounds pretty encouraging.  We do quite a bit of work with AB using DHTML interfaces, so it sounds like it could actually be a better solution than AB for that sort of development.  About the HAB framework: I understood it used JSPs, JavaBeans, etc to render its interface in HTML in pretty much the same way as AB, so are you saying that its tag libraries add an [i]extra[/i] level of abstraction?<br /><br />I think I might just need to dive in and try building something myself, but I think it looks architecturally very good indeed.  Any comments about speed/stability/scalability?
Re: Copy cell text [Q solved]	The only way to make this work is to edit data in the SQL server<br />One will have to map the dimension members in HSP_CELL_NOTE with the objects in HSP_OBJECT and then change the related columen in HSP_CELL_NOTE.<br /><br />This works fine but remember to restart the web server service since it probably caches the cell text notes in the form (something I had a problem with).<br /><br />BR,<br />Erik
Copy cell text	<br /> Hi! <br />We have to move data from one account to another in our planning application. Since this application has been live for a while the users have been using cell text to store information to the different planners. <br /><br />Does anybody have a clue how I move these cell text to the new accounts? <br /><br />Thanks, <br />Erik
Optimize Hyperion Reports	Hello all,<br /><br />We have some reports which are generated using dynamic data from Essbase. Different users can see different amount of data according to their access levels. all of this works very fine.<br /><br />these reports are accesed through the DMZ which accesses our server in the firewall. Now these reports are taking looooooooong time to be generated. It seems that the communication with essbase is there for short time only but it takes a long time to format/paint the report. Can anyone guide me , how can we reduce this time ?<br />All suggestions are welcome.
Re: Optimize Hyperion Reports	There's not a lot you can do to speed up the generation of the report, but I've seen really impressive increases in network performance across WANs when using Reports (and Planning, and any of the other web-based products) by turning on compression in the web application server.<br /><br />For Tomcat, edit the server.xml file in \Hyperion\HyperionReports\HRWeb\conf, and add [b]compression="on"[/b] to the Connector tag.  For example:<br /><br />[code]    <Connector className="org.apache.catalina.connector.http.HttpConnector"<br />              port="8200" minProcessors="50" maxProcessors="200"<br />              enableLookups="true" redirectPort="8443"<br />              acceptCount="500" debug="0" connectionTimeout="600000"<br />              compression="on" />[/code]<br /><br />Then restart Tomcat.  For Planning or Analyzer, just find the server.xml file and do the same.<br /><br />This option was added fairly recently to Tomcat -- I'm pretty sure the first version was 4.1.20.  Reports 7.x and Planning 3.5+ are bundled with 4.1.30, which definitely works.<br /><br />For Websphere, you'll need to get your friendly Websphere admin to install IBM HTTP Server 2.x and install the Apache compression plugin.  I've not tried to enable compression for the other app servers, but it should be possible.<br /><br />For anyone using Tomcat, give this a go!
Re: Optimize Hyperion Reports	Thanks Ben,<br /><br />Your information does helps. We are using websphere express 5.1. I have tried bumping up the memory to the JVM machine but its not helping.<br />The same reports takes like 10 seconds on my dev box which is inside the network but from the DMZ the reports are taking like minute and half.. <br /><br />any clues , for what can be done specifically for the websphere???
Re: Optimize Hyperion Reports	The hard bit is making Websphere serve its pages through IBM HTTP Server 2.0, and specifically making it work with the separate Websphere instance that Reports and Planning create.Â That part is best left to the Websphere admins or IBM support -- we needed some help from IBM to get it working.Â But you'll know it's been done when you can log onto Reports by browsing to http://server/hr (which is served by IHS) as well as http://server:8200/hr (which comes straight from Websphere).<br /><br />Here's a tech note from IBM:<br />[url]http://www-1.ibm.com/support/docview.wss?id=swg21178424[/url]<br /><br />The instructions for setting up IHS 2.0 with Websphere are here:<br />[url]http://www-1.ibm.com/support/docview.wss?uid=swg21115062[/url]<br /><br />The instructions for the compression module, which is part of the Apache webserver project (which IBM HTTP Server is based on) is here:<br /><br />[url]http://httpd.apache.org/docs-2.0/mod/mod_deflate.html[/url]<br /><br />Good luck -- it was well worth it in our case: server in Perth, Western Australia and users in a mining town in New Zealand!
Re: Import Float Data via Rule from Oracle	New? Yes ... but not in the way you're asking. It's new in that in this environment - where there have been no changes to Hyperion or Oracle executables for ages - it just started failing last week. DBA swears the table has not changed (and I don't have the tools here to disprove that). Basically I am at a loss as to why it has "suddenly" started failing; and that's why I put it out there to see if anyone else has issues with float data types...
Import Float Data via Rule from Oracle	Had an interesting problem today. <br /><br />Situation: Essbase 7.1.2 and Oracle 9.2 and simple odbc connected oracle rule file - all dimensions in the table and a data column and real dumb sql statement (select * from table - no brain surgery here!). <br /><br />Anyway long story short the data column was defined as a float in the source table - all others being varchar2(30) ... and the import failed.<br /><br />Changed the sql to a field list and to_char( DataColumn ) and ... it worked!Â ???<br /><br />Should I have known this? Is there a problem importing from floats in Oracle, should this just be a numeric field? <br /><br />Thanks...
Re: Import Float Data via Rule from Oracle	Is this a new problem?  Was wondering if it was since we've seen some funkiness going from 8.1.7 to 9.2..<br /><br />Sorry that wasn't much help.. :(
Running Calc in Analyzer	Hi All<br /><br />Bit of a problem with running a calc script through Analyzer.Â When running a Calc I'm intermittently getting an error message saying: "Calculation Script.....could not be processed."<br /><br />I have changed the MAX_PROPERTY_VALUE_LENGTH in adm.properties from 4 to 20.Â I have also split the Calc Script but am still getting the same error message.<br /><br />It's driving me potty ???<br /><br />Hope someone can help.<br /><br />Thanks in advance<br /><br />Mark
Re: Running Calc in Analyzer	Update:<br /><br />We have changed our substitution variables so they're specific to the database (known problem) - didn't work,<br />also removed all Substitution variables - still didn't work :'(<br /><br />The clouds are gathering!
Re: Running Calc in Analyzer	Hi There,<br /><br />Finally found what was cuasing the problem...<br /><br />It was a clash between what the Filter was restricting and what the Calc Script contained.  We had used a dummy member to load "days in month" which wasn't included in the Filter. ;D x5<br /><br />Hope this helps<br /><br />Laters<br /><br />Mark
Re: Running Calc in Analyzer	Hi Mark,<br /><br />Thanks for updating - don't forget to click on the 'tick' image, this marks the topic as 'solved' and helps others search. In this case you might want to just tick your last post.<br /><br />Cheers,<br />jon
Essbase 7.2	Does anyone know when Essbase 7.2 will be available? Is it part of 'System 9'?
Hyperion e-learning courses	Has anyone done the e-learning courses via the Hyperion website? There aren't that many but I would like some feedback before I sign up.<br />Thanks!
Re: Hyperion e-learning courses	HCG is reasonably priced and doesn't suck (this is about as close to a glowing recommendation as I give).Â We've used them in the past without regret (no, I'm not affiliated with them in any way).Â As for the ones from Hyperion, we thought they were just a little over priced (relative to the alternatives, that is).<br /><br />Here's HCG's link:<br />http://www.harbinger-group.com/index.shtml<br />
License Server 7.1.2	Hi All-<br /><br />I am trying to install Essbase 7.1.2 on UNIX.My question is how would you install the License Server?<br />How would you Stop and Start the License Server?<br /><br />Please help me out.<br /><br />Thanks in advance.<br /><br />Jeeva.
Opportunities in Detroit area	If you are looking for work as an Essbase developer or DBA, I may have some year to year contract work for you in the Detroit area.  Full details are not yet available, but we are generally looking for people with solid communications and support skills with at least 1 year of V6+ Essbase experience in a Unix environment.<br /><br />Send contact information (don't need full resume yet) to:<br />dbliss (at) wideopenwest (dotcom)<br />
Comparing substitution variable string	Hi!<br />We are using Hyperion  Planning and the admin can then lock input months from the user.<br />In order for our calc scripts to work we have assigned substitution variables which we use to find out what months are closed and which are not.<br /><br />So in my example the admin of Planning has locked to forecast scenario up until July.<br />My Substitution variable (&CurrMonth) is then set to Aug.<br /><br />In my script I want to do different things depending on the value of the substitution variable i.e.<br /><br />if( &CurrMonth=="Jan")<br />      DO SOMETHING<br />ELSEIF(&CurrMonth == "Feb")<br />    Do something else<br />etc<br />etc<br />etc<br /><br />However I cannot get this to work. I have tried using the @Name function but the compiler does not like that at all.<br /><br />So any suggestion on how to compare strings?<br /><br />Thanks,<br />Erik<br />
Re: Comparing substitution variable string	Just a thought, but -- did you check on whether the substitution variable contains quotes as part of the member name?  If so, you'll need to 'escape' the quotes on the comparison values, as they are now, they do not contain embedded quotes on the comparison.  I'm not sure how you would escape them, but something like '"Jan"' or "/"Jan/"" would be what I'd suspect is needed if your variable contains a quoted member.<br />
Re: Comparing substitution variable string	You may need to think a bit about the calculation logic, because this isn't necessarily the most elegant expression, but here's a suggestion:<br /><br />[code]<br />IF (@ISMBR("Jan") AND @ISMBR(&CurrMonth))<br />    something<br />ELSEIF (@ISMBR("Feb") AND @ISMBR(&CurrMonth))<br />    something else<br />...<br />[/code]<br /><br />or...<br /><br />[code]<br />Jan (<br />    IF (@ISMBR(&CurrMonth))<br />        something<br />    ENDIF<br />);<br />Feb (<br />    IF (@ISMBR(&CurrMonth))<br />        something<br />    ENDIF<br />);<br />...<br />[/code]<br /><br />With a bit of manipulation you might be able to express the same outcome with logic like this though:<br /><br />[code]<br />IF (@ISMBR(@LSIBLINGS(&CurrMonth)))<br />    something<br />ELSEIF (@ISMBR(&CurrMonth))<br />    something else<br />ELSEIF (@ISMBR(@RSIBLINGS(&CurrMonth)))<br />    something else again<br />ENDIF<br />[/code]<br /><br />
Re: Comparing substitution variable string	Thanks for your suggestions!<br />We solved it the easy way - instead of using text in our sub variable we just replaced it with 1 for Jan etc etc<br /><br />We could then easily compare<br /> if(&CurrMonth ==1 ) /January/<br />            'do stuff<br />elseif(&CurrMonth==2) /Feb)<br />            'etc etc<br /><br />Thanks though!<br /><br />bR,<br />Erik
Re: Comparing substitution variable string	Nice one - I've got something similar in something I'm working on now, but using a dynamic calc member to return the "month number" for use in IF statements like yours, which is actually pretty nifty.
Variation of calc times	Hi!<br />Sorry for the random question:<br />We have been tuning our calc scripts in our development environment (4gb mem, 4 CPU) with great results.<br /><br />We then moved the same calc scripts to our productions environment where the essbase setup is identical (block size, caches etc etc) to th dev environment. We have double the memory and 8 CPUs.<br /><br />Even if there are many things saying that calc times may not improve just because of the increased power, they certainly should not get any worse, which is exactly what they have done. We are losing about 10-15 seconds per script (which all are run on save in Hyperion Planning) in the production environment.<br /><br />Hyperion Planning that we use is located on a different machine together with the application server (TOmcat in dev, BEA Weblogic in prod).<br /><br />Any clues to where I might start looking would be of great help.<br /><br />Thanks,<br />Erik
Re: Variation of calc times	Could be too late but you need to confirm if it [b]is[/b] the Essbase calculation itself that's taking longer or the total process from (I assume) running business rules from a planning web form.<br /><br />Ensure the same data, same number of blocks etc, is in dev and prod and run the business rules as calc scripts (easy to make the code change) ... then you'll know if it's Essbase (unlikely) or other items in the network ... like where the relational db us located, Weblogic vs. Tomcat, etc...<br /><br />Sorry to be so late in replying ....
Analyzer 7.2.1 as a Windows service with Tomcat.	Does anyone have a batch script that will set up Analyzer to run as a Windows Service?<br /><br />Analyzer v721, using default Tomcat installation.<br />Windows 2K server.<br /><br />I've seen this for v6x but it looks like the app directory has changed.<br /><br />TIA
Re: Analyzer 7.2.1 as a Windows service with Tomcat.	You can find an example of such a batch file for Analyzer 7.2 in the Hyperion code libary:<br /><br />http://dev.hyperion.com/download/code_library/<br /><br />I never tried it out. If you use it, please write me your experiences with it :)<br /><br />I have also another code example which someone from Hyperion sent me. I also haven't<br />worked with it, I can send it to you if you want.<br /><br />Hope this is of use for you!<br />Michael
Re: Analyzer 7.2.1 as a Windows service with Tomcat.	A user on Nerwork54 posted a working solution.  http://www.network54.com/Forum/message-58296-1128536069-Tomcat+Service+Script<br /><br />Thanks
Hyperion Articles	HyperionTech Articles: http://dev.hyperion.com/resource_library/articles/
Hyperion Tips and FAQs	Hyperion Tech Tips and FAQs: http://dev.hyperion.com/resource_library/tips_faqs/
Hyperion White Papers	Hyperion  White Papers :http://dev.hyperion.com/resource_library/white_papers/
Hyperion Essbase Optimization Techniques	Hyperion Essbase Optimization Techniques:<br />http://dev.hyperion.com/resource_library/articles/optimization_techniques.cfm <br />
Hyperion Essbase Tuning And Optimization	Hyperion Essbase Tuning And Optimization:<br />http://dev.hyperion.com/resource_library/articles/tuning_and_optimization.cfm
Hyperion Code Library	Hyperion Code Library: http://dev.hyperion.com/download/code_library/
Hyperion Sample Applications	HyperionÂ Sample Applications : [url]http://dev.hyperion.com/download/sample_applications/[/url]
Hyperion Utilities	HyperionÂ Utilities :[url=http://dev.hyperion.com/download/utilities/] http://dev.hyperion.com/download/utilities/[/url]
A Quick Tour of Hyperion Essbase	A Quick Tour of Hyperion Essbase :[url]http://dev.hyperion.com/webcasts_demos/demo/quicktour/[/url]
Report from Essbase	Hi<br />I am working on a complex report where i need to retrieve level0, level1,level2 of Entity on rows for every record processed. Say, for a structure like Country->US->NAmerica->Drinks->Coke entity, should be retrieved as<br />2005 jan Actual Baseline NAmerica Drinks Coke 300<br />2005 feb Actual Baseline NAmerica Drinks Coke 200  and so on across other dimensions<br /><br />Currently i have acheieved this through HAL, where i use "extract data" fn for lev0 and pass it to "extract std dimension fn" to retrieve its parents(lev1 and lev2) and append it to the output record. As this requirement occurs during close of every planning phase, the bulk of data is huge , which almost seems not worth to do in Excel and i find lot of memory errors in HAL, advised to increase Java size by Hyperion Support, which was of no use.<br /><br />Can anyone suggest how better can these kind of report be executed.<br /><br />thanks,<br />Mohan
Re: Report from Essbase	This may not be that elegant, but it's just a thought.  What if you used the outline extractor to pull out your metadata and keep it on a worksheet in your Excel file.  On another worksheet, run your report, and then use a VLOOKUP to bring over the metadata members you need.<br /><br />HTH
Re: Report from Essbase	How about exporting all the data in column format, then importing that into Access to handle your retrieval?  Not sure how large your db is but I'm betting this probably would not work for a large export file. :-\  <br /><br />
Re: Report from Essbase	Along with the other "not so elegant" answers...<br /><br />How about importing the member/parent/parent2 in as an alias with a character delimiting them?, then you can just replace the delimiters with a tab char.Â Ugly, yes, but as long as your member names aren't too long you should be able to pull it off.<br />
Re: Report from Essbase	Hi,<br /> I had just the same thought, working on alternative where in i would create a table for entity inOracle with level members across columns through Outline Extractor. Later import all data into the another table. Finally Query linking both tables. But my concern is , if i do this way then i can develop a custom Planning application in Oracle, why do i require essbase. The HAL Extract which i triggered yesterday eve , is still fetching records....<br /><br />But one issue with the HAL i am working on , is it read/writes the file for every record fetched from Essbase , This is one big issue for getting delayed, but i have no other options to maintain a small quantum of data across files, so HAL wouldnt error out of memory issues.<br /><br />About creating alias, the application is in Phase 2 development and i am just maintaining the application , and feel the development guys would never like to change alias table or create a new alias table.<br /><br /><br /><br />
Re: Report from Essbase	Depending on the version of HAL & Planning you may experience problems related to Java (heap size, etc.) that are only fixed with newer versions of Planning/HAL (3.51 and above for Planning and 7.x for HAL).<br /><br />In any event, if you're just trying to extract your data, you could try writing a report script in EAS or App Mgr (you can create using Query Builder in Essbase Excel add-in) then run that to extract your data, but you may experience similar slowdowns (for different reasons).<br /><br />A better way is to write a calculation script to export your data using MDX as the calc engine is much faster than the report engine.<br /><br />On a side note, I don't want to second guess your application but your entity dimension seems to be mixing apples and oranges -- i.e. Region information and product information (Country->US->NAmerica->Drinks->Coke entity ) -- perhaps these should be two separate dimensions??  <br /><br />I hope this gives you something to work with.
Automate Excel exports	Hi!<br />Is there a way to automate an export to excel from reports? Since Reports graph possibilities are so horrible our users want to use Excel for graph building purposes.<br /><br />Any alternatives?<br /><br />Thanks,<br />Erik
Re: Automate Excel exports	Nope.  Would be nice though!  Have you put that in as an enhancement request?
Re: Automate Excel exports	Possible end-around (I'm not that familiar with reports, so this is only a hypothetical approach).<br /><br />a) Send the report details to any valid data source (i.e. a text file would work with the text ds).<br />b) Set the Excel workbook up to use an external query to get the data and present the graphs.<br />c) You could also use an Auto_Open macro to read the data & publish web views off the workbook.<br /><br />Not exactly client/server oriented (more client automation oriented), but sometimes "down and dirty" is what works best.  For longer term (okay, IT maintainable) solutions, you'll end up laying down some serious bucks, so lay the options out and choose your poison.  :)<br />
Re: Automate Excel exports	Please excuse me if I am missing the point here as I am also not a very experienced Reports user.  However, the reports produced must be referencing a data source, be it Planning, Financial Management, Essbase etc.<br /><br />Could you not export the data from this application to Excel and create the graph this way?<br />
How to register an essbase authenticated analyzer user	Our analyzer user (version 7.2.1.1) are authenticated through essbase.<br /><br />I do not figure out how I can register an essbase authenticated user directly through the administration java client. Today such a user has to log on first into analyzer, then he will will show up in the analyzer administration client where I can assign him a security group.<br /><br />Help is very appreciated.
Include Essbase as a domain	Essbase users can directly login to the Essbase domain via Analyzer if you include Essbase as a domain in the<br />SECURITY CONFIG of the Analyzer:<br /><br />Open <br /><br />\Hyperion\Analyzer721\conf\Analyzer.properties<br /><br />then under the section SECURITY CONFIG take<br /><br />#UseDefaultSecurityProvider=ESSBASE <br /><br />and remove the comment!! If you want the Essbase domain to be considered first, you have to change the order of the SecurityProviders.<br /><br />Hope this helps! Please write me if it works!<br /><br />Michael
Re: How to register an essbase authenticated analyzer user	Thank you for your reply, but it isn't what I meant (I have already done what you have written).<br /><br />My question was: How can I register a new analyzer user in the analyzer administrationtool, that is authenticated through essbase.<br /><br />The problem is when an essbase user logs in the first time into analyzer, he will become automatically member of a group everyone. But effectively he should be also be member of another group in order to see what he should see. So I would like to first register him in the analyzer administration tool in order to make him immediately a group member.
Re: How to register an essbase authenticated analyzer user	You should be able to specify a single group that users will be automatically added to -- I believe this is specified in a properties file and/or the Administration Client -- I'll check my copy on Monday if there's no response here :)  I tend to have users added to a group called "Essbase Users".<br /><br />There's a similar mechanism for externally authenticated users (as in CSS rather than Essbase authentication)  that's configured in the Administration Client -- Analyzer checks for group membership in LDAP/ActiveDirectory/NTLM and assigns them to some other group in Analyzer.
Re: How to register an essbase authenticated analyzer user	Yes it is correct that you can specify a single group that is automatically added to an essbase user when he first log in to Analyzer.<br /><br />In our situation, as we do not want every essbase user to see anything, we attribute the group everyone to the essbase user, where the group everyone basically has no rights at all.<br /><br />But still my original query is not answered enough. How can I register an essbase authenticated user before he once logs into analyzer in order to attribute him a group with which he sees something.<br /><br />Any help still appreciated.
Re: How to register an essbase authenticated analyzer user	I remember running up against this and thinking "this isn't good", but then got caught up in other stuff on the project and forgot about it.<br /><br />What you need to do is create the user as a locally authenticated user (Analyzer domain).<br />Assign them to the correct group.<br />Now when they login for the first time using the XAUTH Domain, Analyzer is going to prompt them and they need to specify they are a pre-existing user and login with the their external authenticated password.  Analyzer will convert them to an externally authenticated user and they will be in the correct security group.<br /><br />One thing I noticed is this whole process is very buggy.  One thing I had to do to get it to work was have the user log in once to Analyzer as the local user (Analyzer Domain), then log out and log back in using the XAUTH domain.  It seems if they didn't login the first time to the Analyzer domain, it didn't recognize them.  Probably some directories are created the first time a user logs in and they are needed for this process to work.<br /><br />It's painful and not the way it should be, but you can get it to work.  Hopefully the new System 9 will handle this better!<br /><br />Best of luck.<br />
Printing in Analyzer 7.2	Hi,<br /><br />I know Analyzer is not for printing. But, we have a requirement we have to have all the reports done in Analyzer.<br /><br />Is there anyway we can print the entire report instead of screenshot. In analyzer we can print only the grid that appers on screen. Is there anyway we can print the entire report without losing the logos and stuff.<br /><br />Even if we can export to word or pdf or any means that should be good. But we need the entire report.<br /><br />If anyone has achieved this please let us know how to do that.<br /><br />any help in this regard will be greatful.<br /><br />TIA<br />Hyperion49<br />
Re: Printing in Analyzer 7.2	Have you had any luck with this .....Â Â I have a similar problem in that I need to print Landscape reports in Intelligence/Performance Suite.Â Once a report is taken to PDF I can't seem to do anything with it ?Â <br /><br />Hope you've found a solution that you can share
Memory issues	Hi ,<br />  I get memory errors when i try to work on more than 2 MB of data (retrieving through lists). Do anyone get similar errors. Is there a workout for it.<br /><br />Thanks,<br /> Mohan
Re: Memory issues	What is your error?  This might help:<br />Increase the java memory settings in the Vignette Business Integration Studio:<br />1. Open the design time  environment and go to  Tools- Options- JVM<br />2. At the bottom of this box there is a line that state " Runtime Debugging JVM"  the "The command  that the debugger will use to start a JVM" <br />3. In this line alter the statement so the JRE can allocate more than 256m of RAM to run this process <br />For example: C:\Program Files\JavaSoft\JRE\1.3.0_05\bin\javaw.exe -Xmx512M -Xms512M -cp "${VBIS_DT_CLASSPATH}" <br /><br />
Spell check	Maybe you should add Essbase to the spell check database?Â :P
Dutch language settings problem	When the forum language is set to Dutch, a lot of the the images do not load properly. The text is all verry smooth translated!  ;)
Thijxx - Mexx Europe International	:) Hello all,<br /><br />The last few months I have been working with Pillar, Essbase and Planning as a member of the Financial Systems Control team of Mexx Europe International located in Voorschoten (The Netherlands). I'm starting with the Hyperion Bootcamp training on Essbase this week and I'm looking forward to learn more about the software!<br />As I am new to this kind of software and my main task is to maintain the Essbase environment, this forum will be very usefull to me.<br />The 'Compare Outlines' tool allready saved me LOTS of workÂ :D<br /><br />Best regards,<br /><br />- Thijs van Ulden
Essbase Administration Service 7.1.3.0 build 96 - User Comment	Hi all,<br /><br />I'm using the Essbase Administration Service 7.1.3.0 build 96 or EAS for a few months now and I think it's full of bugs.<br />Almost daily I encounter new odd problems like I had today. <br /><br />I copied a parent including a member from one outline to another and then I added an association. After a few minutes I found out that I gave the wrong association to the parent and I removed it. But when I pressed OK it was still thereÂ :-\<br />Now I have a parent that has an association I cannot deleteÂ >:(<br />Deleting the parent seems to be the only solution, too bad that doesn't work either. <br />The funny thing is that I can add associations to members and also remove them.<br /><br />EAS is giving so much different problems on a regular basis that I save my work after each adjustment, thats the only solutions I can come up with.<br />Another problem is the resources it uses, every step takes ages, and no, I'm not behind a 33MHz 486 DX2Â :P<br /><br />Does this sound familiar to people?Â ???<br /><br />Best regards,<br /><br />Thijxx<br /><br /><br />EDIT:<br />Forgot to mention I also have strange lines trough the text looking like striketrough but then only for a random amount of characters. Its gone when I scroll, maybe a performance issue?
ASO Formula	I have the member formula in BSO, i want to convert into ASO member formula.<br /><br /><br />IF(@ISIDESC ("U.S.") OR @ISIDESC ("Mexico") OR @ISIDESC ("International")) <br /> "MY Not Relevant"->"Package Not Relevant"->"US Market"->"Product Not Relevant"->"Option not Relevant"->"Input Total Retail Selling Days";<br />ELSEIF(@ISIDESC ("Canada")) <br /> "MY Not Relevant"->"Package Not Relevant"->"Canadian Market"->"Product Not Relevant"->"Option not Relevant"->"Input Total Retail Selling Days";<br />ELSEIF(@ISMBR (Markets))<br /> (("MY Not Relevant"->"Package Not Relevant"->"US Market"->"Product Not Relevant"->"Option not Relevant"->"Input Total Retail Selling Days") * 3 + <br /> "MY Not Relevant"->"Package Not Relevant"->"Canadian Market"->"Product Not Relevant"->"Option not Relevant"->"Input Total Retail Selling Days")/4;<br />ENDIF<br /><br />Thanks<br />sri
Re: ASO Formula	You can use an IIF in MDX, but there is no direct ISDESC equivalent and you have to use tuples in place of the cross dimensional operator:<br /><br />IIF (<br /> (IsAncestor([Region].CurrentMember, [U.S.]) OR IsAncestor([Region].CurrentMember, [Mexico]) OR IsAncestor([Region].CurrentMember, [International]), <br /> ([MY Not Relevant], [Package Not Relevant], [US Market"],[Product Not Relevant], [Option not Relevant], [Input Total Retail Selling Days]), <br /> IIF(IsAncestor ([Region].CurrentMember, [Canada]), <br /> ..tuple for Canada.., <br /> IIF ([Region].CurrentMember IS [Markets], <br /> ... tuple for Markets ...<br /> ... else ...<br /> )<br /> )<br />)<br /><br />Now, I did not test or validate this since I don't know what the outline looks like, but hopefully it gives you the gist of it.<br /><br />Regards,<br />Jade<br />
Re: ASO Formula	I would probably use CASE instead of IIF as you have a bunch of ELSEIF statements in your BSO formula.  Also a handy way to check "ISDESC" is to do the following:<br /><br />[code]<br />IsValid(<br />            Intersect( <br />                          {[Region].CurrentMember}, {Descendants([US]) } <br />                          ) <br />            )<br />[/code]<br /><br />Basically, that tests to see if the current member intersects with the Desc. of US.  If so it will return True to an IF test or a CASE statement.  Note the "{ }" as the Intersect function requires a SET definition which is setup with the { }.
Application Manager vs. EAS	Hello,<br /><br />does anyone have a document in which the Application Manager is compared to the EAS? Which features<br />are new in EAS and, most important, I need the advantages of the EAS.<br /><br />Thanks for help in advance!<br /><br />Michael
Re: Application Manager vs. EAS	Essentially, Application Manager is going away and Analysis Services will be the new standard.  I know many folks aren't used to EAS yet, but It is probably a good idea to start getting used to it.  From Hyperion's site, here's their answer:<br /><br />Essbase Administration Services compared to Application Manager<br /> <br />Administration Services is the new cross-platform framework for managing and maintaining Hyperion Essbase. Administration Services provides a single point of access for viewing, managing, and maintaining Analytic Servers, applications, and databases. This new product incorporates the functionality of Application Manager, provides other new administrative features, and includes Essbase administration tools, such as MaxL.<br /><br />Starting with release 7.0 of Hyperion Essbase, Application Manager will no longer be upgraded to include new features. Administration Services Release 7.0 is now the standard tool to manage the Essbase environment.<br /> <br />And a link to get you started...<br /><br />http://dev.hyperion.com/products/administration_services/<br /><br />
Re: Application Manager vs. EAS	I've been using EAS for a few months now and after some initial culture shock I've found it is usable, albeit far from perfect.<br /><br />The old App Mgr had been around for sooo long one just got used to the same defects release after release after release after release ... well you get the picture.Â ;)<br /><br />Anyway, I suspect that EAS will also continue to have it's own set of ongoing "features" for years and years and ...<br /><br />The editors, for example, are a case of two steps forward one back. Colour highlighting is good, the editors themselves are crap - highlight colours screwed, a few have text finds most don't, replace features lacking, fonts suck, tabs don't work post the second in Rule Editor, and many more, text wrapping is frustrating. But you can finally use long file names, in places, but not spaces. <br /><br />The right click context menus are good. But the screen sizing is poor (should be able to float them) and consistency is notable for the fact that it appears to have been misplaced during development. For all that it's better than App Mgr.<br /><br />Generally I'd say it is an improvement though far from the quality or content of what it [b]should[/b] be! :(<br /><br />
Re: Application Manager vs. EAS	Thank you both for help and the link!  :)<br /><br />Next week I have to introduce people to the EAS and tell them why it is better to use it<br />instead of the App Manager. I know most advantages, but I was looking for some kind of<br />summary of them. But your comments are also very useful!<br /><br />Thanks again!<br /><br />Michael<br /><br /><br />
Re: Application Manager vs. EAS	I've found it really flakey (v7.1.0) too.Â Often slow, unstable, consumes an ever-increasing amount of memory and has a lot of glitching in the display of formulae, outlines etc.<br /><br />I also found that the EAS service on the server would hang every now and then, which is a pain as we would have to wait for technical support to restart it.Â We had to keep Application Manager on one machine so that if the EAS service stopped at a critical moment we'd still be able to get in.<br /><br />One really nice 'pro' is that it seems to read only the members you 'need' in an Outline Editor only, rather than - as App Manager appears to do - loading the entire structure in client memory.Â So you can open and save very large outlines in seconds, rather than minutes (if it all, on low-spec machines).<br /><br />I understand later versions are more stable though, and given that new features are / will not be supported in AM - notably ASO at present, unless anyone knows otherwise - it seems the only choice for new installations.Â The 'cons', in my opinion, are all to do with the implementation rather the functionality itself.
Installation of Administration console on a network drive	Hello,<br /><br />is it possible to install the administration console on a network drive so that it is not required to install it <br />on all locale machines? If so, what are the advantages and disadvantages?<br /><br />Thank you for help!<br /><br />Michael
Re: Installation of Administration console on a network drive	I've installed it locally on a desktop and on a server where the admins would connect to the server (whether directly on App server or Terminal Services Server).  The latter is probably the easiest so you don't have to load on several desktops -- in addition, I'd assume the server would be on the same sub-net as the Essbase server (or close to it) and as such might give you a faster connection/response time.
Re: Installation of Administration console on a network drive	If you mean <br /><br />"can I install it to a network drive then run it from a PC connected to that network drive but not the one I installed from" <br /><br />try it. I'd like to know the answer. If this work I can see no real issues outside of a slight increase in startup time and the usual (unlikely) network failure risks.<br /><br />I've used on Citrix and locally ... prefer it locally. Using Terminal Services is little different, experience wise, than doing it locally but you need enough TS licences...<br />
Re: Installation of Administration console on a network drive	Yes I mean exactly that! We will install EAS on a network drive. Everybody who needs to use can start it from there. I will keep you updated if it really works!<br /><br />Thanks<br /><br />Michael
Essbase Server being replaced - 2 less CPUs	One of our Windows Essbase servers is being replaced. Currently, we have 4 CPU on the box and I am being told that the new server will only have 2 "modern" CPUs that are much faster than the 4 old CPUs.Â I still feel 4 CPUs are better that 2, no matter faster they are.<br />There are 4 application running on this box.<br />Any thoughts, feedback.<br /><br />Tom<br />Essbase 6.5.4
Re: Essbase Server being replaced - 2 less CPUs	[b]More = Better[/b] ;D<br /><br />Fundamental rule of computers! <br /><br />The answer is "it depends". It depends upon your concurrency (particularly of calculation), disk, memory, application and database design, functions / calcs / rules, sparcity, number of users, method of access, usage patterns, network, the number you first thought of and your bosses starsign.<br /><br />I've generally found - and this is really, really simplified - that Essbase Calculations love CPU cycles.<br /><br />But the old "suck it and see" approach is best. <br /><br />I do have one serious suggestion - ask "them" (IT / procurement / whomever) to purchase the 2CPU server as a 4CPU chassis with only 2CPUs - that way an upgrade, if necessary, is far cheaper. And the initial purchase not much more than a full 2CPU chassis. <br /><br />Win this argument and you're close to getting the extra 2CPUs anyway  ;)<br /><br />Get more RAM whilst you're at it ... and faster disk (if it's internal) ...
Re: Essbase Server being replaced - 2 less CPUs	... and don't forget that gigabit ethernet connection with built in SAN and n-way segment multiplexing...<br /><br />(sorry couldn't resist)  ;D<br />
Label Only in EIS	Hi guys,<br /><br />I have a basic question regarding label only members in EIS.<br /><br />If i have a label only member in Essbase and I choose the same member in my report it brings in the first child member values. I know that part.<br /><br />But, my EIS developer says that we cant have label only members in EIS as it wont work the same way.  I do not know much about EIS.<br /><br />All i want to know is can i have Label Only members in EIS build cubes or not? <br /><br />If possible how can i do that?<br /><br />If it is not possible can someone please tell me what are the situations we cant do?<br /><br />Any help will be appreciated.<br /><br />TIA<br />Hyperion49
Links on newhome.asp	Hi!<br />Using the 3.5 version of HFM and I am wondering if it is possible to place a link to a document on the Links section of the default start page (i.e newhome.asp)? If so it is possible to restrict this link to one application on the server or will all applications have access to this link?<br /><br />Thanks,<br />Erik
Re: Links on newhome.asp	Sure it is possible. Just create the link in the required position. Remember to back up the original file and then copy/amend existing links s required. We did this for including links to such items as corporate intranet, training etc<br /><br />This is an all app page, so unless you get creative and create a newhomeapp1; newhomeapp2 etc, which means amending other asp's as well, then thats your lot. To do the multi page option is risky in limitations for future upgrades!<br /><br />Remember, if you have designs on upgrading to v4, the concept of homepage is obsolete. But thats a seperate thread discussion re accessing external links.
Re: Links on newhome.asp	You will need to insert the link in the Sub PrintLinksTable () section of Home.asp.Â As far as I am aware you can link to documents or web addresses.<br /><br />Any links you insert will display for all applications.
User Group	to see itinerary, go to [url=http://www.nchug.net]www.nchug.net [/url] <br /><br />for directions and location in Charlotte, NC
Shared Member in ASO	All -<br /><br />I am migrating outlines from 6.5(BSO) to 7.1.2 (ASO).When I migrate I am unable to migrate shared members from BSO to ASO even after assigning the DIMENSION as Multiple Hierarchies Enabled.<br /><br />For Ex:<br /><br />DIM 1 (Multiple Hierarchy Enabled).....<br />        Member 1 (Dynamic Hierarchy)<br />                  Child 1<br />                  Child 2<br />                  Child 3<br />                  Child4<br />        Member 2 (Stored Hierarchy)<br />                  Child 3 (Shrared Member)<br />                  Child 4(Shared Member)<br /><br />I get an Error message as ASO does not support Shared Members but I have read that if you enable a dimension as Multiple Hierarchy Enabled you can assing members of a Stored hierarchy as shared members.<br />Please help with any inputs.<br />Thanks in advance.<br /><br />Jeeva<br />
Re: Shared Member in ASO	Jeeva -<br /><br />The first hierarchy under a Multiple Hierarchy dimension must be Stored.  You could switch the order of Member 1 and Member 2 and move the Shared Member designation from Child 3 and Child 4 in Member 2 to those members in Member 1.  (Shared members must always come below the first instance of that member.<br /><br />- Joe
Re: Shared Member in ASO	I was able to resolve this doing these: <br />In BSO outline, temporarily rename your shared members - just so the ASO outline Conversion wizard can work. <br /><br />Once converted, change Dimension  (DIM1) to Dynamic Hierarchy. Restore shared members to original names. <br />
Recursion Limit	Hi,<br /><br />Whenever i try to run my report in Analyzer i get the following error and the report wont open.<br /><br />[b]Error(1200494) Error Executing formula for [Loss Ratio]: Recursion limit [31] reached.[/b]<br /><br />This is an ASO Cube and i am not familiar with ASO.  <br /><br />Is there anyway we can fix this?<br /><br />Thanks<br />Hyperion49
Re: Recursion Limit	What's the formula? <br /><br />I suspect simply finding a flag to increase the recursion limit not the answer.<br /><br /> ;)
Re: Recursion Limit	Hi chris,<br /><br />Thanks for the reply the formula is pretty simple. <br /><br />[b]Loss Ratio = (Incurred Losses.current member of accident year)/(Earned Premium. current member of Accident Year)[/b]<br /><br />Is there anyway we can fix thsi recursion limit in ASO Cubes.<br /><br />Thanks<br />Hyperio49
Re: Recursion Limit	There is a new Essbase.cfg setting that determines this.  You can set <br />[code]<br />CALCLIMITFORMULARECURSION FALSE<br />[/code]<br /><br />In the config file.  However, be careful.  The limit of 31 recursions is there to prevent calcs from running away and crashing the server.  Test, test, test to make sure that multiple users retrieving that formula don't crash the server.
Analyzer server installation error:[1033] native: 2001 Essbase Error; nested exc	???<br /><br />it is really a hard work to deal with the installation of <br />ibm olap server analyzer analysis services (hyperion analyzer 7.0.1.8) .<br /><br />i have read theÂ articleÂ at http://businessintelligence.ittoolbox.com/groups/groups.asp?v=hyperion-l&i=277513<br /><br />it is about a problem of installing hyperion analyzer.<br /><br />I am now having the same problem and I trie the methods above but it doesn't work.<br /><br />I have carefully checked the 3 variables (in the article):<br /><br />ARBORPATH = points to the essbase directory<br />PATH = pointed to the essbase/bin directory<br />LD_LIBRARY_PATH = pointed to the /essbase/dlls and the /essbase/bin<br /><br />NOTE: the essbase/dlls directory does not exists/<br /><br />I have <br /><br />1 - olap server (hyperion version 7.1)Â /opt/arbor<br />2 - db2 UDBÂ /opt/IBM/db2/V8.1<br />3 - analyzer serverÂ /opt/hyperion/analyzer<br /><br />all installed on the same machine which is a sun workstation(SPARC) running solaris 8 .<br /><br /><br /> PATH=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common::/usr/bin:/usr/sbin:/usr/ccs/bin:.:/opt/arbor/bin:/opt/arbor/common/ODBC/Merant/4.2/lib<br /> LOGNAME=root<br /> MAIL=/var/mail/root<br /> ESSLANG=SimplifiedChinese_China.MS936@Binary<br /> ARBORPATH=/opt/arbor<br /> SHELL=/bin/ksh<br /> JAVA_HOME=/opt/hyperion/analyzer/jdk<br /> ICU_DATA=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common:/HssEssDriver/<br /> ODBCINI=/opt/arbor/common/ODBC/Merant/4.2/odbc.ini<br /> HYPERION_HOME=/opt/hyperion/analyzer<br /> HOME=/export/home/root<br /> LD_LIBRARY_PATH=/opt/hyperion/analyzer/adm/bin/solaris:/opt/hyperion/analyzer/common:::/usr/openwin/lib:/usr/lib:/opt/arbor/bin:/opt/arbor/common/ODBC/Merant/4.2/lib<br /><br /><br />when i tried to make a connection to olap server through the applet program ,i got the following message:<br />Â Â <br />[color=Red][1033] native: 2001 Essbase Error; nested exception is :<br />        <br />        com.hyperion.ap.APException:[1033] Native: 2001<br />        <br />  Essbase Error[/color]<br />but when i try to connect to db2 udb ,it works fine.<br /><br />my olap server also works fine , i can use maxl and ESSCMD correctly<br /><br />anyone who can help me ? thanks in advance !<br /><br />BTW ,i am from china ,so the lang var is zh.GBK <br />
Re: Analyzer server installation error:[1033] native: 2001 Essbase Error; nested exc	I have solved the problem by creating symbol links to the essbase library file:<br /><br />libessapi.so -> libessapiu.so.1<br />llibessapiu.so -> libessapiu.so.1<br />libessotl.so -> libessotlu.so.1<br /><br />there are some very important log files which can help to position this problem:<br /><br />Analyzer_install_path/appserver/logs/.....
Re: Analyzer server installation error:[1033] native: 2001 Essbase Error; nested exc	Good experience shared with us.<br /><br />Thanks. Man from China.
Unable to save in EIS	I don't know why but since last week I have been unable to save a model or a metaoutline in EIS (Hourglass for ever!)<br /><br />SERVER OS: Linux Redhat Version 3<br />EIS VERSION: Release: 7.1 (Build EIS71B168)<br /><br />I've tested with a EIS console on 3 different PCs (two XP and one 2000) --> same result<br />There is no error message and everything else works fine. I can do outline or data load without any problem  ???<br /><br />is this issue sound familiar to someone?
Lock Outline	Hi All,<br /><br />Just wondering if anyone out there could throw me some pointers.Â I have an Outline which says its locked, but when checking for locked objects its not shown as locked.<br /><br />I have run a MAXL script (see below) to clear any hidden locks but this doesn't work either.<br /><br />[code]alter database 'Payroll'.'PayMth' unlock all objects;<br /><br />alter system logout session on database 'Payroll'.'PayMth';<br />alter system kill request on database 'Payroll'.'PayMth';<br />alter database 'Payroll'.'PayMth' disable startup;<br /><br />alter database 'Payroll'.'PayMth' enable startup;[/code]<br /><br />Thanks in advance<br /><br />Mark ???
Re: Lock Outline	Occasionally, there is an issue where some "hidden object" gets locked by a user.  One way to clear the lock is to delete the user that holds the lock.  Of course, you should copy the user to another name and then rename them afterward (and if they are internally authenticated, inform them of their "temporary" password, etc...).<br /><br />This works in cases where the lock was performed in Essbase, and the object was either deleted behind Essbase's back, or the security file was somehow "out of touch" (i.e. restored afterward) when the lock was removed, user deleted, etc...<br /><br />In other words, a lot of different ways can result in this "Essbase" style lock, and the solution is relatively easy (apart from informing the user of the need to reset their password).<br /><br />However, some times, the lock is made at an O.S. level.  Perhaps someone opened the file on the server and never released the lock that the system placed on the file.  This will occasionally prevent Essbase from getting it's own lock, and it naturally shows up as an already locked object.  The solution here is to go in and remove the O.S. lock (chmod in Unix, R/O property in Win, etc.).<br /><br />HTH<br />
Re: Lock Outline	Hey DougWare<br /><br />That did the trick - Thanks V.Much<br /><br />Mark ;D
Re: Lock Outline	Has another "locked Object" issue recently. :'(<br /><br />Copied the database and.. ;D<br /><br />just another way of getting rid of a lock.  However, we have some small db's so I don't know what the affect of this would be with a larger Db<br /><br />Regards<br /><br />Mark
Formula in ASO outline - causes Excel retrieves to run slow	I have a formula in a member (TimeX) of my Time dimension and it is causing my Excel retrieves to run slow.  It's a simple formula:<br /><br />TimeX:<br />IIF ( IsUda([Account].CurrentMember, "Asset"), <br />    ([Jun-05])<br />    , [Q3-05] )<br /><br />This is the only formula in the entire outline.  Retrieves on TimeX are taking 24 secs.  If my retrieve does not include TimeX, it takes less than a sec.  Has anyone else notice the same performance degradation when using a formula?  Is there a way to speed our Excel retrieves up?  ASO is not as useful to most people if a formula causes retrieves to be slow.  We are running Essbase 7.1.2 on Windows 2000.
Re: Formula in ASO outline - causes Excel retrieves to run slow	I have been working with ASO a lot and have not had any issues like you describe.  There is a bug in 7.1.2 with UDA's and retrieves though so you may want to investigate that avenue.<br /><br />Also, try using a CASE statement and see if that speeds it up any.<br /><br />[code]<br /><br />CASE<br />    WHEN(IsUDA([Account].CurrentMember, "Asset")<br />          THEN<br />                [Jun-05]<br /><br />ELSE<br /><br />      [Q3-05]<br /><br />END<br /><br />[/code]
Getting Page cannot be found when trying to launch Administration Tools client	I was wondering if anyone ran into this issue.  I launch the Analyzer start page and on that page there are links for the Java, HTML clients and the Administration Tools.  I can get into both Java and HTML clients without a problem but when I click on the Administration Tools I get "Page Canoot be Found" error.  I checked the URL that it's being called and it's a correct one.  This used to work a few months ago but now it doesn't.<br />This is Analyzer 7.0.1 running on a Win2003 server on Websphere 5.0.2.<br /><br />I checked the Websphere logs and I see this entry in the SystemOut.log:<br /><br />[i][10/19/05 13:31:53:225 EDT] 7fc932bf WebAppServlet E SRVE0182E: Caught an exception trying to load a JSP on startup: java.io.FileNotFoundException: /Administrator.jsp<br />  at com.ibm.ws.webcontainer.jsp.servlet.JspServlet.loadJSP(JspServlet.java:9<br />14) [/i]<br /><br />Has anyone ran into this problem?<br /><br />Thanks,<br />Mario
Re: Getting Page cannot be found when trying to launch Administration Tools client	You might want to check your privelges, which might have been "revoked" to a user instead of the earlier Administrator.<br /><br />HTH
Re: Getting Page cannot be found when trying to launch Administration Tools clie	Thanks for the suggestions - I just solved the problem by comparing setups on two servers.  What I found was that Administrator.jsp was missing from my Analyzer folder.<br /><br />After I copied it to:<br />\WebSphere\AppServer\installedApps\HIXHYPDEV1\Analyzer70.ear\Analyzer7<br />0.war\<br /><br />I could access Administrator Tools again.<br /><br />Mario
Re: Getting Page cannot be found when trying to launch Administration Tools client	Good, Hope the info was useful. If so, do leave a feedback/comment for the user.<br /><br />Also, don't forget to click on the 'tick' image, this marks the topic as 'solved' and helps others search.
Re: How can i exclude #missing value from the Time Balance Avg calculation?	thanks anyway to garycris.<br /><br />I am using IBM DB2 OLAP SERVER 8.2( hyperion essbase 7.1) and IBM will not continue  cooperating with hyperion ,so I can not get the newest patch/release version .<br /><br />Now I am trying to solve this problem with Calculate script/ formula .<br /><br />
How can i exclude #missing value from the Time Balance Avg calculation?	very strange problem :<br /> I have a account member tagged with Time Balance Avg ,and i have four Time member: Qtr1 , Jan, Feb, Mar<br /><br />the values are:<br /><br />Jan 100<br />Feb 200<br />Mar #missing<br />Qtr1 100 <br /><br />But the expected value of Qtr should be (100+200)/2=150 ,<br /><br />so I tagged the account member with the 'skip #missing value in Time Balance'  and then verify and save the outline.<br /><br />After I re-calculated the cube ,I found the value remain the error one : 100 not 150<br /><br />and when I re-opened the outline ,I found that the tag 'skip #missing value ...' was missing.<br /><br />then I tried several times ,but still couldn't add the 'skip #missing...' tag to the account member<br /><br />Does anyone know why? <br /><br />see the attachment pls.<br /><br /><br /><br /><br /><br />
Re: How can i exclude #missing value from the Time Balance Avg calculation?	Had a couple of minutes to kill so I built a quick test app and made it identical to yours.  Was able to get the correct resluts.  Not sure what could be causing the problem, but the underlying functionality appears to work.<br /><br />Tested on Essbase version 7.1.3.<br /><br />Best of luck, if you figure out what was causing the problem, post the solution.<br /><br /><br /><br />
Re: How can i exclude #missing value from the Time Balance Avg calculation?	Just came up with one more thing.  Did you clear your data after you made the change to the setting?  Try clearing your data, reloading and see if the problem persists.
Re: How can i exclude #missing value from the Time Balance Avg calculation?	thanks to garycris !<br /><br />I can get the picture too.<br /><br />The problem is that when I saved the outline and re-open this outline ,the 'skip ...' tag disappeared.<br /><br />And I had cleared all the data before I modified the outline.
Re: How can i exclude #missing value from the Time Balance Avg calculation?	by the way ,my essbase version is Release 7.1.0 (ESB7103B019)
Re: How can i exclude #missing value from the Time Balance Avg calculation?	Now I'm wondering if it's a bug in that version.  When I tested it I was able to save the outline, close it and when I went back the skip #missing tag was still in place.
Creating a "Complex" spreadsheet	::)<br /><br />I am trying to create a spreadsheet with too many variables...or so it seems. A little background:<br /><br />The basic spreadsheet is a plot of [b]Time [/b] vs [b]Program[/b]. The other dimension members are: <br />[b]Organization[/b], [b]Scenario[/b], [b]Measures[/b].<br /><br />The "complex" part is:<br /><br />I need to extract the Actuals ([b]Scenario[/b]) for a Division ([b]Organization[/b]).......I have set them up as Page Dimensions....for two measures (A, B, C...in one member of [b]Measures[/b] vs X, Y, Z in another member of [b]Measures[/b]).<br /><br />Can I create all of them in one report? If so how?? The complexity arises mainly due to the fact that I have already chosen [b]Measures[/b] for A,B,C....so when I create another combox for X, Y Z....results are not what I expect to see.<br /><br />I am sure there is a more effective way of doing this...<br /><br />I will need to create a several similar reports for different scenarios?<br /><br />Any help will be appreciated.<br /><br /><br />
Re: Creating a "Complex" spreadsheet	It depends on how interactive you want the report to be for your users.  If you can pre-define the views, you can do it, but there ability to drill and pivot, etc becomes limited.<br /><br />The process in Analyzer is clunky but basically it can be done with the Show/Hide functionality.  Using the Show/Hide with Advanced member selection you can remove from view the "extra" results you don't want your users to see.  Basically you're creating asymmetric reports in Analyzer (which by default does symmetric reports).<br /><br />HTH
Re: Creating a "Complex" spreadsheet	Gary:<br /><br />Thank  you for your prompt reply.<br /><br />To expand further,<br /><br />The "problem" is mainly from the fact that I am using members from the same dimension to (as you rightly fathomed) create assymmetric views.<br /><br />Thus a user from a particular organization  should be able to able to toggle between Forecast and Actual ([b]Scenario[/b]) but should be able to view C([b]measure[/b])-Y([b]measure[/b]) for October 2005.<br /><br />Does it make sense??? <br /><br />Currently, the users are using excel and have several views and a lot of manual labor is involved to arrive a particular value.<br /><br />I am not sure how Show/Hide may work in this situation.<br /><br />Regards<br />
Re: Creating a "Complex" spreadsheet	I'm not certain it would work for you without actually seeing what you are trying to do.  The idea behind Show/Hide is to first pull a Symmetric report and then hide the rows/columns you don't want to see to make it Asymetric.  The problem is that you lose a lot of the 'dynamic' functionality and the reports become more static giving the user less functionality.  Ther reason for that is because it's usually too much work to try to pre-build every view a user might want.<br /><br />A simple example would be if you had Scenario Actual and Budget on your columns along with your months and you wanted to see Jan:Jun Actual and then Jul:Dec Budget.  In order to do that you would pull Jan:Dec for Actual and Budget and then use Show/Hide to hide Jan:Jun Budget and Jul:Dec Actual.  From a presentation perspective it will look nice, the problem starts to come next month when you want it to roll.  The report becomes very maintenance intensive and you have to go and update the show hide settings.  Moral of the story is that Analyzer is not great for Asymetric reports.  Do you have Hyperion Reports?  That product's Grid layout allows you to do Asymetric reports pretty easily and the web interface would give your users a familiar way to connect.  Another option would be to build an Excel package and use VBA to automate the things that are slowing you down with the current Excel package.<br /><br />Sorry it's not more help.
Re: Creating a "Complex" spreadsheet	Gary:<br /><br />It makes sense. Thanks a lot for the detailed explanation. I have been able to work around that "problem", though not exactly as I wanted it to be at the start.<br /><br />On a different issue:<br />1) How do I share access of my reports/presentations with users? Though I, as an administrator, have given them requisite list/read rights and even placed the individual reports and presentation in their folder, they are able to access only the individual reports...and not the presentation. What am I doing wrong?<br /><br />2) How do I add comments to my reports/presentations for users to see (as a part of the repor/presentation)?<br /><br />Thanks again Gary<br /><br />
Re: Creating a "Complex" spreadsheet	Have you set the security for the presentation to allow the users to have access to it?  Try going to the view pane, navigate to your presentation, right click the presentation, go to the Security tab and assign access there.<br /><br />As far as Comments, I take it you mean a description that is more descriptive than the Save As file name.  Following the steps above if you go to any report or presentations properties via right click menu, you can set the description.  If by comment you meant some kind of text in the actual report, then you should look at Label or Text Area objects.<br /><br />HTH
Security Dumper add-in (auditing)	This add-in extends the Essbase menu to allow creating a dump of the Essbase security (more complete than the security workbook posted in the other thread).<br /><br />This list includes all filter details, all group details, and all access details, for a given database, and was intended as an "audit" tool.<br /><br />Between this add-in and the security workbook already posted (which was intended to make managing security assignments easier, not so much for auditing), I'm about done messing with security.  ::)<br /><br />
Re: Security Dumper add-in (auditing)	This tool is quite nifty. Thanks for sharing it with us. <br /><br />Doug- here is a question for you on a related note, I am not really familiar with either VBA macro programming nor VB. How difficult is it to learn VBA programming and apply it in the Essbase world? If one does end up learning this, how frequently they might use it in the real world such as day to day activities, maybe as an Essbase developer? Never got around to learning API/VBA etc., :(
Re: Security Dumper add-in (auditing)	I have personally owned every version of VB produced (INCLUDING the truly awfull "VB DOS", which I somehow managed to market an application in).Â So to me, VB is like a second language, and VBA has become the dialect of choice.<br /><br />How easy is it to learn?Â Too easy.Â Script kiddies dabble in it and claim proficiency.Â Casual users think they've mastered it because they can automate tasks in Excel and take complete control of the application.Â VB has always had a bad rep because "it lacked structure", and VBA has taken on that same rep because it ALLOWS unstructured development.<br /><br />Does this mean I try to discourage it's use?Â Yes and no.Â It's not the answer to every problem, and for ANY business environment, it should be reserved as a last resort solution.Â Minimizing it's uses is a good thing, but because of it's bad reputation, many IT departments have outright outlawed it entirely, which is NOT a good thing.Â It doesn't take into account the benefits it provides to those "novice users", the independence it gives to anyone that takes a little time to learn it, OR the amazing versatility it gives to professional deveopers that have truly mastered it.Â People rip on it using old programming concepts, not realizing that the abilities VB has brought to users have made those concepts obsolete.<br /><br />You see, the "bad reputation" is not fair because it presumes that the maintenance aspect of VBA code will always be a higher price to pay than the loss of benefit or the upfront development time of alternative approaches.Â It's also not fair because today's development alternatives suffer from (pretty much) the same issues, just with a "protected" skill set that IT fiefdoms can more easily reserve to themselves.<br /><br />I remember a developer conference where a well known C++ programmer compared C++ to VB, and he showed some beautifully drafted C code to do some simple string parsing (a supposed weak point in VB).Â He then displayed some "VB Code" to do the "same thing", and used this as a basis for comparison.Â Naturally, the C++ program was 10 times faster than the VB crap he used.Â Within a couple hours, I designed some VB code, and using his C++ code for comparison, had a VB version that ran nearly 3% faster than his original version (under "normal" conditions, well written functionally identical C++ code would run a fraction of a percent faster than the VB version, I can only assume that I was able to get better optimization in the algorithm itself).Â The point -- C++ uses a set of highly [s]compiled[/s] optimized DLL's to do it's real low level work, BUT SO DOES VB.Â Until recently, the VB run time DLL's were NOT that optimized.Â Now, however, you pretty much have to write sloppy code to get "poor" results.<br /><br />As for using VB/VBA with Essbase -- well, I'd say it was moderately easy.Â It's easy in the sense that the Essbase API is easy to work with, and not quite so easy when you consider that using any API at all can be frustrating to novice users.Â It's procedural instead of object oriented, for one thing, and for another, the sample code used to explain the Essbase API is written with the same care as the VB code written by that C++ programmer at the developer conference I mentioned above.<br /><br />My recommendations:<br />- Don't be afraid of using VBA in Excel, get samples, get comfortable, get creative.Â This is what makes it powerful AND useful.<br />- Always use "Option Explicit" -- this is an absolute must.<br />- Keep it simple -- complexity breeds problems like nothing else.<br />- Don't try to create applications or "applets" -- instead, create tools that help you get the job done.Â This distinction helps keep each element separate, which leads to less complexity.<br /><br />One last thing -- IT departments can not support user generated code, so if a problem occurs, you are on your own.Â However, it's not difficult to get help from the forums, like this one.
Re: Security Dumper add-in (auditing)	Hey Doug,<br /><br />That's a nice write up.  Would you mind elaborating a little more on the<br /><br />"- Always use "Option Explicit" -- this is an absolute must."<br /><br />TIA
Re: Security Dumper add-in (auditing)	Doug - Thanks for the excellent write-up. The information you have provided is invaluable for a VBA/programming n00b like me. I am planning to buy a VBA Macro Programming book. If yourself or anyone in this board have suggestions on a good book, could you please share it with us? Thanks again! :)
Re: Security Dumper add-in (auditing)	Sure,<br /><br />"Option Explicit" is an absolute must for a lot of related reasons.  I'll begin by what it does for the compiler, as a review of it's original design, and then go on to why this is so critical.<br /><br />Option Explicit forces variables to be explicitly declared in the code, as opposed to allowing undeclared variables to be generated for you.  When you fail to declare your variables, VB will (by default) happily supply you with a variant class variable.  Variant's are not type cast in any meaningful way, and can be used to store any type of value.<br /><br />Now why it's critical for good development:<br /><br />1) Your variables won't be type cast without being declared, so overflows and assignments could generate invalid results, this is generally known as "Evil Type Conversion" (although this also applies to conversions between typed variables as well).<br /><br />2) If you have a typo in your code, there will be no indication, and you end up with two different variables that are especially difficult to identify.  This particular issue exists even if you declare your variables, without the option explicit keyword, you'll get no outward indication that a problem exists.<br /><br />3) Most importantly, maintenance will always be made more complicated when you deal with undeclared variables, even if you declare them routinely, the potential for an undeclared variable is enough to cause unnecessary maintenance problems.<br /><br />So you may be saying to yourself, "so what, big deal" -- the point is that it really is a big deal.  The effort required to declare variables is miniscule compared to the effort associated with fixing a bug in a project that doesn't require them.  While a project that contains option explicit may not be well designed, I consider any project without option explicit to automatically fall into the "poorly coded" category.  Not out of a sense of moral superiority, but because it lacks the most basic troubleshooting tools to help correct any bugs that might exist.<br /><br />Finally, there are a number of "standards" that actively help to distinguish "well developed" projects from hastily assembled macro collections, and you'd be hard pressed to find one that doesn't place "option explicit" at or near the top of the list.  It's not obvious, but there's a reason this represents a consistency you won't find in most other elements of a good standard -- it just helps promote good programming skills from the start.<br />
Re: Security Dumper add-in (auditing)	Thanks for that great tool. I just use to audit some filters recently.<br />The only issue I found is that some of my filter rows are longer than 511 characters! and then they are not displayed totaly in Excel cells.<br /><br />Best regards and keep on dougwaring!<br /><br />SÃ©bastien Roux<br /><br />
Re: Security Dumper add-in (auditing)	Hmm, unless this was a change in V7, you are probably looking at a real issue there -- for the filters themselves.<br /><br />I can confirm that for version 6.5 and below, anything beyond 511 chars (510, actually) is truncated in a filter line.  The best thing to do is break long lines up into multiple lines, and avoid lines longer than ~500 chars.<br /><br />This isn't an issue with the tool, it's an issue with the filter itself, I pull the entire filter line using the API, and if it cannot see the whole line, neither can Essbase (you can confirm this by trying to edit the line in Application Manager).<br /><br />However, if this has changed in V7+, it has some backward compatibility issues that I'll need to deal with -- but I'd still recommend keeping the lines shorter.<br /><br />Thanks for the feedback++<br />-Doug<br />
Can I change the cell size of my database?	the docs says: the space allocated to each cell is 8 byte <br /><br />if my data value will never be greater than 4 byte ,can i change it to 4 byte? how?<br /><br />if essbase does not allow me to change this param ,why?
Re: Can I change the cell size of my database?	No, you cannot change the cell size. <br /><br />There are plenty of historical reasons why this is not alterable, it is not too difficult to understand why.Â ;)<br /><br />The good news, perhaps, is that ASO in the new Version 9 will automatically store to 2, 4 or 8 bytes depending on the value required.<br />
Re: Can I change the cell size of my database?	thanks to Chris Cameron
Re: Can I change the cell size of my database?	Additionally, compression settings will determine how big your block size actually is so many of those 8 byte cells will be compressed down if they are empty.
Re: Can I change the cell size of my database?	It has been many a year since I last did testing on compression types (BSO, obviously) and then it seemed to be a quite specific scenario before one option showed any significant improvement on another.<br /><br />Do you have any samples or test results (mine being long gone...) that could give a more definitive "in these conditions use bitmap, in these use RLE, etc"?
Re: Can I change the cell size of my database?	Chris - I can't say that I know any more than what I learned years ago.  I guess I haven't done much testing either.  The rules that I always went by were based on block density.  When you have low block density and are loading zeroes (bad idea anyway) you should use RLE.  If you have extremely high block density (over 80%) use no compression and everything else should be Bitmap.  I forget which version but fairly recently they released a 4th compression type which is ZLIB and I believe it's based on the same algorithm that "Zip" programs use.  I've never tried it.  I'd also say that it's been a very long time since I used anything other than BitMap.
Re: Can I change the cell size of my database?	What about the use of the Accounts tag to indicate a compression dimension?  I read in System 9 dbag that I should be able to see the bundle fill and average bundle length in DB properties but I do not see them.  Any ideas?  Is this only in a System 9 version - I thought for now System 9 uses Essbase 7.1.5?.
Re: Can I change the cell size of my database?	Not sure about your question Dino, but I can tell you that System 9 Essbase is not v7.1.5.  System 9 Essbase has new functionality like duplicate member names, sub variables in member formulas ad other stuff.
Network error when reading from txt file	Hello!<br />I have the following statement in my nightly .mxl file<br />[code]<br />MAXL> import database XXX.Sales data from data_file<br />Â Â 2> 'd:\Hyperion\Essbase\App\XXX\Output\R_ExpAllSales.txt'<br />Â Â 3> on error write to 'd:\Hyperion\Essbase\App\XXX\Logs\E_SalesLoad1.txt';<br /><br />Â Â ERROR - 1042013 - Network error [10054]: Cannot Receive Data.<br />Â Â ERROR - 1042012 - Network error [10054]: Cannot Send Data.<br />Â Â ERROR - 1241101 - Unexpected Essbase error 1042013.<br />[/code]<br /><br />The user that I am logged in with have just previously in the same .mxl file written to the same location. I.e. it seems that I do not have an access issue here. The exact script works perfectly in an other environment.<br /><br />Does anybody have any clue?<br /><br />Thanks,<br />Erik
Re: Network error when reading from txt file	Unfortunately, this is an error that many of us have to live with -- below is a technical explanation, so I apologize if it generates the dreaded "MEGO" effect (My Eyes Glaze Over...):<br /><br />The network will occasionally step on a crucial packet (via collisions), and the Essbase server will either not get a request or the client will not get a response.  The timeout occurs when the other one figures out it can't complete a request, and depending on the request itself, you can only retry the operation.  This isn't a bug in Essbase so much as Essbase being "not quite" tolerant enough for a network that loses too many packets.  Making it (essbase) more tolerant usually means giving it longer delays and additional retries, but if you already have a fairly high setting for both, increases won't do much (meaning the network is highly over-utilized).  It is also possible that some router or hub is not configured appropriately, contributing to this issue, but finding it, or even being able to point the network people in the right direction could be a monumentally difficult task.  (I've heard that it often occurs as a result of client bridges between wired and wireless networks, but even this much doesn't really help much, it only shows us where to look).<br /><br />If anyone else has a more "useful" answer, please chip in.  Otherwise, my only real recommendations are to:<br />a) try increasing network retries and/or delays (refer to the DBAG section on Essbase.cfg)<br />b) try getting your network people to identify any possible network issues that might reduce collisions.<br />
Re: Network error when reading from txt file	Oh, forgot to mention -- <br /><br />I HAVE seen posts where application conflicts contributed to this type of error, but not knowing what you have running makes it difficult to determine if there is a conflict, and I don't remember any based on reading text files (I seem to remember a planning/data load issue, though).
Re: Network error when reading from txt file	You mentioned that is your nightly.xml file.<br />Is it possible that the server backup process is running and has a lock on the file at the same time your are trying to load it?
Re: Network error when reading from txt file	Good point.  Most of the backup related issues I've seen were not direct file lock issues though, but due to the increased network traffic.  This happened at more than one client every night withing minutes of their nightly backups kicking off, even though they had the Essbase servers at the bottom of their backup queue (doesn't make much difference if they all use the same SAN).<br /><br />Either way, moving the start of the job so it doesn't have any potential conflicts makes sense.<br />
Creation of PDF through Hyperion Reports	Hi All,<br /><br />Our current situation is:  We have lots of "static" reports (due to licensing issues) and now we have new licenses so can create dynamic reports  ;D .<br /><br />I'm toying with the idea of creating PDF reports from these dynamic reports, but was wondeirng how it would be possible to cycle through 20 Cost Centre members (LEV1) and have each PDF point to a different member.  Can H' Reports cycle through a recordset or such like ???<br /><br />Hope this makes sense<br /><br />Many Thanks<br /><br />Mark
Re: Creation of PDF through Hyperion Reports	If I understand the situation correctly, you should be able to put the Cost Centre dimension in the 'Page' section of the report grid.  Select the 20 members and when you generate the PDF report you will have a 20 page report, one for each cost centre.<br /><br />HTH
Re: Creation of PDF through Hyperion Reports	Maybe I'm confused but why don't you create a book?  Then you can schedule it to run or e-mail out, etc...
Re: Creation of PDF through Hyperion Reports	Hi<br /><br />thanks for your responses...<br /><br />Gary - I'll give this a go, but what I'm after is 20 separate PDF's created from one dynamic report/book.  We'd prefer if each Cost Centre member couldn't see each other portfolio - it might distract them!!  Might find a way of splitting the PDf out, but it's an additional step in the process.<br /><br />Aleck - If we use static reports/books, I think each one would have to be separate.  Therefore we'd have 20 or so reports to maintain rather than one.<br /><br />...One Report to Rule them all!! ;)<br /><br />Off to the Hyperion Conference in Barcelona tomorrow, so might find out a little more.  Will get back to you with what I find.<br /><br />Thanks for your suggestions.<br /><br />Mark
Re: Creation of PDF through Hyperion Reports	Sounds like you need a batch.<br /><br />Create your report so the Cost Centre is a user prompt.<br />Add your report to a batch and select the cost centre you want.  Repeat adding the same report to the batch and each time selecting a different cost centre until you have all 20 added.  Use the scheduler to run the batch and export the results to PDF.  When completed, you should have 20 PDF files, one for each cost centre.  The maintenance is kept to one report and one batch.<br /><br />HTH
Re: Creation of PDF through Hyperion Reports	Hi Gary<br /><br />Thanks for that, IÂ´ll give it a go when I get back.<br /><br />Thanks<br /><br />Mark
Re: Creation of PDF through Hyperion Reports	Hi Gary<br /><br />Worked a treat. ;D<br /><br />Many Thanks<br /><br />Mark<br /><br />PS there is a supplementary question but that can wait for another day!
Two concurrent sessions end up to connect to the same application.	Goodmorning. We have noticed that when one user needs to watch simultaneously forms from 2 different applications and switches from form i that is connected to app A, to form iv that is connected to app B, form i is no longer connected to app A but to app B. This is very annoying because there are many cases where a user needs to have two windows opened with data from the 2 applications so as to be able to compare them.<br />We know that this can be corrected cause there are some pcs that work ok.<br />Has anyone faced a similar situation?<br /><br />Thanks in advance for any help,<br />Maria<br />
Re: Two concurrent sessions end up to connect to the same application.	Try opening two separate Internet Explorer sessions instead of opening a new window from the first one.<br /><br />To do this, you need to launch Internet Explorer from the Start menu or desktop [i]twice[/i], log into one application from the first session and the other application from the second.  Works for me when I'm setting security as an admin in one window and testing the result as a user in the other!
Re: Two concurrent sessions end up to connect to the same application.	I did open 2 different sessions but using the same shortcut.<br /><br />When I used a shortcut stored in Favorites to open the application, the situation changed.<br />The session's details (application, username) remained unchanged.<br /><br />Thank you very much for your help,<br /><br />Maria
Connectivity Issue?	One of the servers which Analyzer was using crashed yesterday. Though it has subsequently been up, my Analyzer (7.2) is not working....gives me error when i try to open an existing report or try to create one. <br /><br />When I look into the Repository tab under administration tools, the error generated is: <br />org.apache.commons.lang.exception.NestableRuntimeException:Error loading object with specified column "atf_id" with value of "1420" <br /><br />Any ideas on how to resolve this? Does it mean that I need to reinstall the whole thing again? What kind of privileges would I need? <br /><br />Regards <br />
Hyperion System 9 BI+ Analytic Services (Essbase 9X) New Features	Aside from the new name (sigh) it looks like there are some really nice new features in Essbase 9.<br /><br />1) ASO Restructuring: "In most cases, you can now change a database outline and restructure without clearing data from the database."<br /><br />2) ASO Export: "Ability to export level-0 data from ASO databases."<br /><br />3) Kernel Improvements: "Enhanced support for deep, ragged hierarchies in an outline."  "Improved database compression."<br /><br />4) Support for outlines with Duplicate Member Names.<br /><br />5) Advanced Relational Access.<br /><br />6) Extended Substitution Variable Support:  You can now use sub variables in Outline Formulas, Security Filters, Areas and Mappings definitions for partitions, MDX statements, and Data Load Rules.<br /><br />There is also added functionality for Report Writer Commands, Data Mining Enhancements, Maxl and MDX, and the API.<br /><br /><br />Overall it looks like some very nice new (long awaited) features.<br /><br /><br />Regards,
Reports in Spreadsheet Addin	hi guys,<br /><br />I am back here for some direction...<br /><br />Our business users want to do ad-hoc reporting against the cube using spreadsheet add-in. I think they have been trained to use the tool and are comfortable with it. Now the situation is that our cube is designed in such a way that the kind of reporting they want , does not work. <br />The business users are trying to get some detailed level records from the cube using query designer. So, when the query runs, it is creating just about million of rows (all of them don't have data). And now whenever they run these reports, the add-in just hangs there for hours and it has to be closed forcefully. We can have similar reports using hyperion reports but as per requirement, they need to do ad-hoc reporting using different options quickly. We have worked on cube design and there are no more associations left to me made between different data in the cube so that we can narrow down the possible combinations.<br /><br />In hyperion Reports, we can choose to do compression on database server, which allows it to run, since it is getting non-supressed rows only. In spreadsheet add-in, I am not familiar with this kind of feature.<br /><br />Hyperion Tech support could not provide a good enough answer for this..<br /><br />What could be a way to be able to allow business users to do ad-hoc reporting? Are there any configurations that I can do to allow the users to be able to send a query from excel and supress data on the database server??<br /><br />All suggestions are welcome.<br /><br />Thanks in Advance.
Re: Reports in Spreadsheet Addin	I've seen behavior like this when there were several dimensions that were being zoomed in on.  You can mimic this behavior by doing the zooms manually.  If you select all dimensions and zoom at once, you will wait very very long, and most likely stall out.  However, if you zoom in on one dimension at a time, it works fine.<br /><br />The bottom line then, is that you could try setting the query up to do the first zoom in, and do the others manually.  Not a great answer, but one that might work, assuming of course this is your issue.
who knows how to monitor the progress of a calculation	when a long-time calculation is in progress, I want to know when will the calculation stop.<br /><br />thanks!
Re: who knows how to monitor the progress of a calculation	The answer to this depends on how/who kicked the calculation off.<br /><br />If you are the client that initiated the calculation, you may be referring to an asynchronus calc that was initiated via several methods.  For instance, a calc initiated via the Excel add-in may not display a message when finished if you have your Essbase settings to display errors only.  Changing the setting to Warnings will display a dialog when the calc finishes.  If you initiate the calc using the API, you have to monitor the process state in a loop, waiting for it to finish.<br /><br />Please post more information on what circumstances you are interested in monitoring, and perhaps there is a way to provide a more specific answer.<br />
Re: who knows how to monitor the progress of a calculation	"The Hyperion Essbase Calc Status utility is an Essbase management tool that enables administrators to monitor the status of Essbase calculation scripts."<br /><br />http://dev.hyperion.com/download/utilities/calcstatus_utility.cfm<br /><br />
Re: who knows how to monitor the progress of a calculation	That looks like a nice tool -- unfortunately, I couldn't get it to work here.<br /><br />Gary, have you been able to get that to work?  I may have to try it out at home, but here it's probably butting heads with the group policy settings (they are a bit restricted here).<br />
Re: who knows how to monitor the progress of a calculation	I haven't tried it.  I just recalled seeing it and figured I would point it out.  If I can find some time I'll try to test it out.  Right now I'm installing all the System 9 products to a test environemt, so that's keeping me busy for a few days.
Re: who knows how to monitor the progress of a calculation	the 'calc status' tool doesn't work . it always show a error message'1030000'
Re: who knows how to monitor the progress of a calculation	This is the same error I got -- either it's tied to a version issue, or the group policy on my work machine is preventing key registry settings (or some such).<br /><br />The interface itself looked "slightly" kludgy also, but this was forgiveable.  Either way, I added the concept to my "future tools" list -- it has direct potential.  Of course, I'll want to use more of a dashboard + detail list approach, with more than just calcs included (i.e. restructures, which affect the users just as much).<br /><br />Anyway, it was still a nice suggestion, thanks Gary. :)<br />
Re: who knows how to monitor the progress of a calculation	I tried the the Calc Status and if I remember correctly is a shareware - it stops working after a number of days and you have to buy a registration key.  I even complained about it in a post on the Hyperion Developer Network ([url]http://dev.hyperion.com[/url])<br />I would also be interested in trying out another tool that would accomplish this.<br /><br />Madmari
Re: who knows how to monitor the progress of a calculation	Its not the best,  but the following put into the Essbase.cfg may help a bit-- you just have to monitor the app log:<br /><br />//Displays messages after x% of the DB is calculated<br />CalcNoticeDefault 10<br /><br />Eric
Re: who knows how to monitor the progress of a calculation	[quote author=DougWare link=topic=119.msg362#msg362 date=1131625238]<br />If you initiate the calc using the API, you have to monitor the process state in a loop, waiting for it to finish.<br />[/quote]<br /><br />Hi there Doug<br /><br />Any chance you could expand a little on how to do this as I'm wanting to to run additional VBA just as soon as my Calc has finished running.<br /><br />Any help you could give would be greatly appreciated :o)<br /><br />Thx,<br /><br />steve
Re: who knows how to monitor the progress of a calculation	The following is an older function for running file based calcs...Â It works with references to things you don't need (for instance, the myApp object, which I typically connect to an Excel application or a wrapper class in my own programs).Â This may point you in the right direction for monitoring asynchronous calculations, provided you kick them off with the same context.<br /><br />===================================================<br />' RunCalc -- Runs standard essbase calc script on server<br />Public Function RunCalc(ByVal hCtx As Long, ByVal App As String, ByVal Db As String, ByVal Calc As String, ByVal CalcDesc As String) As Long<br />Dim nResponse As Long<br />Dim sMsgText As String, nMsgType As Long<br />Dim dCalcStart As Date<br />Dim dNextTry As Date<br />Dim sCalcTime As String<br />Dim tProcStateÂ As ESB_PROCSTATE_T<br />Â Â On Local Error Resume Next<br />Â Â myApp.StatusBar = CalcDesc<br />Â Â nResponse = EsbCalcFile(hCtx, hCtx, App, Db, Calc, 1)<br />Â Â If (nResponse = 0) Then<br />Â Â Â Â ' Asynchronous calc running...<br />Â Â Â Â dCalcStart = Now<br />Â Â Â Â dNextTry = dCalcStart + cTenSecs<br />Â Â Â Â On Error Resume Next<br />Â Â Â Â Do<br />Â Â Â Â Â Â Call DontHogTheSystem<br />Â Â Â Â Â Â If Now > dNextTry Then<br />Â Â Â Â Â Â Â Â If Now > (dCalcStart + cTenSecs) Then<br />Â Â Â Â Â Â Â Â Â Â sCalcTime = Elapsed(Now - dCalcStart, False, False)<br />Â Â Â Â Â Â Â Â Â Â myApp.StatusBar = "Elapsed calc time: " & sCalcTime<br />Â Â Â Â Â Â Â Â End If<br />Â Â Â Â Â Â Â Â dNextTry = dNextTry + cFiveSecs<br />Â Â Â Â Â Â Â Â nResponse = EsbGetProcessState(hCtx, tProcState)<br />Â Â Â Â Â Â Â Â If nResponse <> 0 Then Exit Do<br />Â Â Â Â Â Â Â Â If tProcState.State <> ESB_STATE_INPROGRESS Then Exit Do<br />Â Â Â Â Â Â End If<br />Â Â Â Â Loop<br />Â Â Â Â If nResponse <> 0 Then<br />Â Â Â Â Â Â sMsgText = "Warning - Due to an unknown (network?) error, this operation could not continue..."<br />Â Â Â Â Â Â sMsgText = sMsgText & vbCrLf & "(Ref = " & nResponse & ")"<br />Â Â Â Â Â Â nMsgType = vbExclamation<br />Â Â Â Â End If<br />Â Â Else<br />Â Â Â Â myApp.StatusBar = "Essbase calculation error (" & Calc & " object)"<br />Â Â Â Â sMsgText = "Error - Unable to run " & Calc & " (Ref = " & nResponse & ")"<br />Â Â Â Â nMsgType = vbExclamation<br />Â Â End If<br />Â Â If nMsgType <> 0 Then MsgBox sMsgText, nMsgType<br />Â Â RunCalc = nResponse<br />End Function<br /><br />===================================================<br /><br />HTH<br />-Doug
Re: who knows how to monitor the progress of a calculation	Hi there<br /><br />Thx for the code.....it put me on to some of the API functions I was not aware of and in turn has led me to put together the following VBA which seems to work ok until it reaches "Check Process State until Done" section where an error is encountered, sts returns a 1030001 error and so the code just loops continuously.<br /><br />Can anyone spot the problem?Â The code to check the process state I've actually just copied from the Essbase Help which is partly why I'm confused that its not working.<br /><br />Background:Â The code is attached to a login form and based on user input a Calc script may be executed on the server before refreshing a series of reports within the spreadsheet.Â I need to know that the script has finished before refreshing reports.<br /><br />[code]Private Sub OkCB_Click()<br /><br />Dim ProcState As ESB_PROCSTATE_T<br />Dim hCtx As Long<br />Dim strCalc As String<br />Dim x As Long<br /><br />application.ScreenUpdating = False<br /><br />varUser = UserTB<br />varPasswd = PasswdTB<br /><br />Worksheets("Login Data").range("usernme") = varUser<br />Worksheets("Login Data").range("passwd") = varPasswd<br /><br />Unload EssBase_Login<br /><br />strServer = Worksheets("Login Data").range("server")<br /><br />If loadedCB = True Then<br /><br />x = EssVConnect("login data", varUser, varPasswd, strServer, "AOPANS", "ANSAOP06")<br /><br />Â Â If x <> 0 Then<br /><br />MsgBox "Essbase connection failed. Please call Steve S", vbOKOnly, "Essbase connection"<br /><br />Exit Sub<br /><br />Â Â Else<br /><br />Â Â End If<br /><br />strCalc = Worksheets("login data").range("calcscrpt")<br /><br />x = EssVCalculate(Empty, strCalc, False)<br /><br />hCtx = EssVGetHctxFromSheet("ANS Regional Total")<br /><br />'Â Â Check Process State until Done<br /><br />sts = EsbGetProcessState(hCtx, ProcState)<br />'<br />Do While ProcState.State = ESB_STATE_INPROGRESS<br />'<br />sts = EsbGetProcessState(hCtx, ProcState)<br />'<br />Loop<br /><br />Else<br /><br />End If<br /><br />Â Â For i = 1 To 5<br />Â Â Â Â 'Set sheet name/app/db<br />Â Â Â Â strSheet = ThisWorkbook.Worksheets("Login Data").range("a4").Offset(i - 1, 0)<br />Â Â Â Â strApp = ThisWorkbook.Worksheets("Login Data").range("a4").Offset(i - 1, 1)<br />Â Â Â Â strDb = ThisWorkbook.Worksheets("Login Data").range("a4").Offset(i - 1, 2)<br />Â Â Â Â 'Update sheet<br />Â Â Â Â sts = UpdateSheetFromEssbase(strSheet, strServer, varUser, varPasswd, strApp, strDb)<br />Â Â Â Â 'if unsuccessful exit macro<br />Â Â Â Â If sts <> 0 Then<br />Â Â Â Â Â Â ProcessSingleTemplate = sts<br />Â Â Â Â Â Â Exit Sub<br />Â Â Â Â End If<br />Â Â Next<br /><br />Worksheets("MRA").Activate<br /><br />application.ScreenUpdating = True<br /><br />MsgBox "Update complete", vbOKOnly, "Essbase update"<br /><br />End Sub<br />[/code]<br /><br />Any help/guidance is appreciated :o)<br /><br />Regards,<br /><br />Steve S
Re: who knows how to monitor the progress of a calculation	[quote author=steve_s link=topic=119.msg577#msg577 date=1137584749]<br />Can anyone spot the problem?  The code to check the process state I've actually just copied from the Essbase Help which is partly why I'm confused that its not working.[/quote]<br /><br />Sorry, I have to laugh here, it's NOT at you, it's at hyperion.  ;D<br /><br />Essbase's example routines are a joke, in terms of showing how to use the API.  It barely works for syntax (and often doesn't).  So copying from the help is pretty much the same as writing VBA code by using recorded macros (except recorded macros at least tend to work).<br /><br />My first guess is that you are calling the GetProcessState too quickly after initiating the calc.  It could also be that the context handle isn't valid at the point of retrieving it, and you don't hit an error until the attempt to get the state.  If you check too soon, you probably never get into the loop (because you are using "while = INPROGRESS", and there is a small delay in "getting that far").  In my code, I use the initial delay before checking the first time and then exit when the calc is no longer in progress.  This isn't by accident.<br /><br />This is why I use a timer function to only "hit" the server once every few seconds...  If you hit it too often, the server will slow things down a LOT while it handles your requests (picture the kids in the car saying "are we there yet" over and over, but with you having to slow down a bit to answer each time).  In my experience, asking "are we there yet" more than once a second can add 10% to the calc time, doing it repeatedly (without a pause), can cause it to take 10 times longer than normal, easily.  Of course, this all depends on a lot of factors.<br /><br />I would strongly recommend that you:<br />a) Validate the context handle before attempting to use it.<br />b) Add a delay in your check loop, 2 to 5 seconds is good.<br />c) Don't check for it being in progress too soon.<br />d) Take those samples from the help files with a grain of salt -- scratch that, a truck load of salt.<br />
Re: who knows how to monitor the progress of a calculation	hmmmmm....ok point taken :o)<br /><br />Rather than trying to be clever and creating something myself I'll do what I should have done first time around and perhaps just modify the code you put up :)<br /><br />I certainly hadn't thought about the impact on the server of the continuous request to check the process state.Â Will bear that in mind.<br /><br />Thanks again<br /><br />Steve_S<br /><br />
Migration to ASO - PArtition not Validating	All -<br />Here are few problems I am facing:<br />1.I have migrated my Outline from 6.5.4(BSO) to 7.1.2(ASO).<br />The Dimensions are:Original BSO dimensions<br />Dimension 1 - Accounts (Dense) - Has Formulas,DTS,TB Members,Two Pass Calc,Dynamic Calc,Shared Members<br />Dimension 2 - Time (Dense) - Has Formulas<br />Dimension 3 - Scenario (Sparse) -Has Formulas,Two Pass Calc,Dynamic Calc<br />Dimension 4 - Sparse<br />Dimension 5 - Sparse<br />After Conversion to ASO<br />Dimension 1 - Accounts (Dynamic) - Formulas changed into MDX Expressions<br />Dimension 2 - Time (Dynamic) - Manually Changed to Dynamic<br />Dimension 3 - Scenario (Dynamic)  - Manually changed to Dynamic to support formulas<br />Dimension 4 - Multiple Hierarchies Enabled<br />Dimension 5 - Multiple Hierarchies Enabled<br />To Enable DTS,Time Balance,Two Pass Calc and to support Write Back I have partitioned the ASO as Source and BSO as Target.<br />Now my issues are:<br />1.Do I have to Partition along all the 5 dimensions or is it enough to partition across the first 3 dimensions.(I have partitioned only along the 3 dimensions to support for TB,Two Pass,Dyn Calc....)<br />2.When I try to Validate the Partition I get Warnings and the Account Dimension members as mismatching.<br />It says: Validated with Warnings -<br />BSO Target [83,62,44,]; Members [Dim1,Dim2,Dim3]<br />ASO Source [72,62,44,55,77] The numbers are the members in the 5 dim respectively.Why is there a mismatch in members of Account dimension in ASO and BSO<br />3.I guess I have to load the data into ASO,but since 3 of my Dimensions with formulas are in the Partitioned BSO DO I have to Calculate as well as Aggregate both BSO and ASO?<br />Please throw some light on these issues.<br />Thanks in Advance<br />Jeeva
Re: Migration to ASO - PArtition not Validating	1. The number of dimensions to include in the BSO cube depends on your analytic needs. As you are including just dimensions 1 to 3, I assume that you do not need to perform any analysis on dimensions 4 & 5, and all you need for those dimensions are their totals.<br /><br />If this is the case, the partition is correct. But if you need to perform analysis tasks over dimensions 4 & 5, you need to consider them in the partition.<br /><br />2. My best guess for the cell count mismatch is that you are defining dimensions 4 & 5 as part of the partition area. In this case, you need to define just the top of the dimension, not members of those dimensions. And as you do not have those dimensions on the BSO cube, you will need to map them to void.<br /><br />3. If there is still any cell count mismatch, you should review the partition areas defined for the 3 dimensions, to see if these are equivalent or not (like a difference in the number of members).<br /><br />HTH
Memory Error	All -<br />I have encountered this Error message today -<br />" There is not enough of memory in the Essbase Administration Server to open the Outline".<br />I was also encountering Weird stuff in EAS today.Unable to do anything,the system was hanging and was doing nothing.<br />I have checked the Server memory and it had some 14765434 KB of Unused memory available.<br />I even tried to STOP and START the SERVER but to no use.<br />Please let me know if there is any work around involved in solving this problem.<br />Thanks in Advance,<br />Jeeva
Re: Memory Error	Many times, the reason an outline cannot be opened has more to do with the "temp" path on the client than anything else.  This is where the application manager stores the working file when you open an outline for editing.  To do this, it needs a string to point to the temp file, and some versions of Essbase don't provide a large buffer to do this.  I've seen the "out of memory" message when the "Temp" path is as short as "C:\Windows\Temp" -- how much room is available appears to be dependent on the client installation itself (so it only affects a few people in the version that this happens...).  It used to be that all windows versions used the same temp path for all users, "C:\Temp", then they got the idea to change it to be a directory under windows, so it's "part of the system" so to speak...  Finally, they made it part of each users profile, and suddenly, the path to the temp variable became very long -- "C:\Documents and Settings\<user name>\Temp" or even longer.  This is where Essbase started seeing this problem.<br /><br />Okay, so to fix it:<br />- Create a directory called "C:\Temp" (it may already exist)<br />- Right click on "My Computer" and select properties, then select the "Advanced" tab (this varies...)<br />- Press the "Environment Variables" button<br />- Look for a "User" variable called "Temp", and change it to "C:\Temp" (or similar)<br />- Log out, log back in<br /><br />The (not so) funny thing is that Windows is SUPPOSED to dynamically increase the space for environment variables, so there must be something else that could address this, but this approach is the easiest way, so I haven't tried to find any others.<br /><br />Semi-related Note: If there are a large number of files in the temp directory, you can try deleting some older files with the "tmp" extension.  Don't try to delete anything from the last time you logged in, though.  When there are too many files, it can make Windows a bit sluggish.<br />
Re: Memory Error	The Version I am using is 7.1.2 and this is happening in EAS.THis is on a Sun OS box.Will the solution work for this toooo?<br /><br />Thanks,<br />Jeeva
Re: Memory Error	If will apply if the client is windows, and has little to do with the server environment.  For instance, the server could be on V7.x, and if the client is a v6.1 client, I can be fairly sure that a long path has the potential to see this problem.  I don't know for sure if this problem exists with a V7 client, but we used Unix and AIX boxes and had this issue (like I said, it's not the server's OS that does it).<br /><br />Worst case: try the change, if it doesn't help, let me know -- and revert the path back to the old setting.<br /><br />HTH<br />
Re: Memory Error	As said,I have changed the path to C:\Temp, but still the same problem.<br />And moreover when I try to do something else other than opening the outline the system is freezing.<br />I am able to open the Outline in View mode but not in Edit mode.<br /><br />Please help.<br /><br />Thanks,<br />Jeeva
Re: Memory Error	Hmmm, the symptoms sound like they are the same -- open for edit fails while open for query only doesn't.  This is usually a good indication that the client is unable to create the temp file used to store the local copy of the outline (or any other object).<br /><br />However, we could be barking up the wrong tree, but other than the "Temp" variable, I am not aware of any issues that create this situation.  Just to be clear, could you drop down to a command shell and type in "set Temp" to confirm the value?  If it's short, I'm out of ideas.  :(<br />
Re: Memory Error	In the command promt I get -: <br /><br />TEMP = C:\Temp<br /><br />Will Uninstalling EAS Client and re-installing it ,will work?<br />I am on Windows NT.
Re: Memory Error	I don't have any other ideas, and although I hate to give that "default answer" -- it isn't likely to hurt.<br /><br />Perhaps Gary has run into this one, or somebody else on Network 54 or Hyperion Developer Network.<br /><br />Whatever you do find out, let us know, okay?<br /><br />Good Luck.
Re: Memory Error	I am not sure if this is a Windows Client issue or the Server issue,because I checked to open the outline in other machine I get the same Error.I have opened a Ticket with Hyperion,lets see what they come up with.<br /><br />Thanks,<br />Jeeva
Re: Memory Error	Hi -<br /><br />Atlast I was able to resolve the memory issue.Did nothing but rebooted the Essbase Server,Admin Sever and EAS Server.I get no Error.<br />But now I am facing a new problem which is :<br /><br />The issue is we have few Analytic Servers namely:<br /><br /> <br /><br />Dev 1<br />QA 1<br />DEV2<br />QA2<br /> <br /><br />The issue is we are unable to connect to the Servers from EAS Console.<br />I am not sure if this has to do with OS enviornment because I have installed EAS server and EAS client on Windows XP and its working fine.<br />All the above 4 servers are on Sun Solaris where the actual problem is.<br />Please let me know if you have any details of it.<br /><br />Thanks,<br />Jeeva
Essbase 6.5.3 and 7.1.3 in the same UNIX maschine	Hello,<br /><br />before I start to experiment with this issue, I want to ask if anyone has experience with running 6.5.3 and 7.1.3 on the same server? E.G. how can I give them different names to distinguish them in EAS? We use a UNIX Sun Solaris 5.8 Server.<br /><br />Thanks in advance!<br /><br />Michael
Ranking and Dynamic Members	Does anyone know if the @RANK function be used on dynamic members? I am trying to run the following and getting no results (brackets indicate a dynamic member)<br /><br />"Rank" = @RANK(SKIPBOTH,"Product"->[QTR3]->"[% to Goal]"->Manager->Sales,@RANGE(Product"->[QTR3]->"[% to Goal]"->Manager->Sales,@DESCENDANTS("Cost Center")));<br /><br />I have never used @RANK before so I am sure I must be missing something obvious. I have no idea on the dense/sparse implications if any and am still a bit fuzzy on what @range is doing for me in this instance. Was hoping someone could spot something for me so I can avoid wasting a perfectly good Friday on this!<br /><br />If this helps:<br /><br />Qtr3 - Dense (dynamic - time)<br />Sales - Dense (accounts)<br />Rank - Sparse<br />Product - Sparse<br />% to Goal - Sparse (dynamic)<br />Manager - Sparse<br /><br /><br />Thanks
Re: Ranking and Dynamic Members	Thanks Mark - confirmation that it was possible was just what I needed.Â <br /><br />I still could not get mine to work for a while.Â At first I thought it may have been a block creation issue but that wasn't it.Â What I finally found was that if I have a sparse being set equal to rank AND I have a dynamic member in my rank calculation I get #MI/no results.Â However if I rearrange to have a dense member being set equal to my rank OR I take out all dynamic members out of my rank it works fine.Â Go figure - I am sure there is a good reason for this somewhere but I am moving on for now.<br /><br />Again - thanks for your help
Re: Ranking and Dynamic Members	Hi Cleg,<br /><br />Good news, yes the @RANK functions can be used within a dynamic member.Â Bad News, retrieval times are really bad.Â Recreated this on our Management Accounts Db (Cost Centre=300 members) and if I was quick could have made a cup of tea/coffee!<br /><br />This is the example i used:<br /><br />[code]<br />@RANK(SKIPBOTH,"Total Income"->"Qtr1"->"Act"->"Yr2005",@RANGE("Total Income"->"Qtr1""->"Act"->"Yr2005",@DESCENDANTS("Organisational")));[/code]<br /><br />The results of this were sort of right, but you might want to tinker with how you select Cost Centre members.<br /><br />With "% to Goal" being dynamic you might want to set the member to 2-Pass.  But I imagine this will extend retrieval times further.  I don't know what's your outline is, but you might want to move "Rank" into your Accounts Dimension and have a Branch called KPI or RANK and set it to tilda (~) so the figures don't aggregate through.  Only a suggestion.<br /><br />Hope this helps, look forward to seeing how you get on.<br /><br />Regards<br /><br />Mark
Re: Ranking and Dynamic Members	Glad I could help<br /><br />Mark
Hyperion Essbase User Guide?	Hello  <br /> <br />I've a question: Where is the  1.Essbase Users guide 2.Essbase Adimistrative Service  help guide(not online)  in the Hyperion Tech Doc's  ?<br /><br />Hyperion Tech Docs: http://dev.hyperion.com/resource_library/technical_documentation/<br /><br /><br />Thanks<br />
Re: Hyperion Essbase User Guide?	[color=Blue]The Hyperion Essbase docs are in the software. Under the information roadmap.[/color]
UnknownHostException - where is Analyzer setting file to change this setting?	Hi,<br />I have installed Analyzer 7.1 and on Analyzer server Windows computer Analyzer java web client works fine - without problems.<br /><br />But on the ordinary computer only having JRE installed (Windows operating system) it reports the error: "An unknown exception occrurred while communicating with server. Nested exception is: java.net.UnknownHostException: olap"<br /><br />The name of Analyzer computer is "olap" so on local Analyzer server computer Analyzer java web client works fine. But on remote computer doesn't find "olap".<br /><br />Work around solution is to add "name to ip" conversion in c:\windows\system32\drivers\etc\hosts file on each end user computer, but this is very time consuming task.<br /><br />I supose there is some setting file on Analyzer computer where 'hosts' are defined. But I just can't find the correct setting. Where can this host be changed?<br /><br />Thanks,<br />Grofaty
Going from 6.5.4 to 6.5.7-Any issues?	Plan on upgrading from Essbase 6.5.4 to 6.5.7 on both client & server. <br />Primary reasons are Excel 2003 on clients and Windows 2003 on the server. <br /><br />How much testing should be done to ensure everything works? <br />Appreciate comments & feedback from any one who has done this. <br /><br /><br /><br />Regards,<br />Tom M.<br />tmonahan@hotmail.com<br />Essbase 6.5.4<br />
HFM Application Back Up	I'm new to HFM.  How do you back up an application in HFM?  Is it the same as Hyperion Enterprise wherein you just copy and paste the application?  ???<br /><br />Thanks!
Re: HFM Application Back Up	That would be nice! No is the short answer.<br />HFM is a different beast, and the backup needs to be done part of the DBA/IT routine. i.e., you would need to request a backup of the SQL/Oracle (whichever you use) schema(s).<br /><br />Enterprise, as you know has folders and files - HFM is a relational database made up of a lot of tables, so DO NOT fiddle :) Your Hyperion Infrastructure contact should be able to advise on you specific environment.<br /><br />There are ways of migrating from Enterprise, and doingÂ 'soft' backups which would enable you to do an auto reshell rather than restore from the backup. Here is a link you may find useful: [url]http://pgww.com/Solutions/Solutions.asp[/url]. There may be others, so look around.<br /><br />Hope this helps.
Re: HFM Application Back Up	Thanks ng.  I'll talk to our Hyperion IT support.
Analyzer error	Hello, <br /><br />  I have a user who is using Analyzer 6.5 on XP Professional. He just installs several MSFT security patches on his PC and he get this error when trying to run the Java client "The program C:\programfiles\Internet Explorer\iexplorer.exe caused a problem and is going to close. Would you like to save a dump file?". This error automatically closes the Java client. What reason does this cause?<br /><br />Thanks,<br />EB ???
One for HFM - Renumber Web Forms	This utility is for renumbering the rows in Web Data Entry Forms.<br /><br />Normally, if you insert or delete a row in a webform, you have to manually renumber all other rows. To identify a webform row, it looks for lines starting with Rxx= (where xx is a number). As long as any inserted rows have this prefix, it will renumber all rows correctly.<br /><br />This does not require an active connection to HFM. Installation does however require Microsoft .net Framework v1.1<br /><br />Once installed, there are instructions.<br /><br />It can process many files at once. Feel free to use it if you find it useful - appreciate feedback.
How to import column reports	Is there any way for me to create rows in a grid but have different choices for the column.  Like being prompted for a column template.  The choices may have different dimensions.<br /><br />In Enterprise Reporting, we have the capability to import column reports but in Hyperion Report, both row and column dimensions should be laid out.<br /><br />Please help.  The reports won't be as dynamic as the ones in Hyperion Enterprise.<br /><br />Thanks!
Re: How to import column reports	I don't think Hyperion Report can meet your requirement directly.<br /><br />Can you add a dynamic calculated member of another dimension named "Header" ( or something else),  write the formula in outline.<br /><br />IF (@ISMBR("measure1"))<br />      measure1 condition1 constraited;<br />ELSEIF (@ISMBR ("measure2"))<br />      measure2 condition2 constraited;<br />ENDIF<br /><br />Put the member "Header" on the grid dimension layout - columns.  Hope it can help you.
More bad news about clustering and server names	Not sure if it's just me but it appears that once you have a cluster and server, you can't change that.  We moved our Oracle repository from schema to another, then installed HFM on a new server.  When HFM config is launched, it does not allow us to change the server / cluster.  <br /><br />Has anyone else done this, if so did it work?
Re: More bad news about clustering and server names	It was just me!  :o
Supress Rows for negative data.	Hello,<br /><br />I have one report in which I have to subtract 2 columns (say A & B) and show the value in column(say C). I want to supress all the rows for which there are negative values in column C ... This is not working for me.<br /><br />Then I need to calculate the percentage of C compared to A . Now there might be ZERO or MISSING Values in column A and the division by these gives error. Is there anything I can do to replace these values so that division does not gives errors.<br /><br />I have tried to use conditional supression but it does not works for me. I have only few rows in the report which expand ( I am using lists for different levels) and I need to supress these rows for missing data. But when I remove the basic supression and add the conditional in additional supression, the report just stops working and stays in a loop for a long time.<br /><br />Any suggestions....? It would be a really great help.<br /><br />Thanks<br /><br />Monu <br /><br />
Workaround	Use conditional formatting to replace the cells in the row with no value, then use row suppression to suppress rows with no data.<br /><br />
Re: Supress Rows for negative data.	Gary,<br /><br />That's a good suggestion . I tried it but this is not working for me.<br /><br />As far as I understand , formatting (conditional or normal) is applied on the report after all the data retrival and calculations are done. So If I replace the values using conditional formatting, they are not considered in the calculation and the division by ZERO or MISSING values would still show error on my report.<br /><br />About condtional supression, I had basic supression (on missing values) on the row. Now when I change the supression to supress rows if A>B or for "NO DATA" in current row, the report just takes forever. With basic supression , the report is generated in 5 secs and with conditional supression for NO DATA , the report ran for like 5 minutes and I had to cancel if eventually.<br /><br />Thanks
Re: Supress Rows for negative data.	If possible, I'd suggest just adding a dynamic calc member to the Essbase cube that calculates a value for C for you, substituting the result with #MISSING if it is negative.  My apps tend to be peppered with these sorts of artificial sweeteners for reports.  ;D
Re: Supress Rows for negative data.	Try using Reference Property Arguments (IfNonNumber) in your expression.<br /><br />That should fix your problem<br /><br />Hyperion49
Word Wrap in Hyperion Reports 7.2.1	I can't find Word Wrap in the View Menu.  The User Guide says it should be in the View Menu, I don't see all the items in the View Menu.  Should we change the Hyperion Report set up?  ???<br />Thanks in advance :)
copy application	We use Essbase V6.5.3 and I was wondering if there is a way to copy an application from one server to another with all of the filters and users/with privileges. I will appreciate any comments and feedbacks.<br /><br />Thanks<br />Sibel<br /><br />
Re: copy application	You cannot default copy apps and databases easily server to server with the native tools.<br /><br />The only thing I have found, without doing exports and recreating everything on the new server (i.e. dev to production) is OSE from Technolab Corp (approved Hyperion partner). Have a look on their website. This is not meant as an advert.... but I have not seen a way to interact off site.<br /><br />If you find anything else, or others have something, lets hear it.
Re: copy application	Migrate the apps using EAS migration wizard.  EAS allows you to migrate applications from server to server.  Users, Groups, and filters are migrated with the application.
Page Axis Memebers not showing	Hello,<br /><br />I have 3 members in my page dimension. Logically the report should show a drop down box with three options. For some odd reason , only one options is being showed in the drop down box and when i looked carefully, i found out that all the data for all 3 members is being shown on one page(with one memeber) only.<br /><br />Any suggestion as to why this might be happening??<br /><br />thanks a lot
Re: Page Axis Memebers not showing	Did you select the 3 members in ur page dimension?
Re: Page Axis Memebers not showing	Yes I did selected the 3 members in page dimension.<br /><br />Now if i look carefully, the data for first 2 members in showing up in the first selection, data for 3 member is showing in second selection and for 3 selection there is no data on its page.<br /><br />I have actually larger reports which shows detailed level data. The page dimension seems to be fine but whenever i enter my last row for detail data( this row expands), everything blows out and the data appears on different pages for other members.<br /><br />I have no clue as to why it is showing this erratic behavior.<br /><br />Thanks a lot for looking into this !!!
Partitions in 7.1.2 ASO	Hi All -<br /><br />I have created a partition in ASO 7.1.2.<br />We have total of 7 dimensions.I have created a Transparent partions with 3 dimensions in BSO which are partitioned .<br />My questions is:<br />1.Do I load to ASO database?<br />2.Do I Aggregate the ASO as well as Calculate the BSO? (I have few formulas in BSO dimensions which are partitioned)<br /><br />Please let me know.<br />Thanks in advance.<br /><br />Jeeva
Choosing Active Directory after availability	Hi!<br />In our environment we have several active directory machines. For our planning application we use external authentication which is hardcoded in a css.xml file.<br /><br />What has happened is that our outsourcing partner sometimes remove some of the servers from the network for a period and then bring them up again. Does anybody have a clue how to code this in the css.xml file so that the lookup is made to several active directories if the first one is not available?<br /><br />Thanks,<br />Erik
Re: Choosing Active Directory after availability	Not sure how to do exactly what you are looking to do, but I believe if you install Hyperion Hub, you can configure HUB to scan multiple Directories.  Then you just point Planning to the HUB config and it should work.
Re: Choosing Active Directory after availability	The CSS XML file can contain multiple providers.Â <br /><br />If you include all MSAD providers in the XML file, and then configure the search order as required, each provider will be searched in the specified order.<br /><br />FYI: When using multiple providers, be aware that if a user exists in more than one provider with a different password, the first occurance of that user is the one against which the login will be authenticated.<br /><br />Also, you should use Hub if you have more than one product using External Authentication, i.e. Analytic Server & EAS.<br /><br />
ERROR or DESIGN? FIX on subset of FIX	Is this a known restriction / bug / design feature? (Essbase 7.1.3)<br /><br />Trying to use a nested FIX on a subset of a previous FIX has no effect ... and the original set holds.<br /><br />Eg: from Sample.Basic<br /><br />Add an Account "Test1" ... then create a calc script like:<br /><br />FIX( @RELATIVE( "Product", 0 ) )<br />Â FIX( @RELATIVE( "East", 0 ) )<br />Â Â FIX( @MATCH( "Market", "New *" ) )<br />Â Â Â "Test1" = "Sales" / "Ending Inventory" ;<br />Â Â ENDFIX<br />Â ENDFIX<br />ENDFIX<br /><br />You'll find it calcs for all of the Children of EAST, when logic says it should only be for "New York" and "New Hampshire" - and, no, it doesn't seem to matter if you swap @MATCH for something else. Yes, an "AND" works on the same FIX but I'm really questioning the situation where they are nested.<br /><br />I don't recall this behaviour but that doesn't mean it hasn't always been there!<br /><br />Thanks.
Re: ERROR or DESIGN? FIX on subset of FIX	I guess it depends on who you ask?  A Hyperion loyalist would probably say it's a feature.<br /><br />In some ways I guess it makes sense since you have already locked the block @RELATIVE( "East", 0 ), at that point it doesn't seem to be able to slice out another piece.  As you mentioned, you could use the AND.  You could also nest an IF which would allow you to evaluate the block you locked.<br /><br />
Re: ERROR or DESIGN? FIX on subset of FIX	It appears that "nested" FIX's only add to the Set of Members, and never subset it.<br /><br />I suggest this is illogical. Though I accept the corollary to your premise that it makes programming more simple for Hyperion. But I've never accepted that ease of programming is always the right solution.<br /><br />I've been 20 years working in a variety of multidimensional tools, and 10+ with Essbase - I've never been a loyalist to a product or vendor. :) <br />
Re: ERROR or DESIGN? FIX on subset of FIX	Since version 3.x, nested fixes were documented as an intersection, not a union. So this behavior would represent a change from the past, and a dangerous one at that. I cannot remember which version it was fully tested in, but we did go through a significant effort to validate the nature of nested fixes, and our conclusion was that it was indeed an intersection selection, as any software developer would naturally assume.<br /><br />The logic is simple, and has meaning from a design perspective as follows -- if you wanted to extend beyond the currently selected partition of data, you would need to create a new fix, instead of nesting it. Logically, adding new selections to the current fix (a union) would "invalidate" the outer fix, and has no meaning syntactically as inclusive selections are part of the current fix syntax already. Another way to look at this is as follows -- If you nested selections on different dimensions, the nested fixes are an intersection, etc...<br /><br />Therefore, this is either a bug or an unannounced design change -- and if this were a design change, they would have had to announce it with significant fanfare, since it's not backward compatible.<br /><br />-DougB<br />PS: I believe it was version 4.1, where the tests were done, and I've coded nested Fixes through version 6.5 without noticing this behavior, so I'm left wondering how many bizzarre issues this may or may not account for...<br />
Re: ERROR or DESIGN? FIX on subset of FIX	I can concur that I've seen this behaviour too in at least 6.x in code such as:<br /><br />[code]FIX(@LEVMBRS("Market", 0))<br />  /* do something for every Market /<br />  FIX (@REMOVE(@LEVMBRS("Market", 0), "New York"))<br />    / do something for every Market except New York */<br />  ENDFIX<br />ENDFIX[/code]<br /><br />So if it's not [i]always[/i] true (which is possible), then it's at least true in a variety of cases.<br /><br />I can even recall seeing the member I thought was excluded appearing in the selection list that appears in the application log, which was rather eye-opening.
Re: ERROR or DESIGN? FIX on subset of FIX	I would generally only use multiple fixes like that in order to grab different sections of different dimensions.  Since you are ideally getting down just to two members why would you want the overhead of multiple fixes anyway?<br /><br />The behavior that bothers me more is that when a FIX results in an empty set it just ignores the fix and calculates on everything.  THAT is dangerous!
Re: ERROR or DESIGN? FIX on subset of FIX	Well, it's been one of those long-standing pieces of received wisdom that it's generally good to FIX early and often rather than trying to fix on everything you need in one go.  Besides, the original script does a good job of expressing the author's intention -- if you imagine there's more to it than just that one assignment, a reader could look at it and think "OK, this stuff applies to this range, that makes sense... and this stuff applies to a subset of that range... and I can see at a glance exactly what range of members is being deliberately excluded from this part of the calculation".<br /><br />On the latter point - just as well Essbase 9 fixes it, eh?  ;)
Re: ERROR or DESIGN? FIX on subset of FIX	FYI<br /><br />Hyperion have accepted this and the "empty fix" error (not corrected in 7.1.5 contrary to documentation) as defects. <br />
HINT: Fix on children of parent	The Entity dimension design of my current client has an input member at each level of the hierarchy. Data changes made to these members can affect / over-ride values in the bottom level children of it's parents branch; so you want to calculate all the lowest level members that are affected. <br /><br />Following??<br /><br />[code]<br />Country<br />--Country Input<br />--State<br />Â \|--State Input<br />Â \|--City<br />Â \|Â Â \|--City Input<br />Â \|Â Â \|--Shop1<br />Â \|Â Â \|--Shop2<br />Â \|--City2<br />Â \|Â Â \|--City2 Input<br />Â \|Â Â \|--Shop3<br />Â \|Â Â \|--Shop4<br />etc<br />[/code]<br /><br />You may have a form (this is Planning, obviously) on, say, State Input and it affects all the Shop1...4. Unfortunatly you cannot use a @PARENT in a FIX ... but you can use @RELATIVE ... so if want to do this you use:<br /><br />[code]<br /><br />@RELATIVE( @RELATIVE( [Entity], -1 ), 0 )<br /><br />[/code]<br /><br />The inner @RELATIVE goes to the level 1 parent of the input (level 0) member, the outer one goes to all the level 0 descendants of that parent. <br /><br />Problem solved. :) <br /><br /><br /><br />
Re: HINT: Fix on children of parent	Nice Tip, Chris... I rarely use Planning myself, but this is just one more example of being use to the "good life" with Essbase, being able to do things the easy way.  :)<br /><br />Thanks++<br />
Aggregation design wizard in ASO	Does anyone have insight as to how to use "Aggregation design wizard" in ASO to optimize retrieve performance?  I have been using "query tracking" to create recommended aggregate views- but no matter how many queries are run, I only get 4 aggregate views.  Is there a way to increase the number of aggregate views?  Also, is there a way to control what dimensions get aggregated.  Any other tips will be appreciated.<br />Thanks.<br />
Re: Aggregation design wizard in ASO	A way to increase the number of aggregate view is using the MaxL command "execute aggregate process" with "stoping when total_size exceeds" option...<br />However it is not possible to have control of what dimensions get aggregated.<br />
Re: Aggregation design wizard in ASO	Oh, that will not work as well as the new "Query_Tracking" option - which will allow me to target aggregated views creation based on what users pull into Excel.  <br />
Space in Substitution Variable Member	Good morning everyone,<br /><br />i am using Essbase 7.0 and Hyperion Business Rules 3.5.1. My problem is that i cannot use a substitution variable in calculation scripts when the underlying member name contains spaces. For example, the substitution variable CurrVer corresponds to member name "1st Submission" (without the double quotes). Every time I try to make a cross-dimensional reference of fix using this substitution variable, I get an error.<br /><br />e.g.<br />"Value Index" =  "Performance Index"->&CurrVer;<br />or<br />FIX(&CurrVer)<br /> (error: operator expected after [1])<br /><br />Does anyknow know a way to overcome this problem?<br /><br />Thank you in advance,<br />Dimitris
Re: Space in Substitution Variable Member	This is easily fixed - you need to include the double-quotes in the substitution variable's value.
Re: Space in Substitution Variable Member	Ben, thank you very much for your immediate response. I've tried what you suggested and it works fine.<br />The only side effect is that I cannot use the same substitution variable in my reports any more, but I can have two variables, one for Hyperion Reports (without double quotes) and one for Business Rules (including double quotes).<br /><br />Best regards,<br />Dimitris
Assign different access priveledges to combination of dimensions	Good afternoon everyone,<br /><br />I have an application in Hyperion Planning 3.5. Two of the application dimensions are Accounts and Products. Let's support that User Group1 and User Group2 are two different user groups, Account1 and Account2 are member of the Accounts dimension and Product1and Product2 are member of the Products dimesnion. What I want is to assign different priviledges to specific user groups (not users) based on combinations of members of these two dimensions.<br />For example, User Group1 must have read access to the combination of Account1 and Product1 and write access to the combination of Account1 and Product2, while User Group2 must have write access to the combination of Account1 and Product1 and read access to the combination of Account1 and Product2.<br /><br />Thank you in advance,<br />Dimitris
Re: Assign different access priveledges to combination of dimensions	No, it's not possible, but there are a couple of things you can do to fake it in certain cases.  To illustrate:<br /><br />(E1, E2 and E3 are entities; A1, A2 and A3 are accounts.)<br /><br />Let's say you want to grant this sort of access (R = read, W = write):<br />[table]<br />[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][/tr]<br />[tr][td][b]A1[/b][/td][td]R[/td][td][/td][/tr]<br />[tr][td][b]A2[/b][/td][td] [/td][td]W[/td][/tr]<br />[/table]<br /><br />So you'd need to grant READ to E1, READ to A1, WRITE to E2 and WRITE to A2.  But this gives you this:<br /><br />[table]<br />[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][/tr]<br />[tr][td][b]A1[/b][/td][td]R[/td][td]R[/td][/tr]<br />[tr][td][b]A2[/b][/td][td]R[/td][td]W[/td][/tr]<br />[/table]<br /><br />This might not be hugely disturbing, because at least it doesn't let people write where they shouldn't, but it gets much worse as the number of areas that must be written to starts to grow.<br /><br />There's no universal work-around, but one idea is to use dynamic calc accounts to provide limited read access:<br /><br />[table]<br />[tr][td][/td][td][b]E1[/b][/td][td][b]E2[/b][/td][td][b]E1[/b][/td][/tr]<br />[tr][td][b]A1[/b][/td][td][/td][td][/td][td][/td][/tr]<br />[tr][td][b]A2[/b][/td][td][/td][td]W[/td][td]R[/td][/tr]<br />[tr][td][b]A1[/b][/td][td][/td][td]R[/td][td]R[/td][/tr]<br />[/table]<br />(Grant WRITE to E2, WRITE to A2, READ to A1, READ to E1)<br /><br />This uses a couple of dynamic calc members (A1* and E1) which just evaluate to the real A1 and E1 members, but returning #MISSING in the unwanted E1->A2 and E2->A1* cases.<br /><br />If anyone has [i]any[/i] better ideas I'd be very grateful.
application manager window disappears	Hi everyone,<br /><br />Does anybody know under what circumstances the app manager window will disappear suddenly. This happens to us very often and I don't know what can cause this. I will appreciate any comments and feedbacks.<br /><br />Thanks<br />Sibel
Re: application manager window disappears	I haven't seen this reported elsewhere, in this large company, we have at least 50 people that regularly use the application manager on both Windows 2000 Pro and Windows XP -- and a sudden crash of the application manager hasn't been brought to our attention yet.<br /><br />Are you running any "unusual" task tray items?  Perhaps a "non-typical" anti-virus, user manager (i.e. Citrix) or remote control software?<br /><br />Seems rather strange...<br />
Re: application manager window disappears	I had this happen regularly using 6.5.x App Manager across a broadband VPN to a client site, and reading a sizeable outline file. Solution was to use a remote desktop "closer to the action". I never bothered chasing up the exact cause.<br /><br />Does this come close to your scenario?<br /><br />Have you tried the EAS console? <br /><br />
Re: application manager window disappears	Yes,<br />I guess when you are trying to open a very big Outline app manager closes automatically.As Chris said try to open this using EAS which should be stable.<br /><br />Thanks,<br />Jeeva
Re: application manager window disappears	Could be a RAM issue--<br />Does it happen on a machine with alot of RAM?<br /><br />Eric
Re: application manager window disappears	This happens on a regular basis here.  <br /><br />If you attempt to open an outline and then focus is removed from app manager, app manager just shuts itself.  I usually have to turn off my email and instant messaging alerts as it can be very frustrating.  It does not appear to be related to outline size.  Any outline will do.  We just put it down to an App Manager "feature" (we use v6.5.3).<br /><br />We have not had this problem since moving to EAS, but EAS also has some little quirks too.  <br /><br />Sorry that I could not offer any solutions to the problem just added some observations.
Re: application manager window disappears	App Manager 6.57 on Win XP Pro with 1 Gig RAM over LAN to Essbase 7.X on Linux.  We build several cubes using the same metaoutline (same design) against some different sets of data resulting in similar cube designs with varying size.  It seems like opening the larger outlines consistently crashes App Mgr.<br /><br />We switched back to App Mgr from EAS after EAS started randomly changing our compression settings.
Is Visual Explorer free?	We will be upgrading to 7.1.x from 6.5.4 in the next few months. In getting familiar with the upcoming migration, I have been reading about the new Visual Explorer add-on that is a part of the Excel add-in. Is this tool free? Is it installed by default? I have looked through the install guide and I see that Visual Explorer is listed as a "new feature" for release 7.1.<br /><br />In a webcast I watched on the Hyperion Dev Network (http://dev.hyperion.com/webcasts_demos/webcasts/) it was not clear.<br /><br />Anyone?<br /><br />
Re: Is Visual Explorer free?	Visual Explorer is an additional fee item.  It is pre-installed with the Excel add-in, so you will see it on the Essbase menu, but you will not be able to use it unless your license file grants the appropriate permission.
Combining Grid Pages	I have a report with 2 grids which require the users to select a series of dimension members. Currently the end user is required to enter the members in for each grid. Is there a way that each grid can read the initial prompt values inputed by the user ILO the user being prompted second time to enter the same value?  ???
Re: Combining Grid Pages	You're not able to reference a prompt from one grid to another.  It used to be that you couldn't reference a prompt from one row to another in the same grid, but tankfully they fixed that.  The work around is to use the point of view.