SAP HANA Idea Incubator – Multiple Process Improvement Proposals SAP BW

Here are some of my ideas & suggestion within existing setup which can significantly benefit end users and BW consultants

Data Modelling

• Default handling of junk characters upon loading : BW data models will have to always write their own piece of code to handle junk characters and it’s a long standing wish from all developers

• There should be a provision to compare the BW objects and Reports across the system to identify inconsistencies

• There is no standard way on how data integrity checks are to be performed with source system, SAP should define standard processes for data reconciliations OR provide data models to compare data between source systems

• Similar to metadata repository SAP can have a repository which has inbuilt tools, Also it would be nice if SAP provides standard tools for certain tedious operation which need custom workarounds, some examples include,
  • Identifying BeX Reports associated with Roles
  • Reports which are associated with Web Templates & Workbooks
  • Where used list of variables in Reports
  • Reports having last used information

Reporting

• Suggest to have one single button to remove all Drills from the report output

• If a report has 30+ fields for drills then its tedious to add the fields for drills to report output as users will have to scroll till bottom, enable search functionality for fields which are available for drills

• Enable functionality to add multiple fields for drills at once in report output

https://ideas.sap.com/SAPHANAIdeaIncubator/user-friendly-options-in-bw-report—pro

Thanks

Abhishek Shanbhogue