advertisement

Mod 4_restricting_data[1]

50 %
50 %
advertisement
Information about Mod 4_restricting_data[1]
Technology

Published on March 10, 2014

Author: wsmiller

Source: slideshare.net

Description

Business objects Restricting Data
advertisement

Restricting Data Module 4 Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 1

Understanding Conditions You can restrict a query to return specific data for an object rather than all values Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 2

Understanding Conditions (cont) A Condition has 3 elements: • Object • Operator • Operand Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 3

Understanding Conditions (cont) • Object: field or column of data • Operator: specification of the relationship between the object and the operand • Operand: object value to be searched for Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 4

Types of Conditions BOA has 4 types of conditions: – Single- and multi-value conditions – Prompted conditions – Multiple conditions – Predefined conditions Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 5

Applying Single-Value Conditions With a single-value condition, you limit data returned from a single result object. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 6

Applying Single-Value Conditions (cont.) Equal to Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 7

Applying Single-Value Conditions (cont.) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 8

Applying Single-Value Conditions (cont.) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 9

Applying Multi-Value Conditions When using several values the procedure is similar to singlevalue except you use a different operator. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 10

Applying Multi-Value Conditions (cont.) Show list of values In List Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 11

Applying Multi-Value Conditions (cont.) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 12

Applying Prompted Conditions With a Prompted query condition, BOA asks you to choose which data to retrieve before running the query. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 13

Applying Prompted Conditions (cont.) Type: “Select Command” here. Then press Enter or click outside this box. OK Joint Activities Type the command: or select from the Values “Joint Activities” Then press Enter or click OK. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 14

Applying Prompted Conditions (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 15

Applying Prompted Conditions (cont) • You can keep track of the data you have retrieved by displaying or printing the contents of your prompt along with the report. • This is especially useful in reports that have no column to display the contents of the prompt. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 16

Using Condition Objects Draw a box with the mouse. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 17

Wildcards in Conditions Use the following wildcards to search for partial values, a single character, or any number of characters: _ = a single character % = any number of characters (including none) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 18

Wildcards in Conditions Matches Pattern Type the pattern: M% Then press Enter or click outside the box. Run the query. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 19

Using Relational Operators in Conditions • Relational operators determine the type of comparison to be made between two values in conditional expressions or between a value and a set of values. • Relational operators are usually expressed as symbols. In BOA they are represented thus: = > Equal to Greater than <> >= Not equal to Greater than or equal to < Less than <= Less than or equal to Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 20

Relational operators are primarily used with numeric data and often with dates. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 21

Using Relational Operators Right-click and choose Delete to remove the existing condition. Type the number: 3000 Then press Enter or click outside the box. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 22

Using Relational Operators (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 23

Logical Operators for Multiple Conditions To apply more than one condition to focus on certain data, use the AND or OR operator. – AND means that both conditions must be met. – OR means that either one of the conditions must be met. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 24

Logical Operators (cont) Apply simple conditions to the Ccpo ID Description and Curr Pay Plan, by right-clicking on these objects. Run the query Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 25

Logical Operators (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 26

Logical Operators (cont) • When specifying 3 or more conditions in a query, the structure of the logical operators assumes a processing priority. • You must organize your conditions in the appropriate priority for the result you need. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 27

Logical Operators (cont) • Display a table showing the number of positions in all the Commands in CPAC Japan where there are “Wage” employees, as well as the number of positions and their commands, where there are ANY Wage Grade Non-Supervisory employees. • Tip: This requires you to use the OR operator. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 28

Logical Operators (cont) Right click the “And” between the top two conditions and select “Shift Right” to group those two conditions together. Double-click the last “And” operator to Run change it to an “Or” operator. the query Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 29

Logical Operators (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 30

Using Condition Objects • Predefined conditions use condition objects. • You can apply one or more predefined conditions when you build a query. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 31

Using Condition Objects Try it . . . (cont) Create a table that will show Command descriptions and a count of positions that are filled for each command, using a predefined condition from the Civilian Position Class. Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 32

Using Condition Objects (cont) Double-click the desired predefined condition to apply it to the query. Run the query Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 33

Using Condition Objects (cont) Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 34

EXERCISE TIME Modified, with permission, from Business Objects SA copyrighted materials - Introduction to Reporting 35

Add a comment

Related presentations

Presentación que realice en el Evento Nacional de Gobierno Abierto, realizado los ...

In this presentation we will describe our experience developing with a highly dyna...

Presentation to the LITA Forum 7th November 2014 Albuquerque, NM

Un recorrido por los cambios que nos generará el wearabletech en el futuro

Um paralelo entre as novidades & mercado em Wearable Computing e Tecnologias Assis...

Microsoft finally joins the smartwatch and fitness tracker game by introducing the...

Related pages

Section 1: Getting Started with WebIntelligence

Section 1: Getting Started with BI Suite [Contents] Login BI Suite is accessed through a channel in MyEd so you must first be registered with EASE to gain ...
Read more

InfoDev - Business Objects Course Syllabus

Home > IT Workshop > Business Objects Course Syllabus. No: ... 4 Restricting Data Returned by a Query. 19 ... • Using the drill-down mode. 52
Read more

BusinessObjects Desktop Intelligence XI R2: Report Design ...

Lesson #4 - Restricting Data Returned by a Query • Applying query conditions ... Lesson #11 - Analyzing in Drill Mode • Analyzing the data cube
Read more

Buy sap certification material at cheaper prices

4. Restricting data returned by a query 5. ... · Using the drill-down mode Taking a snapshot of the data · Sharing reports with BusinessObjects users
Read more

BOBJ4x Video Course - ERPDrill.Com, World Class SAP ...

Home / SAP Video Courses / BOBJ4x Video Course ... 4. Restricting data returned by a ... · Using the drill-down mode Taking a snapshot of the data ...
Read more

BOBJ BO Enterprise 4x Video Course Online Training

BOBJ BO Enterprise 4x Video Course Online Training to pass your SAP Training and Certification exams
Read more

SAP Training and SAP Training Videos for SAP Video ...

BO Enterprise 4.0x Video Course online Training to pass your SAP Training and Certification exams
Read more

SAP BOBJ Online training Hyderabad. SAP BOBJ Online ...

SAP BOBJ Online training institute in Dilsukhnagar. ... 4. Restricting data returned by a query. 5. ... · Using the drill-down mode Taking a snapshot of ...
Read more