Skip to Content

Previous blog The Full Monty – Part 13 – BObj Integration Kit SP3 Install & Configure.

As I read more, it seems there are a few aliases for this product: Xcelsius, Xcelius Designer, Dashboard Design, Crystal Dashboard Design, Presentation Design. In an attempt to stay current and simple, I think I will simply use the term “Dashboard”, from now on.

I will now require Microsoft Excel, because the “Dashboard” levers some of Excel’s functionality. But I have not bothered to document the Excel install.

The Enterprise version of the Dashboard Design has native/direct connectivity to any SAP BW System, eliminating the need Excel or Live Office. If you require any other source for the Dashboard Design, then Excel and Live Office is required.

Downloads 

I downloaded the “Dashboard” files from the Home Page SDN->Downloads(tab), toward the bottom, under “FREE DOWNLOAD CATALOG”, there was a “BusinessObjects Product Trials” link which I clicked. This popped up the familiar BObj trials page, from which I could see two offerings

  • SAP Crystal Dashboard Design starter package
  • SAP Crystal Dashboard Design personal editon

I clicked the “Free Trial” links next to them, filled out the on-line form, and downloaded both. At 540MB each, I extracted them to two different directories “Xcelsius_Engage_30day_trial” &  “Xcelsius_Engage_30day_trial pe”. They were identical.

Based on my earlier experience downloading “Crystal Reports” and the “BObj Integration Kit”, I thought I would take a look at the “SAP BUSINESSOBJECTS PORTFOLIO” on the “SAP Market Place” to see what was there. I found “BOBJ XCELSUIS ENGAGE/ENTER 2008 SP WINDOWS” Object #51038212, which I downloaded.

After comparing all three downloads, I can tell you that they are all the same SP3 version and contain a ProductID.txt file with a single line “BuildVersion=12.3.0.670.”

When it came to entering the License Key, it looked like the keys are the only mechanism to determine what version does what, hence, all the links eventually download the same information. This is just my belief. I am open to suggestion.

Obtain License Key

A license key is required, and can be obtained by downloading an excel file, from the SAP Market Place, Main Page, tab “Keys & Requests”->”License Keys”.

image

 

Save the file, and unzip it, to reveal an excel spreadsheet contained, e.g. “Temporary Keys & Information 08-07-2010.xls”, with all the necessary keys, among other information. We will return to this file soon.

MS Excel Installation 

To begin with, I installed “Microsoft Office Ultimate 2007”, containing Excel. Nothing interesting there. I also installed the “MS Office SP1”.

Dashboard Installation

Next I installed my “Dashboard”

From the unzipped location, I ran the “setup.exe” file.

image

 

The installation wizard began, I chose not to create a log, and kept the defaulted language

image

 

continue through

image

 

at the “User Information” screen, I navigated to my License Key file downloaded earlier, and entered the License Key associated to “SAP Crystal Dashboard Design, Departmental Edition”

image

 

I had no further languages to install

image

 

I chose to see what the “Custom” option did

image

 

I chose the “SDK” option for no other reason than, I may need it

image

 

the installation was soon underway

image

 

the installation was underway

image

 

five minutes after, the installation finished successfully

image

 

I looked under Windows Programs

image

 

and started “Xcelsius 2008”, and continued through the “Xcelsius 2008 Trial” message by pressing the “Continue” button

image

 

at the main screen I navigated to the menu Help->About Xcelsius…

image

 

to see what I had. Notice the “SAP” menu bar too.

Live Office Installation

Live Office is a BObj Product Add-On for Microsoft Office Products. It can be used to access data directly from an SAP system, e.g. Tables, SAP Queries.

Installing Live Office will add a menu bar to the Office Suite Products. For example, before installation Excel looks like this

image

 

after, it will look like this, with the “Live Office” menu tab

image

 

After making sure I do not have any Microsoft Office products open, I ran the “setup.exe” from the “Live Office 3.1” directory, which I downloaded

I chose not to create a log file

image

 

a couple of minutes later, the installation wizard showed up

image

I accepted the License Agreement

image

 

No extra languages to install

image

 

“Next” to the “Destination Folder”

image

“Next” to begin the installation

image

installation was underway

image

10 minutes later, the installation finished

image

There was no Windows Program Group or executable, as suspected, but the “Live Office” menu was now present in Excel.

image

 

I rebooted my system

Live Office Testing

I started Excel, and pressed the “Crystal Reports” button from the “Live Office” menu, and was presented with a once off logon prompt & configuration setting for my BObj.

I gave it my administrator user and the “Web Service URL:”     http://pc:8080/dswsbobje/services/session

image

 

I then navigated to my “Flights” Report, and started to construct the Excel data

image 

I pressed the “Switch to Fields”

image

 

chose all fields/data

image

image

 

did not choose any filters

image

 

I kept the default name

image

and then “Live Office” started to extract the data

image

and finally represented in Excel

image

 

That’s the job of “Live Office” done

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Ingo Hilgefort
    Hi Gingle,

    great blog about the integration. just wanted to pass on one comment, in case customer would like to use the new direct connectivity for SAP BW and Xcelsius you will need to use Xcelsius Enterprise as that is the edition with the new connectivity.

    I was looking at part 13 as well but somehow it seems that the blog is not shown completely

    best regards
    Ingo Hilgefort

    (0) 
    1. glen spalding Post author
      hi ingo, i am very honoured that you have taken time to read my blog. I have learnt much from your’s as you can see. I am very new to all this.

      i have taken note of your comment

      also, i have looked at part 13, and it seems fine, my end. can you explain further

      (0) 
  2. Berenice Guerrero
    Hi Gingle,

    Thanks, it’s a great blog =D, Have you tried the SAP Crystal Dashboard Design, starter package??? because I wanna know about the 10 licenses of SAP Crystal Dashboard Viewing option.

    Let me explain you, I had installed the SAP Crystal Dashboard Design, personal edition, and I downloaded the “starter package” which include the departamental edition and the viewing option, but I realized that it was identical, just like you say, the key makes the difference, so I entered the new key, (without any other installation) and automatically were activated the options of the departamental edition, but now I don’t know where to get my 10 licenses of the viewing option :S
    Do I need install it again? (Guessing that when the installation ends I’ll see a web page with the download links…)

    (0) 
    1. glen spalding Post author
      hi Berenice, i’m afraid you have got me there. my main focus is on the technicalities of testing, and i am not exploring all the license issues. do post again, if you find out something useful. cheers
      (0) 

Leave a Reply