SAP Webi Interview Questions
This SAP Webi Interview Questions contains few questions answers for fresher as well as experienced as a free online practice test.
What is Aggregate awareness function? Why do we use it?
Answer
- Aggregate awareness function is used in scenarios where we have same fact tables in different grains. Using this function we can define only one object for the measures in the fact tables.
- aggregate_aware(highest_level,lower level)
- We also need to define dimensions for associated granularities and define their incompatibilities with the corresponding facts through the aggregate navigation. This is accesses through Tools → Aggregate Navigation.
Use
They are used to enhance the performance reports by utilizing arrogate tables available at database and are applied at Universe level as function.
What is the use of subquery?
Answer
- Subqueries provides you a more flexible option to filter the data as compared to an ordinary query filter. Using Subqueries you can limit the values returned with a WHERE clause. You can also compare the values of objects in a subquery with the other objects.
- Using Subqueries, you can implement complex logic to limit the size of data which are not possible to apply with simple query filters.
- They are used in Query panel.
In Query panel, you can’t see ranking option enabled, what could be the reason?
Answer
Database ranking is done by editing the script generated by query. If you database doesn’t support ranking, then option to create ranking will not highlight in query panel.
Also note that Ranking can’t be created on hierarchical data.
What do you understand by hierarchical data?
Answer
Hierarchical data is defined a data with Parent-child relationship and you can analyze the data at different levels of hierarchy.
All the measures that are associated with hierarchical data are aggregated as per object level in hierarchy.
Example
Consider a Geography hierarchy, you have Country India and State defined as Delhi. Now if you use this geographical hierarchy in report and want to analyze Number of Units sold at each level for different categories, then hierarchies allow you to use Aggregation at country level and if you drill down to state level, for each state too.
What is difference between Break and Sections?
Answer
- Section breakup the data into multiple cells that are called Section headers and Each Section header contains a value for dimension and data corresponding to dimension value.
- Break is used divides the data up into one block and each column carries dimension, attributes and measures and these values are repeated for each other row values in the block.
What is query stripping?
Answer
Query stripping feature optimizes the query to fetch only DATA which will be directly or indirectly rendered or displayed to the User, thus decreasing the response time and faster display of the report for the user. This feature is only available for OLAP universes, and it will be greyed out when using any RDBMS universe. It is used in Query panel.
What are the different chart type in Webi tool?
Answer
- Bar
- Box
- Column
- Line
- Map
- Radar
- Pie
- Waterfall
Explain the difference between Query filter, Report filter and block filter?
Answer
- A query filter limits the data returned from the database.
- A block filter allows selected data to display in a single block and hides the other data.
- A report filter allows selected data to display in a page and hides the other data. The report filter applies to all data blocks on the page.
When you synchronize two queries from different data sources, what rules must you respect?
Answer
Respect the following rules
- Object names can differ.
- The data type for the merged objects must be the same.
- Data must have the same case because the data provider is case-sensitive.
- You can only synchronize on dimensions.
- You can only display measures with synchronized dimensions. When you use them for another purpose, duplicate values appear.
You use the MINUS operator to combine queries, what would be the result?
Answer
All records that match the first query condition and not the second condition.
What is the use of Conditional formatting in Webi report?
Answer
Conditional Formatting is used to highlight some specific values in the report. If you want you can show specific low or high values with some specific colors. Conditional formatting can be applied to below elements −
- Rows in horizon tables
- Columns in Vertical tables
- Cells in forms and cross tables
- Sections
- Free Holding Cells
Condition formatting can be used to make these formatting changes −
- Text Color
- Size and Style
- Cell Border
- Color
- Size and Style
- Cell backgrounds
How you can add multiple query filters in Query panel?
Answer
By using AND/OR operators
What are the different Report filters operators?
Answer
- Equal To
- Not Equal To
- Different From Operator
- Greater Than
- Greater Than or Equal To
- Less Than
- Less Than or Equal To
- Between
- Not Between
- In List
- Not In List
- Is Null
- Is Not Null
You want to use queries from different data sources in a Webi document. How you can use this?
Answer
Using Query Merge. This option allows you to merge the data from different data sources. Assume that you have created Query 1 and Query 2 in Query Panel. When you combine both the queries in a single WebI report, objects from both the queries are shown in list of available objects.
You want to add a new column in the report based on an existing fact value. How you can add this functionality?
Answer
Using New Variable
What is an input context?
Answer
The input context is the list of dimensions that are included in the calculation itself.
What is use of string concatenation?
Answer
Lastname+ “, “ + Firstname
What is the use of Nofilter() function?
Answer
To override a report filter or a ranking
How do you create a hyperlink in the Web Intelligence Interactive panel?
Answer
By using Create Hyperlink dialog box
To allow sync between two queries in Query merger, you use a new variable to add it to report. What re properties that you need to define to enable sync?
Answer
Enter the Variable name, Qualification as “Detail” and it will add a new field Associate Dimension. In Associate dimension, select the unique object from the same query.
How do you connect SAP HANA database to Webi document?
Answer
To use HANA tables for report creation, Use Universe Designer to create Universe using a Relational connection to HANA database.
Can you attach a Webi document in mail?
Answer
Yes, by using send by email attachment option
You have saved a Webi Report .wid file and send it to other user to make changes. He is not able to open it and getting access error. How you can resolve this?
Answer
When you use Save as option, on right side you get many options – Refresh on open, Permanent Regional formatting, Save for all users, Remove document Security.
Select Save for all users’ option while saving the report.
In a Webi report, you want to add Radio buttons for end users to quickly view and analyze the data. Which of the Webi feature support this?
Answer
Input Controls
What do you understand by input controls? Can we use input controls on Geography and Time hierarchy?
Answer
- Input controls are used to filter and analyze the report data. You define input controls using text boxes and radio buttons. Input controls are associated with report elements like tables and section headers and use control to apply filter on report elements.
- When you select a value of an input control, it filters the values in report element that is associated with input control by selected value.
- Input Controls can also be used on hierarchical data.
