SAP BW...Bex and Web Reporting


Q.What is a free characteristics?

Ans.The characteristics in this area are not displayed in the initial view of the query but you can drill down and filter once you execute the query.


Q.What is filter area?

Ans.The characteristics inthis area are restricted and cannot be filtered or drilled down further.


Q.What is 1ROWCOUNT key figure?

Ans.For ODS and infosets, the query designer automatically adds this key figure “number of records” to count the records.


Q.What is a restricted key figure and give an example?

Ans.These key figures “restricted” by one or more characteristics; for example when you want to compare the sales of product “A’ between different fiscal year periods, you will createa restrictedkey figure with “Sales Qty” as key figure and restricted by 0MATERIAL of value “A”.


Q.What is a constant selection?

Ans. This features allows you to marka selection in the query designer as “constant”, navigation and filtering has no effect on this selection during run time; for example if you want to report a product’s sale in reference to a product group rather than all the products, you make the product group as the constant selection; any drill down, navigation, filtering will always give the sales quantity of the product group.


Q.How wil you debug errors withSap GUI (like active X error,etc)?

Ans.Run bex analyzer→ Business Explorer menu item → Installation check; this shows an excel shet with a start button; click on it; this verifies the GUI installation ; if you find any errors either reinstall it of fix it.


Q.How do you activate personalization for bex?

Ans.IMG → Activate personalization of bex.

No comments:

Post a Comment