Feed on
Posts
Comments

Archive for the 'BI Top Tips' Category

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 [...]

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 [...]

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 [...]

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 [...]

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 [...]

TekLink © 2010