Posted in BI / BW, BI Top Tips, SAP on November 3rd, 2006 No Comments »
When users run SAP BW queries and use the F4 key to select values for selections and parameters there is the possibility they will get to see sensitive information they are not authorised to view e.g Payroll information (Pay Grade) which could be part of the Employee master data Infoobject.
To alter the settings that determine [...]
Posted in BI / BW, BI Top Tips, SAP on November 2nd, 2006 No Comments »
SAP HR users have difficulty understanding how to use the Action Type and Action Reason dimensions on the employee and personnel action Infocube.
The confusion exists when a user tries to restrict the BW query on Action Reason without first choosing the Action Type. When this happened a pop-up window display all the entries of Action [...]
Posted in BI / BW, BI Top Tips, SAP on November 1st, 2006 No Comments »
It is sometimes unclear how BW handles the formatting of dates. Here is a quick overview:
For BEx reporting, SAP BW uses the settings stored on the users local machine. On your desktop click Start -> Settings -> Control Panel -> Regional options to view the settings local to your PC.
Some date related reporting objects get [...]
Posted in BI / BW, BI Top Tips, SAP on October 31st, 2006 No Comments »
To resolve problems and answer BW queries, it is often necessary to compare R/3 data with the data reported through BW. Just identifying the Datasource for an extractor can sometimes be a challenge in itself.
For Master Data, Text and Hierarchies take a look at table ‘RODCHABAS‘. This table contains entries of InfoObject/Basic Characteristics together with [...]
Posted in BI / BW, BI Top Tips, SAP on October 30th, 2006 No Comments »
When loading data from R/3, data record errors often occur due to Overlapping Time Period. The reason for this type of error is BW has tried to load multiple records that contain the same key and overlapping validity periods (start date/end date). The records are then rejected during the update.
You can sometimes get around this [...]