arcplan is holding a special reception for current and prospective Oracle OLAP users during Oracle OpenWorld. The event takes place on Tuesday, October 2nd near the Moscone Center in San Francisco. If you’d like to join us, RSVP and we’ll let you know where to meet up with us from 5-7pm for cocktails, hors d’oeuvres, and networking with other Oracle users.
Why is arcplan sponsoring this event? As the leading BI front-end for Oracle, we’re always interested in meeting Oracle users to discuss their unique needs. arcplan connects natively to Oracle data sources (as well as more than 20 others), and together with Vlamis Software and Simba Technologies, we’re also Oracle OLAP experts.
Hope to see you on October 2nd!
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.