Business Intelligence Blog from arcplan
10Oct/110

Teradata PARTNERS User Group Conference 2011 Recap

by

If you follow arcplan news, you’ve probably heard about our new partnership with Teradata. We just got back from exhibiting at the Teradata PARTNERS User Group Conference (TDPUG) in San Diego late last week and we’re blown away by how well we were received at the show.

Overall, the show was positive and encouraging, with Teradata’s customers really looking to partners for ways to extend the reach of their existing infrastructure and drive utilization and data storage within Teradata.

We met with so many data architects, DBAs, BI managers, and analysts who were excited over arcplan’s status as the only partner to support Teradata’s new OLAP connector without the need for a semantic layer. We talked to many Teradata customers who have already installed (or are in the final stages of installing) the OLAP connector in order to directly integrate a BI solution into their Teradata Warehouse. That’s what arcplan does, and it saves developers time – time to value, time to build reports, dashboards, and other analytic applications…and it also saves money since it requires less resources and less infrastructure.

We demo’d arcplan’s support for the Teradata OLAP connector and heard a lot of interest in the fact that arcplan takes the power of Excel (the only other way to access the OLAP interface directly) and broadens it to the casual business user of BI – those who need intuitive access to their reports and dashboards either on their desktop browser or on any mobile device. In fact, I spent most of the show walking around with my iPad out, showing arcplan + Teradata everywhere I went (as you can see in the picture).

We also spoke with attendees in the finance function, or IT managers responsible for budgeting and planning support, whose interest was piqued by our integrated platform, which combines reporting with budgeting and planning capabilities (allowing Teradata customers to leverage their existing infrastructure and expertise to address this additional organizational need!).

We’ll definitely be back next year. In the meantime, if you have questions about how arcplan works with Teradata, or if you’re a Teradata customer who is exploring the OLAP connector, email us or leave us a comment!

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.

19Sep/110

Hey Students! Ready for the BI Challenge 2012?

by

Update June 2012: Learn more about the students who won our competition >>

Attention students in Germany, Austria & Switzerland! arcplan’s student relations arm, arc|ademy, is holding its first annual BI Challenge! A total of 15,000 euros in prize money awaits the winners.

Challenge Categories
We’re inviting students who are using the BI platform arcplan Enterprise 7 as part of their studies to create an arcplan application and enter it into one of three categories: “Innovation,” “Fast Movers,” and “Business Excellence.” In the first category, the winning application will be particularly innovative in its visualization, methodology, or technical approach. Fast Movers are applications that have been deployed in an extraordinarily short span of time or can be deployed particularly quickly. Finally, the Business Excellence category is for applications that aim to improve the quality of business decisions. Each winner will receive 5,000 euros.

Submission Details
Students wishing to apply (as individuals or as teams of up to six people) for the arc|ademy BI Challenge 2012 can submit their applications as presentations – in PowerPoint or PDF format (in German) – or as arcplan documents together with the databases. These documents should not contain any confidential information and the overall size of the application should not exceed 10Mb. When submitting only a presentation, temporary access to a live test system should be provided.

Continue reading this post >>

14Sep/110

Our New Partnership with Teradata – See us at the PARTNERS User Group Conference

by

We’re excited to announce our new partnership with Teradata, THE big data/data warehouse experts! arcplan is their only partner to support Teradata’s new OLAP interface.

The cool thing for Teradata customers is…well, there are many cool things! arcplan is the ideal front-end to Teradata, providing analysis, reporting, planning, and real-time mobile analytics to Teradata customers. The new “arcplan OLAP Connector for Teradata” allows users to answer multidimensional analytical questions by slicing and dicing their large data volumes quickly over the Web or on any mobile device. Teradata customers can also build ad-hoc reports, intuitive and interactive dashboards, and can even manage their budgeting and planning with one architecture.

We’re also a sponsor of Conquering Complexity, the Teradata PARTNERS User Group Conference, taking place October 2-6 in San Diego, CA. Stop by and see us at booth 613!

In the meantime, if you have any questions, leave us a comment or email sales@arcplan.com. There’s more information in the full press release.

9Sep/110

Webinar Recording: Dashboard Design Tips & More

by

In case you missed our webinar, More Dash Less Bored, here’s the recording to view at your convenience:


https://www4.gotomeeting.com/register/404124687

 

We discussed the wealth of chart types available to you and when to use them, as well as the 10 keys to successful dashboards. Toward the end, we showed a demo of arcplan Enterprise best-practice dashboards with features like:

  • On-demand video help
  • Bookmarking (saving reports with your specified filters)
  • Dashboard export options (to PDF, PPT, or Excel)
  • Dashboard delivery (one-time or recurring email delivery of dashboards)

We had a terrific turn-out for this annual event, and we’d like to thank everyone who attended! Looking forward to next year’s already!