Here we have mentioned most frequently asked SAP WEBI Interview Questions and Answers specially for freshers and experienced.
1. What Are The Different Versions Of Business Objects That You Have Worked On?
Ans:
BO XI R1
BO XI R2
BO XI R3
BO XI R3.1
BO XI R3.2
In year 2011, BO XI 4.0 was introduced and latest version of the tool is SAP BO 4.2.
2. What Are The Key Differences Between Boxi R3 And Sap Bo 4.x?
Ans:
Deski is not available in BO 4.x
IDT is introduced to support multiple data sources
Import Wizard is no longer available in BO 4.x
Bo 4.x is 6 layered architecture as compared to BOXI R3 5 layer architecture.
3. How Do You Migrate Deski To Webi Reports In Business Objects?
Ans:
Using Report Conversion Tool
4. To Publish A Webi Report Created On The Top Of Universe In Bo Repository, It Should Be Created On Which Connection?
Ans:
Secured connection published to Repository
5. What Are The Differences Between Personal, Shared And Secured Connections?
Ans:
A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file.
A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection. Neither can a Universe to exported to repository using a shared connection.
A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS.
6. What Is Bi Launchpad?
Ans:
BI Launchpad is a Java or HTML based interface of Business Objects tool to perform analytical reporting and data analysis. You can set the preference for your BI Launchpad which determines which tool interface is launched via Launchpad.
Using Web or Internet Application to access WebI interface via BI Launchpad, you can perform the below tasks –
Create, edit and refresh all the reports in Web Intelligence.
Create and edit all the queries in no data source (Universes) but not BEx queries in Web application.
7. Explain The Architecture Of Web Intelligence Tool?
Ans:
It is three layered architecture –
Database layer – This layer defines multiple SAP and non-SAP data sources.
Semantic Layer – This layer defines multidimensional data model.
Presentation Layer – This layer defines where data is presented to end users.
Various data sources can be used to create analytical and ad-hoc reports
8. What Are The Different Application Modes That Can Be Used In A Web Intelligence Tool?
Ans:
There are three different application modes that can be used to build the queries, create documents and to analyze the reports. When you open an existing reports below modes are available –
Data Application Mode
Reading
Design
9. What Are The Different Data Sources That You Can Use To Create A New Webi Document?
Ans:
Universe
Flat files in .csv or .xls format
BEx queries
Analysis View
10. What Is The Extension Of A Webi Document?
Ans:
.wid file
11. You Have Few Report Created In Older Versions Of Web Intelligence 3.1 And Want To Upgrade To 4.x, Which Tool You Should Use?
Ans:
Using Upgrade Management Tool UMT
12. What Is The Extension Of Universes Created In Information Design Tool And Udt?
Ans:
.unx- File created with Information Design Tool
.unv- File created in Universe Design Tool
13. What Is A Query Panel?
Ans:
You can select from list of available objects as per your access permissions. You may not be able to use few of the objects cos of permission.
In query panel, you have Universe outline in left pane and Result objects, query filters, data preview panels in main pane.
14. Which Connection You Can Use To Import All Olap Functionalities From An Infocube In Sap Bw?
Ans:
BICS Business Intelligence Consumer Service. BICS connectivity is the recommended way for BI tools to connect to Business Explorer (BEx) queries on the SAP NetWeaver BW server.
15. What Are The Different Save As Formats Supported For A Webi Report?
Ans:
WID
PDF
Excel
Excel 2007
CSV Achieve
TXT File
16. What Are Classes And Subclasses?
Ans:
Classes are used to group similar objects in a report. A class can contain one or more subclasses.
Subclasses contains further subcategory of objects in upper level of a class.
Classes are used to organize objects in some logical manner. While creating queries on Universe you can find the information on objects that you have to use in query.
17. What Is Difference Between Members And Named Set In Hierarchies?
Ans:
Members are defined at different level of hierarchies in a data source.
Example: Consider a Geography hierarchy contain members – “India” at country level and “Haryana” at State level.
You can also include individual members in query from hierarchy if you don’t want to add all the members. Named set can be used to define set of members.
A named set is defined as named expression and results a set of members. You can define named set at Universe level or a relational or OLAP database level.
18. Where Do You Define Hierarchies To Use In Webi Report?
Ans:
Universe level
19. How Do You Use Infocubes In Sap Bw To Connect To Webi Document?
Ans:
You can create Webi documents based on BEx (business Exchange Queries) created by BEx Query Designer which is based on Info Cube in SAP BW system. You can connect to a BEx query in WebI with use of BICS BI consumer service connection. You need not to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are automatically mapped in WebI document.
20. How Do You Connect To Sql Server To Create A Universe To Use In A Webi Report?
Ans:
Using a Relational connection created in Universe Designer
21. What Are The Query Filters?
Ans:
Query filters are used to limit the rows returned in a WebI document. Query filters allow you to hide the data that you don’t want to show to specific people and also limit the size of .wid document. When you run a query, it only returns the rows that meet the query filter definition.
Below are the key features used in Query filter –
You can retrieve data as per specific business requirement.
You can hide the data that you don’t want specific users to see in a WebI document.
Limit the size of WebI document of network and hence provides performance optimization.
Example – Being an Area Sales Manager for NY, you want to see margin values for your region and Sales universe contains data from all the regions in United State. Also you only want to see data from the stores in NY where sales margin is greater than 100K USD in 2nd Quarter Q2 2015.
22. What Is Difference Between Query And Report Filters?
Ans:
Query filters are applied in Query Panel and they are used to limit the number of rows from data sources and to return the same in document.
Report filters are applied at report level on reports, tables, charts, etc. These filters are not used to limit the data retrieval from the data source and only hide certain values at report level.
23. Why Do We Use Prompts? Where Do We Apply Prompts To Use In Webi Report?
Ans:
Prompt is defined as special filter for users which allows them to enter a value every time data is refreshed in the document.
Using prompts, you have multiple users viewing one document to display different sub set of data in database. Prompts allow you to retrieve the data from database and reduce the time.
Prompts are created in Query Panel
24. What Is Context And How They Are Created?
Ans:
Context defines a particular join path between tables or a specific group of joins for a particular query. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.
Contexts may be created using detect contexts feature or manually. They are generally created based on logical calculation and business requirements, hence the detect context method is not very effective. To manually create a context Go to Insert Context, give the context name and select the joins that should be present in the context. For a universe contexts should be created in a way that all joins(except shortcut joins) fall in at least one context.
25. What Is Aggregate Awareness Function? Why Do We Use It?
Ans:
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.
26. What Is The Use Of Subquery?
Ans:
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.
27. In Query Panel, You Can’t See Ranking Option Enabled, What Could Be The Reason?
Ans:
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.
28. What Do You Understand By Hierarchical Data?
Ans:
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.
29. What Is Difference Between Break And Sections?
Ans:
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.
30. What Is Query Stripping?
Ans:
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.
31. What Are The Different Chart Type In Webi Tool?
Ans:
Bar
Box
Column
Line
Map
Radar
Pie
Waterfall
32. Explain The Difference Between Query Filter, Report Filter And Block Filter?
Ans:
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.
33. When You Synchronize Two Queries From Different Data Sources, What Rules Must You Respect?
Ans:
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.
34. You Use The Minus Operator To Combine Queries, What Would Be The Result?
Ans:
All records that match the first query condition and not the second condition.
35. What Is The Use Of Conditional Formatting In Webi Report?
Ans:
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
36. How You Can Add Multiple Query Filters In Query Panel?
Ans:
By using AND/OR operators
37. What Are The Different Report Filters Operators?
Ans:
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
38. You Want To Use Queries From Different Data Sources In A Webi Document. How You Can Use This?
Ans:
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.
39. You Want To Add A New Column In The Report Based On An Existing Fact Value. How You Can Add This Functionality?
Ans:
Using New Variable
40. What Is An Input Context?
Ans:
The input context is the list of dimensions that are included in the calculation itself.
41. What Is Use Of String Concatenation?
Ans:
Lastname+ “, “ + Firstname
42. What Is The Use Of Nofilter() Function?
Ans:
To override a report filter or a ranking
43. How Do You Create A Hyperlink In The Web Intelligence Interactive Panel?
Ans:
By using Create Hyperlink dialog box
44. 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?
Ans:
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.
45. How Do You Connect Sap Hana Database To Webi Document?
Ans:
To use HANA tables for report creation, Use Universe Designer to create Universe using a Relational connection to HANA database.
46. Can You Attach A Webi Document In Mail?
Ans:
Yes, by using send by email attachment option
47. 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?
Ans:
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.
48. 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?
Ans:
Input Controls
49. What Do You Understand By Input Controls? Can We Use Input Controls On Geography And Time Hierarchy?
Ans:
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.
50. What are some of the common BI report types?
Ans:
• Analytical reports
• Operational Reports
• Dashboards
51. What is a Dashboard?
Ans:
A collection of summarized reports is called dashboard. In other words a dashboard is simply an organized way to look at several KPIs at once.
52. Define the term slowly changing dimensions (SCD).
Ans:
Please formulate an answer on your own.
53. 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?
Ans:
Input Controls
54. Please explain how SCD type 2 is usually implemented?
Ans:
Please formulate an answer on your own.
55. What is a hierarchy?
Ans:
Group of related dimension objects are referred to as dimension hierarchies. An example of a dimension hierarchy is Geography, which can consist of City, Region, and Country.(Hierarchy is an ordered series of related dimensions, which can be used, in multidimensional analysis) Good examples of hierarchy are geography and time
56. What do you understand by input controls? Can we use input controls on Geography and Time hierarchy?
Ans:
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.
57. Pick five available data sources for webi reports?
Ans:
• No Data Source
• Universe
• Excel
• Bex
• Analysis View
• Web Services
58. What are some of the best practices in creating reports?
Ans:
Limit the number of Data Providers Used
Push down operations towards the Database/Universe which means
Retrieve aggregated data instead of aggregation within the document
Do not (accidentally) disable the cache mechanism of Web Intelligence
Web Intelligence has a great caching mechanism for documents that have already been viewed. Using Cache improves the load time of documents; however there are a few functions within Web Intelligence that will prevent the use of the Cache. These functions are:
CurrentTime()
CurrentDate()
UserName()
Avoid Auto-Fit When possible
Avoid Charts with a high number of Data Points
Limit use of “Scope of Analysis”
Build lean reports by having as little calculations as possible.
Use Query filters instead of Report Filters
Ensure Query Stripping is utilized
59. Your client has a weekly sales report and wants to know whether there was a decrease or an increase in the current week’s sales compared to the previous week. Can that be done in Webi? If so how?
Ans:
Yes, you would do that by enabling Data Tracking.
60. How does data tracking work?
Ans:
Data tracking follows the theme of formatting rules with a difference, that is, its formatting results are determined by comparing two different results.
With data tracking, we can analyze changes over time and are able to track increments and decrements of changes along measures and dimension values.
61. What different Operators available to combine queries in Webi?
Ans:
Union, Intersection, Minus
62. What is the purpose of Scope of Analysis Panel in Query Panel?
Ans:
several possible answers:
It is used to do additional analysis
It is used to do drill down on data
It is used to analyze detail of data
63. What is the difference between a subquery and a combined query?
Ans:
A subquery is a just a query within a query, whereas a combine queries are two or more queries joined together to form a result set.
64. What is a Universe?
Ans:
Universe is a semantic layer that shows provides users access to database in a business friendly way
65. Where is data tracking Enabled?
Ans:
By navigating to the Analysis toolbar and then to the Data Tracking tab, we will be able to adjust the data tracking options.
66. What are the two prerequisites of passing parameters between reports?
Ans:
1. We require a common value that the master report can pass to the target report, which is the same as in merged data providers. The value needs to be in the same type (for example, numeric to numeric object)
2. In this method, we require that the target report will have a prompt condition as part of its query filters; this prompt functions as the landing area of the value being passed from the master report.
67. What are the different versions of Business Objects that you have worked on?
Ans:
BO XI R1
BO XI R2
BO XI R3
BO XI R3.1
BO XI R3.2
In year 2011, BO XI 4.0 was introduced and latest version of the tool is SAP BO 4.2.
68. What are the key differences between BOXI R3 and SAP BO 4.x?
Ans:
Deski is not available in BO 4.x
IDT is introduced to support multiple data sources
Import Wizard is no longer available in BO 4.x
Bo 4.x is 6 layered architecture as compared to BOXI R3 5 layer architecture.
69. How do you migrate Deski to Webi reports in Business Objects?
Ans:
Using Report Conversion Tool
70. To publish a Webi report created on the top of Universe in BO repository, it should be created on which connection?
Secured connection published to Repository
70. What are the differences between Personal, Shared and Secured connections?
Ans:
A Personal connection is created by one user and cannot be used by other users. The connection details are stored in PDAC.LSI file.
A shared connection can be used by other users through a shared server. The connection details are stored in SDAC.LSI file in the Business Objects installation folder. However one cannot set rights and securities on objects in a shared connection. Neither can a Universe to exported to repository using a shared connection.
A secured connection overcomes these limitations. Through it rights can be set on objects and documents. Universes can be exported to the central repository only through a secured connection. The connection parameters in this case are saved in the CMS.
71. 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?
Ans:
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.
72. What is BI Launchpad?
Ans:
BI Launchpad is a Java or HTML based interface of Business Objects tool to perform analytical reporting and data analysis. You can set the preference for your BI Launchpad which determines which tool interface is launched via Launchpad.
Using Web or Internet Application to access WebI interface via BI Launchpad, you can perform the below tasks –
Create, edit and refresh all the reports in Web Intelligence.
Create and edit all the queries in no data source (Universes) but not BEx queries in Web application.
73. Explain the architecture of Web Intelligence tool?
Ans:
It is three layered architecture –
Database layer – This layer defines multiple SAP and non-SAP data sources.
Semantic Layer – This layer defines multidimensional data model.
Presentation Layer – This layer defines where data is presented to end users.
Various data sources can be used to create analytical and ad-hoc reports
74. What are the different application modes that can be used in a Web Intelligence tool?
Ans:
There are three different application modes that can be used to build the queries, create documents and to analyze the reports. When you open an existing reports below modes are available –
Data Application Mode
Reading
Design
75. To add, delete objects in a report, applying conditional formatting, applying formulas in report, creating variables, you should open Webi document in which of the following mode?
Ans:
Design mode with Data
76. What are the different data sources that you can use to create a new Webi document?
Ans:
Universe
Flat files in .csv or .xls format
BEx queries
Analysis View
77. What is the extension of a Webi document?
Ans:
.wid file
78. You have few report created in older versions of Web Intelligence 3.1 and want to upgrade to 4.x, which tool you should use?
Ans:
Using Upgrade Management Tool UMT
79. What is the extension of Universes created in Information Design Tool and UDT?
Ans:
.unx- File created with Information Design Tool
.unv- File created in Universe Design Tool
80. What is a Query panel?
Ans:
You can select from list of available objects as per your access permissions. You may not be able to use few of the objects cos of permission.
In query panel, you have Universe outline in left pane and Result objects, query filters, data preview panels in main pane.
81. Which connection you can use to import all OLAP functionalities from an InfoCube in SAP BW?
Ans:
BICS Business Intelligence Consumer Service. BICS connectivity is the recommended way for BI tools to connect to Business Explorer (BEx) queries on the SAP NetWeaver BW server.
82. What are the different save as formats supported for a Webi report?
Ans:
WID
PDF
Excel
Excel 2007
CSV Achieve
TXT File
83. What are classes and subclasses?
Ans:
Classes are used to group similar objects in a report. A class can contain one or more subclasses.
Subclasses contains further subcategory of objects in upper level of a class.
Classes are used to organize objects in some logical manner. While creating queries on Universe you can find the information on objects that you have to use in query.
84. What is difference between members and named set in hierarchies?
Ans:
Members are defined at different level of hierarchies in a data source.
Example
Consider a Geography hierarchy contain members – “India” at country level and “Haryana” at State level.
You can also include individual members in query from hierarchy if you don’t want to add all the members. Named set can be used to define set of members.
A named set is defined as named expression and results a set of members. You can define named set at Universe level or a relational or OLAP database level.
85. Where do you define hierarchies to use in Webi report?
Ans:
Universe level
86. How do you use InfoCubes in SAP BW to connect to Webi document?
Ans:
You can create Webi documents based on BEx (business Exchange Queries) created by BEx Query Designer which is based on Info Cube in SAP BW system. You can connect to a BEx query in WebI with use of BICS BI consumer service connection. You need not to create Universe for BEx queries and all attributes, hierarchies, dimensions and measures are automatically mapped in WebI document.
87. How do you connect to SQL server to create a Universe to use in a Webi report?
Ans:
Using a Relational connection created in Universe Designer
88. What are the query filters?
Ans:
Query filters are used to limit the rows returned in a WebI document. Query filters allow you to hide the data that you don’t want to show to specific people and also limit the size of .wid document. When you run a query, it only returns the rows that meet the query filter definition.
Below are the key features used in Query filter –
You can retrieve data as per specific business requirement.
You can hide the data that you don’t want specific users to see in a WebI document.
Limit the size of WebI document of network and hence provides performance optimization.
Example – Being an Area Sales Manager for NY, you want to see margin values for your region and Sales universe contains data from all the regions in United State. Also you only want to see data from the stores in NY where sales margin is greater than 100K USD in 2nd Quarter Q2 2015.
89. What is difference between query and report filters?
Ans:
Query filters are applied in Query Panel and they are used to limit the number of rows from data sources and to return the same in document.
Report filters are applied at report level on reports, tables, charts, etc. These filters are not used to limit the data retrieval from the data source and only hide certain values at report level.
90. Why do we use Prompts? Where do we apply Prompts to use in Webi report?
Ans:
Prompt is defined as special filter for users which allows them to enter a value every time data is refreshed in the document.
Using prompts, you have multiple users viewing one document to display different sub set of data in database. Prompts allow you to retrieve the data from database and reduce the time.
Prompts are created in Query Panel
91. What is context and how they are created?
Ans:
Context defines a particular join path between tables or a specific group of joins for a particular query. Any objects created on a table column which belong to specific contexts is naturally compatible with all other objects from same contexts.
Contexts may be created using detect contexts feature or manually. They are generally created based on logical calculation and business requirements, hence the detect context method is not very effective. To manually create a context Go to Insert Context, give the context name and select the joins that should be present in the context. For a universe contexts should be created in a way that all joins(except shortcut joins) fall in at least one context.
92. What is Aggregate awareness function? Why do we use it?
Ans:
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.
93. What is the use of subquery?
Ans:
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.
94. In Query panel, you can’t see ranking option enabled, what could be the reason?
Ans:
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.
95. What do you understand by hierarchical data?
Ans:
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.
96. What is difference between Break and Sections?
Ans:
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.
97. What is query stripping?
Ans:
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.
98. What are the different chart type in Webi tool?
Ans:
Bar
Box
Column
Line
Map
Radar
Pie
Waterfall
99. Explain the difference between Query filter, Report filter and block filter?
Ans:
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.
100. When you synchronize two queries from different data sources, what rules must you respect?
Ans:
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.
101. You use the MINUS operator to combine queries, what would be the result?
Ans:
All records that match the first query condition and not the second condition.
102. What is the use of Conditional formatting in Webi report?
Ans:
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
103. How you can add multiple query filters in Query panel?
Ans:
By using AND/OR operators
104. What are the different Report filters operators?
Ans:
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
105. You want to use queries from different data sources in a Webi document. How you can use this?
Ans:
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.
106. You want to add a new column in the report based on an existing fact value. How you can add this functionality?
Ans:
Using New Variable
107. What is an input context?
Ans:
The input context is the list of dimensions that are included in the calculation itself.
108. What is use of string concatenation?
Ans:
Lastname+ “, “ + Firstname
109. What is the use of Nofilter() function?
Ans:
To override a report filter or a ranking
110. How do you create a hyperlink in the Web Intelligence Interactive panel?
Ans:
By using Create Hyperlink dialog box
111. 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?
Ans:
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.
112. How do you connect SAP HANA database to Webi document?
Ans:
To use HANA tables for report creation, Use Universe Designer to create Universe using a Relational connection to HANA database.
113. Can you attach a Webi document in mail?
Ans:
Yes, by using send by email attachment option
About the author
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.