Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SAP BW cert > BW305 SAP Business Warehouse Query Design and Analysis > Flashcards

BW305 SAP Business Warehouse Query Design and Analysis Flashcards

1
Q

~Which of the following statement about SAP HANA are true?~

  • Data is retrieved in response to structured queries through disk access.
  • Data is retrieved in response to structured queries through main memory access.
  • HANA enables SAP to deliver in-memory applications that were previously impossible.
  • HANA uses traditional three-tier architecture of data, application, and presentation layers.
A

-Data is retrieved in response to structured queries through disk access.
(+)Data is retrieved in response to structured queries through main memory access.
(+)HANA enables SAP to deliver in-memory applications that were previously impossible.
-HANA uses traditional three-tier architecture of data, application, and presentation layers.

~Using SAP HANA, data is retrieved from main memory using a structured query and HANA is the new SAP technology that is capable of delivering in-memory responsiveness. Using SAP HANA, disk access is not required any longer to respond to a query. The three-tier architecture was used before SAP HANA came in to use. Read more in
the lesson, Describing the Evolution and Data Layout of SAP HANA, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

~Which of the following advantages of column tables?~

  • Elimination of materialized aggreates.
  • Higher data compression rates.
  • Elimination of parallel execution.
  • Elimination of additional indexes.
A

(+)limination of materialized aggreates.
(+)Higher data compression rates.
-Elimination of parallel execution.
(+)Elimination of additional indexes.

~Using column tables, pre-aggregation is not required, data can be better compressed and additional indexes do not need to be maintained. Column tables are not a pro-requisite to perform parallel execution of queries to improve performance. Read more in the lesson, Describing the Evolution and Data Layout of SAP HANA, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

~Determine whether this statement is true or false.~

~The main goal of data warehousing is to store all relevant enterprise data in a consistent, harmonized and valid state in one system and make it available for reporting.~

  • True
  • False
A

(+)True
-False

~The important goal of a data warehouse is to maintain consistent, harmonized and two data that the enterprise will use to perform operational and strategic analytics. Read more in the lesson. Describing the Concepts of Business Intelligence (BI) and Data Warehousing on any Database, in course BVV305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

~Choose the correct enswer(s).~

~From which of the following sources can SAP BW extract data?~

  • CSV file
  • Microsoft Word file
  • Relational database system
  • SAP ERP system
A

(+)CSV file
-Microsoft Word file
(+)Relational database system
(+)SAP ERP system

~SAP BW an extract data from a CSV file. a relational database system or an SAP ERP system. BW cannot extract data from a Microsoft Word file. Road more in the lesson. Describing the Concepts of Business Intelligence (8l) and Data Warehousing on any Database, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

~Select a box on the left and then the matching one on the right.~

~Match each object with its description.~

(1) InfoObject – (1) Stores amounts or quantities.
(2) Characteristic InfoObject – (2) Consists of InfoObjects and is the..
(3) Key figure - (3) Provides information about its…
(4) InfoProvider – (4) Key figures. Characteristics, time…

A

(1) InfoObject – (1) Stores amounts or quantities.
(2) Characteristic InfoObject – (2) Consists of InfoObjects and is the..
(3) Key figure - (3) Provides information about its…
(4) InfoProvider – (4) Key figures. Characteristics, time…

1-4
2-3
3-1
4-2

~InfoObject = Key figures, characteristics, time characteristics, units, and technical characteristics; Characteristic InfoObject = Provides information about its associated key figures; Key figure = Stores amounts or quantities; InfoProvider = Consists of InfoObjects and is the basis for BW queries. Road more in the lesson. Describing the Concepts of Business Intelligence (BI) and Data Warehousing on any Database, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

~Select a box on the left and then the matching one on the right.~

~Match the following InfoProviders with their properties:~

(1) InfoCube - (1) Provides view of data of several…
(2) Characteristic InfoObject - (2) Stores transaction data on detailed…
(3) DataStore - (3) Stores transaction data on…
(4) Object MultiProvider - (4) Stores master data

A

(1) InfoCube - (1) Provides view of data of several…
(2) Characteristic InfoObject - (2) Stores transaction data on detailed…
(3) DataStore - (3) Stores transaction data on…
(4) Object MultiProvider - (4) Stores master data

1-3
2-4
3-2
4-1

~InfoCube = Stores transaction data on aggregated level; Characteristic InfoObject = Stores master data; DataStore Object = Stores transaction data on detailed level; MultiProvider = Provides view of data of several InfoProviders. Read more in the lesson. Describing the Concepts of Business Intelligence (BI) and Data Warehousing on any Database, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

~Determine whether this statement is true or false.~

~In the Modeling function area of the Data Warehousing Workbench, you can create and maintain InfoObjects, InfoProviders, and data flow objects.~

  • True
  • False
A

(+)True
-False

~The Modeling area of the Workbench is where most of the essential BW objects, such as InfoObjects. InfoProviders, and data flow objects are created. Read more in the lesson. Describing the Concepts of Business Intelligence (BI) and Data Warehousing on any Database, In course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

~Choose the correct answer(s).~

~BW on SAP HANA differs from BW running on other databases in the following ways:~

  • Query performance increases
  • Load performanse decreases
  • The number of data persistency layers increases
  • Flexible combination of BW data model with SAP HANA native data model
  • Activation time for DataStore Objects data decreases
A

(+)Query perfomance increases
-Load perfomanse decreases
-The number of data persistency layers increases
(+)Flexible combination of BW data model with SAP HANA native data model
(+)Activation time for DataStore Objects data decreases

~When BW running on SAP HANA query perfomance increases, data modelling flexibility increases and the DSO activation time decreases. Load performance using SAP HANA will not decease because SAP HANA performance is optimized for data retrieval than data loading. Data persistentcy will decrease using BW on SAP HANA because the in-memory design alowws for more data to be read at query execution time instead of being stored in numerous tables until required. Read more in the lesson, Outlining the Basics of SAP BW Powered by SAP HANA, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

~Select a box on the left and then in the matching one on the right.~

~Match the following SAP BW objects on any database with the SAP HANA:~

(1) InfoObject - (1) Advanced DataStore Object
(2) InfoCube – (2) IntoObject
(3) Data Store Object - (3) CompositeProvider
(4) MultiProvider – (4) Advanced DataStore Object

A

(1) InfoObject - (1) Advanced DataStore Object
(2) InfoCube – (2) IntoObject
(3) Data Store Object - (3) CompositeProvider
(4) MultiProvider – (4) Advanced DataStore Object

1-2
2-1
3-4
4-3

~InfoObject = InfoObject; InfoCube = Advanced DataStore Object; Data Store Object = Advanced DataStore Object; MultiProvider = CompositeProvider. Read more in the lesson. Outlining the Basics of SAP BW Powered by SAP HANA, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

~Determine whether this statement is true or false.~

~The SAP BusinessObjects Business Intelligence solution consists of different client tools for specific use cases and the SAP BusinessObjects BI platform server that functionality including repository, user management, security, and reports scheduling.~

  • True
  • False
A

(+)True
-False

~The SAP BusinessObjects Business Intelligence solution contains several client tools, such as Analysis, Design Studio and Web Intelligence. All of these tools utilize the SAP BusinessObjects BI platform server as a central repository and administration technology. Read more in the lesson. Outlining the Basics of SAP BW Powered by SAP HANA, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

~Choose the correct answer(s).~

~Which tabs do you find In the design panel or SAP BusinessDetects Analysis, edition for Microsoft Excel? ~

  • Components
  • Information
  • Data Sourse
  • Workbook
  • Analysis
A

(+)Components
(+)Information
-Data Sourse
-Workbook
(+)Analysis

~The tabs that you can find in the design panel of SAP BusinessObjects Analysis, edition for lMicrosoft Excel are the Components, Information and Analysis tabs. Data Sourse is a section found on the Analysis tab. There is no tab for workbooks. Navigating in BusinessObjects Analysis, Edition for Microsoft Office, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

~Choose the correct answer(s).~

~How can you navigate in SAP BusinrssObjects Analysis, edition for Microsoft Excel?~

  • Use drag and drop within the crosstab
  • Use drag and drop between the design panel and the cosstab
  • Use drag and drop within the delagn panel
  • Use double click
  • Use the context menu
  • Use the slandard Excel menu functions and icons
  • Use the Analysis menu functions and icons
A

(+)Use drag and drop within the crosstab
(+)Use drag and drop between the design panel and the cosstab
(+)Use drag and drop within the delagn panel
-Use double click
(+)Use the context menu
-Use the slandard Excel menu functions and icons
(+)Use the Analysis menu functions and icons

~You can navigate with all of the listed options exept for double click, and the slandard Excel menu functions and icons. Navigating in BusinessObjects Analysis, Edition for Microsoft Office, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

~Choose the correct answer(s).~

~Which of the following statements regarding the main differences between Analysis views and Analysis workbooks are correct?~

  • An Analysis view contains one analysts (data source) while an Analysis workbook can contan several analyses (data sources)
  • An Analysis view contains the navigation state of the data source, but a workbook contains the design elements in Excel as well as the navigation state of the data sources
  • An Analysis view contains data while an Analysis worktbook does not
A

(+)An Analysis view contains one analysts (data source) while an Analysis workbook can contan several analyses (data sources)
(+)An Analysis view contains the navigation state of the data source, but a workbook contains the design elements in Excel as well as the navigation state of the data sources
-An Analysis view contains data while an Analysis worktbook does not

~The male differences between Analysis views and Analysis workbooks are that views contain single data sources only and with the navigation state of the data source. A workbook can contain multiple sources and the Excel navigation features are also available in addition to the navigation state ot the data source. Analysis views do not contain any data whereas a workbook can contain data. Read more tri the lesson. Navigating in BusinessObjects Analysis, Edition for Microsoft Office. In course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

~Choose the correct answer(s).~

~In Design Studio Generic Analysis application, for which of the following components is a context menu for navigation available?~

  • Crosstab
  • Actions button
  • Navigation panel
  • Filter line
  • Chart
  • Information button
A

(+)Crosstab
-Actions button
(+)Navigation panel
-Filter line
(+)Chart
-Information button

~In Design Studio Generic Anansis, the context menu options are Crosstab, Navigation Panel and Chart. Tne Actions button is not in tne context menu. Finer line is a function activated by choosing the Filter icon. The Intommtion button is an icon that is not contained in the context menu. Read more in the lesson, Navigating in BusinessObjects Design Studio Generic Application in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

~Determine whether this statement is true or false.~

~By selecting and combining the InfoObjects in a query, you determine the way in which data from an InfoProvider is evaluated.~

  • True
  • False
A

(+)True
-False

~The selection of characteristics and key figures in a query will control the way that InfoProvider data will be evaluated. Read more in the lesson. Creating Simple Queries, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

~Determine whether this statement is true or false.~

~When you make changes to an InfoProvider level filter, it affects all queries in winch this filter is re-used.~

  • True
  • False
A

(+)True
-False

~A global filter is designed to be reused across all queues that use the same InfoProvider. Read more in the lesson. Creating Simple Queries in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

~Choose the correct answer(s).~

~In which sections of the query can key figures be inserted?~

  • Filter; Default Value
  • Free
  • Rows
  • Columns
A

-Filter; Default Value
-Free
(+)Rows
(+)Columns

~Key figures can be inserted in to either rows or columns. Default filter values and Free relate to characteristics and not key figures. Read more In the lesson. Creating Simple Queries, In course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

~Choose the correct answer(s).~

~Which of the following statements regarding filters are true?~

  • Filter values in the Filter: Fixed Values section affect the whole query and can be overwritten via navigation in the executed report.
  • A reusable filter can contain fixed values and default values.
  • Filter values in the Filter: Default Values section affect the whole query and can be overwritten via navigation in the executed report.
  • Filter values in the Filter: Fixed Values section affect the whole query and can be narrowed via navigation in the executed report.
A

-Filter values in the Filter: Fixed Values section affect the whole query and can be overwritten via navigation in the executed report.
(+)A reusable filter can contain fixed values and default values.
(+)Filter values in the Filter: Default Values section affect the whole query and can be overwritten via navigation in the executed report.
(+)Filter values in the Filter: Fixed Values section affect the whole query and can be narrowed via navigation in the executed report.

~Filters can reuse fixed and default vales. Default Value filters can be overwritten during navigation and Fixed Value filters can only be narrowed during navigation Fixed Value filters can only be narrowed during navigation; they can not be overwritten. Read more in Inc iesson Creaung Sow Queries. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

~Choose the correct answer(s).~

~Which of the following statements are true?~

  • For time-dependent master data such as attributes, texts, of hierarchies, the key date determines the date for which time validity the data is selected.
  • The key date acts as a static temporal filler for the whole query
  • The key date is a mandatory field in the query definition
  • The key dale determines the temporal validity of the query definition
  • For the key date you can also use a variable instead of specific value
A

(+)For time-dependent master data such as attributes, texts, of hierarchies, the key date determines the date for which time validity the data is selected.
-The key date acts as a static temporal filler for the whole query
-The key date is a mandatory field in the query definition
-The key dale determines the temporal validity of the query definition
(+)For the key date you can also use a variable instead of specific value

~For time dependent master data, the key date is used to determine the valid time-dependent attributes, texts or hierarchies. Key dates can have a specific value or they can be determined using a variable. The Key date is not a temporal filler. it Is used to select the time dependent data. Key dates are optional but, if a date is not specified, then the current date will be used. The key date is a single date and is not used lo define any query validity periods. Read more in the lesson, Creating Simple Queries in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

~Determine whether this statement is true or false.~

~A filter is defined to apply to the whole query but a restricted key figure only filters a single key figure value. ~

  • True
  • False
A

(+)True
-False

~Filters affect the overall query result whereas a restricted key figure filters an individual key figure. Read more in the lesson. Creating Restricted Key Figures. in course BW605H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

~Determine whether this statement is true or false.~

~When you apply a navigation filter to a restricted key figure, the restricted key figure remains the same in the result.~

  • True
  • False
A

-True
(+)False

~A restriction of a navigation filter would affect the restricted key figure values as well. Read more in the
lesson. Creating Restricted Key Figures. In course BW305H. ~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

~Choose the correct answer(s).~

~You use the key figure Sales Order Amount in the Columns section of a BW query and restrict it to the months January and February 2016. How many columns will be displayed in the report?~

  • One column with Sales Order Amour January and February 2016.
  • Two columns, one for Sales Order Amount January 2018 and one for Sales Order Amount February 2018
A

(+)One column with Sales Order Amour January and February 2016.
-Two columns, one for Sales Order Amount January 2018 and one for Sales Order Amount February 2018

~Restricting a key flgure to two months will create a single column in the query result which will be the total of the values for January and February. Read more in the lesson. Creating Restricted Key Figures. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

~Choose the correct answer(s).~

~Which of the following statements regarding infoProvider level calculated key figures are correct?~

  • You can include formula variables
  • You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the query level
  • You must drag the calculated key figure to the section where it should be used in your query
  • You can include basic key figures, restricted key figures and calculated key figures that have been defined at the InfoProvider level
  • When you make changes to an InfoProvider level calculated key figure, it affects all queries in which it is re-used
A

(+)You can include formula variables
-You can include basic key figures, restricted key figures, and calculated key figures that have been defined at the query level
(+)You must drag the calculated key figure to the section where it should be used in your query
(+)You can include basic key figures, restricted key figures and calculated key figures that have been defined at the InfoProvider level
(+)When you make changes to an InfoProvider level calculated key figure, it affects all queries in which it is re-used

~lnfoProvider level cautated key figures can contain formula variables; they must be dragged to where they are needed on the query; they can include otner InfoProvider level key figures; and changes to them will be reflected in all queries that use tnem. Key figure objects created at query level cannot tie included in intoProvider level objects. Read more in the lesson. Creating Catulaled Key Figures. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

~Choose the correct answer(s).~

~Which one of the following are percentage functions that are available as an operator in BW Query Designer? ~

  • Percentage Share of Result
  • Percentage Share of Overall Result
  • Percentage Share of Report Result
  • Percentage Share of InloProvider Result
A

(+)Percentage Share of Result
(+)Percentage Share of Overall Result
(+)Percentage Share of Report Result
-Percentage Share of InloProvider Result

~In Query Designer, the percentage functions available are Percentage Share of Result, Overall Result and Report Result. There is no function for a Percentage Share of the InfoProvider Result. Read more in the lessee, Creating Calculated Key Figures. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

~Choose the correct answer(s).~

~Which one of these values does a boolean operator deliver In a BW query formula when it Is true? ~

  • 0
  • 1
  • True
  • False
A
  • 0
    (+) 1
  • True
  • False

~Tne Boolean operator for a true statement is the number 1. Read more in tne lesson, Creating Calculated Key Figures with Boolean Operators, in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

~Choose the correct answer(s).~

~Which of the following aggregation options must you define as an exception aggregation?0~

  • Summation
  • Average
  • Minimum
  • Maximum
  • Counder
  • Last Value
A
  • Summation
    (+)Average
  • Minimum
  • Maximum
    (+)Counder
    (+)Last Value

~Aggregations using average, counter or last value are defined as Exception Aggregation. Standard aggregations use Summation, Maximum and Minimum which are independent or any specific exception characeristic. Read more in the lesson. Creating Calculated Key Figures with Exception Aggregation. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

~Choose the correct answer(s).~

~Which of the following statements regarding key figure structures are correct? ~

  • To create a key figure structure, right-click on the key figure to open its context menu and choose Create Structure
  • Formulas can only be defined within key figure structures
  • You can only use one key figure structure in a query.
  • Each component of a key figure structure must contain a key figure.
A

-To create a key figure structure, right-click on the key figure to open its context menu and choose Create Structure
-Formulas can only be defined within key figure structures
(+)You can only use one key figure structure in a query.
(+)Each component of a key figure structure must contain a key figure

~Queries can only contain one Key figure structure and every component of a Key figure structure must contain a Key figure. Key figure structures are created by right-clicking in the actual structure - not by selecting a single key figure. Formulas can be created outside of a key figure structure. Read more in the lesson. Creating Structures. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

~Choose the correct answer(s).~

~What do you have to consider when you create a query with multiple structures?~

  • You must use a maximum of two structures
  • You must use one structure in the report columns and one structure the report rows.
  • You can only use one structure without key figures in a query
  • By using both the structures in the rows or in the columns you can avoid formula collision
  • You can only use one structure with key figures in a query
A

(+)You must use a maximum of two structures
-You must use one structure in the report columns and one structure the report rows.
-You can only use one structure without key figures in a query
-By using both the structures in the rows or in the columns you can avoid formula collision
(+)You can only use one structure with key figures in a query

~ When creating queries with multiple structures, there is a limit of two structures in a query and only one of them can be
a key figure structure. Read more m tne lesson. Creating Structures. in course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

~Determine whether this statement is true or false.~

~By default, the formula that was created first will be used when there is a formula collision.~

  • True
  • False
A
  • True
    (+)False

~A formula collision is created when a row and column formula intersect in a cell The collision is regardless of which formula was created first. Read more in the lesson, Resolving Formula Collisions and Working with Cells, In course BW305H.~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

~Choose the correct answer(s).~

~Which of the following can you do in the BW Query Designer Cell Editor?~

  • Use a cell as a reference cell so that it can be referenced in calculations
  • Define help cells that contain comments for formulas in the report
  • Apply cell formulas or selection conditions to any cell in your Analysis report.
  • Define formulas and selection conditions for cells to override the automatically crealed cell values.
A

(+)Use a cell as a reference cell so that it can be referenced in calculations
-Define help cells that contain comments for formulas in the report
-Apply cell formulas or selection conditions to any cell in your Analysis report.
(+)Define formulas and selection conditions for cells to override the automatically crealed cell values.

~In the BW Query Designer Cell Editor, you can create a cell that is used as a reference in other calculations and you can define formulae and selection conditions that take precedence over autornaucally defined cell values. Help cells with comments cannot be created. Cell formulas and selectron criteria can only be used in a defined cell - not any cell in the Analysis report. Read more in tne lesson. Resolving Formula Collissons and Working with Cells in course BW305H.~

31
Q

~Choose the correct answer(s).~

~You need to create a report that shows non-selling materials. With which option in BW Query Designer can you display characteristic values without transaction data in the report?~

  • Change the access type for Result Values to Posted Values
  • Change the access type for Result Values to Master Data
  • Choose Atways for the setting Show Result Rows
  • Set the document link for master data in the query properties
  • Choose Values in Master Data Table for the Filter Value Selection.
A

-Change the access type for Result Values to Posted Values
(+)Change the access type for Result Values to Master Data
-Choose Atways for the setting Show Result Rows
-Set the document link for master data in the query properties
-Choose Values in Master Data Table for the Filter Value Selection.

~To display characteristic values that contain no transaction data, you could change the access type for Result Values to show Master Data. The access type Result Values of Posted Values will not show master data which has no transaction data. The option to set Always for the Snow Results Row only ensures mat a total is shown but ot will not snow characteristics without transaction data. Setting the document link for master data does not provide visibility of master data that is missing transaction data. The option to choose values in master Data Table in Fitter Value Selection allows a user to select filter values from the master data table but this will not ensure that all master data without transaction data will be selected. Read more in thee lesson Configuring the Properties of Characteristics, in course BW305H.~

32
Q

~Choose the correct answer(s).~

~Which two steps do you need to perform to make a display attribute available as a navigation attribute in a query?~

  • Activate the navigation attribute in the characteristic properties in BW Query Designer
  • Drag and drop the display attribute to the Free section or the BW Query Designer
  • Activate the navigation attribute in the SAP SW data flow transformation
  • Change the attribute type from Display to Navigation in the InfoObject maintenance
  • Activate the navigation attribute in the respective InfoProvider
A

-Activate the navigation attribute in the characteristic properties in BW Query Designer
-Drag and drop the display attribute to the Free section or the BW Query Designer
-Activate the navigation attribute in the SAP SW data flow transformation0
(+)Change the attribute type from Display to Navigation in the InfoObject maintenance
(+)Activate the navigation attribute in the respective InfoProvider

~To make a display attribute available as a navigation attribute in a query, you need to change the infoObject attribute type from Display to Navigational and then activate the navigation attribute for the relevant InfoProvider, Navigation attributes cannot be activated in Query Designer. This is done using the BW Modeling toots. Dragging an attribute into the tree section can only be done for existing navigation attributes. Navigation attributes cannot be activated using the data flow transformation toots. This is done using the BW Modeing tools. Read more in the lesson Creating a Query and Running Display and Navigation Attributes in course BW305H.~

33
Q

~Choose the correct answer(s).~

~Which of the following statements regarding row and column hierarchies are correct?~

  • Characteristics and display attributes can be included in the hierarchical display
  • Characteristics and navigation attributes can be included in the hierarchical display
  • Structures can be included in the hierarchical display
  • Characteristics with an assigned external hierarchy can be included in the hierarchical display
  • Hierarchical display can be chosen ether for the rows or for the columns
A

-Characteristics and display attributes can be included in the hierarchical display
(+)Characteristics and navigation attributes can be included in the hierarchical display
(+)Structures can be included in the hierarchical display
(+)Characteristics with an assigned external hierarchy can be included in the hierarchical display
-Hierarchical display can be chosen ether for the rows or for the columns

~Both characteristics and navigation attributes can be used in hierarchial displays, structures can be used and characteristics with external hierarchies can be included in a hierarchy display. Characteristics and display attribules connot be included in a hierarchical display. Hierarchical displays are not restricted to only rows or columns, they can be used in rows and columns simultaneously. Read more in the lesson Adding Hierarchies to Reports, in course BW305H.~

34
Q

~Choose the correct answer(s).~

~Which of the following statements regarding hierarchical structure display are correct?~

  • In a structure, hold down the CTRL key and drag the structure members that you want to display as subitems directly over the structure member that you want to display as the parent node for the subrtems
  • The hierarchical structure display only works for structures with key figures
  • The number of levels for a hierarchical structure display is limited to 2
  • You can use the node status to determine whether the node displays collapsed or expanded in the report
A

(+)In a structure, hold down the CTRL key and drag the structure members that you want to display as subitems directly over the structure member that you want to display as the parent node for the subrtems
-The hierarchical structure display only works for structures with key figures
-The number of levels for a hierarchical structure display is limited to 2
(+)You can use the node status to determine whether the node displays collapsed or expanded in the report

~Using the CTRL key, you can drag and drop structure members that you want to see in the display. You can also see the hierarchy node status to control whether or not the node is displayed as collapsed or expanded in the initial display. Read more in the lesson. Adding Hierarchies to Reports. in course BW305H.~

35
Q

~Choose the correct answer(s).~

~Which one of the following statements regarding external hierarchies are correct?~

  • An external hierarchy belongs to exactly one characteristics
  • A characteristic can only possess one external hierarchy.
  • An external hierarchy cannot be created and maintained in BW.
  • An external hierarchy represents master data which is not part of the InfoProvider on which the query is based
  • External hierarchies can be loaded from source systems
A

(+)An external hierarchy belongs to exactly one characteristics
-A characteristic can only possess one external hierarchy.
-An external hierarchy cannot be created and maintained in BW.
(+)An external hierarchy represents master data which is not part of the InfoProvider on which the query is based
(+)External hierarchies can be loaded from source systems

~External hierarchies can only belong to a single characteristic, they can represent master data that is not part of the query InfoProvider (which is why they are cased ‘externaL’) and they can be loaded from external systems. Characteristics can contain many different hierarchies. External hierarchtes can be created completely within BW if desired. Read more in the lesson. Adding Hierarchies to Reports. in course BW305H.~

36
Q

~Determine whether this statement is true or false.~

~You can sort the members of an external hierarchy in ascending or descending order.~

  • True
  • False
A

(+)True
- False

~External hierarchy members can be sorted in ascending or descending order try setting thee hierarchy
property. Read more in thee lesson Adding Hierarchies to Reports. in course BW305H.~

37
Q

~Choose the correct answer(s).~

~How can you restrict a characteristic with an external hierarchy in a query? ~

  • Use one or multiple hierarchy nodes
  • Use one or multiple characteristic values (leaves of the hierarchy)
  • Use combinations of hierarchy nodes and charactenstit values
A

(+)Use one or multiple hierarchy nodes
(+)Use one or multiple characteristic values (leaves of the hierarchy)
(+)Use combinations of hierarchy nodes and charactenstit values

~All of the options listed allow you to restrict a characteristic with an external hierarchy in a query. Read more in the lesson, Adding Hierarchies to Reports. in course BW305H.~

38
Q

~Choose the correct answer(s).~

~Variables may be used as placeholders for which of the following values?~

  • Characteristic values
  • Structures
  • Hierarchy nodes
  • Formula elements
A

(+)Characteristic values
-Structures
(+)Hierarchy nodes
(+)Formula elements

~Variables can be a placeholder for characteristic values, hierarchy nodes and formula elements. Variables can not be used as a placeholder for structures. Read more in the lesson. Explaining Variables. in course BW305H.~

39
Q

~Select a box on the left and then the matching one on thee right.~

~Match the processing types with the use case examples.~

(1) Manual Entry - (1) Create characteristic restrictions so…
(2) Replacement Path – (2) Use a characteristics attribute value…
(3) SAP Exit– (3) Restrict a key automatically to…
(4) Authorization - (4) Enter a filter value when a query is…

A

(1) Manual Entry - (1) Create characteristic restrictions so…
(2) Replacement Path – (2) Use a characteristics attribute value…
(3) SAP Exit– (3) Restrict a key automatically to…
(4) Authorization - (4) Enter a filter value when a query is…

1-4
2-2
3-3
4-1

~Manual Entry = Enter a filter value when a query is executed. Replacement Path = Use a characteristics attribute in a formula. SAP Exit = Restrict a key fiigure automatically to the first quarter of the current year. Autorizetion = Create characteristic restrictions so that only values to which access is allowed are visible in the report. Read more in the lesson Explaining Variables, in course BW305H.~

40
Q

~Choose the correct answer(s).~

~How can text variables be processed? ~

  • Manual Entry
  • Replacement Path
  • Authorization
  • Customer Exit
A

(+)Manual Entry
(+)Replacement Path
-Authorization
(+)Customer Exit

~Text variables can be set as a default entry, they can be automatically determined using replacement path definitions and they can be processed using a customer-defined exit. Text variables cannot be replaced using authorizations. Read more in the lesson. Explaining Variables, in course BW305H.~

41
Q

~Choose the correct answer(s).~

~What do you have to consider when working with variables?~

  • You cannot use hierarchy variables in combination with hierarchy node variables
  • Text variables must be with mandatory input
  • In Order to display the lower and upper limit of an interval you need two different text variable
  • In order to be able to use the same dynamic selection twice in one query without entering the values twice, you use the same variable twice in the query
A

-You cannot use hierarchy variables in combination with hierarchy node variables
-Text variables must be with mandatory input
(+)In Order to display the lower and upper limit of an interval you need two different text variable
(+)In order to be able to use the same dynamic selection twice in one query without entering the values twice, you use the same variable twice in the query

~Upper and tenet limit intervals require the use of two different text variables for the ‘From’ and “To” dates. To reduce the entry of variable values, you can use the same variable twice in a query. Hierarchy variables and hierarchy node variables can be used together in a query. Text variables should not be set up as mandatory because they replacement path to be determined. Read more in Unit 7, of the course BW305H.~

42
Q

~Choose the correct answer(s).~

~Which of the following statements regarding variables are correct?~

  • SAP Exit is a variable processing type that is only available in SAP BI Content variables
  • The only processing type for SAP BI content variables is SAP Exit
  • Charactenstic value variables can be used in all queries where the characteristic is used
  • A hierarchy variable can get only one single value
  • Variables always must get values so that the query can be executed.
A

(+)SAP Exit is a variable processing type that is only available in SAP BI Content variables
-The only processing type for SAP BI content variables is SAP Exit
(+)Charactenstic value variables can be used in all queries where the characteristic is used
(+)A hierarchy variable can get only one single value
-Variables always must get values so that the query can be executed.

~All SAP BI Content variables witn replacement path are designed as SAP Exit variables. Because charactenstic value variables are based on the cnaracteristic, they can be used in any queries where that characteristic is used. A hierarchy can only use a single value because the results display can only show a single one. Many BI Content variables are manual entry or default value - not every Content variable uses an SAP Exit. It is possible for a query to execute without every variable value being entered. Read more in Unit 7, of the course BW305H.~

43
Q

~Determine whether this statement is true or false.~

~A characteristic value variable for the characteristic 0CALQUARTER that shows the current quarter, will show the same quarter of the last year if you enter an offset of -12.~

  • True
  • False
A
  • True
    (+)False

~To show the same quarter of the last year, the offset value should be -4 (quarters). Read more in the lesson, Applying Business Content Variables, in course BW305H.~

44
Q

~Choose the correct answer(s).~

~How can you use formula variables? ~

  • As operands for local calculations in reports
  • As operands in formulas that are retrieved via replacement path
  • As threshold values in exceptions and conditions
  • As key values for characteristic restrictions
A

-As operands for local calculations in reports
(+)As operands in formulas that are retrieved via replacement path
(+)As threshold values in exceptions and conditions
-As key values for characteristic restrictions

~A formula variable can be used as a formula operabd using replacement path. Formula variables can also be used to specify threshold values in conditions and exceptions. Read more in the lesson, Creating Formula Variables, in course BW305H.~

45
Q

~Choose the correct answer(s).~

~What happens if no value is chosen for the hierarchy variable in the variable prompt?~

  • The characteristic is removed from the drilldown
  • An error occurs if the variable is one for mandatory input
  • The charactenstic values are displayed as flat presentation
  • The system automatically chooses the first hierarchy according to the technical name
  • No data at all is displayed.
A

-The characteristic is removed from the drilldown
(+)An error occurs if the variable is one for mandatory input
(+)The charactenstic values are displayed as flat presentation
-The system automatically chooses the first hierarchy according to the technical name
-No data at all is displayed.

~If no valve is chosen for a hierarchy variable, an error will occur if it is a mandatory one. If the variable is optional and no entry is made, the data will be displayed as a flat list without a hierarchy. If the hierarchy variable is not entered, the characteristic will still be displayed in the result, the charactensitc will not be removed. If the hierarchy variable is not entered, the system will not automatically select one. If the hierarchy variable is not entered, the data will be displayed witnout a hierarchy based upon the query selection criteria. Read more in the lesson, Creating Hierarchy Variables and Hierarchy Node Variables, in course BW305H.~

46
Q

~Determine whether this statement is true or false.~

~In SAP BusinessObjects Analysis, edition for Microsoft Office, exceptions should be used instead of conditional formatting in Microsoft Excel to highlight values because exceptions are defined for a key figure and not individual cells?.~

  • True
  • False
A

(+)True
-False

~Using exceptions rather than conditional formatting means that the exception definition is linked to the key figure and will display as a user changes the navigation state of the query. Read more in the lesson, Creating a Query and Including Exceptions, in course BW3O5H.~

47
Q

~Determine whether this statement is true or false.~

~An exception can only be applied to a single key figure in a query.~

  • True
  • False
A

-True
(+)False

~An exception definition can be defined to apply to all key figures or to an indmdual one. Read more in the lesson, Creating a Query and Including Exceptions, in course BW305H.~

48
Q

~Select a box on the left and then the matching one on thee right.~

~Match each cell restriction operator with its result when the exception is applied.~

(1) Everything Except Totals - (1)The exception applies for every…
(2) Everything - (2)The exception applies only to a…
(3) Fixed Value - (3)The exception affects only the…
(4) Totals Only - (4)The exception affects all values…

A

(1) Everything Except Totals - (1)The exception applies for every…
(2) Everything - (2)The exception applies only to a…
(3) Fixed Value - (3)The exception affects only the…
(4) Totals Only - (4)The exception affects all values…

1-4
2-1
3-2
4-3

~Everything Except Totals = The exception affects all values except for the aggregated values or the charactenstic. Everything = The exception applies for every drill-down state of the characteristic with no restrictions on cell context. Fixed Value = The exception applies only to a specific characteristic value or characteristic value variable. Totals Only = The exception affects only the aggregated values of the characteristic. Read more in the lesson, Creating a Query and Inducing Exceptions. in course BW305H.~

49
Q

~Determine whether this statement is true or false.~

~A condition is technically a filter that is applied to key figure values.~

  • True
  • False
A

(+)True
-False

~A condition defines a threshold of key figure values that should be displayed in the query result. This is an example of a filter on key figures. Read more in the lesson, Creating a Query and Including Conditions, in course BW305H.~

50
Q

~Choose the correct answer(s).~

~You have created a condition that should show the customers for Top 10 Sales Revenue. You can activate the condition in Analysis but do not see a result. What is the reason?~

  • Conditions are not supported in Analysis
  • You must reset the query in Analysis
  • You must add the customer characteristic to the drill-down
A

-Conditions are not supported in Analysis
-You must reset the query in Analysis
(+)You must add the customer characteristic to the drill-down

~The customer characteristic must be added to the drilldown in order to be seen in the result. Conditions are supported in Analysis. Resetting the query will not activate the condition unless the characteristic is in the drilldown. Read more in the lesson, Creating a Query and Including Conditions. in course BW305H.~

51
Q

~Choose the correct answer(s).~

~How can you implement an ascending sorting by key figure values?~

  • Use a Bottom … condition
  • Use a Top … condition
  • Use the sorting property for the key figure
A

(+)Use a Bottom … condition

  • Use a Top … condition
  • Use the sorting property for the key figure

~To show ascending key figure values, you can assign a condition to show the ‘Bottom…’ key figures. Using a ‘Top… ‘ condition will show a descending list. The sorting property on the key figure will not provide options to limitt the sort to specific numbers of records or summations of records. Read more in the lesson, Creating a Query and Including Conditions, in course BW305H.~

52
Q

~Choose the correct answer(s).~

~For which of the following scenarios can conditions be used?~

  • Filter for business partner numbers beginning with ‘1’
  • Filter for business partners located in Germany
  • Filter for business partners for which the number of the open order items is greater than 100
  • Filter for business partners which contribute to the upper 75 % of sales revenue
A

-Filter for business partner numbers beginning with ‘1’
-Filter for business partners located in Germany
(+)Filter for business partners for which the number of the open order items is greater than 100
(+)Filter for business partners which contribute to the upper 75 % of sales revenue

~Conditions would be used to filter business partners with open order items greater than 100. They could also be used to filter for partners that contribute to the top 75% of revenue. Conditions would not be used to fitter business partner numbers, a characteristic filter could do that. Conditions would not be able to only show customers in Germany. Again, a characteristic filter could do that. Read more in the lesson, Creating a Query and Including Conditions, in course BW3O5H.~

53
Q

~Determine whether this statement is true or false.~

~Using the RRI, you can jump from a report to another report or to a different destination, as long as it is within the SAP BW system.~

  • True
  • False
A

-True
(+)False

~Using RRI, a user could jump to another report in BW or they could jump to another system to execute a report. Read more in the lesson, Applying the Report - Report Interface, in course BW305H.~

54
Q

~Choose the correct answer(s).~

~Where do you define the sender/receiver assignment for a jump target?~

  • In the BW Query Designer Properties pane
  • In SAP BW, using transaction RSBBS
  • In the context menu of a report cell in Analysis
  • In the InfoProinder properties both of the sender and the receiver query
A

-In the BW Query Designer Properties pane
(+)In SAP BW, using transaction RSBBS
-In the context menu of a report cell in Analysis
-In the InfoProinder properties both of the sender and the receiver query

~Sender/receiver assignment for a jump target is defined in the BW server using transaction RSBBS. Sender/receiver assignments are not created in Query Designer, Analysis cell context menus or in the InfoRrovider properties of the sender and receiver. Read more in the lesson, Applying the Report - Report Interface in course BW305H.~

55
Q

~Choose the correct answer(s).~

~Which of these settings must you enter when creating a jump target in the RRI?~

  • Target System
  • Report Type
  • Receiver Vanable
  • Goto
A

(+)Target System
(+)Report Type
-Receiver Vanable
-Goto

~To create a jump target setting for RRI, you need to define the target system and the report type. Receiver variables and the GoTo options are not used on tne creation or a jump target. Read more in the lesson, Applying the Report - Report Interface, in course BW305H.~

56
Q

~Choose the correct answer(s).~

~Which of the following are jump targets within the RRI?~

  • BW query
  • Analysis workbook
  • Transaction in SAP source system
  • Web address
A

(+)BW query
-Analysis workbook
(+)Transaction in SAP source system
(+)Web address

~Valid jump targets are a BW query, a transaction in an SAP source system and web addresses. An Anarysis workbook is not a valid jump target. Read more in the lesson, Applying the Report - Report Interface, in course BW305H.~

57
Q

~Determine whether this statement is true or false.~

~The target query needs a variable to be able to receive the filter values from the sender query.~

  • True
  • False
A

-True
(+)False

~To jump to a target query, a variable is not required. Read more in the lesson, Applying the Report - Report Interface, in course BW305H.~

58
Q

~Choose the correct answer(s).~

~Users create reports for customers and their sales volumes. Sometimes, they need to drill down to the material level to analyze what exactly customers have bought. With which query layout can you optimize the query performance?~

  • Customer and material in the rows
  • Customer and material in the free characteristics
  • Customer in the rows and material in the free characteristics
  • Material in the rows and customer in the free characteristics
  • Customer and material in the rows with rows hierarchy expanded initially to customer
A

-Customer and material in the rows
-Customer and material in the free characteristics
(+)Customer in the rows and material in the free characteristics
-Material in the rows and customer in the free characteristics
(+)Customer and material in the rows with rows hierarchy expanded initially to customer

~Query performance could be optimized by setting customer in rows and have matenal as a free characteristic. Alternatively, customer and material could be in the rows using a rows hierarchy but only customer is shown when the query initially executes. Putting customer and material in the rows will slow down the query when it has to run. Having customer and material as free characteristics means that users will only see a single aggregated result when the query is run and they wil need to ad characteristics to understand what the key figure total represents. Defining the report to show material but provide an option to drill down to customer is not meeting the business requirement, users want to see customer and then drill down to material as they desire. Read more in the lesson, Optimizing Query Performance, in course BW305H.~

59
Q

~Choose the correct answer(s).~

~What are some functions of the query monitor?~

  • Test and check for BW queries.
  • Regenerate BW queries.
  • Change BW query definitions
  • Check and monitor performance
  • Change performance-relevant BW query properties
  • View technical information about BW queries
  • Delete BW queries
A

(+)Test and check for BW queries.
(+)Regenerate BW queries.
-Change BW query definitions
(+)Check and monitor performance
(+)Change performance-relevant BW query properties
(+)View technical information about BW queries
-Delete BW queries

~The query monitor provides functions to rest and check queries, regenerate queries, monitor performance, after performance-relevant query settings, and show technical information about a query. The monitor does not change query definitions or delete queries. Read more in the lesson, Applying Performance Monitoring Tools, in course BW305H.~

60
Q

~Choose the correct answer(s).~

~Which of the following are query read modes for SAP BW queries?~

  • Query to read all data at once
  • Query to read data on refresh
  • Query to read only aggregated data
  • Query to read data during navigation.
A

(+)Query to read all data at once
-Query to read data on refresh
-Query to read only aggregated data
(+)Query to read data during navigation.

~Two query modes are ‘to read all the data at once’ or to only ‘read data during navigation’. Reading on refresh or only reading aggregated data are not read mode options. Read more in the lesson, Configuring Query Read Mode, in course BW305H.~

61
Q

~Determine whether this statement is true or false.~

~In the BW query execution mode 6, all OLAP/calculation operations are pushed down to SAP HANA.~

  • True
  • False
A

(+)True
-False

~With BW query execution mode 6, all OLAP/calculation operations, including exception aggregation, are pushed own to SAP HANA. Read more in the lesson, Configuring Query Read Mode, in course BW305H.~

62
Q

~Determine whether this statement is true or false.~

~Before you can delete a variable in the BW Query Designer or in the transaction RSZDELETE, you must find all places where this object is used and remove it from there first.~

  • True
  • False
A

(+)True
-False

~Before any variable can be deleted, it must be removed from all queries that use it. Read more in the lesson, Managing Query Objects, in course BW305H.~

63
Q

~Choose the correct answer(s).~

~How can you delete queries and query components?~

  • Use the transaction RSZDELETE
  • Use the Query Monitor (transaction RSRT1
  • Use the BW Query Designer
  • Use the Data Warehousing Workbench (transaction RSA1).
A

(+)Use the transaction RSZDELETE
-Use the Query Monitor (transaction RSRT1
(+)Use the BW Query Designer
-Use the Data Warehousing Workbench (transaction RSA1).

~Queries can be deleted using the BW transaction RSZDELETE or they can be deleted using Query Designer. Queries cannot be deleted using Query Monitor or the Data Warehousing Workbench. Read more in the lesson, Managing Query Objects, in course BW305H.~

64
Q

~Determine whether this statement is true or false.~

~When you select a query for translation in the Data Warehousing Workbench, you must also manually select the query objects for translation.~

  • True
  • False
A

-True
(+)False

~When a query is selected for translation, the query objects are automatically setected for translation. Read more in the lesson, Managing Query Objects, in course BW305H.~

65
Q

~Determine whether this statement is true or false.~

~An authorization object provides up to 10 fields in which the authorized values have to be inserted.~

  • True
  • False
A

(+)True
-False

~In standard SAP, there is a limit of 10 fields in a single authorization object. Read more in the lesson, Describing Authorizations in course BW305H.~

66
Q

~Determine whether this statement is true or false.~

~Users who execute queries need authorizations in the authorization objects S_RS_COMP and S_RS COMP1.~

  • True
  • False
A

(+)True
-False

~Query execution will always check that users have the authorization objects of S_RS_COMP and S_RS_COMP1. Read more in the lesson, Describing Authorizations, in course BW305H.~

67
Q

~Choose the correct answer(s).~

~Which of the following statements regarding analysis authorizations are correct?~

  • Authorization-relevant characteristics are characteristics for which the data are protected.
  • Authorizationfor for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users who want to display data from authorization-relevant characteristics
  • When a query is executed, all authorization-relevant characteristics that are contained in the InfoProvider on which the query is based on are checked.
  • Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics.
A

(+)Authorization-relevant characteristics are characteristics for which the data are protected.
-Authorizationfor for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users who want to display data from authorization-relevant characteristics
(+)When a query is executed, all authorization-relevant characteristics that are contained in the InfoProvider on which the query is based on are checked.
(+)Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics.

~An authorization-relevant characteristic is one where the data needs to be protected and users need approval to see the data. During query execution, all authorization-relevant characteristics in the InfoRrovider are checked and compared to the user authorizations. Transaction RSECADMIN is used to create analysts authorizations. With analysis authorizations, S_RS_COMP and S_RS_COMP1 authorizations are not sufficient to execute a query. Users need analysis authorization for individual characteristic values for the query to execute successfully. Read more in the lesson, Descrbing Authorizations, in course BW305H.~

68
Q

~Choose the correct answer(s).~

~Which of the following statements regarding analysis authorizations are correct?~

  • Authorization-relevant characteristics are characteristics for which the data are protected.
  • Authorizationfor for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users who want to display data from authorization-relevant characteristics
  • When a query is executed, all authorization-relevant characteristics that are contained in the InfoProvider on which the query is based on are checked.
  • Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics.
A

(+)Authorization-relevant characteristics are characteristics for which the data are protected.
-Authorizationfor for the authorization objects S_RS_COMP and S_RS_COMP1 are sufficient for users who want to display data from authorization-relevant characteristics
(+)When a query is executed, all authorization-relevant characteristics that are contained in the InfoProvider on which the query is based on are checked.
(+)Using the transaction RSECADMIN, you can create analysis authorizations for a group of authorization relevant characteristics and restrict the values for these characteristics.

~An authorization-relevant characteristic is one where the data needs to be protected and users need approval to see the data. During query execution, all authorization-relevant characteristics in the InfoRrovider are checked and compared to the user authorizations. Transaction RSECADMIN is used to create analysts authorizations. With analysis authorizations, S_RS_COMP and S_RS_COMP1 authorizations are not sufficient to execute a query. Users need analysis authorization for individual characteristic values for the query to execute successfully. Read more in the lesson, Descrbing Authorizations, in course BW305H.~

69
Q

~Determine whether this statement is true or false.~

~SAP BusinessObjects Analysis, edition for Microsoft Office is the reporting tool of choice for executives because it allows the use of sophisticated graphical elements to visualize highly aggregated data.~

  • True
  • False
A

-True
(+)False

~Executives might prefer to use tools other tnan SAP BusinessObjects Analysis, edition for Microsoft Offfice because this tool is designed for use by business analysis. Read more in the lesson, Describing Business Intelligence Products Consuming Queries, in course BW305H.~

70
Q

~Determine whether this statement is true or false.~

~SAP BusinessObjects Web Intelligence allows all information consumers in the company to build individual applications for their reportng needs.~

  • True
  • False
A

(+)True
-False

~SAP BusinessOblects Web Intelligence is designed to provide users with access to simple, interactive reporting tools. Read more in the lesson, Describing Business Intelligence Products Consuming Queries, in course BW305H.~

71
Q

~Determine whether this statement is true or false.~

~A practical use case for formatted reporting is an annual report that is centrally created and managed, and distributed to all executives in the company.~

  • True
  • False
A

(+)True
-False

~SAP Crystal Reports is designed for formatted reporting of corporate reports. Read more in the lesson, Describing Business Intelligence Products Consuming Queries, in course BW305H.~

72
Q

~Determine whether this statement is true or false.~

~SAP BusinessObjects Design Studio is the tool of choice for graphical visualizations of aggregated data. Dashboards are often built on queries with a very small result set.~

  • True
  • False
A

(+)True
-False

~SAP BusnessObjects Design Studio is designed for application designers to create both analysis applications and dashboards. Read more in the lesson, Describing Business Intelligence Products Consuming Queries, in course BW305H.~

73
Q

~Determine whether this statement is true or false.~

~The SAP Lumira desktop experience is used to prepare data from multiple sources, visualize it, and then compose stories from those visualizations that can be shared with other decision makers.~

  • True
  • False
A

(+)True
-False

~SAP Lumira is designed to present data to analyst and executives in a highly visual manner. Read more in the lesson, Describing Business Intelligence Products Consuming Queries, in course BW305H.~

SAP BW cert (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions