tag:blogger.com,1999:blog-4019598559914347729.post7674996636536248565..comments2024-02-09T04:19:32.395-06:00Comments on Tim Tow's Hyperion Blog: Why you can't use SQL to query EssbaseTim Towhttp://www.blogger.com/profile/01455458983202814616noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4019598559914347729.post-87450316641041875312010-05-13T16:10:19.692-05:002010-05-13T16:10:19.692-05:00The outline extractor has a specific purpose, to e...The outline extractor has a specific purpose, to extract member information from an Essbase database outline. It does not use SQL. Essbase Studio is for building Essbase databases, not for extracting dimension information (although it may support the ability to reverse engineer dimensions and, if it doesn't, perhaps it should!)<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-77967608715392724622010-05-13T15:26:44.914-05:002010-05-13T15:26:44.914-05:00how do we replace the use of the outline extractor...how do we replace the use of the outline extractor? and is essbase studio a good replacement for it?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-61998191723769851622010-03-01T09:09:58.863-06:002010-03-01T09:09:58.863-06:00Oracle database and Essbase serve two very differe...Oracle database and Essbase serve two very different purposes. I recently posted a blog entry that talks about the growth of Essbase in the Oracle ecosystem: http://timtows-hyperion-blog.blogspot.com/2010/01/more-evidence-that-oracle-loves-essbase.html<br /><br />TimTim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-66392383972773379362010-02-25T19:28:29.403-06:002010-02-25T19:28:29.403-06:00Hi Tim
it's always feel si good to read your ...Hi Tim<br /><br />it's always feel si good to read your blogs and see th passion you have for essbase. Like many others, I am another essbase freak. I've done deep dive in oracle as well. I am implementing oracle and essbase combination projects in banks. From my last couple of years I've started feeling that people have started preferring oracle over essbase. Specially when it can store one number with multiple columns e.g. Sales number can be stored with 30 different parameters like RM details and customer details. It's very easy to implement such things using oracle with obiee as front end but it's difficult to implement same in essbase. <br /><br />Moreover non tech customers prefer flash obiee rather than excel addin and obiee marries well with oracle as compare to essbase.<br /><br />Looking at all these things I am getring bit spectical about future for essbase. As oracle database getting powerful and stronger to store big Combinations. <br /><br />Hence can you please share your thoghts on future for essbase.<br /><br />Thanks a million.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-5722854729936724582009-07-21T08:55:18.708-05:002009-07-21T08:55:18.708-05:00Hi Tim,
Do we have any tool with which we can ...Hi Tim,<br /><br /> Do we have any tool with which we can fire MDX queries on a cube and retrieve the data similar to the tools like toad and SQLdeveloper in case of SQL language.Vinnynoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-42280353397617222972008-03-06T13:09:00.000-06:002008-03-06T13:09:00.000-06:00I can elaborate, or perhaps clarify, the statement...I can elaborate, or perhaps clarify, the statement. Microsoft is sunsetting VB and replacing it with .NET (including VB.NET). Oracle continues to support the Essbase VB API.Tim Towhttps://www.blogger.com/profile/01455458983202814616noreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-2912011586873503062008-03-06T12:58:00.000-06:002008-03-06T12:58:00.000-06:00"..combined with the fact that VB has a sunset tha..."..combined with the fact that VB has a sunset that is fast approaching."<BR/><BR/>Any elaboration on this? Are they simply moving to .Net framework only? Or ditching MS all together?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4019598559914347729.post-78658150074388383302008-01-22T01:15:00.000-06:002008-01-22T01:15:00.000-06:00I have observed this a lot too -- when I say I wor...I have observed this a lot too -- when I say I work with databases, a lot of peoples' first remarks are: "Oh, like SQL and stuff?" I used to make the mistake of trying to explain that it was multi-dimensional and all that, but I gave up when I noticed that most peoples' eyes would glaze over.Jasonhttps://www.blogger.com/profile/06647515241454833806noreply@blogger.com