essbaselabs.blogspot.com

projectrenegade.blogspot.com

Oracle EPM and BI Technology: Too Many Blogs

http://projectrenegade.blogspot.com/2009/04/too-many-blogs.html

Oracle EPM and BI Technology. Tuesday, April 21, 2009. I thought I would be able to keep up with all these blogs but I cannot so I am posting to let you know that I will only be blogging at Essbase Labs. 160; You will find some of same content but geared more towards Essbase instead of general EPM. Http:/ essbaselabs.blogspot.com/. Subscribe to: Post Comments (Atom).

rmsfinance.com

RMS Finance Consulting » Hyperion

http://www.rmsfinance.com/resources

RMS Finance - Rapid Business Models. Ashton Kutcher can now get my Essbase calculation updates. Use case is to follow an Essbase server on Twitter and get updates as calculations are run on the server. The Baker's Dozen: 13 Tips for Querying OLAP Databases with MDX. MDX is a SQL-like query language used to retrieve data from OLAP databases and to define KPIs. Essbase on Oracle TechNet. Downloads, Documentation, Utilities, Tutorials, . Corporate finance and accounting. 1440 Wall Street - Media. Oracle App...

theessbasemechanic.wordpress.com

When A Cube Has To Be Quarantined | Dan Pressman, The Essbase Mechanic

https://theessbasemechanic.wordpress.com/2015/01/11/when-a-cube-has-to-be-quarantined/comment-page-1

Dan Pressman, The Essbase Mechanic. The Inner Workings of Essbase. January 11, 2015. When A Cube Has To Be Quarantined. Oracle’s EPM development team has worked to reduce the gap between “states,” particularly in ASO where techniques are available to greatly reduce the impact as seen by the users. Oracle’s product roadmaps indicate continued work in this area, and we look forward to seeing them in future releases. Do you want every financial analyst in the company screaming at you? Dog WCat: W indicates ...

theessbasemechanic.wordpress.com

May | 2014 | Dan Pressman, The Essbase Mechanic

https://theessbasemechanic.wordpress.com/2014/05

Dan Pressman, The Essbase Mechanic. The Inner Workings of Essbase. Monthly Archives: May 2014. May 4, 2014. A Few Words about Freedom, Dimensional Irrelevance, and ASO. Or, BSO PRACTITIONER: REFORM THYSELF! What Is Dimensional Irrelevance, Anyway? In other words, OLAP data tends to be very sparse. Dimensional Irrelevance and BSO. Okay, we all started with BSO, where we learned that Dimensional Irrelevance and sparse data in general can be your enemy. Sure, BSO’s use of blocks and your choice of spars...

whatsallthehype-essbase.blogspot.com

What's All The Hype Essbase Blog: January 2011

http://whatsallthehype-essbase.blogspot.com/2011_01_01_archive.html

What's All The Hype Essbase Blog. Tuesday, January 25, 2011. Identifying Descendants with MDX? There were many times when I found myself wondering why there wasn’t an ISDESC or IsDescendants function for MDX. Then one day I found the IsAncestor function. With this function, a descendants function is completely unnecessary, although it is a little counterintuitive when you are used to the BSO world of formulas. The formatting of this function is: IsAncestor (member1, member2 [,INCLUDEMEMBER]). You can als...

scottsoracleblog.blogspot.com

Scott's Oracle EPM and BI Blog: January 2013

http://scottsoracleblog.blogspot.com/2013_01_01_archive.html

Scott's Oracle EPM and BI Blog. I don't always Blog about Oracle / Hyperion, but when I do, I try to keep it interesting - Scott Danesi. Sunday, January 13, 2013. Peloton $100 Discount Code for KScope13 Registration. Register before the March 25, 2013 Early Bird deadline and save money off the Advanced Rate. For an additional $100 discount, email insights@pelotongroup.com. Or fill out the form on the link below to receive the Peloton discount code immediately. Hope to see you there! When executing the fo...

scottsoracleblog.blogspot.com

Scott's Oracle EPM and BI Blog: New Essbase Subreddit!

http://scottsoracleblog.blogspot.com/2013/11/new-essbase-subreddit.html

Scott's Oracle EPM and BI Blog. I don't always Blog about Oracle / Hyperion, but when I do, I try to keep it interesting - Scott Danesi. Tuesday, November 19, 2013. I know it has been a while since my last update, but I found out some pretty exciting news. Jason Jones. Has created an Essbase Subreddit where us Oracle EPM professionals can post links and talk about nerdy Essbase related topics. :). Here is a link to the new Subreddit that Jason created:. Http:/ www.reddit.com/r/essbase. Hyperion @ 42 Below.

whatsallthehype-essbase.blogspot.com

What's All The Hype Essbase Blog: ASO vs. BSO Calculations

http://whatsallthehype-essbase.blogspot.com/2011/07/aso-vs-bso-calculations.html

What's All The Hype Essbase Blog. Wednesday, July 20, 2011. ASO vs. BSO Calculations. The reason why I write this today though is because I found another great reason to have ASO cubes instead of BSO. Some have written that BSO cubes allow for more complex calculations, which may be true in some regards. I have found that MDX in ASO cubes provides greater flexibility and allows writing of complex calculations in far few lines of code in a member. A fully written BSO formula was 1242 lines and 75,493 bytes.

whatsallthehype-essbase.blogspot.com

What's All The Hype Essbase Blog: ASO Partial Data Clears Using MaxL and MDX

http://whatsallthehype-essbase.blogspot.com/2012/10/aso-partial-data-clears-using-maxl-and.html

What's All The Hype Essbase Blog. Monday, October 29, 2012. ASO Partial Data Clears Using MaxL and MDX. Now on to the fun stuff…. The MaxL Script Editor can be used to perform the clear. The syntax to be used is:. Clear data in region '{MDX set expression}' [physical]. First and foremost, a set must have curly brackets around it. Second, it has to be one of the prescribed MDX functions that return a set. Remembering those two things, building the MDX set expressions becomes easier. Alter database 'ASOsam...

whatsallthehype-essbase.blogspot.com

What's All The Hype Essbase Blog: July 2011

http://whatsallthehype-essbase.blogspot.com/2011_07_01_archive.html

What's All The Hype Essbase Blog. Wednesday, July 20, 2011. ASO vs. BSO Calculations. The reason why I write this today though is because I found another great reason to have ASO cubes instead of BSO. Some have written that BSO cubes allow for more complex calculations, which may be true in some regards. I have found that MDX in ASO cubes provides greater flexibility and allows writing of complex calculations in far few lines of code in a member. A fully written BSO formula was 1242 lines and 75,493 bytes.