Skip to Content

Mapping the data in source systems to BI reports and dashboards is where companies spend the most time and money, in both initial development and ongoing maintenance. Transactional systems typically have complex data schemas that span multiple functional modules and utilize thousands of relational tables. In addition, the names used for tables and columns are often cryptic, which makes it difficult to decipher what data a table contains unless you’re familiar with a particular transactional system.

 

Further complicating the integration process is the fact that an application programming interface (API) must be used to access the security mechanisms and business logic of the transactional system. And it’s common for the joins used in BI reports to be broken by transactional system upgrades because column and table names get changed, columns are added to or deleted from tables, or whole tables are added/deleted.

 

Unlike a generic BI tool, business intelligence in SAP Business All-in-One comes preconfigured, which help reduce the time and cost associated with implementing and maintaining reports and dashboards. To see a product demo go to the following page on SAP.com.

http://www.sap.com/solutions/sme/businessallinone/solutionoverview/businessintelligence/index.epx

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Kristian Appel
    Dear Dan
    Could you please start blogs like this with a sentence like: ”Warning this is a commercial”. Section 1 and 2 of your blog states well known problems in the extraction phase and as a reader I’m asking “What is he aiming at” and then it’s revealed that you want to sell something. Please move your conclusion up in the text so that I do not waste my time.

    With Kind Regards
    Kristian Appel

    (0) 
      1. Kristian Appel
        You are foregiven (;-))
        There is a tendency at the moment that the Blogs are changing in nature. More (I think) is promoting something either products or events. As I see it it is a kind of spam. I would like to read intelligent blogs, but spare me for the commercials.

        With Kind Regards
        Kristian

        (0) 

Leave a Reply