Skip to Content
Author's profile photo Former Member

Challenges Faced in BW 3.X and Resolutions in BI 7.X Environment

Challenges faced in 3.x environment

  • Users rely on BW as a source for data downloads not as a BI tool spawning offline processes and inconsistencies in metrics.
  • Performance issues and troubleshooting takes up most of the team’s time resulting in real enhancements being few and far in between.
  • Small changes to a cube generally requires a major reload effort causing long downtimes.
  • Some users do not have faith in the accuracy of the data.
  • Formatted reports developed using 3rd party tools takes long time to run.
  • Frequent updates to data (sub day/ real time) needed. BW is a monster and is slow to respond.
  • Unable to produce a report on intersecting data between two infocubes.


Resolution in BI 7.X Environment

  • Excel integration/Cell based functionality helps create efficient and exact reports per user specifications drastically reducing need for offline processes.
  • BI Accelerator promises quantum leap in query performance and reduces maintenance effort.
  • Remodeling and repartioning help reduce downtime for critical data cubes.
  • Reconciliation data sources are a great resource for building audit applications which will improve user confidence in the BI system.
  • Improved report output capabilities include fixed format reporting and printing from the Web or output to PDF.
  • NW7.x now support real time data acquisition and reporting.
  • Enhanced infoset to integrate infoproviders to a JOIN condition.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Lars Breddemann
      Lars Breddemann
      Is this really how you and obviously others (see Column Store in SAP HANA) think a interesting blog post should look like?
      Would YOU like to read a two-part bullet list when you expect a SCN blog?

      I'm stunned that blogs like this one actually pass moderation.

      Maybe my standards are too high, maybe I expect too much - but is THIS really what you want others to know about you?
      To be the author of bullet point lists?

      Basically I want to tell you the same I wrote to Neha (see link above): keep on blogging, but write something original, important or funny.

      Guess, now I'm the bad guy here...

      Anyhow - cheers, Lars

      Author's profile photo Former Member
      Former Member
      Thanks for your reply. yes, this is a new trend here in SCN.This blogs are based on my personal experiences and are original.
      Author's profile photo Lars Breddemann
      Lars Breddemann
      Ok - I'm giving up.

      Maybe reading the opinion of other also very active community members might change your self-assessment concerning this blog post...
      What happened to SDN (quality)?