Forcing SAP Webi report to show specific data

In SAP WebI (Web Intelligence), you can force a report to show specific data by creating a separate query that filters for the desired values. This can be done by creating a separate query that only shows priority. Then you need to replace column [Query1].[Priority] with the merged dimension [Priority].

Step-by-Step Process

Follow these steps to implement data filtering using merged dimensions ?

Step 1: Create a Separate Query

First, create a new query in your WebI document that contains only the specific data you want to display. For example, if you want to show only high-priority items ?

SELECT Priority 
FROM Data_Source 
WHERE Priority = 'High'

Step 2: Replace with Merged Dimension

After creating the separate query, you need to merge the dimensions between your queries. Replace the original column reference [Query1].[Priority] with the merged dimension [Priority] in your report structure.

Original: [Query1].[Priority]
Replace with: [Priority] (merged dimension)

Benefits of This Approach

This method allows you to control exactly what data appears in your report by creating a master list of allowed values. The merged dimension ensures that only the data matching your criteria will be displayed, effectively filtering out unwanted records from the final report output.

Conclusion

Using merged dimensions with separate queries provides precise control over data visibility in SAP WebI reports, ensuring only specific, relevant data is presented to end users.