Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requirement?
GROUP_CURRENCY
CURRENCY_TYPE
RATETYPE
FX_TYPE
Your customer wants to load certain accounts with both local and reporting currencies without doing a currency translation. Which expression in the formula of the business rule for currency conversion can you use to achieve this?
[COPYLC]
[NOTRANS]
1
[AS_IS]
For which dimension type can you activate a data audit trail for a model?
Account
Time
Entity
Category
Which business rules are used in the consolidation monitor? (Choose three)
Currency translation
Eliminations and adjustments
US eliminations
Account-based calculations
Global definitions
What limitation exist for dimension properties in BPC 10.0 for Netweave?
No more than 20 properties can be created for a given member.
Properties with more than 60 characters cannot be used for dimension member formulas.
Properties cannot be deleted once they are created
Property size can only be increased, not decreased.
What benefits does BPC offer to a corporation? (Choose 2)
It gives the IT department control over budgeting and planning functions.
It integrates with the Microsoft Office suite including Word, Excel and Powert Point
It enables compilance with IFRS and SOX
It enables you to drill through to the SAP ECC system for reporting
Which of the following delivered components cause quick implementation in Planning and Consolidation? (Choose three)
Report Templates
Input Schedules Templates
Cost Center Planning Application
Sample Logic
Which of the following could be some examples of the impact of implementing SAP BPC? (Choose three)
Streamline the planning, budgeting and forecasting process.
Increase the involvement of IT with the planning, budgeting and forecasting process.
Increase the business user productivity
Full integration with the MS Office suite of products.
Increase the business user´s integration with the data model
What limitations exist for dimension properties in BPC 10.0 for Netweaver?
Properties with more than 60 chararcers cannot be used for a dimension member formulas.
How can you add a property other than a hierarchy to a dimension?
Maintain the dimension property
Refresh the dimension members
Maintain the dimension members
Proccess the dimension
Which dimension type can be used to track openning and closing balance?
Intercompany
Datasource
Subtable
Group
What is the best business practise to execute a multiple iteratons of a budgeting process in BPC?
Create a separate dimension
Create a separate property
Create a separate dimension memeber
Create a separate application
Which implementation step is mandatory to set up an on-the-fly KPI calculation?
Add a "Formula" property to the account member.
Execute a data manager package
Update the "system_constants" file
Add the library file "mdxlib.lgl" to the option sheet of the account member.
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Which implementation option do you choose?
Worksheet logic
Business Rules
Dimension member formulas
Script Logic
Which of the following are valid for a BPC Dimension? (Choose 2)
Equivalent to BW Characteristic
Equivalent to a BW Dimension
Contain three types of master data
Can have multiple hierarchies
Which of the following can you say about members of a dimension?
Members with no children are called Based-level Members
Members with childrens are Parents
Parents members have a calc value of NO
Members have properties that can be used in reporting
Which dimension type is optional for a model?
D-Audit
T-Time
C-Category
A-Account
What dimension types are mandatory from the applications (models) type Financial? (Choose 2)
I-Intercompany
Which dimension type is optional for an Application (Model)?
Data source type
Category type
Time type
Account type
The four required dimension types for any model include: (Choose 4)
Intco Dimension
Request ID
What is a BW object equivalent to a BPC Model?
Info Cube
Info object
DSO
Info area
Table
Transaction data is described by:
Infocube
Dimension
Appset
Dimension members
Calculated KFs
The ownership account contains: (Choose 3)
Percentages
Methods
Parent Positions
Rates
Which of the following application options are common between Finance and Consolidation Application? (Choose 4)
Currency Conversion
Calculation
Intercompany Elimination
Validations
US Elimination
Openning Balance
What object in business wharehouse is equivalent to an application (Model) in BPC?
Basic Infocube
Realtime Infocube
Multiprovider
Transactional Infocube
Every AppSet (Environment Shell) has a 2 character AppSet Prefix stored in a table called UJA_APPSET_INFO. This prefix can be used in a technical name of: (Choose 3)
Infoarea
infoobject
Infoobject Catalog
What applications do you need for Consolidation as a mandatory application?
Legal
Ownership
Rate
Intercompany Matching
Finance
For the budgeting process, you need to extrapolate a base amount across 12 months with a gowth factor of 3% What modeling function do you use?
TREND
FORECAST
SPREAD
WEIGHT
How do you allow data entry and posting in a BPC Excel sheet?
Add a row to show the variance of the plan
Use a hierarchical structure for member values
Set the workbook option to "Refresh automatically"
Use base members
Which function do you use to display a dimension name?
EPMDimensionOverride
EPMDimensionProperty
EPMDimensionList
EPMDimensionType
Your customer wants to load certains accounts with both local and report currencies without doing a currency conversion. Which expression in the formula of the business rule for currency conversion can you use to achieve this?
Which of the following options can you use for drill through?
RFC Connection based on the current view
URL based on the current view
URL based on the selected cell
RFC Connection based on the selected cell
Which of the following are the options for the drill through feature? (Choose 2)
A BW Web report
ECC
Website
A BW Excel report
When use drill through , the member id that is passed into ECC would include which of the following?
The current view
The page key range
The member set
the position of the cursor
Which of the following are valid business reasons to use the ECC Drill through? (Choose 2)
Access source record
Create new transaction
Access an account balance
View detail that is not stored in BW
Which of the following are required for a BW query drill through?
URL with the query name
InfoObject name and value parameter
okcode
A dimension property
Which of the following are required for a ECC drill through? (Choose 3)
URL with a tcode
At least one ECC field name
The OKCODE
A dimension property to join on
What settings do you need for Source Account to calculate the liability account annual net income (ANI)?
Expense, Destination Account = Revenue and ANI, do not reverse sign
Revenue and Cost, Destination Account = ANI, do not reverse sign
Revenue and Cost, Destination Account = ANI, reverse sign
Expense, Destination Account = Revenue and ANI, reverse sign
A KPI should be calculated centrally, on-the-fly, and be available to all reports. Wich implementation option do you
Busines Rules
Dimension Member Formulas
Script logic
Which of the following is required to run formulas in script logic files as data is written to the database? (Choose 1)
A separate Script logic file with the formula
Default logic file
A dimension member formula
A mnu command
What is missing in this code?
*RUN_PROGRAM CURR_CONVERSION CATEGORY = %C_CATEGORY_SET% TID_RA = %TIME_SET% RATEENTITY = GLOBAL ENTITY = %ENTITY_SET% *ENDRUN_PROGRAM
CURRENCY = %RPTCURRENCY_SET%
RATEENTITY = %ENTITY_SET%
ACCOUNT = %ACC_SET%
Rate type is missing
TCURR table is missing
Which of the following is required to run formulas in script logic file as data is written to the database?
A separate script logic file with the formula
An mnu command
What components are needed to run business rules?
Business Rule
Dimension logic
Conversion field
Data Manager Package
Which 2 functions can be used using script logic and business rules? (Choose 2)
Carry Forward
Validation (Controls)
Automatic adjustments
Which business rules are used in the consolidation monitor? (Choose 3)
Currency translations
What value is used in the destination flow column of the currency conversion businees rule when there is no subtabe type dimension in the Application?
Same as in the destination account column
Same as in the source account rate type column
Same as in the in the flow column
Same as in the formula column
Your customer wants to use a unique business rule to translate currency for selected entities. Which property do you set for the selected entities to meet this requeriment?
GROP_CURRENCY
The currency conversion setup includes wich of the following?
A rate aplication wich is referenced to the legal application and stores the exchange rates used to translate into the reporting and group currencies.
The currency property of the entity dimension which designates the local operating currency of legal subsidiaries normally
Rate type property in the account dimension which determines the rate and logic to be used in translation
Tcurr table which stores exchange rates such as sport and historical
Currency business rules
The currency data manager package and process chain
Which of the following are included in the currency translation process? (Choose 2)
Account rate types are used to select accounts in the business rule table
Entity local currencies are read from the entity type dimension
The LC in the transaction data record is used to calculate group currency in the same record
Formula keywords are use to select exchange rates from the rate application
Which of the following modeling aspects are included in the rate application as delivered? (Choose 2)
A from and to currency
A key date
A designated group currency
A rate type account
What value is the destination flow column of the currency conversion business rule when there is no subtable type dimension in the application? (Choose 1)
Same as in the destination account
Same as in the source flow column
Which of the following is/are true with regards to validations? (Choose 3)
All validations configuration can be transported
Validations integrate with Activity audit
Authorizations is controlled by access to task profiles
Las changed date and time is stored in tables
Authorization is controlled by access to transaction code S-TRANS
Which of the following are features of Characteristic Validation? (Choose 2)
Compare assets to liabilities and Owners equity
Prevent invalid combinations of Dimensions Members
Use a Badi for complex validation
Control journal, manual and Data manager activity by application
To lock and entity from changed data
While setting up validations in UJ_VALIDATIONS, we configure: (Choose 3)
value ranges
Use non-existing members
Only = sign
We can include multiple values
All configurations in UJ_VALIDATIONS are _________ specific:
Model
Environment
DSO (Data Source Object)
What settings are possible for restricting data access for a given work state? (Choose 2)
Administrator
Reviewer
Owner
Manager
Assistant
How do you control inserting records into the database in BPC?
Via Work Status
Via Business Rules
Via Distributor and Collector
Via Audit
For which scenario is it impossible to use the work status?
To allow or disallow a user to modify data
To lock a region of data in a application
To lock a step in a Business Process Flow
To track the status of a planning process
What actions are possible with work status? (Choose 2)
Using it only with entity and time type dimensions
Bypassing it while executing a data management package
Linking it to multiple hierarchies for an Application
Launching it from the content library
User1 is the parent owner and user2 is the children. What happens when user2 sets a work status? (Chose 3)
If it is set to "Manager", user1 can post a journal
If it is set to "All", only user1 and user2 can post a journal
If it is set to "Locked", neither can post a journal.
If it is set to "Manager", user2 can post a journal
If it is set to "Both", user1 and user2 can post a journal
Which step is required to store a comment to a filled cell in an Excel pop-up in BPC for Net Weaver?
Save the Excel workbook locally
Enable comments in the Application parameters
Assign a keyword
Enable comments in the Application Set parameters
Comments are stored in:
Cube
Real Time cube
What interfaces can you use during the step Define Action when setting up a BPF?
Manage Books, BPC Web, BPC for Word
BPC Administration, BPC for Excel, BPC for Word
Data Audit, BPC for Excel, BPC for Power Point
Journal, BPC for Excel, BPC for Word
Who is notified when a step is completed using Business Process Flow?
BPF User
BPF Manager
BPF Owner
BPF Reviewer
Who is notified when an activity is submitted in the Bussines Process Flow?
Performer
What are the required dimensions to create the BPF instances?
Time and Category
Entity, Category and Time
A step is re-opened? What is the next step status?
Open
Re-Open
Pending
Delayed
Approved
Dimension Logic
Conversion Fields
Data Manager Packages
What DIM is same for all models in consolidation step?
Category and Time
Category, Entity, Time
Category, Group, Time
Category, Group, Time, Entity
What applications do you need for Consolidation as mandatory application?
Which fields are required to eliminate the investment when using the All Formula? (Choose 2)
Source Account
Destination All
Destination Group Account
Destination Equity Account
Destination Minority Interest
What needs to run before ownership elimination?
Account transformation
Intercompany book
What fields are required to eliminate the investment when using the "All Formula"? (Choose 2)
Destination group account
Destination equity account
Destination minority interest
Destination All Account
How manu journal templates are in a model?
N no of journal templates
Only one journal template per application
Based on the no of dimensions
Journal templates are app specific
For which users does the system prevent saving templates to the company folder? (Choose 2)
For a non admin user with the Manage Template task
For a non admin user without the Manage Template task
For a user with the Primary Admin default function task
For a team leader with the Manage Template task
For a team leader without the Manage Template task
What determines the user access to BPC applications? (Choose 2)
Profile SAP_ALL
Secured Dimensions
Member acces profile
User/Team assignment
Which objects do not get trasported in SAP Business Objects Planning and Consolidation for Net Weaver?
Multiproviders
Roles
Journal Templates
Where is achieved audit data stored in BPC for the SAP Netweaver technology platform?
In a flat file
In a BW InfoCube
In a BW table
In a Data Store Object
Where do you set the data audit to capture transactional data changes?
At Appset level in Admin Console
At Appset level in Web Admin
At Application level in Admin Console
At Application level in Web Admin
For which dimension can you activate a data audit trail for an Application?
What data managment option is required to load transaction data from a file to a BPC application?
Maintain data managment
Run the data management package
Organize the package list
Download the data file
What task are accomplished during full optimization in BPC for Netweaver? (Choose 2)
Creating a copy of the MultiProvider for the BPC Application
Closing the open request after posting 50.000 records
Updating DB statistics for the InfoCube
Compressing and Indexing the InfoCube
Executing a data model analysis and alerting if the data model can be improved.
What is the consequences in BPC for Net Weaver when updating the web admin parameters without entering the required parameters?
Warnings
Nothing
Crashes
Errors
What task can be done using the Web Administration? (Choose 2)
Changing documents type but not documents subtype
Activating but not deactivating auditing
Adjusting the version number of a report template
Setting up file types
Which of the following are required for an import? (Choose 2)
Conversion
Flat File
Transformation
Dynamic Template
During testing you notice that account descriptions are missing. How do you resolve this issue?
Import transaction data
Import master data descriptions
Refresh dimension members
Import master data hierarchies
Which package group is customer-specific in SAP BO Planning and Consolidation for Net Weaver?
Financial Processes
Data Managment
Reporting Management
System Administrative
Procesing a dimension does the following:
Validate Dimension member formulas
Validate Hierarchy
Update member data into BW
BW attribute change run
Which objects do not get transported in SAP Business Objects Planning and Consolidation:
MultiProviders
What program can you use to validate the consistency of an application set after copying the standar application set?
UJA_DATA_CHECKER
UJA_COPY_APPSET
UJA_APPSET_INFO
UJT_CHECK_TABLE_ENTRIES
Which default function task type always includes Appset maintenance?
Administration
Primary
System
Secondary
What solution for uploading master data into BPC for Netweaver requieres customer-specific process types?
Loading data directly into the dimension member sheet
Loading data via flat file using BPC Data Manager
Loading data via flat file using BW
Loading data from a SAP BW InfoObject into a BPC dimension using BPC Data Manager
Which parameter in the options list of a transformation file is available only in BPC for the SAP Net Weaver technology platform?
DELIMITER
SELECTION
VALIDATERECORDS
AMOUNTDECIMALPOINT
When you load the data to the BPC infoprovider you want to delete the existing data and reload the new data what options you use:
Merge and replace the date
Append the date
Delete and do a full load
Replace and clear
Merge the data
What are the out of the box solution for loading master data load? (Choose 2)
Load Master Data from SAP ERP directly into BPC, version for SAP Netweaver
Load Master Data from SAP Netweaver BI Characteristic Directly using data manager
Flat file by DM
Flat file in BW
What are the out of the box solution for loading the transaction data load?
Load transaction data from SAP Netweaver BI using an Openhub destination that provides flat files to data manager (Delta load)
Load transaction data from SAP Netweaver BI Infocubes directly using data manager custom process type (Delta load)
Load transaction data via flat file via SAP Netweaver BI dataflow.
Load transaction data via UD Connect (SAP Netweaver Dataflow)
Load transaction data via flat file using BPC Data Manager
Where are the achieved reports stored in BW?
SAO
Write DSO
Real Time Infocubes
Tables
Which of these transformations file options is unique for NW setup?
MAXREJECTCOUNT
VALIDATION
SELECT
Performance is critical to the BPC application. The use of light and full optimization is possible. What activity is unique to a full optimization?
Zero compression during elimination
Check the data model
Close the open request
Update data statistics for the cube
What task are accomplished during full optimization in BPC for NW? (Choose 2)
Creating a copy of the multiprovider for the BPC application
Upadating DB statistics for the Infocube
Compressing and indexing the Infocube
Executing a data model analysis and alerting if the data model can be improved
Which section of the transformation file would be used to assing BW Characteristic to BPC Dimensions? (Choose 3)
Options
Mapping
External and Internal
Which folder must store the conversion files?
Company
C Drive
Wizard
Books
Which component of BPC can be used to execute series of data manager packages in sequence?
Package
Package group
Package list
Package link
Package process
Which of the following objects are required when executing an upload of data into BPC using a data manager process?
Conversion files
Transformation files
Trasnformation rule
Process chain
Which of the following task can be performed as a background job via process chain?
Copy Application
Modify Application
Optimized Application
Copy Appset
