By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData CollectiveSmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    data-driven white label SEO
    Does Data Mining Really Help with White Label SEO?
    7 Min Read
    marketing analytics for hardware vendors
    IT Hardware Startups Turn to Data Analytics for Market Research
    9 Min Read
    big data and digital signage
    The Power of Big Data and Analytics in Digital Signage
    5 Min Read
    data analytics investing
    Data Analytics Boosts ROI of Investment Trusts
    9 Min Read
    football data collection and analytics
    Unleashing Victory: How Data Collection Is Revolutionizing Football Performance Analysis!
    4 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: The End of Classic Business Objects
Share
Notification Show More
Aa
SmartData CollectiveSmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > The End of Classic Business Objects
Business Intelligence

The End of Classic Business Objects

DougLautzenheiser
Last updated: 2011/02/06 at 7:19 PM
DougLautzenheiser
3 Min Read
SHARE
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).

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 can not be replicated using Web Intelligence (aka WebI).

One of my clients decided instead to just eliminate Business Objects altogether and move to a different web-based BI product. To assist with the replacement initiative, we added a new feature to our BI Consolidator scanning engine. While the utility had always been able to look for keywords, for this BO analysis we needed to actually parse the SQL, extract table and column information into a database, and produce redundancy reports.

More Read

SAP HANA and Big data startups

How SAP Hana is Driving Big Data Startups

SAP Buys Concur for $7.4B for Travel & Expense SaaS
SAP Sets Course for Simple ERP
SAP Big Data Chat: The Data Scientist [VIDEO]
SAP Acquisition of KXEN Proxy War in the Cloud, Predictive Analytics Space

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. 

TAGGED: sap
DougLautzenheiser February 6, 2011 February 6, 2011
Share This Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

RN coders for hosptial data
RN Coders Can Improve Hospital Data Strategies
Big Data
cloud technology in education
How Cloud Technology Can Be Integrating in Schools
IT
big data and IP laws
Big Data & AI In Collision Course With IP Laws – A Complete Guide
Big Data
ai in marketing
4 Ways AI Can Enhance Your Marketing Strategies
Marketing

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

SAP HANA and Big data startups
Big DataNewsSAPSoftware

How SAP Hana is Driving Big Data Startups

5 Min Read

SAP Buys Concur for $7.4B for Travel & Expense SaaS

3 Min Read

SAP Sets Course for Simple ERP

13 Min Read

SAP Big Data Chat: The Data Scientist [VIDEO]

1 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence
AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?