Wednesday, December 22, 2010
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" 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:
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" 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. 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.
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. Visit us at Booth 404 at ASUG SAP BO User Conference
By YolandePublished: September 8, 2010Posted in: 360 View, Events, InfoBurst, Roambi, SAP Business Objects, XcelsiusTags:
InfoSol will be a Diamond Sponsor at the 2010 ASUG SAP BusinessObjects User Conference to be held in Orlando. Florida October 5-7. The conference is expected to draw an estimated 1,500 to 2,000 BusinessObjects users.
InfoSol will be leading two session tracks during the conference : one highlighting Xcelsius Customer Case Studies and the other highlighting the next generation of BI report and dashboard publishing. We have also been invited to participate as one of the selected Xcelsius Guru companies in an Xcelsius Gurus event at the conference.
InfoSol will be highlighting many of its value add solutions including InfoBurst and 360View. Several InfoSol partners are also sponsoring and exhibiting including Mellmo the developers of Roambi and Antivia the developers of XWIS.
Be sure to stop by the InfoSol booth (#404) to say hello and enter for our raffle to win an iPad.
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
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:C145. place a push button with the following properties:
label: G2source data: L5:L14destination: C5:C146. 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.3 Steps in Creating Your First Report
So, you’ve been told you need to start using Crystal Reports. It’s installed on your machine and you’ve opened it. Now how do you get started?
The good news is that you don’t need to be a programmer or a database expert. However, you will need to be aware of the business requirements
for the report, how the report will be distributed, and be familiar with the data in the database. Assuming you have this knowledge, you can jump right in:
When you select Print Preview, Crystal Reports will generate the report by retrieving the records from the database and display the requested data on the report. It then is the time to be sure that the newly designed report meets all the business requirements per the request. Changes to the report, additions and deletions are simple to employ. If all is good, you can then export the report to several different Windows applications or to HTML. There is even a free Crystal Reports Viewer for those who don’t have a copy of Crystal Reports.
We provide plenty of practice creating basic reports in our Introduction to Crystal Reports 2008 class.
Add on manager is greyed out
Posted on 24 March 2010 1:33 pm.Femke
After installing Windows 7 the add on manager is greyed out in Xcelsius.
This is due to the default User Account Control settings. Change the setting to the lowest level (9) and then import the add ons. After restart of Xcelsius you can change the level back up again (or leave it).
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.Xcelsius and the Object Browser
In Xcelsius, the Object Browser is your new best friend. It stores and displays all of the components that are on the canvas and allows you to hide them and/or lock them into position. Xcelsius allows you to design a dashboard by placing components on the canvas. It adds exciting visualization to Excel data– trends, what-if, projections and much more.
To add a component to a canvas of the visualization:
Open the spreadsheet that contains the data you want to use.Decide which type of component you need. ( Selectors, Containers, Charts, Gauges.)
Select the component and click on the canvas to insert the object.Use the Object Browser to control the component.Click on the eye to hide temporarily.Click on the padlock to lock the component position on the visualization.Once you have completed the components layout, you save it. The process of saving converts your visualization of the Excel data to an .xlf file. Click on preview and and a .swf file is created. This file then can be placed in a web page, PowerPoint, Word, Excel and Acrobat.
Xcelsius creates a dynamic, interactive and visual presentation of Excel data and a wow factor to your presentations!
Learn more about the Object Browser and other cool Xcelsius features in our 2-day Xcelsius class.
Webinar Alert: Fast-Tracking your BI Career One Dashboard at a Time!
With all the new BI trends and themes evolving today, how do you keep your career on track?
We are excited to announce a free webinar, hosted by Xcelsius Guru and SAP Mentor, Mico Yuk and a surprise guest, that will provide a firsthand look at key trends and themes within the BI industry and insight on how to take your career to the next level.
During the webinar the following important topics will discussed:
1. The future of the BI Industry and how dashboards will play an integral part
2. How to navigate your career in 2011 and take it to the next level
3. How to monopolize the emerging mobile technologies
Your Next Steps:
Click here to Register!Mark the date on your calenders: Wednesday, December 15, 2010, at 1pm EST, 10am PSTAttend the webinar with your questionsWe encourage anyone looking to get their BI career on track and to the next level to register today, as seats are limited. We look forward to this very exciting webinar!
Soo Tang Yuk fosters and evangelizes the ‘Xcelsius Gurus Network” and its communities. To find out more about her, please visit the About Us page.
Tags: BusinessObjects, Crystal Solutions, FleXcelsius, SAP Crystal Dashboard Design, Web Intelligence, Xcelsius 2008, Xcelsius Webinars
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.
Subscribe to:
Posts (Atom)