Sunday, February 6, 2011

The End of Classic Business Objects

In his recent blog postings, SAP Business Objects trainer Dallas Marks has talked about "the end of the world as we know it" as it relates to the software vendor's decision to sunset their classic BO authoring tool known as Desktop Intelligence (or DeskI as its short nickname).

The legacy Windows product is going away, and the vendor expects their customers to switch to the web version. To date, there is minimal conversion help and some DeskI features cannot be replicated using Web Intelligence (aka WebI).

Of course, another option is to just eliminate Business Objects altogether and move to a different web-based BI product. To assist companies choosing this type of replacement initiative, we added a new feature to our BI Consolidator scanning engine.

While the utility had always been able to look for specific keywords, for BO analysis we wanted to parse the SQL, extract table and column information into a database, and produce redundancy reports.

From the BO Repository, we copied the underlying SQL from the DeskI and WebI data providers for each BO Document (the reports). A utility parses the details and saves all of the data into an "inventory" repository for later analysis.

The following BO information is captured within the SQL inventory repository:
  • BO Universe name and a calculated high-level "group"
  • BO Folder name and group
  • BO Userid 
  • BO Document name and group
  • BO Data Provider name, type (DeskI or WebI), and group 
  • SQL Tables being accessed on FROM phrases
  • SQL Table types (e.g., aggregate aware, summaries, history, hierarchies, security, etc.)
  • SQL Table groups 
  • SQL Columns being accessed on SELECT phrases 
  • SQL Columns being referenced on WHERE phrases 
  • SQL Column types (e.g., count, amount, ID, code) and groups 

These calculated "groups" allow us to organize information into higher level categories for redundancy analysis. With both category and detail data, we can discern which databases, tables, and columns are being used within thousands of BO reports. Tying this repository together with usage statistics, we can also determine which of the BO reports are of high usage and their associated data elements.

In addition to BO WebI and DeskI, our scanning can also capture information from your Crystal Reports modules.

SAP is eliminating your BO DeskI product, but converting your legacy reports to WebI is not your only option. Contact me if you are interested in learning more. 

8 comments:

vishnu said...

software companies in india

Joshua Smith said...

Thank you for sharing with good useful information. It was nice to read the review. Try to use outsources software development company thats allow you to get custom development software for your business.

BigClasses said...

Thanks for providing the information on  Business Objects Online training. Online training have the benefits of being convenient, flexible and on your own time.

Sara Lisa said...

Hi Doug! Excellent suggestions.Thanks so much this is just what ive been looking for.SAP BO Online Training

john williams said...

Hi..i am kartik,, thanks for sharing a vailable information in sap hana SAP HANA

kishor mahakale said...

Really good piece of knowledge, I had come back to understand regarding your website from my friend Sumit, Hyderabad And it is very useful for who is looking for SAP BO.

James navion said...

great work really thank you for the info about sap .a free live demo on all sap courses.by Exp trainers
SAP BO Online Training

James navion said...

great work really thank you for the info about sap .a free live demo on all sap courses.by Exp trainers
SAP BO Online Training

About Me

My photo

I am a project-based consultant, helping data-intensive firms use agile methods and automation tools to replace legacy reporting and bring in modern BI/Analytics to leverage Social, Cloud, Mobile, Big Data, Visualizations, and Predictive Analytics. For several world-class vendors, I led services teams specializing in providing software implementation and custom application development. Based on scores of successful engagements, I have assembled proven methodologies and automated software tools.

During twenty years of technical consulting, I have been blessed to work with smart people from some of the world's most respected organizations, including: FedEx, Procter & Gamble, Nationwide, The Wendy's Company, The Kroger Co., JPMorgan Chase, MasterCard, Bank of America Merrill Lynch, Siemens, American Express, and others.

I was educated at Valparaiso University and the University of Cincinnati, graduating summa cum laude. In 1990, I joined Information Builders, the vendor of WebFOCUS BI and iWay enterprise integration products, and for over a dozen years served in branch leadership roles. For several years, I also led technical teams within Cincom Systems' ERP software product group and the custom software services arm of Xerox.

Since 2007, I have provided enterprise BI services such as: strategic advice; architecture, design, and software application development of intelligence systems (interactive dashboards and mobile); data warehousing; and automated modernization of legacy reporting.