Sunday, December 5, 2010

Kimono Starts to Open on BusinessObjects XI 4.0 at ASUG BO Conference

The 2010 ASUG BusinessObjects User Conference provided a lot of interest not just for the 1,100 registered attendees but also for the additional 600 attendees of the SAP Fall Focus who shared the same venue. Judging by the number of attendees in the various sessions, it appeared a large number of SAP Fall Focus attendees decided to attend the BusinessObjects tracks. The same was true in the exhibit area as many of the BusinessObjects sponsors were swamped with excited and interested customers.

This year Xcelsius dashboards shared the limelight with Mobile Business Intelligence in terms of the most popular topics being discussed amongst attendees.

There was also some buzz around the new BusinessObjects XI 4.0 release promising to be the first truly integrated business intelligence platform. While there were a few small demonstrations of some of the new XI 4.0 products in the general session, most of the other sessions stuck to slides and pre-recorded Camtasia demonstrations.  With the release moving to “ramp up” stage in November, the kimono was only half opened on some of the new features and functions. These included the new Data Services that will now incorporate Text Analytics in addition to Data Integrator and Data Quality in a single engine solution. Also, there is the new Universal Metadata Layer that not only combines Business Views and Universes but also now provides direct access to Multidimensional OLAP data sources.

Part of the integration approach with XI 4.0  is to provide common services across all the main content provider tools like Crystal Reports, Web Intelligence, Xcelsius, Explorer. These include a common query panel for accessing data through a universe so in the new Xcelsius Enterprise 4.0 developers would have access to universe objects while building the dashboard.

An updated Web Intelligence brings new charting libraries from the Explorer product and an update Crystal Reports delivers a new grid view with drag and drop on graphics capability.

Common platform services like Auditing and Life Cycle Manager now extend across all the content provider tools including Xcelsius.

SAP’s new solution for in-memory analytics, known as HANA (High performance ANalytical Appliance), was also discussed.

Once the ramp up period gets underway, we will have a better chance to more thoroughly explore the new features and functions but based on this sneak preview, there appears to be some promising new functionality in XI 4.

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

Changing Default Field Settings in Crystal Reports

When you design your reports in Crystal Reports, Crystal Reports uses the database format for the database fields.  It also uses the database fonts as I discussed in Setting Default Fonts in Crystal Reports. This, again, requires that you format these fields every time you want to use them in you report.

I recommend you take the time upfront to change these default settings in Crystal Report so that you won’t have to change the settings on each new report you create. Here’s how you change the default field settings in Crystal Reports:

From the File Menu, select Options.Choose the Fields tab.For each field category, select the format you would use regularly. (For example; for Numbers you may like the comma format and 2 decimal places.)Currency could be the same as Number, but with the currency symbol: Floating places the symbol directly to the left of the number, e.g.  $456.87.Fixed places the symbol several spaces away from the number, e.g. $       456.87.Date is often in the database as Date and Time, but your organization does not use the time part!  Format it so that Crystal Reports fixes that so it appears the way you want it on your report.  You can include the leading zero (05/05/2010) or not (5/5/2010.)  Pick the preferred format for your organization.Date and Time should be the same as Date, if your organization does not use the Time part.  Otherwise, format according to the preference of your organization.

Keep in mind, Crystal Reports is considered a presentational report designing tool.  While your report should always look professional, it does not mean the report designer needs to spend hours formatting it.  The report designer needs to present the correct data in a professional manner, but with Crystal Reports, that processt does not have to be difficult!


View the original article here

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

Getting Started with SAP Crystal Reports Server

In the fifth and final challenge of Reportapalooza, I’ll be writing a three part series of blog posts about the product at the heart of the SAP Crystal product line – SAP Crystal Reports Server.

My experience with BusinessObjects software goes back to versions 6.1 and 6.5 and the days of Application Foundation and the BOMain.key. Then in 2006, I had the good fortune of being introduced to BusinessObjects XI and the new CORBA architecture. This led to an ongoing string of (mostly) enjoyable experiences installing, deploying, migrating to, and administering BusinessObjects XI R2, XI 3.0, and XI 3.1. These experiences also included many years of developing Universes, building Desktop Intelligence reports, Web Intelligence documents, and finally Xcelsius 4.5 and 2008 dashboards. But my experience with SAP Crystal Reports only goes back to version XI and I’ve never had the opportunity to even see SAP Crystal Reports Server. So I jumped at the opportunity to install and peruse SAP Crystal Reports Server as part of the “Reporting Remix” and Reportapalooza.

Diving right in, I installed “SAP Crystal Reports Server 2008 V1” on my favorite box. My first attempt failed though because I tried to install it on a machine that already had SAP BusinessObjects XI 3.1 installed. My mistake, I should’ve known better.  :)  Not a problem, I moved to another PC.

As the installation began, I started noticing some very familiar screens. These were some of the same exact windows and options that are offered when SAP BusinessObjects XI 3.x is installed. Below is a description of a few of the dialog screens presented during installation.

Install Type selection – Provides the option to install a MySQL Database Server.Server Component Configuration – CMS Port selection and administrator account setup.Server Intelligence Agent – An “umbrella” service that helps manage services (or servers) by automating starting, restarting, and stopping of servers.Web Application Server selection – Java Web Application Server is the default and “WACS” is recommended deployment type. However, the option to install a Tomcat server and deploy to it is provided.  Additional options are also provided, such as:Allowing you to deploy to a pre-installed Web App ServerThe option to manually deploy the WAR file web components after installationInstall an IIS Web App Server (assuming ASP.NET v1.1 already exists)MySQL Database Configuration – Used for storing system data.Web Application Container Server Configuration – HTTP port setting. 6405 is the default.

After making it through the initial series of settings, installation is ready to begin. The screens continue to remind me of installing BOE but they all say “Crystal Reports Server 2008 V1 Setup”. Pictured below is the Server Intelligence Agent dialog screen showing the option to rename the Node Name and manually adjust the Port number. I changed the Node Name but kept the default Port #.

Crystal Reports Server Intelligence Agent - Node Name - Port Assignment

The screenshot below shows the Web Application Server deployment options.

Web Application Server selection

The two screen shots below show the installation in progress. Expect installation to take from 30 minutes to 1 hour.

Installation Underway

Installation Continues

As my installation moved very close to completion, I was prompted (on Vista) by my Windows Firewall to either Keep Blocking or Unblock “BusinessObjects Enterprise”. “BusinessObjects Enterprise”? Wow, so far, it’s almost exactly like BOE!

Unblock Firewall

Suddenly I remembered the driving force behind the architecture change from BusinessObjects 6.5 to the smooth, elegant, and .WAR filled CORBA architecture in XI. It was because of the powerful and stable SAP Crystal Reports Server.

Installation complete! It’s time to click Start and have a look at what was installed. The screen shot below shows full list of tools installed. The items that jumped out to me are:

Central Configuration Manger (CCM) – Windows based server management utilityCentral Management Console (CMC) – Web based administrative consoleImport Wizard – Tool for migrating objects from one environment to anotherJava Infoview – The reporting portal (and same favicon used by InfoView in BusinessObjects)

SAP Crystal Reports Server 2008 Tools

The first thing I did was click “Java Infoview” and logon as the administrator. At first glance, it’s identical to SAP BusinessObjects Enterprise XI 3.1. But within minutes I began to notice a couple subtle differences. For one, there were a couple key products missing that I’m used to seeing. Such as:

Universe DesignerWeb Intelligence

Then I realized how long Crystal Reports has been around. And how many clients use Crystal Reports to develop highly refined pixel perfect reports. What is the best method for delivering reports to users in a zero-client environment and not requiring the installation of Crystal Reports on every users PC? The answer is SAP Crystal Reports Server.

In my next two posts I will begin describing some of the common features and primary functions in SAP Crystal Reports and how it relates to an enhanced user experience.

Thank you,
Jim Brogden
jim.brogden@daugherty.com

If you enjoyed this post, make sure you subscribe to my RSS feed!

Cool Dashboards from ProMorphics

Although I’ve worked in a number of different industry verticals, I’m currently focused on the Utilities vertical.  I’m always on the look out for great dashboards and I found some!  I want dashboards that combine the best features of Xcelsius together with amazing usability and depth of function.  My latest discovery is from ProMorphics.  ProMorphics is a services organization and they have been a member of the SAP Ecosystem for a number of years.   I recently got a chance to view the results of some of their compelling dashboards  and the results speak for themselves.

When I spoke with ProMorphics they talked about their commitment to listen to the customer and to go the extra mile.  They’ve been extremely successful at using Xcelsius as a prototyping/rapid development tool so that they can get feedback and turn the results around extremely quickly.

Their sample dashboards focus on these three areas:

Environmental Health and Safety (EH&S)Field OperationsSales and Financial Performance (Peek Performance)

If you work in a utility related industry, you may want to engage ProMorphics and leverage their expertise.  It’s not surprising that 70% of their business comes from repeat customers.

ProMorphics Operations Dashboard with Custom Xcelsius Controls

Although ProMorphics does not allow you to download their .xlf files, you can view the dashboards via the following website:
http://www.promorphics1.us/22/interactivedemos/demos

Here is a 10 minute video walk-through of their Peak Performance dashboard with Kasia Szewczyk
http://www.promorphics1.us/29/audiovideo/recording

It’s always good to see partners who exploit all the features within a solution.  In the screenshot above, you can see how they have built Google Map integration as well as a custom calendar control.  These are examples of custom Xcelsius controls written in Flex.  I saw example after example of custom controls, developed to make sure they gave the customer exactly what they wanted.  If you engage ProMorphics in a project, they will also make these custom Xcelsius controls available to you.  Some partners like Centigon Solutions do allow you to buy their Xcelsius controls separately but ProMorphics currently does not.

«Good BI»


View the original article here

Visit my new blog @ MyXcelsius.com

News, Articles, Training & More…

Be the first to like this post.Sorry, I could not read the content fromt this page.

View the original article here

Selectors: 6 steps to Multiple Selection

Posted on 20 August 2010 10:50 am.Femke

As I get more and more request for the multiple select file I have written out below the steps to take (thus I will not send the file anymore, you can follow the steps yourself :-) ). Also I updated the source file to use the push button instead of a second source button as this is easier to understand. I created this initially for a Web Intelligence prompt, but of course you can use it for any prompt.

6 Steps to create a multiple select:

1. create spreadsheet
Multiple Select Spreadsheet

place in cells A5 to A14 your labels (eg. label 1, label 2 etc)in range B5 to B14 you create the parameter labels as they need to be send through (eg. “label 1?, “label 2? etc)place in C5 to C14 a 0 (zero), these are the ‘old selection values’place in D5 to D14 an incremental number (10 labels = 1 to 10)place in D18 a reference to D2 “=D2? (one of the destination cells of the selector), using this formula reference a delay is created in the overall calculation. When instead the direct input cell is used in the cell range E5:E14 no more then 4 items can be selected before re-initialisation. Using this delay formula enables selection of all items.place in E19 the hard coded value 1 (one), this is a source value for the “new value”place in E5 the “new value” formula “=IF($D5=$D$18,$E$19,$C5)” and drag this formula through to E14place in G5 the formula “=IF($E5=1,B5,”")” and drag through to G14. This is the first part of building the WebI prompt with multiple values.place in H5 the formula “=IF($E5=1,C5,”")” and drag through to H14. This is used in the alert of the selector (enables you to see which labels are selected).Place in J5 the formula “=IF(G5=”",”",G5)” and in J6 the formula “=IF(G6=”",IF(J5=”",”",J5),IF(J5=”",G6,J5&”,”&G6))” drag this formula through to J14. This is the second part of building the webi prompt. Cell J14 is the actual prompt send to WebI.place in L5 to L14 a 0 (zero), these are used by the push button to re-initialise to the last selection.place in cell G2 the formula “=”Reset to only “&B2? (label for push button)

2. place a selector, eg.listbox with the following properties:

Labels: A5:A14Insertion type: rowSource data: B5:E14Destination: B2:E2Selected Item: Dynamicenable alertsalert values: H5:H14by valueselect “low values are good”deselect “enable auto colors”, remove 1 color and enter the value 0.5, the range minimum to 0.5 will be with a white background, range 0.5 to maximum will have a red background.

3. place a label which shows the concatenated prompt value

4. place a source data button with the following properties:

insertion type: columnsource data: E5:E14destination: C5:C14

5. place a push button with the following properties:

label: G2source data: L5:L14destination: C5:C14

6. preview your dashboard.

That’s it. Easy is it not?

You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.


View the original article here