...

Artificial Intelligence - Web Intelligence

Back to Course

Lesson Description


Lession - #1055 SAP Webi-Using Queries


Queries in Webi are overseen in the Query panel. At the point when you make a Webi report, you use query in the query panel to get information from the information source.

Queries can be made from various interfaces like you can make queries in light of Universe, address information in OLAP data set as items, flat files like Excel and CSV documents, information in SAP InfoCubes utilizing BEx queries, Analysis view or Query as a web administration.

Each query has aspects and measures. Gauges generally return numeric information in view of the computation and different items in the information source. Queries can be various leveled or non-progressive in nature. Non-progressive queries have no connection between the objectrs.

Hierarchies define connection between the items. For instance: In a Geographical hierarchy, you have measures in light of geographical hierarchies like districts, states and urban communities. Utilizing hierarchies, you can bore all over to see information at a higher level.

Query panel isn't accessible, assuming you use Web Interface of Webi tool.

Query Definition

In a Webi record, you recover information in report from the information source utilizing the query panel. Every one of the queries are implicit the query panel and connection point of query panel relies upon the information source you are utilizing to get information.

Queries can be made on Universe, which contains Relational and OLAP information models, information from level records like CVS, XLS documents, SAP BW BEx query, and Analysis view. Query is raced to get information from the information source. You can apply filters and furthermore see information in the query panel.

To open a Query Panel − Go to Web Intelligence → New → Select Data Source → Ok.

At the point when you click 'Ok', you need to choose information source from the list of chosen information source type.

New window will open known as Query Panel. Select the objects from Universe outline, which you need to add to the report in result objects.

Query and Documents User Rights

You can see various items in the Query panel and create, edit, and delete objects in queries according to login client access privileges. Clients are regularly made by BusinessObjects Administrator. CMC is utilized to make client profiles to login to BO devices.

In the event that you need more access privileges, you can not get to not many objects of a report. Access freedoms are characterized by the BO head.

Classes and Subclasses

Classes are utilized to group items in a report. A class can contain at least one subclasses. Subclasses contains further subcategory of items in the upper level of a class.

Classes are utilized to sort out objects in a legitimate way. While making queries on Universe, you can find the data on objects that you need to use in query.

Dimension

Dimension lists all the objects utilizing which we need to examine the information. Dimension gives the premise to analysis in a report. Dimension ordinarily contains non-hierarchical character type information like client name, item name, client address, sales office address, and so on.

Analysis Dimension − An Analysis dimension contains group of hierarchies systems connected with one another. At the point when you add an analysis dimension in a report, its default hierarchy shows up in query.

Attributes and Measures

Attribute gives information about dimensions or hierarchy. For instance − Home location of a client dimension. Attribute has one-to-one relationship with comparing dimension. Every client has just a single location object.

Hierarchies

An hierarchy represents parent-child relationship in Universe. It permits you to drill up or down in the report to a higher level. For instance − Geography hierarchy contains Country, State and City. Time order contains Year, Quarter, Month and Week.

Involving the part selector in defining hierarchy, you can characterize which part shows up in the result set. In hierarchical information sources, orders are related with an aspect.

Members and Named Set in Hierarchy

Members are characterized at various degree of orders in an information source. For instance − Consider a Geography progressive system containing individuals - "India" at the nation level and "Haryana" at the State level.

You can likewise remember individual individuals for inquiry from hierarchy, to add every one of the individuals. Named set can be utilized to characterize a set of individuals.

web intelligence report template