Administration - Which objects must be configurated if you want to control user access to amodel from a Web Client? Note: There are 2 correct answers to this question
Data access profiles
Task profiles
BW rules
Secured dimensions
Input forms and reports - You want to be able to insert comments in an excel popup on SAP BEC version for Netweaver. What do you hace to enable?
The enable Comments indicator in model features
Environment parameters in Customizing (SPRO)
The Show as Microsoft Excel Cpmments checkbox
Model parameters in Customizing (SPRO)
Business Rules and Controls - Which business rule requires global definitions business rules?
US eliminations
Currency translation
Eliminations and adjustments
Account-based calculations
Logic and calculation - Which translation allows you to access to system_constants.lgf and MDXlib.lgf files in SAP BPC for version…
Script Logic Tester (UJKT)
Transports (UJBPCTR)
File Service (UJFS)
Write back runtime Parameters (UJRO)
Logic and calculation - Which of the following options do you use to calculate KPIs on the fly?
Script Logic
Worksheet Logic
Dimension member formulas
Business rules
Consolidation central - (NO SE CUAL ES LA RESPUESTA) - The consolidation monitor displays a blank screen for the current period although the previous period has beeen displayed properly. What could be the reason for this?
No master data exists
No ownership records exists
No trial balance exists
No exchange rate records exists
Dimensions - Which dimension types can you use for the context when you use the Controls Monitor in a Financial model? There are 3 correct answers to this question
G-Group
T-Time
E-Entity
R-Currency
C-Category
Input forms and reports - What is an advantage of using Web reports over EPM reports?
Web reports support EPM functions
Web reports support multiple dimensions in the rows and columns
Web reports can access data from multiple sources
Web reports use a thin client
Dimensions - What do you do when you maintain domensions data manually and want to return to the previous unsaved value?
Choose back
Choose revert
Choose restore
Choose display
Administration - A user tries to connect to a model usig Excel interface on the EPM add-in. However, the model is not available. What could be the issue?
The task profile is assigned to the user's team
The data access profile is not assigned to the user's team
The data acess profile is assigned to the user's team
The task profile is not assignedto the user's team
Models - Which objects in BW is equivalent to a model in SAP BPC for Netweaver?
Standad infocube
Multiprovider
Real-Time Infocube
Virtual Provider
Models - Which properties are required to carry out currency translation for legal consolidation? There are 2 correct answers to this question
RATETYPE in the account type dimension
RATE_YEAR in the category dimension
RATE_PERIOD in the category dimension
CURRENCY in the entity type dimension
Models - For which of the following models do you have to create al least two "Drivers and Rates" type models?
Ownership
Estándar
Consolidation
Finantial
Input forms and Reports - How do you change an EPM Report from read only to read/write using the EPM Offlice Add-in Excel?
Switch the template to an input schedule
Activate "Use as input form" in the sheet options
Activate "Member recognition" in the sheet options
Switch the type from Report to Input form
MODELS - Which of the following rules are based on business rules? There are 3 correct answers to this question
Allocation
Driver-based calculations
Input forms and Reports - What information is needed when you configurate the interface between EPM Office Add-in Excel and Bex Query to enable the BW drill thought… There are 3 correct answers to this question
The technical field names of the dimensions
The FILTER_IOBJNM and FILTER_VALUE parameters
The OKCODE parameter
The URL of the Bex Query
The technical names of the InfoObjects
Administration - Which of the following steps are mandatory if you want to perform a transport from development system to the production system. There are 2 correct answers to this question.
Run the Transport-Create-Request (UJBPCTR) transaction
Take the environment offline
Select Planning and Consolidation Objects in the BW Transport Collector
Run a full optimization
Input forms and Reports - When you enter a new value into a cell manually, you want the cell color to switch to a different colour. How to configure the formatting sheet to achieve this?
Select Apply for changed Member Default Format
Select Apply for inputable Member Default Format
Select Apply for Local Member Default Format
Select Apply for Calculated Member Default Format
Consolidation celtral - You have defined the global definitions in the business rules. Which of the following ownership accounts must contain data if you want to perform the ownership calculation? There are 2 correct answers to this question
PCON- Percent Consolidation
PCTRL - Percent Control
POWN - Percent Ownership
PCON_SYS - Percent Consolidation_System Calculation
POWN_SYS - Percent Ownership_System Calculation
Dimensions - (NO LA SE) You use INC account type for revenue accounts and the EXP account type for expense accounts. What is displayed in a Planning and Consolidation report when revenues are stored as negative values and expenses are stored as positive values? There are 2 correct answers to this question
Negative revenue values
Positive expense values
Positive revenue values
Negative expense values
Administration - Which of the following steps do you need to follow to configure data audit?
Activate the collection of the data by environment
Add a global parameter in Customizong (SPRO)
Add a parameter to Data Manager Packages
Activate the collection of the data by model
Dimensions - Which of the following dimensions types can be used as reference dimensions? There are 2 correct answers to this question
D - Audit
T- Time
G - Group
E - Entity
S - Subtables
Administration - Which step is mandatory if you want to check the data integrity of the incoming records?
Configure controls
Activate the validations for the environment
Assign a driver dimension to the validation rule
Implement a Badi
Input forms and Reports - What do you have to create to capture the data from multiple planning iterations?
Dimensions
Properties
Members
Models
"Logic and calcluations - What is missing in the following currency tranlation logic script if you want to translate local currency in a financial. *RUN_PROGRAM CURR_CONVERSION CATEGORY=%CATEGORY_SET% TID_RA=%TIME_SET% RATEENTITY=GLOBAL ENTITY=%ENTITY_SET% *ENDRUN_PROGRAM"
Logic for the Entity type dimension
Logic for the Currency type dimension
Logic for the Group type dimension
Logic for the Account type dimension
Administration - What can you use to prevent the insetion of records into the database in SAP BPC
Book publication
Work Status
Data audit
Controls
Business rules and controls - (NO LO SE)You have created the controls and a user has tested them for the current period. However, the user does not see the controls for the following period. How do you resolve this issue?
Grant authorization to the user to view the controls for following period.
Assign the control level to the following period
Change the work staus in the Consolidation Monitor for the following period
Assign the control set to the following period
Administration - You want to use specific default values when you add data manually from Web Client. How can you achieve this?
Specify the default members for data input
Select the "Activate Member Recognition" option
Select the "Use as Input Form" option
Specify the default members for reporting
Administration - Which of the folowing tasks are perdormed during a full optimization in SAP BPC version.. There are 2 correcto answers to this question
Aggregate rollups
Create a copy of the Multiprovider for the InfoCube
Check the BW dimension tables to see wheter these can be improved
Update DB statistics for the InfoCube
Administration - Which of the following journal parameters are available for a model? There are 2 correct answers to this question
Balanced currency
Allow Journals to be Reopened
Enforce Balanced Journal
Balanced by entity
Busines rules and controls - You want to enable users to resolve the "out of balance" issue when blocking control fail. When you configure the controls, what do you attach to the blocking controls?
An input schedule
A Web Report
An Excel Report
A journal
Administration - Which steps are mandatory if you want to implement the work status? There are 3 correct answers to this question
Define the Reviewer property in the owner dimension
Enable data locking for the model
Enable data audit for the model
Define at least one hierarchy in the owner dimension
Define the Owner property in the owner dimension
Busines rules and controls - The parent company D owns 91% of company A, 51% of company B, and 49% of company C. Which company can use the equity method?
D
A
B
C
"Logic and calculation - You execute the following Logic Script by running a Data Manager package without transfering any further parameters and without using the default logic ""WHEN ACCOUNT IS ACCOUNT1 REC(FACTOR=1.5,ACCOUNT=ACCOUNT2) ENDWHEN"" Which data is used by this calculation?"
All accounts
Only the workspace context
Only the context default
Only ACCOUNT1 and ACCOUNT2
Web client and dashboards - Which prerequisites must be fullfilled if you want to display Planning and Consolidation data in the Dashboard Designer? There are 2 correct answers to this question
A runtime connection must exist between the Planning and Consolidation System and the Dashboard
A list of models must be generated in the EPM report
An EPM report must be created
A BPC data grid must be used in the Dashboard
Models - When does the DEFAULT.LGF logic script run?
When business rules are executed
When data is sent from an input form
When table-based logic is executed
When data is refreshed
Business rules and controls - You select a parent in the detailed section of the control definition. Which of the following options do you choose to ensure that the control will be executed for each member of the selected parent?
Breackdown Dimension
Control level
Threshold Tolerante
Equation type
Input forms and Reports - Which function do you use to calculate variances?
EPMMemberProperty
EPMExecuteAPI
EPMComparision
EPMMemberOffset
Business rules and controls - Which of the following values can you use in the destionation flow to configure the currency translation business rule? There are 2 correct answers to this question
Base Level Members
Blank
Property values
Descendants
Consolidation central - (NO TENGO LAS FOTOS) When executing the ownership calculation you receive and error message. You therefore analyze the group/entity structure in the attached screenshot. Which method type is missing in the consolidation method?
N_A
N_
Models - When you create a new model from an existing model which items are copied?
Controls Definitions
Data Manager Packages
Transaction Data
Journal Templates
Logic and calculation - (NO LO SE) What is entered in the destination group account when you configure AR/AP Intercompany Elimination using the Eliminations…
The same values as in the destination minority account
The intercompany AP account
The intercompany AR account
The offset account
Web client and Dashboards - You want to create a PDF book that contaions PDF files by cost center for the current year based on an EPM report, and publish it in the library. Which of the following steps are required when you create the publication template? There are 2 corect anwers to this question
Include the cost center dimension in the page axis of the publication template
Assign the EPM report to the publication template
Assign a time variable to the publication template
Assign the cost center to the variable members of the publication template.
Include the cost center dimension in the fixed keys of the publication template
Administration - Which of the following delivered task profiles allows you to maintain environments?
PrimaryAdmin
System Security
SystemAdmin
Secondary Admin
Data manager - How do you onfigure the Data Manager package to execute a specific logic script file?
Define the logic script file in the package link
Define the logic script in the process chain
Define the logic script file in the advance package settings
Define the logic script file as a variable in package parameters
Consolidation central - Which hierarchy is used in the consoliation monitor?
Intercompany based hierarchy
Entity hierarchy
Group hierarchy
Ownership-based hierarchy
Logic and calculation - Which of the following calculations uses only logic script?
Ownership calculation
Reclassification
Logic and calculation - You want to calculate revenues as a product of the units sold and price per unit and save the reslts in the database. How can you achieve this?
Use the logic script
Use business rule
Use theworksheet logic
Use the dimension member formulas
Logic and calculation - Which package groups are delivered by SAP by SAP BPC for NetWeaver? Note: There are 2 correct answers to this question
Data Manager
Other function
Reporting Management
Financial Process
Web client and Dashboards - You want to specify a model and a dimension members that are usedevery time you created Web Reports. Where do you set these values?
EPM Context
Context default
Preferences
Workspace
Logic and calculation - You use DESTINATION_APP keyword in your logic script. If the source model contains fewer dimension than the target, which operator do you use to derive the missing dimensions?
*SKIP_DIM
*ADD_NAME
*RENAME_DIM
*XDIM_MEMBERSET
Input forms and reports - Which tool can you use in the EPM Office Add-In Excel to email a list of static files? Note: There are 2 correct answers to this question.
Distribution
Portal publication
Worksheet generation
Logic and calculation - Which property of the currency dimension is required for currency translation?
PARENT_GROUP
STORE_GROUP_CURR
GROUP_CURRENCY
CURRENCY_RATE
Web client and dashboards - Which of the following dimensions is automatically selected when you create a Business Process Flow template?
Time
Account
Entity
Category
Data manager - Which of the following functions do you use to load data from a flat file to a model?
Organize package
Data preview
Run package
Download data
Dimensions - How do you model cost center rollups by profit center?
Create a user-define dimension for the profit center
Create a user-define dimension for the cost center
Create a profilt center hierarchy by cost center
Create a cost center hierarchy by profit center
Input forms and reports - Where do you activate the parameter that is used to automatically refresh the input form when you open it?
EPM - User options
EPM - Command Display Options
EPM - Context Options
EPM - Sheet Options
Web client and Dashboards - You reopen a step in a Business Process Flow. What will the staus of the next step be?
Reopened
Open
Delayed
Rejected
"ADMINISTRATION - Which value is assigned ti ACCOUNT3 in the following logic script? ACCOUNT1=10, ACCOUNT2=20 ""WHEN ACCOUNT3 ""IS ACCOUNT2,ACCOUNT1 ""REC (FACTOR=2,ACCOUNT3=ACCOUNT), ""ENDWHEN"
60
20
30
10
Models - Which of the following methods does the SHARE QUERY ENGINE (SQE) use to retrieve data from the database? Note: There are 2 correct answers to this question.
Cell query
RSDRI query
MDX query
Axis query
Consolidation central - Which of the following tasks can you perform using the Consolidator monitor? Note: There are 2 correct answers to this question.
Run Data Manager Packages
Run Currency translation
Run controls
Run ownership calculation
Run consolidation
Business rules and controls - Which of the following business rules can you use in a financial model?
Methods
Methods - based Multipliers
Elimination and Adjustments
Currency Translation
Dimensions - What is the maximum lenght of a dimension member in SAP BPC version for Netweaver?
500 characters
20 characters
256 characters
32 characters
Models - When using US Eliminations, which dimension must you include in the model?
Group
Flow
Dimensions - Which of the following dimension types are required for an ownership model? Note: There are 3 correct answers to this question.
I - Intercompany
A - Account
R - Currency
Web client and Dashboards - Which of the following interfaces can you use when you define actions using Business Process Flow template?
EPM Office Add-in Excel
EPM Office Add-in Word
Journal
BW Application Server
Planning and Consolidation Administration
Dimensions - Which dimensions can you use to configure the Carry-Forward business rule? Note: There are 3 correct answers to this question.
Data source
Data manager - After running a Data Manager package link with 5 packages, you notice that package 3 failed. What happened to the other packages?
Package 1,2,4 and 5 ran
Package 1 and 2 were rolled back, 4 and 5 did not run
Package 1 and 2 were rolled back, 4 and 5 run
Package 1 and 2 ran, package 4 and 5 did not run
Input forms and reports - For the budgeting process, you need to distribute a base amount across 12 month with a growth factor of 3%. Which modelling function do you use?
WEIGHT
TREND
FORECAST
SPREAD
MODELS - You want to set up a consolidation model. Which of the following dimenions should be the same for consolidation, rate and ownership models? Note: There are 2 correct answers to this question.
Data Source
Data manager - Which of the following tasks can you perform using a Data manager package delivered by SAP? Note: There are 3 correct answers to this question.
Export master data to SAP ECC
Execute a BADI
Load master data and texts from BW InfoObject
Export transaction data to a flat file
Load transaction data from BW InfoProvider
Data manager - Which transformation file parameter do you use for filtering when you import data from an infoprovider?
SELECTION
AMOUNTDECIMALPOINT
SKIP
MAXREJECTCOUNT
Administration - Which user account do you need to log onto SAP BPC version for Netweaver?
Window Ad users
ECC users
BW users
CMS users
Dimesnions - Which of the following conventions apply to dimension property ID? Note: There are 2 correct answers to this question.
They must contain less than 33 characters
They must begin with a character
They must contain less than 21 characters
They must begin with a number
"Input forms and reports - (NO LO SE) You use account by entity report and whatn to frill down on parent account for one entity at a time, as in the attached screenshot. How do you achieve this drill down behaviour? Before Picture … After Picture"
Activate Member an children
Activate Expand / Collapse on Single Member
Activate Keep / Exclude on Single Member
Activate Member and Descendants
Input forms and reports - Your EPM report is enable to send data and comments. You type in a revenue and a comment in the EPM report and save the sata. Where is the data stored?
The revenue value in a Infocube and the comment in a DataStore Object
Both the revenue value and the comment in a DataStore Object
The revenue value in an InfoCube and the coment in another database table.
Both the revenue and the comment in a n InfoCube
Business rule and controls - Which rule type is required if you want to perform consolidation of investments?
Eliminations and Adjustments
US Eliminations
Account-bassed Calculations
Intercompany Bookings
Dimensions - Which models types is required to consolidate investments? Note: There are 3 correct answers to this question.
Standard
Exchange Rates
Data manager - From which of the following objects can you import data using the "Load Transaction Data from BW InfoProvider" Data Manager Package? Note: There are 3 correct answers to this question.
InfoCube
InfoObject
MultiProvider
DataStore
InfoArea
Input forms and reports - You enter data using EPM Office Add-in Excel. When you attemp to save data, you receive an error message saying that the member you wan… What can you use to resolve this issue? Note: There are 2 correct answers to this question
Change the header dimensions to base members
Set the Expand option to "Member and children"
Restrinct rows and columns to base members
Change the calc property of the parent members to N