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. 

6 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

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

About Me

My Photo
Helping companies make better decisions via Business Intelligence. INTP working on the E&J. Traveler, reader, family guy, coffee drinker.