sapbi

Question 1 of 78

Medal-premium 1

What can you do with a condition? (Choose 2)

Select one or more of the following:

  • A - Define filter restriction

  • B - Analyse combinations of charactrestics using ranked lists

  • C - Restrict combination of characteristics using a structure

  • D - Define value limits

Question 2 of 78

Medal-premium 1

Where can you set a variable offset to time-based characteristic?

Select one of the following:

  • A - In the values For dialog in the query designer

  • B - In the characteristic definition in SAP Business Warehouse

  • C - In the Calculated Key Figure dialog in the query designer

  • D - In the InfoProvider definition in SAP Business Warehouse

Question 3 of 78

Medal-premium 1

What do you have to consider when you work with exception aggregation?

Select one of the following:

  • A - Exception aggregations are excuted on multiple rows

  • B - Exception aggregations are excuted on multiple columns

  • C - Exception aggregations are excuted instead of standard aggregations

  • D - Exception aggregations are excuted in addition to standard aggregations

Question 4 of 78

Medal-premium 1

What is a prerequisite for creating an external hierarchy?

Select one of the following:

  • A - The hierarchy must be time-dependent

  • B - The hierarchy must cotain at least two nodes

  • C - The With master data indicator of the infoObjects must be set

  • D - The With hierarchies indicator of the infoObjects must be set

Question 5 of 78

Medal-premium 1

You want to build a BEx Query in the BEx Query Designer to display to 10 customers with the highest sales revenue, what must you do? (Choose 2)

Select one or more of the following:

  • A - Use the all charactersitics in drill-down independently option

  • B - Use indivual characteristic and characteristic combinations

  • C - Create a condition using TOP sum ranked list operator

  • D - Create a condition using TOP N ranked list operator

Question 6 of 78

Medal-premium 1

Where can a characterstic be restricted in the BEx Query definition?

Select one of the following:

  • A - In the characterstic's context menu in InfoProvider section

  • B - In the characterstic's context menu in the default value section

  • C - In the query properties, in the tab "Extended"

  • D - In the query properties, in the tab "General"

Question 7 of 78

Medal-premium 1

Which display options are available in the Display As tab of the Query Designer? (Choose 3)

Select one or more of the following:

  • A - Text and Key

  • B - Key and short Text

  • C - Key and Text

  • D - Text

  • E - Short Text and long Text

Question 8 of 78

Medal-premium 1

In a report you want to add 20% to the Volume Key Figure only if it is above 100. How can you achieve this?

Select one of the following:

  • A - (Volume>100) * Volume * 0,2 + Volume

  • B - IF Volume > 100 THEN Volume * 0,2 + Volume ELSE Volume

  • C - (Volume>100) * Volume * 0,2 + (Volume<=100) * Volume

  • D - IF Volume > 100 THEN Volume * 0,2 * ELSE Volume

Question 9 of 78

Medal-premium 1

What can you use to create a restricted key figure? (Choose 2)

Select one or more of the following:

  • A - a calculated key figure

  • B - a structure

  • C - a characteristic selection

  • D - a formula

Question 10 of 78

Medal-premium 1

What can an end user do in SAP BusinessObjects Analysis, Edition for Microsoft Office with a BEx Query as a datasource? (Choose 2)

Select one or more of the following:

  • A - Show the runtime statistics of the Analysis workbook

  • B - Activate an exception that was created in the BEx Query Designer

  • C - Change the display language for text fields

  • D - Sort the displayed elements on a given measure

Question 11 of 78

Medal-premium 1

In the BEx Query Designer, what can you define using the cell editor? (Choose 2)

Select one or more of the following:

  • A - Help cells that serve as containers for help selection or help formulas

  • B - Additional filter restrictions that apply to a complete column or row of the result set

  • C - Reference cells that can pass their results to variables with the replacement path processing option

  • D - Formulas and selection conditions for sales to override the cell value that are created automatically

Question 12 of 78

Medal-premium 1

You have two structures and an intersecting formula; nothing is defined in eliminate formula collision. What will happen when you run the Query?

Select one or more of the following:

  • A - By default, the formula from the structure that was created first will be used.

  • NA

  • NAA

  • ANA

Question 13 of 78

Medal-premium 1

Authorization system objects you need... (Choose 2)

Select one or more of the following:

  • A - S_RS_Auth

  • B - S_RS_COMP

  • C - S_RS_COMP1

  • D - S_RS_Folder

Question 14 of 78

Medal-premium 1

How many key figure structure can you use in a query?

Select one or more of the following:

  • A - 1

  • B - 2

  • C - 3

  • D - 4

Question 15 of 78

Medal-premium 1

What are the functions of the query monitor? choose 2

Select one or more of the following:

  • A-Check or change query properties

  • B-Test or regenerate Queries and query view.

  • C- Refresh

  • D-Update

Question 16 of 78

Medal-premium 1

What are charachterestics of data warehousing with SAP Business Warehouse? (Choose 2)

Select one or more of the following:

  • A - It is optimized for read access

  • B - It is optimized for write access

  • C - It has a multidimensional structure

  • D - It has a relational structure

Question 17 of 78

Medal-premium 1

Which of the following SAP Business Warehouse elements does SAP Crystal Reports for Enterprise support?

Select one or more of the following:

  • A - Zero suppression

  • B - Scaling factor

  • C - Number of decimals

  • D - Hierarchy version variable

Question 18 of 78

Medal-premium 1

What can you use as data source when you create reports in SAP Crystal Reports for Enterprise? (Choose 2)

Select one or more of the following:

  • A - Analysis view

  • B - Universe

  • C - SAP ERP

  • D - SAP HANA view

Question 19 of 78

Medal-premium 1

In Crystal Reports 2013, how can you join date field and string filed for city? (Choose 2)

Select one or more of the following:

  • A - City+Date

  • B - City & Date

  • C - Join (City, Date)

  • D - City + Text (Date)

Question 20 of 78

Medal-premium 1

Which table fields can you find in the field explorer display? (Choose 2)

Select one or more of the following:

  • A - Text

  • B - Parameters

  • C - Formulas

  • D - Filters

Question 21 of 78

Medal-premium 1

In Crystal Reports 2013, design only for CANADA (Bold, Blue, DD-MM-YYYY); Which option?

Select one or more of the following:

  • A - Apply data calculation

  • B - Apply time-based query

  • C - Combine filters

  • D - Use formula to conditional formatting

Question 22 of 78

Medal-premium 1

After you properly configured SAP BusinessObjects BI Mobile and published an SAP BusinessObjects Web Intelligence document in the SAP BusinessObjects BI Platform. How can you make this document available on Mobile devices?

Select one or more of the following:

  • A - Create a copy of the document in one of the predefined folders for mobile content

  • B - Assigned this document to one of the predefined groups of users for mobile content

  • C - Create a shortcut in one of the predefined folders for mobile content

  • D - Save the report in one of the predefined categories for mobile content

Question 23 of 78

Medal-premium 1

Which of the following tools does SAP recommend as an altrenative to the SAP Business Warehouse BEx Web Application Designer?

Select one or more of the following:

  • A - SAP BusinessObjects Analysis, Edition for OLAP

  • B - SAP BusinessObjects Web Intelligence

  • C - SAP BusinessObjects Design Studio

  • D - SAP BusinessObjects Explorer

Question 24 of 78

Medal-premium 1

How / BW Transport BI / Unified / Handling?

Select one or more of the following:

  • A - CTS+

  • B-STS

  • C-SST

  • D-RDR

Question 25 of 78

Medal-premium 1

Which of the following business Warehouse elements are available in SAP BusinessObjects Web Intelligence (Choose 2)

Select one or more of the following:

  • A - Navigational Attribute

  • B - InfoProvider dimension

  • C - Hierarchy version variable

  • D - Restricted key figure

Question 26 of 78

Medal-premium 1

When you open a report in reading mode,which of the following tasks can you perform? (Choose 3)

Select one or more of the following:

  • A - Activate change data tracking

  • B - Set the positions of report elements

  • C - Show or hide report filters and outlines

  • D - Purge and refresh an existing data provider

  • E - Drill down in a report designed for drilling

Question 27 of 78

Medal-premium 1

Which of the following calculation modes are available to create a ranking in a report? (Choose 3)

Select one or more of the following:

  • A - Sum

  • B - Count

  • C - Count Distinct

  • D - Percentage

  • E - Cumulative percentage

Question 28 of 78

Medal-premium 1

What can you do in the query panel,when you create a document in SAP BusinessObjects Web Intelligence using BEx Queries? (Choose 2)

Select one or more of the following:

  • A - Display the query script

  • B - Preview the query results

  • C - Add a subquery

  • D - Add a new query

Question 29 of 78

Medal-premium 1

What can you do with input controls (Choose 2)

Select one or more of the following:

  • A - Share input controls between different reports

  • B - Change values within variables

  • C - Associate input controls with tables and section headers

  • D - Customize values using the scripting language

Question 30 of 78

Medal-premium 1

What happens in a SAP BusinessObjects Web Intelligence document when you apply a break in a dimension? (Choose 2)

Select one or more of the following:

  • A - The values of the dimension are automatically sorted in ascending order

  • B - The values of the dimension appear as a header outside the block

  • C - A blank row is inserted after each value of the dimension

  • D - The cells of the dimension are automatically merged and centered

Question 31 of 78

Medal-premium 1

What are the actions you can perform in the Data Manager Section? (choose 3)

Select one or more of the following:

  • A - Data Providers - Insert, Delete, Update, Change Source, View results

  • B - Local Variables - create, Modify, Delete

  • C - Merged Dimensions - Create, modify, Delete

  • D- Actions query

Question 32 of 78

Medal-premium 1

What is used when retrieving data from BW using relational universes?

Select one or more of the following:

  • A-Mdx

  • B-Sql

  • C-Bics

  • D-Olap via bics

Question 33 of 78

Medal-premium 1

To what format can you export an exploration view?

Select one or more of the following:

  • A - PNG

  • B - RTF

  • C - HTML

  • D - PDF

Question 34 of 78

Medal-premium 1

In SAP BusinessObjects Explorer 4.x, what do you have to create to access data from SAP ERP Clasic infosets ?

Select one or more of the following:

  • A - An OLAP universe

  • B - A UNX universe

  • C - A RFC connection

  • D - A direct BICS connection

Question 35 of 78

Medal-premium 1

Which of the following data providers are supported on SAP BusinesObjects Explorer 4.1? (Choose 2)

Select one or more of the following:

  • A - SAP HANA

  • B - UNV universes

  • C - OLAP universes

  • D - Oracle EBS

Question 36 of 78

Medal-premium 1

What are the BEx elements supported when you explore information space on top of BW, using relational universes? (Choose 2)

Select one or more of the following:

  • A - Characteritics

  • B - Display attributes

  • C - Calculated key-figures

  • D - Free charcteristics

Question 37 of 78

Medal-premium 1

What task can you perform when you explore data...? choose 2

Select one or more of the following:

  • A - Calculate calculated measures

  • B - Format

  • C - View Metadata

  • D - Track change in data

Question 38 of 78

Medal-premium 1

What can you do with the Information Design Tool? (Choose 2)

Select one or more of the following:

  • A - Translate metadata objects into different languages

  • B - Federate multiple relational data sources

  • C - Convert .unv to .unx universes

  • D - Import users from SAP Business warehouse

Question 39 of 78

Medal-premium 1

In the Information Design Tool, which of the following tasks can you perform in the business layer of a universe? (Choose 2)

Select one or more of the following:

  • A - Create a navigational path

  • B - Modify an attribute

  • C - Create an outer join

  • D - Detect join cardinalities

Question 40 of 78

Medal-premium 1

In the Information Design Tool, which connection can you use to access SAP Business Warehouse Data?

Select one or more of the following:

  • A - ODBC

  • B - OLAP

  • C - JDBC

  • D - MDX

Question 41 of 78

Medal-premium 1

Where can you find the definition of Metadata?

Select one or more of the following:

  • A - Business Layer

  • B-NA

  • C-SA

  • D-FD

Question 42 of 78

Medal-premium 1

You have implemented a navigation option with drop down boxes and custom VBA code in an Analysis Workbook. On your computer the VBA code runs without errors.When the customer opens your workbook the code execution fails with an error message (Choose 2)

Select one or more of the following:

  • A - The name of the characteristics are different in the customer's system

  • B - The analysis addIn is NOT started on the customer's computer

  • C - The customer has NOT activated the VBA Macro Library

  • D - The underlying data source is NOT yet refreshed

Question 43 of 78

Medal-premium 1

In which of the following platforms can you store and share Analysis workbook? (Choose 2)

Select one or more of the following:

  • A - SAP NetWeaver platform

  • B - SAP BusinessObjects BI platform

  • C - SAP HANA platform

  • D - Sybase unwired Platform

Question 44 of 78

Medal-premium 1

What do you use to access a Bex query in Analysis workbook (Choose 3)

Select one or more of the following:

  • A - An SAP HANA view

  • B - An existing analysis view

  • C - An OLAP source on the SAP BusinessObjects BI platform

  • D - SAP GUI for connection information

  • E - A universe

Question 45 of 78

Medal-premium 1

What can you do with VBA API methodes in SAP BusinessObjects Analysis, Edition for Microsoft Office? (Choose 2)

Select one or more of the following:

  • A - Schedule a workbook for pre- calculation within the SAP BusinessObjects Business Intelligence platform server

  • B - Filter two sources simultaneously on the same characteristic value

  • C - Fill a drop down box with the list of members of a characteristic

  • D - Add user- specific navigation options to a context menu

Question 46 of 78

Medal-premium 1

Using a BEx query as a data source,what can you do on the Analysis tab within the Design Panel in SAP BusinessObjects Analysis, Edition for Microsoft Office? (Choose 2)

Select one or more of the following:

  • A - Activate an Exception defined in the BEx query

  • B - Add additional attributes to the query result

  • C - Change a condition definition in the BEx query

  • D - Add filters to the existing BEx query filters

Question 47 of 78

Medal-premium 1

Which of the following can be used as a data source in SAP BusinessObjects Analysis, Edition for Microsoft Office.

Select one or more of the following:

  • A - Analysis Workspace

  • B - Relational universe (.unx)

  • C - Oracle hyperion Essbase

  • D - SAP HANA view

Question 48 of 78

Medal-premium 1

You want to create a workbook that shows turnover per material group Materials are organized hierarchically on three levels. Business users want to view the data at level 3.They also want to be able to aggregate on lower hierarchy levels (Choose 2)

Select one or more of the following:

  • A - Open the context menu of the material in the analysis and expand the hierarchy to the required level

  • B - Open the hierarchy options of the material from the menu bar and deselect the required level in the ''Show Levels" option

  • C - Open the hierarchy options of the material from the menu bar and expand the hierarchy to the required level

  • D - Open the hierarchy options of the material from the menu bar and select the required level in the "Show Levels" option

Question 49 of 78

Medal-premium 1

How would you share your SAP BusinessObjects edition for OLAP workspaces with other analysis? (Choose 2)

Select one or more of the following:

  • A - Save the workspace to a public folder in the SAP BusinessObjects platform

  • B - Save the workspace to a role in the SAP Business warehouse system

  • C - Export the workspaace to Microsoft Excel

  • D - Export the workspace to SAP BusinessObjects Mobile

Question 50 of 78

Medal-premium 1

In the SAP BusinessObjects Analysis.Edition for Microsoft Office ,you define a filter for a measure that filters all elements that are larger than 10.000 EUR. The filter works but the total is still calculated based on all elements. What could be the reason for this?

Select one or more of the following:

  • A - The data source was NOT reset

  • B - The calculate Total as fiels was NOT set to sum

  • C - The sata source was NOT refreshed

  • D - A dynamic calculation of type Accumulative SUM was NOT added

Question 51 of 78

Medal-premium 1

You want to show the refresh date of a data source in a text field when a filter is applied to the data source. How can you achieve this? (Choose 2)

Select one or more of the following:

  • A - Retrieve the refresh date using the "lastDataUpdate()" method

  • B - Place the code into the script of the "On Click" event of the text element

  • C - Retrieve the refresh date using the "lastRefreshedAt()" method

  • D - Place the code into the script of the "On Result Set Changed" event of the data source

Question 52 of 78

Medal-premium 1

In the Design Studio, which of the following are basic components? (Choose 3)

Select one or more of the following:

  • A - Button

  • B - Dimension filter

  • C - Dropdown box

  • D - Panel

  • E - Date field

Question 53 of 78

Medal-premium 1

Which method can you use to load the items of a dimension into a dropdown box?

Select one or more of the following:

  • A - .getMembers()

  • B - .getMembersList()

  • C - .getSelectedMember()

  • D - .getMemberDisplay()

Question 54 of 78

Medal-premium 1

How does SAP recommend you improve the performance of an analytical application in the design studio? (Choose 2)

Select one or more of the following:

  • A - Set the Pixel-Based Scrolling property to true

  • B - Set the Load in Script property to true

  • C - Use Application.doBackgroundProcessing

  • D - Use the .setFilter method

Question 55 of 78

Medal-premium 1

In the Design Studio, you set the Conditional Formatting property of a crosstab to true. The background color of the cells is currently green, yellow, or red depending on a BEx exception value. you would like to use colored icons in the cells instead of background colors. How can you achieve this?

Select one or more of the following:

  • A - By using a custom CSS sheet

  • B - By placing icons in a custom column

  • C - By changing the BEx Query

  • D - By using a custom script

Question 56 of 78

Medal-premium 1

Which of the following method calls is valid in SAP BusinessObjects Design Studio?

Select one or more of the following:

  • A - Component.Method.Argument1 & Component Method ArgumentN;

  • B - Component.Method(Argument1 , ArgumentN);

  • C - Component.Method{Argument1 , ArgumentN};

  • D - Component.Method(Argument1 = Value1, ArgumentN = ValueN);

Question 57 of 78

Medal-premium 1

Which of the following deployment options does Design Studio support? (Choose 2)

Select one or more of the following:

  • A - SAP BusinessObjects BI platform

  • B - SAP NetWeaver Platform

  • C - SAP Enterprise Portal

  • D - SAP Mobile Platform

Question 58 of 78

Medal-premium 1

You want to display data from SAP Busines Warehouse (SAP BW) in the SAP Business Objects BI Mobile App. You have installed the SAP BusinessObjects Design Studio client. What else do you have to set up ?

Select one or more of the following:

  • A - SAP BusinessObjects Design Studio Add-On in SAP Busines Objects BI platform server (&) Relational Univers to SAP BW

  • B - SAP BusinessObjects Design Studio Add-On installation in SAP Busines Objects BI platform and SAP BW server (&) OLAP Connection to SAP BW

  • C - SAP BusinessObjects Design Studio Add-On installation in SAP Busines Objects BI platform server (&) OLAP Connection to SAP BW

  • D - SAP BusinessObjects Design Studio Add-On in SAP BW server (&) iView in SAP Entreprise Portal

Question 59 of 78

Medal-premium 1

How to copy from a multiProvider A to a multiProvider B?

Select one or more of the following:

  • A - The multiprovider B must contain the infoObjects that are contained in A

  • B - The multiprovider B must contain the infoProviders that are contained in A

  • C - The multiprovider A must contain the infoObjects that are contained in B

  • D - The multiprovider A must contain the infoProviders that are contained in B

Question 60 of 78

Medal-premium 1

What Information needed to transfer from a query source to a query target (rpt-to-rpt) ? choose 4

Select one or more of the following:

  • A - Global Filters

  • B - Variables

  • C-InfoProvider

  • D-InfoObject

  • E - Dynamic Filter

  • F - Filter from restrected key figure

Question 61 of 78

Medal-premium 1

what can you use to access workbook? choose 2

Select one or more of the following:

  • A - SAP Neatweaver

  • B - SAP BusinessObjects BI platform

  • C - Crystal Reports 2013

  • D - Bex Analyser

Question 62 of 78

Medal-premium 1

Choose the correct order for Order Scripting Event ?

Select one or more of the following:

  • A- 1-On Startup 2-On Variable Initialization 3-Processed in the background

  • B-1-On Variable Initialization 2-On Startup 3-Processed in the background

  • C-1-Processed in the background 2-On Variable Initialization 3-On Startup

Question 63 of 78

Medal-premium 1

Report include selection option representation (which reporting tools can support that)?

Select one or more of the following:

  • A - Crystal report

  • B - Analysis

  • C - webi

  • D - Dashboard

Question 64 of 78

Medal-premium 1

For what purpose does SAP recommend you use the SAP BusinessObjects Dashboards?

Select one or more of the following:

  • A- To create highly visualized info to aid decision makers

  • b-na

Question 65 of 78

Medal-premium 1

Which of the following tasks can you perform when using in Dashboards? 4 choose

Select one or more of the following:

  • A- Build sophisticated Dashboards and visualizations quickly

  • B-Connect your Dashboards to external data sources

  • C-Maximize the value of your IT solution with visual front ends.

  • D-the sharing of information in multiple familiar formats

  • E-NA

Question 66 of 78

Medal-premium 1

To which format can you export Dashboards? (Choose 5) the answers in the exam is pdf and word doc

Select one or more of the following:

  • A-pdf

  • B-Microsoft Office Word DOC

  • C-XLS

  • D-Microsoft Office PowerPoint PPT

  • E-HTML

  • F-Adobe Flash file (.swf)

  • G-XML

Question 67 of 78

Medal-premium 1

What is the advantage of direct dimensional access BEx via BICS?

Select one or more of the following:

  • A-re use existing bex query

  • B-connectivity is shared across all bi tools

  • C-one connection can point to multiple queries

  • D-provides hierarical metadata

  • E-NA

Question 68 of 78

Medal-premium 1

What can Smart copy do ? choose 2

Select one or more of the following:

  • A- Copy the navigation state single source

  • B-Crosstab with assigned data source

  • c-na

Question 69 of 78

Medal-premium 1

What do you use Dashboard selector for?

Select one or more of the following:

  • A- Selctor componets that allow users to choose options when running the model such as list boxes and check boxes

  • B-NA

Question 70 of 78

Medal-premium 1

Exception selection good 1 bad 3 he maid edit on overall result ?

Select one or more of the following:

  • A-it will affect only the Overall result

  • B-The acceptation will be deactivated

Question 71 of 78

Medal-premium 1

Which tool in a Business warehouse component can imported data from the source system?

Select one or more of the following:

  • A-PSA

  • B-DTP

  • C-Infopackage

Question 72 of 78

Medal-premium 1

Which of the components is a Business warehouse component to store the imported data from the source system?

Select one or more of the following:

  • A-PSA

  • B-DTP

  • C-Infopackage

Question 73 of 78

Medal-premium 1

Which of the following stores data physically? (Choose 3)

Select one or more of the following:

  • A- infoproviders

  • B- info cube

  • C- infosets

  • D-dataStore object

  • E- InfoObject

Question 74 of 78

Medal-premium 1

How Bex Query translates?

Select one or more of the following:

  • A--Translation Manger

  • B-RSA1

Question 75 of 78

Medal-premium 1

You want to change the style of cell in analysis and save It even after a refresh, ?

Select one or more of the following:

  • A-Save style and Apply style

  • B-DELETE deafult

Question 76 of 78

Medal-premium 1

Which of the following data connection types are valid in SAP BusinessObjects Dashboards? (Choose 2)

Select one or more of the following:

  • A-Web Services

  • B-Crystal Reports Data Consumer

  • c-na

Question 77 of 78

Medal-premium 1

In report you use a prompt with the text"Enter values for state" for the dimension State you want to use a freestanding cell with the combined text"Quarterly Revenue " and the name of the state that a user entered to the previous prompt ? Which formula syntax would achieve this? (Choose 2)

Select one or more of the following:

  • A - "Quarterly Revenue for "+UserResponse ("Enter values for State")

  • B - "Quarterly Revenues for" +ReportFilter([State])

  • C - Concatenation("Quarterly Revenues for ";UserResponse("Enter values for Sate"))

  • D - Concatenation("Quarterly Revenues for ";ReportFilter([State])

Question 78 of 78

Medal-premium 1

Wich of the following can you do in the Bex query designer Cell Editor? (Choose 2)

Select one or more of the following:

  • A - Use a cell as a reference cell so that it can be referenced calculations.

  • B- Define help cells that contain comments for formulas in the report

  • C-Apply cell formulas or selection condition to any cell in your analysis report

  • D- Define formulas and selection condition for cells to override the automatically created cell balues.

Icon_fullscreen
abo anmar
Quiz by , created about 1 year ago

sapbi

Eye 300
Pin 0
Balloon-left 0
Tags No tags specified
abo anmar
Created by abo anmar about 1 year ago
Close