BW Reporting And Analysis Short Notes #1

1. Bex allows a wide spectrum of users to access information in SAP BW.
 
2. You can select a filter value directly from the results area of an executed report using Keep Filter Value.
 
3. You can select one or more values from the value set. You can select filter values for characteristics using value selection in Bex by select Filter Value.
 
4. You can sort specified values in ascending or descending order by selecting the hyperlink that has the name of the characteristic or structure. First click in Ascending and second click in descending.
 
5. Filter and Drill Down to set a characteristic at a certain value and at the same time drill down by a different characteristic on the same axis.
 
6. Fix Filter Value to Axis ,when want to see data for one characteristic value and want the characteristic value to continue to appear in the Drill Down.
 
7. Goto function to reach documents and other targets using report / report interfaces.
 
8. Goto Display document on key figure reach the documents that correspond to the cell selection.
 
9. Goto Display Document reach document in the master data area of the characteristic value.
 
10. Goto Document for Navigation Status reach documents that correspond to the selection cell.
 
11. You need SAP Internet Transaction server and the SAP GUI for HTML in all SAP systems in which you wish to call up transactions over the web.
 
12. You can export the query data to Microsoft Excel 2000 - forward.
 
13. You can call the Currency Translation dialog box to determine the currency into which the key figure or a structural component of a query convert.
 
14. The three places where you can all up a context menu with in the results of a report are: On the Name of the characteristic, On the Key value of  the Characteristic, On the name of the characteristic, on a key figure.
 
15. Conditions have no influence on results rows. The results row corresponds to the result row in the table without this condition.
 
16. Exception reporting allows you to determine critical objects in a query in your Web application.
 
17. You can activate the Hierarchy itself from the properties screen that you call up from the context menu for the characteristic.
 
18. To Use Drag & Relate with in BW unifier, you need SAP Enterprise portal 5.0, SAP BW 3.0, SAP BW Unifier.
 
19. Bex Browser allows you to access all documents types of the BW that are assigned to your Role or stored in your Favourites.
 
20. The term Role was called Activity Group  in 2.0A and Channel in 1.2B.
 
21. The Role display in the SAP Easy Access menu can be switched ON and OFF.
 
22. You can manage any kind of file in the Bex Browser. These files are then stored in Business Document Service.
 
23. A maximum of 32 folder symbols can be uploaded.
 
24. You cannot transport folder symbols between BW systems. Upload the folder system to all BW Systems.
 
25. You cannot reposition folder and objects using Drag & Drop.
 
26. In MetaData Repository you can display the definition of all active objects that are delivered in Business content as well as link to the other objects.
 
27. You can activate a query in the Business Content and then go on to execute it in the Query designer.
 
28. You use the Metadata Repository as an information source that allows you to obtain an overview of delivered objects.
 
29. Business Content has the advantage that all necessary and related objects can be activated at the same time.
 
30. Define Cell function is only available for the queries with two structures.
 
31. With Define cell you can control the values of the cell at the intersection of the structural components.
 
32. Free Characteristics do not display in the initial view of the results when you execute the query. You can integrate these characteristics into the results using navigation steps.
 
33. You can use the free characteristics for selecting the filter values in the report.
 
34. Change Query Global Definition  can change the query definition.
 
35. Change Query Local View correspond to navigation in the report and are not saved in the Query definition.
 
36. If you are in Change Query Local View , you can switch directly to the global definition by choosing Change Query Global Definition.
 
37. InfoProviders are objects for which you can create and execute queries in SAP BW.
 
38. Data Targets are the objects which have their own data store.
 
39. Characteristic InfoObjects have to be included in the InfoProvider tree in the AWB to make them available as Data Targets for Flexible updates and as Infoproviders for Reporting.
 
40. ODS Objects are available for Transaction Data and Master Data.
 
41. Multiproviders combines data from several infoproviders and makes it available for use in reporting.
 
42. Multiproviders are based on a Union connection unlike joins in BW Infosets (Intersection).
 
43. The System generates the Key Figure Number of Records (1ROWCOUNT) for the characteristic infoproviders and for ODS objects and places them in key Figures Folder.
 
44. For ODS Object the dimensions are Data Part and Key Part.
 
45. Two dimensions are provided for each Infoprovider in the Infoset. Attribute and Key part. Hence for an infosset composed of an ODS object connected to a Characteristic, Four dimension display.
 
46. You can Stucture BW Infosets only from ODS Objects and or Character Info Objects.
 
47. Restricted Key Figures created a InfoProvider level, you are then able to reuse the Individual key figures in other reports.
 
48. Restricted Key Figures are key figures of InfoProvider that are restricted by one or more Characteristic selections.
 
49. The Key figure that is restricted by one or more characteristic selections can be a basic key figure , Calculated Key figure or a key figure that is already restricted.
 
50. Unlike a filter whose restrictions are valid for entire query, for a Restricted key figure , only the key figure in question is restricted to its allocated characteristic value.
 
51. RKF can be created at the Infoprovder level or Locally in the Query definition.
 
52. Constant Selection  function allows you to mark a defined selection as being constant. Navigation and Filter no longer have an effect on selection in question.
 
53. Constant selection allows you to select reference variables that does not change at the report run time.
 
54. Percentage Variance - PSV % ASV gives the percentage by which the ASV exceeds the PSV.
 
55. Percentage Share - SV %A IC gives the percentage share of SV made up of IC.
 
56. Percentage Share Result - %CT SV gives the share of SV of each characteristic value.
 
57. Percentage Share of Overall Result - %GT SV gives the share to the overall result.
 
58. NDIV(Expr) - Delivers 0 if the expr gives a division by 0 in the calculation, otherwise is the result of the expression.
 
59. Result delivers the result of the operand in all rows or columns.
 
60. Overall Result delivers result of the operand.
 
61. Calculated key Figures can be defined at both the Infoprovider level and Query Level.
 
62. Formula Collision can occur in the interfaces of the two formulas.
 
63. Boolean Operator - Costs < Sales Volume delivers 1 if true else delivers 0.
 
64. Formula Collsion function only displays in the properties dialog box if two structures are used in the query definition and both contain formulas.
 
65. Reusable Structures can be used in several queries for the same Infoprovider.
 
66. To Make local changes in a particular query you can choose Remove Reference in the context menu for the structure, and there by change Reusable to Local.
 
67. A maximum of 2 structures can be defined in a query definition. One of these can contain Key figures. You use characteristic values in one and figures in other structure.
 
68. In the Characteristics properties dialog box you can make settings for a range of functions that affect the key figures for this characteristic.
 
69. Display of Results - Determine whether rows are displayed always, never or With only one value.
 
70. Display of Results - Normalize To - When values are normalized, key figure displays as a percentage of chosen result. Charactertistic is normalized only if it is in the Drill Down.
 
71. You cannot use the attribute that you have selected for Sorting in the display.
 
72. Can show the Display attributes in the report in drill down, but Navigation steps are not possible. - Cannot choose values from a display attribute as a filter.
 
73. In order to use an attribute as an Navigation attribute, You have to flag the attribute as Navigation attribute in the Info Object Maintenance of the characteristic.
 
74. In order to use an attribute as an Navigation attribute, select that attribute from the list of possible navigation attributes in Infocube maintenance.
 
75. You can display the characteristics included in the query definition as a hierarchy.
 
76. You can select an external hierarchy as a display hierarchy for a characteristic in the query definition.
 
77. You can display characteristics and key figures in the rows and in the columns as Hierarchies by selecting Display as Hierarchy from the context menu of row or  column header.
 
78. You can override the hierarchy properties in the query definition.
 
79. You can use Hierarchies to select the filter values for characteristics by selecting individual Hierarchy nodes.
 
80. Can Combine Hierarchy, structures in the display so that you can choose to display the characteristic in Non Hierarchical form and Hierarchical form.
 
81. If Hierarchy and Structure combined but do not choose Display as Hierarchy, a Column and Row are used for both hierarchy and structure.
 
82. With the Hierarchy display, Hierarchy appears with a structure in a column or row.
 
83. To Create Hierarchies, In the Infoobject maintenance for the characteristic concerned you have to set the With Hierarchies indicator.
 
84. Leaves contain the characteristic values for the basic characteristics and cam therefor have entries in the Fact table.
 
85. Intervals contain a number of leaves that belong together described as Upper and Lower Limit.
 
86. Can create a hierarchy only for those characteristic that do not relate to another characteristic.
 
87. Hierarchy nodes appear twice in the Hierarchy when nodes that have the same Technical key and that appear more than once are leaves.
 
88. When Leaves are not attached to the same super ordinate, you can either set the nodes as Link Nodes or make the hierarchy structure as Time Dependent.
 
89. Use Link nodes to include a subtree in a hierarchy more than once.
 
90. Link node is only a link to the original node that you cannot change independently.
 
91. Variables are query parameters that you define in the query designer and that are filled with values only when query is executed.
 
92. Variables act as placeholders for Characteristic values, Hierarchies, Hierarchy nodes, Texts and formula elements.
 
93. Variables are Reusable objects.
 
94. Variables do not depend on Infoprovider, but rather on the Infoobjects for which they are created.
 
95. If you are using variables when making interval selections, you can swap the limits by highlighting the relevant variables by choosing Swap Interval Limits.
 
96. variable processing Types - User Entry / Default Value, Replacement Path, Authorization, Customer exit, SAP exit.
 
97. User Entry / Default value - can manually enter the required value for the variable in a dialog box when query executed.
 
98. Replacement Path - Enables you to specify the value that automatically replaces the variable when the query or web application is executed.
 
99. Authorization - Enables you to fill the variables automatically with the values from the Authorization of the user.
 
100. Customer Exit - Enables you to determine values for variables by means of a function module exit.

SAP BW Tips

Also read

Get help for your SAP BW problems
Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.