Wednesday, November 24, 2010

Upcoming Event – ASUG Arizona Chapter – October 29, 2010

 Paul Grill from INFOSOL will be presenting Xcellent Xcelsius at the upcoming meeting of the ASUG Arizona Chapter. 

Date: Friday, October 29, 2010
Time: 8:30 a.m. to 4:00 p.m.
Location: Intel
5000 W. Chandler Blvd. Building CH3, Conference Room
Chandler, AZ 85226 – 112 

For complete information about this meeting refer to your Arizona Chapter Quarterly Update email.

Arizona Chapter Discussion Forum

Yolande Grill is the Vice President of Business Development at InfoSol Inc. I would like to think of myself as the Chief Transformation Officer. My favorite quote to ponder is one from Trina Paulus. "How Exactly does one become a butterfly? You must want to fly so badly, that you are willing to give up being a catterpillar"

View the original article here

Integrating Xcelsius into Crystal Reports Series – 1 of 3

Before getting started, I want to provide a quick update on the Reportapalooza competition:

Unfortunately, I fell a bit behind while attending 2 SAP Conferences back to back this month.  Sorry if I let anyone down but I can’t tell you how much I appreciate the support.  I also want to give a huge CONGRATS to our current leader David Deitch who is an Xcelsius beginner turned Guru in this competition!

Now to Challenge #5.  Labeled the ‘Report Remix’ challenge, I am tasked with learning more about Crystal Reports 2008 and sharing it with YOU the community, hence the ‘remix’ which is to take you on the journey with me of learning a new Crystal product :) .  Below is my official public statement:

So let’s get started with a few simple questions?

Q. How can you integrate Xcelsius flash files into your Crystal Reports?

A. It’s a 2 step process. You first have to configure the Crystal Reports Data Consumer connection in Xcelsius (seen below) and then use the .swf button in Crystal Reports to embed the Xcelsius flash file. (More details on how to setup each will be provided in the next article)

Q. What are the Pros and Cons?

A. Pros – It is no secret that Xcelsius’ ability to handle large amounts of data is VERY limited. By embedding your Xcelsius flash file into Crystal Reports you get to leverage the power of the Crystal engine while utilizing the beautiful graphics in Xcelsius. It’s like having the best of both worlds.  In fact, in my next blog posts I am going to show how to integrate a map in Xcelsius into a Crystal Report.

A. Cons – If your not as familiar with Xcelsius you may have some issues using the ‘Crystal Reports Data Consumer’ connection. It could use some fine tuning (note to the  Product Team :) )

One more thing! This is your last week to submit your dashboards to the community Reportapalooza competition.  Hope you read this far down,  because if you have something worth seeing I am opening the door to review any entries that you send via email to gurus at everythingxcelsius.com and provide feedback if sent by 10/31 @ 12am EST.

Mico Yuk is a 2010 SAP Mentor and the founder of the Xcelsius Guru Network and the Everything Xcelsius blog. To learn more about her, please visit our About Us page.

Tags: Business Objects, Reportapalooza, SAP Crystal Dashboard Design, Xcelsius 2008


View the original article here

Comparing Xcelsius 2008 Editions

Business Objects Started off Offering Crystal Xcelsius as a single edition. Later with 4.5 they came up with 2 editions, Designer and Workgroup. Starting 2008, they have significantly increased in terms of various flavors of the software. Now they have 4 editions, allowing the customers to choose whatever they want based on the Price and requirements. The 4 editions are below. Detailed Comparison here.

Xcelsius PresentXcelsius EngageXcelsius Engage ServerBusinessObjects Xcelsius EnterpriseBe the first to like this post.

View the original article here

SAP BusinessObjects Business Intelligence 4.0

SAP is closing in on their release date of the next major release of BusinessObjects… and as with any release, marketing want to get the name just right.  We’ve seen quite a few changes over the years.

Remember all those changes in Windows naming? Windows 3.1, Windows 95, then Windows XP?  Now finally it’s back to numbers with Windows 7?  There’s probably someone out there that’s written a book about how to name your next software release.  :-)

Here’s a look at where we’ve come from in the last 7 years of BusinessObjects Product Names… starting back in 2003 with the combination of BusinessObjects 6 and Crystal Enterprise 10 into the new XI… Xtreme Insight!

BusinessObjects Product Names

… the more they stay the same.  It is so true… and the upcoming release will include some additional name changes.  Here are some names on the horizon.

XI Product Name4.0 Product NameSAP BusinessObjects EnterpriseSAP BusinessObjects Business Intelligence PlatformSAP BusinessObjects Web IntelligenceSAP BusinessObjects Web IntelligenceSAP BusinessObjects Xcelsius EnterpriseSAP BusinessObjects DashboardsSAP BusinessObjects Analysis, edition for OLAPSAP BusinessObjects Analysis, edition for Excel

For more information on the whys check out Jon Reed’s blog post.

It’s amazing how some product names take on a life of their own even before the product is released.  Pioneer is a great example.  It is the first release of the legacy SAP BEx Web Analyzer and SAP BEx Analyzer for Excel.  Pioneer was simply the code name for this yet to be release product.  We can now retire that code name and begin using the actual product name, SAP BusinessObjects Analysis.

Some name changes like Xcelsius were introduced even before a major new release. Earlier this summer, I had someone call me to ask me about SAP Crystal Dashboard Design.  I’d never heard of it. It wasn’t until I googled it that I discovered that we weren’t offering a new product.  SAP had just renamed some Xcelsius packages.  SAP Dashboard Design and SAP Presentation Design had formally been known as Xcelsius Engage and Xcelsius Present, respectively.

Thinking back, Xcelsius has also been through a number of changes:  Xcelsius 4.5, Crystal Xcelsius 4.5, Xcelsius 2008…  It will be interesting to see if the Xcelsius Designer, aka Xcelsius 2008 keeps it’s name and becomes Xcelsius 2010.

Did you know that SAP BusinessObjects Analysis, edition for Excel has already been released?  Yep!  The plug-in for Excel is completely stand-alone and can be used without interfering with your existing BusinessObjects XI 3.1 environment.  If you have SAP and want to get the best possible connectivity within Excel without waiting for your entire environment to be upgraded, you can.  Today.

«Good BI»


View the original article here

Missing Leo Apotheker

There was a lot of trepidation amongst the BusinessObjects community when SAP acquired Business Objects in January 2008. We had all seen how Oracle had consumed Hyperion (which had, in turn, consumed Brio) to the point of losing its identity as an independent BI solution. The question was would SAP do the same to BusinessObjects?

On the day of the acquisition, I was attending a joint sales and partner meeting for BusinessObjects in Las Vegas listening to a mix of top Business Objects and SAP Executives delivering presentations to motivate sales for the coming year. There was really very little of substance until this man named Leo Apotheker took to the stage. He was engaging and passionate as he explained that Business Objects would remain an autonomous division of SAP so that it could effectively continue to sell Business Intelligence to all. He then went on to explain who SAP was and the core values of the company and how those would benefit the BusinessObjects employees, partners and product suite.  He painted an exciting vision of both the direction for SAP and BusinessObjects. I believe he impressed and inspired a lot of people in the room that day.

The global financial crisis followed later that year and into 2009 and Apotheker had his work cut out for him to steer SAP through a difficult time but he continued to push Business Intelligence to the forefront of SAP as well as actively support the Sustainability solution initiative within SAP.

So at the beginning of 2010 as we emerged from that difficult period, I was both shocked and sad to see Leo Apotheker leave SAP.  Of course, what he put in place has borne remarkable results with now more than 50% of SAP’s license revenues coming from Business Intelligence (not bad when you consider SAP was eight times larger than Business Objects at the time of acquisition) and SAP a clear leader in the Sustainability solution arena.

Leo Apotheker is now the CEO of Hewlett-Packard ( a company eight times larger than SAP – HP Press release ) and I think they are very fortunate to have such a visionary leading them. Unfortunately, we will not see how much further he could have taken SAP but, from where I sit, he certainly set them on the right track.

In searching for a picture to post on this blog, I found the following blog post from Feb 7, 2010  http://www.enterpriseirregulars.com/12079/news-analysis-saps-ceo-leo-apotheker-resigns/ which has many links including one to the official SAP press release.

Paul Grill started his career in Information Technology in the U.K. in 1978, as an Executive Data Processing Trainee for Honeywell. More than thirty years later, he still has a voracious appetite for learning as Information Technology continues to advance at an ever accelerating pace. He was first introduced to the world of Business Intelligence in 1991, in France, when he saw a demonstration of an early version of BusinessObjects on Windows 2.1. He returned to the U.S. to rave about this phenomenal product, but it was many years before BusinessObjects made it into the mainstream. Paul founded InfoSol in 1997, and made Business Intelligence one of the key solutions offered by the company. Today, InfoSol is a leading SAP BusinessObjects solutions partner, known for its expert consulting, education and innovative add-on solutions. Paul is well known within the SAP BusinessObjects community for his extensive knowledge of Business Intelligence, and he has lectured and written many articles on the subject. Paul enjoys writing, running and coaching kids soccer, and is passionate about Ancient Egyptology.

View the original article here

Beauty is in the Eye of the Beholder

Several years ago, I saw an exhibition of surrealist paintings in Paris including works by Salvador Dali and Joan Miro. I found the Dali paintings visually stunning as well as fascinatingly compelling whereas I had a hard time understanding the Miro ones. Others, who were with me, expressed the complete opposite opinion and loved the Miro work but had little time for the Dali pieces.

We all have different likes and dislikes to visual images whether they are paintings, cars or even business intelligence dashboards. I can personally testify to the dashboards since our company has developed over 400 of them in the last four years and they come in all shapes, sizes and visual tastes. I remember one particular dashboard that we developed for a transportation company that I thought was very visually stunning and provided multiple levels of drill down and some very powerful “What if?” scenarios. While the manager at the company also liked it a lot, his director felt it was not stunning enough and wanted different colors and more 3-D components. They both felt the dashboard met their functional needs but for the look it really just boiled down to a matter of personal taste.

The beauty of a dashboard tool like Xcelsius is that it allows you to design and cater to all these different tastes. You have a wealth of components, colors, themes and templates available and, if this is still not enough, you can develop your own.

While some people prefer simple dashboards with clear sharp components, others may prefer a more complex and richer look. If you do not like pie charts and certain colors, you do not have to use them.

Dashboard design is an art but the key to designing an effective, as well as a visually pleasing, dashboard is not to read books about the subject and it is also not to hire a graphic artist. The key is to sit down with the people who are going to be using the dashboard and to understand what they want to see and how they want to view and interact with it. While this may sound too simplistic, it is not. Of course, there can be room for visual enhancement and “cool” features but only if they serve a purpose.

There are many dashboard products on the market today that provide limited views and components so that you often have to force fit your requirements into what is available within the product. Xcelsius, on the other hand, allows you to design and create dashboards in an almost infinite number of ways and you are only limited by your imagination (or your user’s requirements).  As to how they look, it is doubtful you will ever please everyone but remember that beauty is in the eye of the beholder.

For a gallery of Xcelsius dashboards designed by INFOSOL and defined by customers, visit INFOSOL’s Dashboard Gallery

Paul Grill started his career in Information Technology in the U.K. in 1978, as an Executive Data Processing Trainee for Honeywell. More than thirty years later, he still has a voracious appetite for learning as Information Technology continues to advance at an ever accelerating pace. He was first introduced to the world of Business Intelligence in 1991, in France, when he saw a demonstration of an early version of BusinessObjects on Windows 2.1. He returned to the U.S. to rave about this phenomenal product, but it was many years before BusinessObjects made it into the mainstream. Paul founded InfoSol in 1997, and made Business Intelligence one of the key solutions offered by the company. Today, InfoSol is a leading SAP BusinessObjects solutions partner, known for its expert consulting, education and innovative add-on solutions. Paul is well known within the SAP BusinessObjects community for his extensive knowledge of Business Intelligence, and he has lectured and written many articles on the subject. Paul enjoys writing, running and coaching kids soccer, and is passionate about Ancient Egyptology.

View the original article here

Crystal Reports Modifying Existing Reports

Let’s suppose that a third party designed the report you need, but you have to modify it. Where to begin? Follow this checklist to give you, as the report modifier, answers that you may need to go forward.

Save the report with a new name so you keep the original. (Work on the copy for your own mental health.)Go to the Database Expert. Check the connection type on the Data Tab - that will tell you only the type of connection (e.g, local, OLE DB, SQL etc).Still in the Database Expert, click on the Links Tab. Check to be sure the tables used for the report are linked correctly.Now check with the Select Expert to see how the records are filtered.What fields did they use?? What restrictions did they put on the records? For example, did they filter for only records with an order date of 2009?If any or all of the filters are no longer valid, delete them by clicking on the tab and clicking on Delete.Refresh the report. You probably will get more records than the original report as you have removed the filters.Now, you may need to filter for the new report you are designing. You will use the Select Expert. Choose the database field you need to use and design the filter using the two dropdowns on each tab, the first is the operators and the second is the criteria.For example, your report needs to show the data for NM, ID, and AK. The operator: is one of and the criteria: NM, ID, AK.

If necessary, go to Print Preview.Remember to save it as you work.Refresh the report.You would continue on in this manner until your report displays the data that you need, according to the request.

Remember, everything takes practice. The more you work in Crystal Reports, the easier it will become. Take your time and practice.

Happy Reporting!


View the original article here