Test sap reporting and database

ERASED TEST, YOU MAY BE INTERESTED ON SAP REPORTING and DATABASE

COMMENTS	STATISTICS	RECORDS

TAKE THE TEST

Title of test:
SAP REPORTING and DATABASE

Description:
REPORT and DB Elements

Author:

Manish Tiwary

Other tests from this author

Creation Date:
19/03/2014

Category: Others

Number of questions: 35

Share the Test:

New Comment

tiwarman ( uploaded 10 years )

Very Good !!

Answer

Content:

SAP ERP HCM consists of Talent Management End-User Service Delivery Workforce Process Management Data Warehouse.
Which reporting tool is particularly suited to master data and line Item reporting Ad Hoc Query =(Infoset Query in HR) SAP Query Business Warehouse.
Flat reporting means reporting on uncompressed raw data from tables. TRUE FALSE.
When multidimentional reporting is performed using the Business Warehouse data is prepared in a way that is particularly suitable for reporting.The data is stored in : Data Table View Table Infotypes Infocubes.
InfoCubes contain : Key Figures Characteristics.
Depending on the system environment , reporting tools can be divided into two categories : The ERP system (flat reporting) Business Warehouse (analytical reporting).
Tools used to execute existing reports and queries are : Human Resource Information Manager's Desktop and Manager Self service Ad Hoc Query SAP Query Information system in the SAP Easy Access Menu.
Ad Hoc Query can report on data from : Personnel Administration Organizational Management Training and Event Management Recruitment Personnel Development Payroll.
SAP Query performs the fallowing functions for reporting in HR. STEP 1 STEP 2 STEP 3 STEP 4.
The main components of business warehouse are : The business warehouse server The data warehousing workbench The business explorer Infocubes.
The HCM Business Content includes : Extractors HCM Infocubes Queries HCM Infosets.
SAP SEM HR Measure Catalog Include : Basic Key Figures Personnel Planning Recruitment Compensation and Benefits Enterprise's effectiveness Training Personnel Management Time Management.
Naming Convention are used to group HR -specific reports together : RP** RH** RPT** RPC** RPAPL**.
User who work together in the same application are grouped together in user groups TRUE FALSE.
One can easily change the Queries that belong to other user groups : FALSE TRUE.
Define distinction between two query areas : Standard Query Area Global Query Area.
The logical database you need to use when creating an Infoset is determined by the HR components on which you need to report. Recruitment Organizational Management Time Management.
For reporting on Concurrent Employment we need to access which database ? PNP PNPCE PCH PAP.
If I want to report on all HR master data infotypes I would use : PNPCE PNP PAP PCH.
Ad Hoc Query is a tool that enables you to report on following data HR master data TM,PY (PNPCE) Applicant Master Data (PAP) Data from Personnel Planning (PCH).
What are the main steps we use when working with Ad Hoc Query : Select selection output fields in the overview tree Enter a value ,and choose a selection option if necessary Execute the selection( the hit list is determined by selecting objects that match the selection criteria. Format output in the output preview Access output.
The main type of output list are : Basic list Statistics Ranked List Average List.
The technical name of a query must not exceed 14 characters, and must not contain any special character with exception of : Underscores Hyphens Exclamation Mark.
Query that contain a period can be saved but cannot be reaccessed. True False.
Ad Hoc Query can be accessed via Information System HIS Manager's Desktop Input help for Object Selection Processing of selected object set in general reporting ESS.
If you use SAP query to create queries ,note that you can create one basic list and up to nine statistics or rank lists for one query (defined using selection and output fields) True False.
A data warehouse is a standalone application environment with its own database that extracts data from diffrent data sources and is used to perform queries and analysis. True False.
Human Resources Analytics combines the strategic planning of SAP SEM with the operative planning of SAP ERP HCM to provide Integrated Business Content for extensive analysis and benchmarking. True False.
The advantage of Business Warehouse are as follows : Standardized structure and display for all corporate information Easy access to corporate information via single point of entry Highly sophisticated reporting for analysis Environment conducive to high performance Data retrieval from heterogeneous environment Day-to-day activity reporting.
The OLAP Processor Executes queries and generates diffrent views of a query. Facilitates horizontal,vertical, and hierarchical "drilldowns". Enables you to exchange characteristics Has diffrent aggregation functions.
Hierarchies are delivered in HR for the following : Organizational Structure Cost Centres Business events/business event groups Age Structure Capacity Utilization level Personnel Structure.
BW functions also enable you to create cross-application Infocubes and queries or key figures which are known as MultiCubes MutiQueries.
The primary tool used to create analysis dashboards in SAP Business Objects : BEx Analyzer Xcelsius.
Balanced Scorecard comprises of four perspectives for the success of Enterprise Financial Customer Process Learning and Development Country Specific.
Balance scorecard facilitates Defining the Goals and Cascading to employee's.. Improving HR processes Minimizing the cost incurred by employee turnover and so on Employee Planning.

Report abuse

▲