sapbi

Question

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

Answer 1

A - Define filter restriction

Answer 2

B - Analyse combinations of charactrestics using ranked lists

Answer 3

C - Restrict combination of characteristics using a structure

Answer 4

D - Define value limits

Answer 5

A - In the values For dialog in the query designer

Answer 6

B - In the characteristic definition in SAP Business Warehouse

Answer 7

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

Answer 8

D - In the InfoProvider definition in SAP Business Warehouse

Answer 9

A - Exception aggregations are excuted on multiple rows

Answer 10

B - Exception aggregations are excuted on multiple columns

Answer 11

C - Exception aggregations are excuted instead of standard aggregations

Answer 12

D - Exception aggregations are excuted in addition to standard aggregations

Answer 13

A - The hierarchy must be time-dependent

Answer 14

B - The hierarchy must cotain at least two nodes

Answer 15

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

Answer 16

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

Answer 17

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

Answer 18

B - Use indivual characteristic and characteristic combinations

Answer 19

C - Create a condition using TOP sum ranked list operator

Answer 20

D - Create a condition using TOP N ranked list operator

Answer 21

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

Answer 22

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

Answer 23

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

Answer 24

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

Answer 25

A - Text and Key

Answer 26

B - Key and short Text

Answer 27

C - Key and Text

Answer 28

E - Short Text and long Text

Answer 29

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

Answer 30

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

Answer 31

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

Answer 32

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

Answer 33

A - a calculated key figure

Answer 34

B - a structure

Answer 35

C - a characteristic selection

Answer 36

D - a formula

Answer 37

A - Show the runtime statistics of the Analysis workbook

Answer 38

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

Answer 39

C - Change the display language for text fields

Answer 40

D - Sort the displayed elements on a given measure

Answer 41

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

Answer 42

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

Answer 43

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

Answer 44

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

Answer 45

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

Answer 46

A - S_RS_Auth

Answer 47

B - S_RS_COMP

Answer 48

C - S_RS_COMP1

Answer 49

D - S_RS_Folder

Answer 50

A-Check or change query properties

Answer 51

B-Test or regenerate Queries and query view.

Answer 52

C- Refresh

Answer 53

A - It is optimized for read access

Answer 54

B - It is optimized for write access

Answer 55

C - It has a multidimensional structure

Answer 56

D - It has a relational structure

Answer 57

A - Zero suppression

Answer 58

B - Scaling factor

Answer 59

C - Number of decimals

Answer 60

D - Hierarchy version variable

Answer 61

A - Analysis view

Answer 62

B - Universe

Answer 63

C - SAP ERP

Answer 64

D - SAP HANA view

Answer 65

A - City+Date

Answer 66

B - City & Date

Answer 67

C - Join (City, Date)

Answer 68

D - City + Text (Date)

Answer 69

B - Parameters

Answer 70

C - Formulas

Answer 71

D - Filters

Answer 72

A - Apply data calculation

Answer 73

B - Apply time-based query

Answer 74

C - Combine filters

Answer 75

D - Use formula to conditional formatting

Answer 76

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

Answer 77

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

Answer 78

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

Answer 79

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

Answer 80

A - SAP BusinessObjects Analysis, Edition for OLAP

Answer 81

B - SAP BusinessObjects Web Intelligence

Answer 82

C - SAP BusinessObjects Design Studio

Answer 83

D - SAP BusinessObjects Explorer

Answer 84

A - Navigational Attribute

Answer 85

B - InfoProvider dimension

Answer 86

C - Hierarchy version variable

Answer 87

D - Restricted key figure

Answer 88

A - Activate change data tracking

Answer 89

B - Set the positions of report elements

Answer 90

C - Show or hide report filters and outlines

Answer 91

D - Purge and refresh an existing data provider

Answer 92

E - Drill down in a report designed for drilling

Answer 93

C - Count Distinct

Answer 94

D - Percentage

Answer 95

E - Cumulative percentage

Answer 96

A - Display the query script

Answer 97

B - Preview the query results

Answer 98

C - Add a subquery

Answer 99

D - Add a new query

Answer 100

A - Share input controls between different reports

Answer 101

B - Change values within variables

Answer 102

C - Associate input controls with tables and section headers

Answer 103

D - Customize values using the scripting language

Answer 104

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

Answer 105

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

Answer 106

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

Answer 107

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

Answer 108

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

Answer 109

B - Local Variables - create, Modify, Delete

Answer 110

C - Merged Dimensions - Create, modify, Delete

Answer 111

D- Actions query

Answer 112

D-Olap via bics

Answer 113

A - An OLAP universe

Answer 114

B - A UNX universe

Answer 115

C - A RFC connection

Answer 116

D - A direct BICS connection

Answer 117

A - SAP HANA

Answer 118

B - UNV universes

Answer 119

C - OLAP universes

Answer 120

D - Oracle EBS

Answer 121

A - Characteritics

Answer 122

B - Display attributes

Answer 123

C - Calculated key-figures

Answer 124

D - Free charcteristics

Answer 125

A - Calculate calculated measures

Answer 126

B - Format

Answer 127

C - View Metadata

Answer 128

D - Track change in data

Answer 129

A - Translate metadata objects into different languages

Answer 130

B - Federate multiple relational data sources

Answer 131

C - Convert .unv to .unx universes

Answer 132

D - Import users from SAP Business warehouse

Answer 133

A - Create a navigational path

Answer 134

B - Modify an attribute

Answer 135

C - Create an outer join

Answer 136

D - Detect join cardinalities

Answer 137

A - Business Layer

Answer 138

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

Answer 139

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

Answer 140

C - The customer has NOT activated the VBA Macro Library

Answer 141

D - The underlying data source is NOT yet refreshed

Answer 142

A - SAP NetWeaver platform

Answer 143

B - SAP BusinessObjects BI platform

Answer 144

C - SAP HANA platform

Answer 145

D - Sybase unwired Platform

Answer 146

A - An SAP HANA view

Answer 147

B - An existing analysis view

Answer 148

C - An OLAP source on the SAP BusinessObjects BI platform

Answer 149

D - SAP GUI for connection information

Answer 150

E - A universe

Answer 151

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

Answer 152

B - Filter two sources simultaneously on the same characteristic value

Answer 153

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

Answer 154

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

Answer 155

A - Activate an Exception defined in the BEx query

Answer 156

B - Add additional attributes to the query result

Answer 157

C - Change a condition definition in the BEx query

Answer 158

D - Add filters to the existing BEx query filters

Answer 159

A - Analysis Workspace

Answer 160

B - Relational universe (.unx)

Answer 161

C - Oracle hyperion Essbase

Answer 162

D - SAP HANA view

Answer 163

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

Answer 164

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

Answer 165

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

Answer 166

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

Answer 167

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

Answer 168

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

Answer 169

C - Export the workspaace to Microsoft Excel

Answer 170

D - Export the workspace to SAP BusinessObjects Mobile

Answer 171

A - The data source was NOT reset

Answer 172

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

Answer 173

C - The sata source was NOT refreshed

Answer 174

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

Answer 175

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

Answer 176

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

Answer 177

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

Answer 178

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

Answer 179

A - Button

Answer 180

B - Dimension filter

Answer 181

C - Dropdown box

Answer 182

E - Date field

Answer 183

A - .getMembers()

Answer 184

B - .getMembersList()

Answer 185

C - .getSelectedMember()

Answer 186

D - .getMemberDisplay()

Answer 187

A - Set the Pixel-Based Scrolling property to true

Answer 188

B - Set the Load in Script property to true

Answer 189

C - Use Application.doBackgroundProcessing

Answer 190

D - Use the .setFilter method

Answer 191

A - By using a custom CSS sheet

Answer 192

B - By placing icons in a custom column

Answer 193

C - By changing the BEx Query

Answer 194

D - By using a custom script

Answer 195

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

Answer 196

B - Component.Method(Argument1 , ArgumentN);

Answer 197

C - Component.Method{Argument1 , ArgumentN};

Answer 198

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

Answer 199

A - SAP BusinessObjects BI platform

Answer 200

B - SAP NetWeaver Platform

Answer 201

C - SAP Enterprise Portal

Answer 202

D - SAP Mobile Platform

Answer 203

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

Answer 204

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

Answer 205

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

Answer 206

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

Answer 207

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

Answer 208

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

Answer 209

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

Answer 210

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

Answer 211

A - Global Filters

Answer 212

B - Variables

Answer 213

C-InfoProvider

Answer 214

D-InfoObject

Answer 215

E - Dynamic Filter

Answer 216

F - Filter from restrected key figure

Answer 217

A - SAP Neatweaver

Answer 218

B - SAP BusinessObjects BI platform

Answer 219

C - Crystal Reports 2013

Answer 220

D - Bex Analyser

Answer 221

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

Answer 222

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

Answer 223

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

Answer 224

A - Crystal report

Answer 225

B - Analysis

Answer 226

D - Dashboard

Answer 227

A- To create highly visualized info to aid decision makers

Answer 228

A- Build sophisticated Dashboards and visualizations quickly

Answer 229

B-Connect your Dashboards to external data sources

Answer 230

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

Answer 231

D-the sharing of information in multiple familiar formats

Answer 232

B-Microsoft Office Word DOC

Answer 233

D-Microsoft Office PowerPoint PPT

Answer 234

F-Adobe Flash file (.swf)

Answer 235

A-re use existing bex query

Answer 236

B-connectivity is shared across all bi tools

Answer 237

C-one connection can point to multiple queries

Answer 238

D-provides hierarical metadata

Answer 239

A- Copy the navigation state single source

Answer 240

B-Crosstab with assigned data source

Answer 241

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

Answer 242

A-it will affect only the Overall result

Answer 243

B-The acceptation will be deactivated

Answer 244

C-Infopackage

Answer 245

C-Infopackage

Answer 246

A- infoproviders

Answer 247

B- info cube

Answer 248

C- infosets

Answer 249

D-dataStore object

Answer 250

E- InfoObject

Answer 251

A--Translation Manger

Answer 252

A-Save style and Apply style

Answer 253

B-DELETE deafult

Answer 254

A-Web Services

Answer 255

B-Crystal Reports Data Consumer

Answer 256

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

Answer 257

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

Answer 258

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

Answer 259

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

Answer 260

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

Answer 261

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

Answer 262

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

Answer 263

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

	Created by abo anmar over 8 years ago

Next up

sapbi

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Question 41

Question 42

Question 43

Question 44

Question 45

Question 46

Question 47

Question 48

Question 49

Question 50

Question 51

Question 52

Question 53

Question 54

Question 55

Question 56

Question 57

Question 58

Question 59

Question 60

Question 61

Question 62

Question 63

Question 64

Question 65

Question 66

Question 67

Question 68

Question 69

Question 70

Question 71

Question 72

Question 73

Question 74

Question 75

Question 76