Brainscape's Knowledge GenomeTM

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


See full index

SAP BW cert > BW405 SAP BW/4HANA Query Design and Analysis > Flashcards

BW405 SAP BW/4HANA Query Design and Analysis Flashcards

1
Q

~The virtualization layer is one of the three ~

  • True
  • False
A
  • True
    (+) False

~ The three layers of SAP BW/HANA are the virtualization layer, data layer and data acquisition layer
Unit. Lesson: . ~

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

~ The Column Store is one of the four main concepts of the SAP HANA database ~

  • True
  • False
A

(+) True
- False

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

~The CompositeProvider stores no data. ~

  • True
  • False
A

(+) True
- False

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

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

  • True
  • False
A

(+) True
- False

~ SAP BusinessObjects Business Intelligence solution contains different client tools, such as Analysis, Design Studio and Web Intelligence. All of these tools utilize the SAP BusinessObjects Bl platform server as a central repository and administration technology. Read more in the lesson, Outlining SAP Business Objects Bl platform, in course BW405 BW/4HANA Query Design and Analysis, Unit: Report Launching and Navigation in Reports, Lesson: Outlining SAP BusinessObjects Bl platform. ~

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

~Which Tabs did you find in the design panel of SAP BusinessObjects Analysis for Microsoft Excel?~

  • Components
  • Informatiom
  • Data Sourse
  • Workbook
  • Analysis
A

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

~ The tabs that you can find in the design panel of SAP BusinessObjects Analysis for Microsoft Excel are Components, Information and Analysis Tabs. Data Source is a section found on the Analysis Tab. There is no Tab for workbooks. Read more in the lesson, Navigation in BusinessObjects Analysis for Microsoft Office, in course BW 405 BW/4HANA Query Design and Analysis, Unit: Report Launching and Navigation in Reports, Lesson: Navigation in SAP BusinessObjects Analysis for Microsoft Office. ~

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

~ How can you navigate in SAP BusinessObjects Analysis for Microsoft Excel? ~

  • Use drag and drop within the crosstab.
  • Use drag and drop between the design panel and the crosstab
  • Use drag and drop within the design panel
  • Use double-click
  • Use the context-menu
  • Use the standard Microsoft 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 crosstab
(+) Use drag and drop within the design panel
- Use double-click
(+) Use the context-menu
- Use the standard Microsoft Excel menu functions and icons
(+) Use the Analysis menu functions and icons

~ You can navigate with all of the listed options except the double-click, and the standar Microsoft Excel menu functions and icons. Read more in the lesson, Navigation in BusinessObjects Analysis for Microsoft Office, in course BW 405 BW/4HANA Query Design and Analysis,
Unit: Report Launching and Navigation in Reports, Lesson: Navigating
in SAP BusinessObjects Analysis for Microsoft Office.~

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

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

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

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

~ The main 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 Microsoft Excel
navigation features are also available in addition to the navigation state of the
data source. Analysis views do not contain any data, whereas a workbook can
contain data.
Read more in the lesson. Navigating in BusinessObjects Analysis for Microsoft
Office, in course BW405 BW/4HANA Query Design and Analysis,
Unit: Report Launching and Navigation in Reports, Lesson: Navigating
in SAP BusinessObjects Analysis for Microsoft Office. ~

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

~ In the SAP Businessobjects Lumira Generic Analysis application, for which of the following components is a context menu for
navigation available? ~

  • Crosstab
  • Navigation panel
  • Filter line
  • Chart
A

(+) Crosstab
(+) Navigation panel
- Filter line
(+) Chart

~ In SAP Businessobjects Lumira Generic Analysis application, the context menu options are Crosstab, Navigation Panel, and Chart. Filter line is a function activated by choosing the Add Filters icon. Read more in the lesson. Navigating in SAP Businessobjects Lumira Generic Analysis Application, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Report Launching and Navigation in Reports. Lesson: Navigating in SAPLumira Generic Analysis Document.~

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

~ 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Simple Queries. Lesson: Creating Simple Queries.~

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

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

  • True
  • False
A

(+) True
- False

~ A global filter is designed to be reused across all queries that use the same InfoProvider.
Read more in the lesson. Creating Simple Queries, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Simple Queries. Lesson: Creating Simple Queries. ~

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

~ 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 into 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 BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Simple Queries. Lesson: Creating Simple Queries. ~

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

~ 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 values; 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 cannot be overwritten. Read more in the lesson, Creating Simple Queries, in course BW305H.
Read more in course BW405 BW/4HANA Query Design and Analysis, Unit: Simple Queries, Lesson: Creating Simple Queries.~

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

~Which of the following statements are true?~

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

(+) For time-dependent master data such as attributes, texts, or hierarchies, the key date determines the date for which time validity the data is selected.
- The key date acts as a static temporal filter for the whole query.
- The key date is a mandatory field in the query definition.
- The key date determines the temporal validity of the query definition.
(+) For the key date you can also use a variable instead of a 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 filter: it is used to select 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 to define any query validity periods. Read more in the lesson. Creating Simple Queries, in course BW305H.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Simple Queries. Lesson: Creating Simple Queries.~

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

~ 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Restricted Key Figures. ~

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

~ When you apply a navigation filter, the restricted key figure value 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.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Restricted Key Figures. ~

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

~ 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 Amount January and February 2016.
  • Two columns, one for Sales Order Amount January 2016 and one for Sales Order Amount February 2016.
A

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

~ Restricting a key figure 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.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Key Figures in Queries. Lesson: Creating Restricted Key Figures. ~

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

~ 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

~ InfoProvider level calculated key figures can contain formula variables: they must be dragged to where they are needed on the query: they can include other InfoProvider level key figures; and changes to them will be reflected in all queries that use them. Key figure objects created at query level cannot be included in InfoProvider level objects. Read more in the lesson. Creating Calculated Key Figures, in course BW305H.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Calculated Key Figures.~

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

~ 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 InfoProvider Result
A

(+) Percentage Share of Result
(+) Percentage Share of Overall Result
(+) Percentage Share of Report Result
- Percentage Share of InfoProvider 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 lesson. Creating Calculated Key Figures, in course BW305H.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Calculated Key Figures. ~

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

~ Which one of these values does a Boolean operator deliver in a BW query formula when it is true? ~

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

The Boolean operator for a true statement is the number 1. Read more in the lesson. Creating Calculated Key Figures, in course BW405H.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Key Figures with Boolean operators. ~

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

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

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

~ Aggregations using average, counter or last value are defined as Exception Aggregation. Standard aggregations use Summation, Maximum and Minimum which are independent of any specific exception characteristic. Read more in the lesson. Creating Calculated Key Figures with Exception Aggregation, in course BW305H.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Key Figures in Queries. Lesson: Creating Calculated Key Figures with Exception Aggregation. ~

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

~ 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.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Structures in Queries. Lesson: Creating Structures. ~

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

~ 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 in the lesson, Creating Structures, in course BW305H.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Structures in Queries. Lesson: Creating Structures. ~

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

~ 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 BW405.
Read more in course В W405BW/4HANA Query Design and Analysis. Unit: Structures in Queries. Lesson: Resolving Formula Collision and Working with Cells. ~

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

~ 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 created 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 created 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 automatically defined cell values. Help cells with comments cannot be created. Cell formulas and selection criteria can only be used in a defined cell - not any cell in the Analysis report. Read more in the lesson. Resolving Formula Collisions and Working with Cells, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Structures in Queries, Lesson: Resolving Formula Collision and Working with Cells. ~

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

~ 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 Always 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 Always 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 Show Results Row only ensures that a total is shown but it will not show 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 Filter 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 the lesson. Configuring the Properties of Characteristics, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Characteristics. Attributes, and Hierarchies. Lesson: Configuring the Properties of Characteristics. ~

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

~ 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 BW 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 BW data flow transformation.
    (+) 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 tools. Dragging an attribute into the free section can only be done for existing navigation attributes. Navigation attributes cannot be activated using the data flow transformation tools. This is done using the BW Modeling tools. Read more in the lesson. Creating a Query and Running Display and Navigation Attributes, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Characteristics. Attributes, and Hierarchies. Lesson: Creating a Query and Running Display and Navigation Attributes. ~

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

~ 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 either 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 either for the rows or for the columns.

~ Both characteristics and navigation attributes can be used in hierarchical displays, structures can be used and characteristics with external hierarchies can be included in a hierarchy display. Characteristics and display attributes cannot 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Characteristics. Attributes, and Hierarchies. Lesson: Adding Hierarchies to Reports. ~

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

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

  • In a structure, drag the structure member that you want to display as subitems directly over the structure members that you want to display as the parent node for the subitems.
  • 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, drag the structure members that you want to display as subitems directly over the structure memb that you want to display as the parent node for the subitems.
- 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.

~ You can drag and drop structure members that you want to see in the display as subitems. You can also set 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Characteristics. Attributes, and Hierarchies. Lesson: Adding Hierarchies to Reports. ~

29
Q

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

  • An external hierarchy belongs to exactly one characteristic.
  • 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 characteristic.
- 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 called ‘external’) and they can be loaded from external systems. Characteristics can contain many different hierarchies. External hierarchies can be created completely within BW if desired. Read more in the lesson. Adding Hierarchies to Reports, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Characteristics. Attributes, and Hierarchies. Lesson: Adding Hierarchies to Reports. ~

30
Q

~ 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 by setting the hierarchy property. Read more in the lesson. Adding Hierarchies to Reports, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis.Unit: Characteristics. Attributes, and Hierarchies. Lesson: Adding Hierarchies to Reports. ~

31
Q

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

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

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

~ AII of the options listed allow you to restrict а characteristic with ап external hierarchy in а query. Read more in the lesson, Adding Hierarchies to Reports, in course BW405.
Read more in course BW405 BW/4HANA Query Dt!sign and Analysis. Unit: Characteristics, Attributes, and Hierarchies, Lesson: Adding Hierarchies to Reports. ~

32
Q

~ Variables may bе 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 сап bе а placeholder for characteristic values, hierarchy nodes and formula elements. Variables cannot bе used as а placeholder for structures. Read more in the lesson, Explaining Variables, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Explaining Variables. ~

33
Q

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

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

A

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

(1) - (4)
(2) - (2)
(3) - (3)
(4) - (1)

~ Read more in the lesson. Explaining Variables, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Explaining Variables. ~

34
Q

~ 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 BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Explaining Variables. ~

35
Q

~ 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 variables.
  • 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 variables.
    (+) 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 lower 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 the Unit, Variables in Queries, in the course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Explaining Variables. ~

36
Q

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

  • SAP Exit is a variable processing type that is only available in SAP Bl Content variables.
  • The only processing type for SAP Bl content variables is SAP Exit.
  • Characteristic 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 Bl Content variables.
- The only processing type for SAP Bl content variables is SAP Exit.
(+) Characteristic 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 Bl Content variables with replacement path are designed as SAP Exit variables. Because characteristic value variables are based on the characteristic, 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 Bl 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 the Unit, Variables in Queries, in the course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Variables in Queries. Lesson: Explaining Variables. ~

37
Q

~ A characteristic value variable for the characteristic OCALQUARTER 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 BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Applying Business Content Variables.~

38
Q

~ 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 operand 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 BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Variables in Queries. Lesson: Creating Formula Variables.~

39
Q

~ 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 characteristic 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 characteristic 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 value 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 characteristic 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 without a hierarchy based upon the query selection criteria. Read more in the lesson. Creating Hierarchy Variables and Hierarchy Node Variables, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Variables in Queries. Lesson: Creating Hierarchy Variables and Hierarchy Node Variables.~

40
Q

~ In SAP Businessobjects Analysis 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Exceptions and Conditions in Queries. Lesson: Creating a Query and Including Exceptions.~

41
Q

~ 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 individual one. Read more in the lesson. Creating a Query and Including Exceptions, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Exceptions and Conditions in Queries. Lesson: Creating a Query and Including Exceptions. ~

42
Q

~ 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)

~ Read more in the lesson. Creating a Query and Including Exceptions, in course BW405.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Exceptions and Conditions in Queries. Lesson: Creating a Query and Including Exceptions. ~

43
Q

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

  • True
  • False
A

(+) True
- False

~ А condition defines а threshold of key figure values that should bе displayed in the query result. This is an example of а filter оn key figures. Read more in the lesson. Creating а Query and lncluding Conditions, in course BW405.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: exceptions and Conditions in Queries. Lesson: Creating a Quегу and lncluding Conditions. ~

44
Q

~ You have created а condition that should show the customers for Тор 10 Sales Revenue. You сап activate the condition in Analysis but do not see а 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 characterists 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.~

45
Q

~ How can you implement within the query definition an ascending sorting bу key figure values? ~

  • Use а Bottom …. condition.
  • Use а Тор …. condition.
  • Use the sorting property for the key figure.
A

(+) Use а Bottom …. condition.

  • Use а Тор …. condition.
  • Use the sorting property for the key figure.

~ То show ascending key figure values, you can assign а condition to show the ‘Bottom …’ key figures. Using а ‘Тор …’ condition will show а descending list. The sorting property on the key figure will not provide options to limit the sort to specific numbers of records or summations of records. Resetting the query will not activate the condition unless the characteristic is in the drilldown. Read more in the lesson, Creating а Query and lncluding Conditions, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Exceptions and Conditions in Queries. Lesson: Creating а Query and lncluding Conditions. ~

46
Q

~ 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 filter 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 BW405.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Exceptions and Conditions in Queries. Lesson: Creating a Query and Including Conditions. ~

47
Q

~ 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.
Read more in course BW405BW/4HANA Query Design and Analysis, Unit: Report-Report Interface. Lesson: Applying the Report-Report Interface. ~

48
Q

~ 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 InfoProvider 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 InfoProvider 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 InfoProvider properties of the sender and receiver. Read more in the lesson. Applying the Report - Report Interface, in course BW3O5H.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Report-Report Interface. Lesson: Applying the Report-Report Interface. ~

49
Q

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

  • Target System
  • Report Туре
  • Receiver Variable
  • Goto
A

(+) Тarget System
(+) Report Туре
- Receiver Variable
- Goto

~ То create а 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 the creation of а jump target. Read more in the lesson, Applying the Report - Report lnterface, in course ВWЗО5Н.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: Report-Report lnterface, Lesson: Applying тв Report-Report lnterface.

50
Q

~ 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 а BW query, а transaction in an SAP source system and web addresses. An Analysis workbook is not а valid jump target. Read more in the lesson. Applying the Report - Report lnterface, in course ВWЗО5Н.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: Report-Report lnterface, Lesson: Applying the Report-Report Interface. ~

51
Q

~ 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 material 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 will need to and 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 BW405.
Read more in course. Unit:. Lesson:. ~

52
Q

~ What are some functions of the query monitor? ~

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

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

~ The query monitor provides functions to test and check queries, regenerate queries, monitor performance, alter 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 BW405.
Read more in course. Unit:. Lesson:. ~

53
Q

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

  • Query to read all data at once.
  • Query to read data оп 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 оп 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 ‘геаd data during navigation’. Reading оn refresh or only reading aggregated data are not read mode options. Read more in the lesson, Configuring Query Read Mode, in course BW405.
Read more in course, Unit: . Lesson: . ~

54
Q

~ Where can you the set the property Operations in SAP HANA in order to define the runtime push-down of Queries in SAP
BW/4HANA? ~

  • CompositeProviders
  • InfoObject Characteristics
  • BW Queries
  • DataStore-Objects (advanced)
A

(+) CompositeProviders
(+) InfoObject Characteristics
(+) BW Queries
- DataStore-Objects (advanced)

~ You find it the Runtime Profile Properties when managing them in SAP BW/4HANA Modeling Tools.
Read more in course BW405BW/4HANA Query Design and Analysis. Unit: Query Performance Optimization. Lesson: Describing the SAP BW/4HANA Analytic Manager. ~

55
Q

~ 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 саn bе deleted, it must bе removed from all queries that use it. Read more in the lesson. Managing Query Objects, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis, Unit: Query Management, Lesson: Managing Quегу Objects. ~

56
Q

~ How can you delete queries and query components? ~

  • Use the transaction RSZDELETE.
  • Use the Query Monitor (transaction RSRТl).
  • Use the BW Query Designer.
  • Use the Data Warehousing Workbench (transaction RSAl).
A

(+) Use the transaction RSZDELETE.
- Use the Query Monitor (transaction RSRТl).
(+) Use the BW Query Designer.
- Use the Data Warehousing Workbench (transaction RSAl).

  • Queries can bе deleted using the BW transaction RSZDELETE or they can bе deleted using Query Designer. Queries cannot bе deleted using Query Monitor or the Data Warehousing Workbench. Read more in the lesson, Managing Query Objects, in course BW405.
    Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Query Management, Lesson: Managing Quегу Objects. ~
57
Q

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

  • True
  • False
A
  • True
    (+) False

~ When а query is selected for translation, the query objects are automatically selected for translation. Read more in the lesson. Managing Query Objects, in course BW405.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: Quегу Management. Lesson: Managing Quегу Objects. ~

58
Q

~ 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 BW3O5H.
Read more in course BW405BW/4HANA Query Design and Analysis,Unit: Report-Report Interface, Lesson: Applying the Report-Report Interface. ~

59
Q

~ 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 BW3O5H.
Read more in course BW405BW/4HANA Query Design and Analysis,Unit: Report-Report Interface, Lesson: Applying the Report-Report Interface. ~

60
Q

~ 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.~

61
Q

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

  • Authorization-relevant characteristics are characteristics for which the data are protected.
  • Authorizations 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.
- Authorizations 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 InfoProvider are checked and compared to the user authorizations. Transaction RSECADMIN is used to create analysis 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. Describing Authorizations, in course BW405.
Read more in course BW405 BW/4HANA Query Design and Analysis. Unit: Authorizations Overview. Lesson: Describing Authorizations. ~

62
Q

~ Which of these reporting tools can you use to visualize the results of а BW query? ~

  • SAP Crystal Reports for Enterprise
  • Data Warehousing Workbench
  • SAP BusinessObjects 81 Platform
  • SAP BusinessObjects Analysis for Microsoft Office
A

(+) SAP Crystal Reports for Enterprise
- Data Warehousing Workbench
- SAP BusinessObjects 81 Platform
(+) SAP BusinessObjects Analysis for Microsoft Office

~ SAP Crystal Reports for Enterprise and SAP BusinessObjects Analysis for Microsoft Office can bе used to visualize the results of а BW query.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: SAP Analytics Overview, Lesson: Outlining Strategy and Portfolio: SAP Analytics.

63
Q

~ SAP BusinessObjects Analysis 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

~ SAP BusinessObjects Analysis for Microsoft Office is NOT the reporting tool of choice for executives because it allows the use of sophisticated graphical elements to visualize highly aggregated data.
Read more in course BW405 BW/4HANA Quегу Design and Analysis, Unit: SAP Analytics Overview, Lesson: Outlining Strategy and Portfolio: SAP Analytics. ~

64
Q

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

  • True
  • False
A

(+) True
- False

~ SAP BusinessObjects Web lntelligence allows all information consumers in the company to build individual applications for their reporting needs.
Read more in course BW405 BW/4HANA Quегу Design and Analysis. Unit: SAP Analytics Overview. Lesson: Outlining Strategy and Portfolio: SAP Analytics. ~

65
Q

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

  • True
  • False
A

(+) True
- False

~ А practical use case for formatted reporting is an annual report that is centrally created and managed, and distributed to all executives in the company.
Read more in course BW405 BW/4HANA Query Design гпd Analysis. Unit: SAP Analytics Overview. Lesson: Outlining Strategy and Portfolio: SAP Analytics. ~

66
Q
  • SAP Lumira Discovery 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 Discovery is used to prepare data from multiple sources, visualize it. and then compose stories from those visualizations that can Ье shared with other decision makers.
Read more in course BW405 BW/4HANA Query Design aпd Analysis, Unit: SAP Analytics Overview. Lesson: Outlining Strategy aпd Portfolio: SAP Analytics. ~

67
Q

~ SAP Lumira Designer is the tool of choice for graphical visualizations of aggregated data. Dashboards are often built on
queries with а very small result set.~

  • True
  • False
A

(+) True
- False

~ SAP Lumira Designer is the tool of choice for graphical visualizations of aggregated data. Dashboards are often built on queries with а very small result set.
Read more in course BW405 BW/4HANA Query Design aпd Anгalysis, Unit: SAP Analytics Overview. Lesson: Outlining Strategy and Portfolio: SAP Analytics. ~

68
Q

~ Which are the core functional use cases of SAP Analytics Cloud? ~

  • Providing flexible self-service reporting
  • Modeling planning applications
  • Defining predictive scenarios
  • Modeling SAP BW/4HANA objects
  • Uploading local data into a SAP BW Workspace
  • Modeling and sharing visualizations and dashboards
  • Setting up analytic applications with individual custom scripts.
A

(+) Providing flexible self-service reporting
(+) Modeling planning applications
(+) Defining predictive scenarios
- Modeling SAP BW/4HANA objects
- Uploading local data into a SAP BW Workspace
(+) Modeling and sharing visualizations and dashboards
(+) Setting up analytic applications with individual custom scripts.

~ The core functional uses cases of SAP Analytics Cloud are: Providing flexible self-service reporting, modeling planning applications, defining predictive scenarios, modeling and sharing visualizations and dashboards, modeling and sharing visualizations and dashboards, and setting up analytic applications with individual custom scripts.
Read more in course BW4O5 BW/4HANA Query Design and Analysis. Unit: SAP Analytics Overview. Lesson: SAP Analytics Cloud Overview. ~

SAP BW cert (9 decks)

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