Business Intelligence Blog from arcplan
1May/120

Collaborate 12 Oracle Conference Recap

by

I just returned to Germany after spending last week in Las Vegas for the Collaborate 12 conference. arcplan had a booth at the show, billed as the “Technology & Applications Forum for the Oracle Community,” for the first time in 4 years. We’ve noticed trade shows having a bit of a renaissance and this one – with 6,000 attendees – was no exception. With our strong Oracle customer base and our billing as the most widely-used BI front-end to Oracle Essbase, we thought 2012 was the perfect time to return to Collaborate. And after our great experience at KScope 11, the Oracle Developer Tools User Group Conference last year in Long Beach, we want to participate in more conferences where the attendees are the users and creators of BI applications in their enterprises. Collaborate turned out to be a terrific (re)addition to our lineup.

The conference kicked off with a keynote from Oracle CIO & SVP Mark Sunday on “IT at Oracle: The Art of IT Transformation to Enable Business Growth.” His presentation stressed the importance of simplifying IT, which complements arcplan’s vision and our 2012 tagline: It simply works™. With our focus on reducing infrastructure and helping our customers leverage what they already have, this message really resonated with us.

The rest of the session topics reflected Collaborate’s heterogeneous nature as a melting pot of three different user groups (OAUG, IOUG and Quest)…

Continue reading this post >>

27Sep/110

What OLAP and MDX Mean for You

by

Are you an Oracle customer who’s heard about OLAP but aren’t sure what it can do for you? Oracle OLAP (On-Line Analytical Processing), an option to Oracle Database 11g Enterprise Edition, is a calculation engine that supports advanced analytical applications including planning, budgeting, forecasting, sales, and marketing, to help identify key business trends and model complex business scenarios.

MDX stands for Multidimensional Expressions and lets you query multidimensional objects, such as cubes, and return multidimensional cellsets that contain the cube’s data. With the MDX Provider for Oracle OLAP, organizations and departments that use Excel for ad-hoc querying, analysis and reporting can connect to Oracle OLAP data just like connecting to any other data source.

The MDX Provider for Oracle OLAP enables users to take advantage of Excel PivotTable and PivotChart functionality to analyze Oracle OLAP data, including advanced formatting and dashboard presentation capabilities, and integration with other Microsoft Office products. With all data and calculations stored centrally in the database and analysis performed directly against the database, users benefit from the performance and security features of the Oracle Database, while helping to ensure that the analysis performed takes advantage of the very latest information.

Yes, it’s a mouthful, but essentially, MDX allows for easier, faster querying of your database, which is of course a good thing.

arcplan recently partnered with Simba Technologies, whose MDX Provider for Oracle OLAP allows organizations to utilize arcplan’s portfolio of products for Business Intelligence and planning. Even though arcplan’s products can access Oracle OLAP through standard SQL queries, the addition of MDX provides for a much more efficient method of data access.

There’s more information about this on arc|community, our user forum.