Tuesday, December 14, 2010

Upcoming Webinars

Visit www.sapdiary.com

The following is a list to our upcoming webinars… Follow the link next to the webinar date to register.

InfoBurst Webinars

November 5 – 11A PST – http://goo.gl/EZpQ
November 8 – 11A PST – http://goo.gl/036g
November 10 – 11A PST – http://goo.gl/8ewE
November 12 – 11A PST – http://goo.gl/6yYs
November 15 – 11A PST – http://goo.gl/vhW2

360 View Webinars

November 4 – 11A PST – http://goo.gl/hCj7
November 9 – 11A PST – http://goo.gl/CdRc

On facebook, follow InfoBurst at www.facebook.com/infoburst

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

Two Advantages of a Manual Maximum Calculation in Xcelsius

Visit www.sapdiary.com

T-SQL: Previous and Next Modified Date

Normally queries like this are not really solved in T-SQL; rather a front end UI like WebI is capable of navigating through the records.

However if you intend doing it in T-SQL, then here’s how we can retrieve the Next and Previous Records of a given record:

/* Create Sample Table */
DECLARE @TT table
(
ProductID int,
ModifiedDate datetime,
CategoryGroupName varchar(10)
)

/* Create Sample Data */
INSERT INTO @TT VALUES ( 101, ’2010-10-01', ‘AA’)
INSERT INTO @TT VALUES ( 203, ’2010-10-01', ‘AA’);
INSERT INTO @TT VALUES ( 305, ’2010-10-01', ‘AA’);
INSERT INTO @TT VALUES ( 101, ’2010-10-02', ‘BB’);
INSERT INTO @TT VALUES ( 203, ’2010-10-03', ‘BB’);
INSERT INTO @TT VALUES ( 634, ’2010-10-03', ‘BB’);
INSERT INTO @TT VALUES ( 101, ’2010-10-04', ‘CC’);
INSERT INTO @TT VALUES ( 203, ’2010-10-04', ‘CC’);
INSERT INTO @TT VALUES ( 305, ’2010-10-04', ‘CC’);
INSERT INTO @TT VALUES ( 634, ’2010-10-04', ‘CC’);

SELECT
Prod2.ProductID,
Prod2.ModifiedDate,
(SELECT MAX(ModifiedDate)
FROM @TT Prod1
WHERE     Prod1.ModifiedDate <  Prod2.ModifiedDate and Prod1.ProductID=Prod2.ProductID ) as PreviousModifiedDate,
(SELECT MIN(ModifiedDate)
FROM @TT Prod1
WHERE     Prod1.ModifiedDate >  Prod2.ModifiedDate and Prod1.ProductID=Prod2.ProductID) as NextModifiedDate
FROM @TT  Prod2
GROUP BY Prod2.ProductID, Prod2.ModifiedDate
ORDER BY 1,2

Result looks like:


View the original article here

InfoBurst blog has a new home

The InfoBurst team at InfoSol is relocating their Infoburst2009 site to a new web address.  Visit the new product blog at infosolblog.com/infoburst

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

BO XI 3.1: To Upgrade or Not to Upgrade?

As SAP announces the “ramp up” or controlled release for SAP BusinessObjects XI 4.0, some companies who are planning to upgrade to BO XI 3.1 are wondering if they should now wait.

The simple answer is “no” and there are many good reasons to upgrade to XI 3.1 as soon as possible.

Firstly, BusinessObjects XI 3.1 has been the general release for a couple of years now and has proven to be a stable and solid platform. It brings a new version of Web Intelligence with the Rich Client (offline) capability with access to external data providers like Excel. It also has other features, previously only available in Desktop Intelligence, like the fold/unfold feature and stored procedure support through the universe. It adds new functionality also like the ability to track data changes between versions, contextual hyperlinking and use of drop-down selection boxes for prompts.

At the same time, XI 3.1 fully supports Desktop Intelligence reports unchanged which is quite significant when you consider that there will be no support for Desktop Intelligence in XI 4. This means that XI 3.1 will be the last BusinessObjects release to support Desktop Intelligence or the old Full Client reports.

BusinessObjects XI 4.0 will be a major new release with a lot of new functionality some of which will be available in the first 4.0 release and some which will be released later in service pack updates. It will be a 64-bit software application. It will have a new semantic layer that will combine the capabilities of the old BusinessObjects universe and Crystal Business Views and with a slew of new functionality including support of OLAP (MDX) data sources like SAP BW and MS OLAP cubes. The old BusinessObjects Universe Designer will remain supported in XI 4 for compatibility and easier transition.

There are new functionalities and capabilities in Web Intelligence, Xcelsius, Crystal and other content providers including taking advantage of the new semantic layer and universe design tool. There are two versions of Crystal – Crystal Enterprise which is new and uses the new semantic layer and Crystal Reports 2011 which is a continuation of Crystal Reports 2008. There is a new OLAP analysis tool called Advanced Analysis which replaces Voyager and there are significant improvements to Data Services and the BOE infrastructure functionality.

There will also be a new utility to move the contents of your old BusinessObjects content to XI 4. The Import Wizard is effectively replaced by this new tool called the Upgrade Manager Tool. This works for upgrades from XI 3.1 and the plan is to also be able to upgrade from XI R2 with security model changes. There is no upgrade available from earlier releases meaning you would need to move to XI R2 or XI 3.1 before moving to XI 4.

The ramp up will probably last 3 to 6 months so the general availability of XI 4.0 is expected sometime between February 2011 and May 2011. It is unlikely that the first service pack will be available until late in the year and most existing BO customers will probably not look at moving to XI 4 until 2012 or 2013 (based on previous trends).

For these BO customers still using Desktop Intelligence, there will be the added consideration and work of converting or replacing their old reports with Web Intelligence which for some may be a considerable effort and cost.

According to information disseminated at the ASUG BO annual conference in October, in addition to Desktop Intelligence, the following other existing BO XI products will be end of  life :  Voyager, Encyclopedia/Discussions and Performance Manager.

Historically, the current and immediately prior software releases tend to be actively supported for all software issues which would suggest that at some point in 2011 only XI 4.0 and XI 3.1 will be considered the actively supported releases.

Taking all of this information into consideration, it does make sense to upgrade to BusinessObjects XI 3.1 in the coming months if you have not done so already.

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

Drill in chart to different Tab

Posted on 5 October 2010 12:02 am.Femke

If you want to give your users the choice of clicking on a chart (e.g. clicking on the chart title) and then going to a specific tab where the KPI is displayed in more detail, you can use the property “Selected Item: Item (by position)” of the Tab-component and several toggle.

You can even return to the overview tab by using the same method (toggle button). However If you want your users to be able to navigate through BOTH the tab buttons and your toggle buttons, you need to set-up the “return” toggle buttons “with non existing tab positions” as source data. This as the Tab component does not have an insert selection option itself. And when clicking on a tab and then clicking in the chart (on toggle button), the position is not changed and thus it does not trigger the “Selected Item: Item (by position)” property.

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


View the original article here

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