SAP NetWeaver 7.0 gives the accompanying instruments:
BEx Query Designer BEx Web Application DesignerBEx Broadcaster
The BEx apparatus can be utilized to show over a significant time span information contrasting in the level of their subtleties and according to alternate point of view. It very well may be utilized to make arranging projections utilizing BI Integrated Planning. The BEx Information Broadcasting can be utilized to appropriate business knowledge content by email, either as pre-determined archives with authentic information, or as connections with live information.
As the name recommends, it is utilized to characterize questions to recover information from SAP BW. Inquiry Designer goes about as the extension between SAP BW Info Providers and the revealing front-end instruments (SAP BW/SAP BO). It restricts the field list showed, which depends on their necessities. It likewise characterizes the default position of these report objects inside a report Query Designer and adds esteem by permitting clients to characterize channels, choice screen factors (a.k.a. Prompts), Calculations, Unit Conversions, and so on that are not accessible in Info Providers.
Getting to Query Designer:
To get to BEx Query planner, follow the underneath steps: Explore to Start - > All Programs. Under the envelope "Business Explorer", the "Question Designer" is accessible. Click on "Question Designer".
Info Provider Details are accessible here. Tabs to see different report parts. Properties Box which shows the properties of every part chosen in the question. Messages, for example, any mistake or advance notice messages during the Query check is shown here. Shows the Where-Used List of any part chosen inside the inquiry.
Inquiry Panel - Standard Toolbar:
The Standard device bar in the Query Designer has the accompanying buttons.
Make New Query
Distribute on Web
Actually look at Query
Switch tabs for Filter and Rows/Columns
Key Figures : Key Figures address the mathematical information or the KPIs(Key Performance Indicator). They are additionally separated into Calculated Key Figures (CKF) and Restricted Key Figures (RKF).Qualities : A trademark gives the measures as per which items are grouped. for example Material,Period, Location, and so on.Navigational traits show up as attributes in Query architect.
OTHER Query Elements:
Aspects : Similar qualities are gathered in an aspect. for example Time aspect consistsof Year, Month, Week, and so on. Credits : Attributes characterize the extra properties of a trademark. For example Material might have size, length or width. It is beyond the realm of possibilities to expect to add a presentation quality to an inquiry except if the connected qualities are likewise added to the question. Be that as it may, it is feasible to set the property of trademark as "No Display".
Select the Tab "Variable Sequence". The tab "Variable Sequence" is utilized to control the request in which determination screen factors are shown to clients. List the factors utilized in the Query. There can be various factors present here. These factors can be sequenced according to our need. Select the "Show" tab. The Check box "Conceal Repeated Key Values" controls regardless of whether the trademark will rehash in each column. The choice "Show Scaling Factors for Key Figures" controls whether the scaling factor is accounted for at the highest point of comparing segment. Select the "High level" tab. The tab "Progressed" is generally significant according to BO viewpoint . It controls regardless of whether the inquiry is noticeable to BO. The choice should be checked to permit inquiry admittance to BO. The Check box "Permit External Access to this Query" ought to be checked in the event that this Query is to be utilized from BO
Select the "Lines/Columns" tab.
The choices under "Result position" segment choose the Location of sub-all out (a.k.a. brings about BW world) as beneath/above or right/left of the Characteristics. he choices under "Stifle Zeros" segment choose the utilization of Zero-Suppression on the question.
Channels are utilized to confine the information recovered by a question. Channels can be dynamic or static in nature. Values entered as static channels can't be overwritten by clients at runtime while dynamic channels or factors can be overwritten by client/framework during inquiry execution. Moves toward apply channels in the Query Select the "Channel" tab. Channels can be applied in the "Trademark Restrictions" area. Channels can be applied in the "Default values" area. Trademark Restrictions are applied before information get activity, while the default values will bring about whole information being brought by question. The limitation is applied exclusively in report front end. If "Clear all channels" choice is applied in WAD/Analyzer, the channels in Default Values will be deleted from front end, yet the channels applied by means of Characteristic Restriction will in any case stay in force. It is prescribed to have something like a couple of trademark limitations while utilizing a BW question for BO Universe.
Factors are question boundaries that we characterize in the Query Designer and are loaded up with values just when you execute the inquiry. Factors are reusable items. The factors characterized in the Query Designer are accessible in all Info Providers. They don't rely upon the Info Provider, but instead on the Info Object for which they were made. Kinds of Variables Trademark values Orders Order Nodes Texts
Moves toward make a variable: To make a variable, peruse to the organizer called "Trademark Value Variables" under the comparing trademark. Right snap on the organizer and select the choice "New Variable". In the resulting window, enter the Description. Enter the Technical name. Variable Processing Types Under reference trademark, the variable can be relegated to either the particular Info Object or all Info-Objects in light of same reference trademark. Under the "Subtleties" tab, we can indicate whether the variable acknowledge: Single Value/Multiple Values/Range Determination Option (permits any of the above at runtime, isn't upheld in BW-BO)Click the "Default values" tab. We can determine the default channel applied to the report. This worth can be over-composed by client at run-time. Conditions and Exceptions: Conditions go about as channels on key figures. for example Top 10 clients, items with base 10% edge, and so forth. Exemptions are like "contingent featuring" in MS succeed. They are utilized to feature lines/segments/cells where the KPI esteem is above or under a specific limit. As these are not imported to a BO Universe, we won't examine them in subtleties in current instructional exercise.