cancel
Showing results for 
Search instead for 
Did you mean: 

MSS BW Reporting [Beginner]

Former Member
0 Kudos
118

Hello all,

I'm looking into implementing BW (3.5) Reporting on our EP (7.0)'s MSS Business Package. And I don't have any idea on how to configure the MSS to show the reports in the reporting workset.

Any guides or how-to's that you can share for this? It would really help me a lot.. (Assuming I've already successfully deployed the MSS package on our EP)

Thanks in Advance.

-Jan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Jan,

Please following the steps for BI MSS Reports Workset.

Go to SA38

Run Program - FPB_LP_WRITE_ENTRIES

Workset: Reports

Technical name: com.sap.pct.erp.mss.reports

Use

This workset contains a collection of reports that are relevant for a manager.

Features

The Reports workset contains the Report page with the following iViews:

Launchpad (com.sap.pct.erp.common.reportlaunchpadpcd)

This iView is part of the Business Package for Common Partsand is called using Delta Links. In the delta link, the following application parameters are defined:

○ role=MSS

○ instance=REP

○ display_external=X

Balanced Scorecard Elements (com.sap.pct.erp.mss.balanced_scorecard_elements)

Reports in the Launchpad

BI content includes Web templates that are used to display reports in the Launchpad. To add the Web templates to the

Launchpad as example entries, execute the program FPB_LP_WRITE_ENTRIES with the MSS role and the REPinstance.

Irrespective of the logon language, the program adds example entries with descriptive texts in English. The example entries provide you with an indication of how you can use the Launchpad. In Customizing for the Launchpad, you can tailor the example entries to suit your requirements.

Some of the Web templates are also available as iViews in other locations within MSS:

Cost Centers u2013 Cost Pools under Budget

Budget Consumption: Overview under Planning

● Headcount under Team

● Headcount FTE under Team

For information about a manager's personnel area, you can also integrate Manager's Desktop reports in the Launchpad. For more information, see HCM Reports.

Please find the list of BI reports used in Portal for MSS

1. Quarterly Results by Profit Center

This report shows the costs and revenues, together with theprofitability, for each quarter on your profit centers accordingto period accounting.

2. Results by Profit Center and Manager

This report shows the revenues, costs and profitability for eachprofit center together with the name of the responsible manager.

3. Cost Centers: Cost Blocks Graphic

This report shows the actual and forecast values for the main cost blocks on your cost centers in graphical form.

4. Cost Centers: Cost Blocks

This report shows the costs, commitments and forecast for eachcost center together with the name of the responsible manager.

5. Cost Centers: Operating Expenses

This report shows the planned and actual expenses for your costcenters by period and year.

6. Cost Centers: Planning Data

This report shows the data planned for your cost centers by costelement, statistical key figure and activity type.

7.Orders: Operating Expenses

This report shows the planned and actual expenses for yourinternal orders by period and year, together with the associatedbudget.

8.Projects

This report shows the internal orders used to represent theprojects together with the planned costs, actual costs andcommitments for the project.

9.Headcount

These reports shows the headcount for the organizational unitsyou are responsible for and by time periods you select. Thefollowing information is given: Headcount in full numbers,headcount expressed in FTE, the employee entries and leavings.

10. Illness/Overtime

This report shows overtime and illness time and cost infomationfor organizational units you are responsible for and by timeperiods you select.

11. Employee Availability

This report shows the availability of employees in a particularrole together with their assignments, working time and pay ratesby organization and service area.

12.Employee Utilization

This report shows the absences (availability) and assignments ofemployees in a particular role by organization and service areaon a daily, weekly and monthly basis.

13. Qualifications

This report shows the assignments, demands and the resourcesqualifications required by an assignment.

Points if helpful

Close thread if problem solved

Thanksyou,

Regards

Vijai

Former Member
0 Kudos

This is great, Vijai. A big help. Thank you very much.

Points given.

Answers (2)

Answers (2)

Former Member
0 Kudos

if you have not configured ure BI with portal u will nedd to follow below steps:

Step 1: Create RFC Destination in J2EE Engine......................................................................................4

Step 2: Create RFC Destination for the Portal..........................................................................................5

Step 3: Maintain Portal Server Settings for the Portal...............................................................................7

Step 4: Maintain Single Sign-On in the BI System....................................................................................8

Step 5: Export BI Certificate to the BI System..........................................................................................9

Step 6: Import BW Certificate to the Portal.............................................................................................10

Step 7: Create BI System in the Portal....................................................................................................12

Step 8: Configure User Management in the Portal.................................................................................15

Step 9: Export Portal Certificate to the Portal..........................................................................................16

Importing the Portal Certificate to the J2EE Engine............................................................................17

Step 10: Import Portal Certificate to BI System.......................................................................................19

Step 11: Set up Repository Manager for BI Documents and BI Metadata..............................................21

Step 12: Maintain User Assignment in the Portal....................................................................................21

Step 13: Import SAP Basis Plug-In to BI System....................................................................................22

Related Content........................................................................................................................

Former Member
0 Kudos

Thanks for the prompt response.

Are you saying that I just need to have BW integrated into EP through those steps?

And after that, the BW reports in MSS (headcount, leavers, overtime rate, etc.) will be available without further configuration? Any specific steps to configure those iViews on MSS? Is that through the Launchpad -- of which I have no idea of how to execute.

Any help would be great.

thanks.

Former Member
0 Kudos

hi,

Lauchpad integrates report from different system.. it brings report from ECC as well from BI..some of the iview in MSS also brings report from SRM, SCM or SEM.. u will need to check ivew from wehre it's bringing the data...

Basically gather ure requirementIn and look at the iview which is useful for u and from where it's fetching data, u will then need to configure that system..i mean if it is bringing data from ECC..ECC should be configured on your system..same way if it is from BI ...BI should be configured

Go thru link to understand MSS and various iView..u will then get clear picture of MSS :-

http://help.sap.com/saphelp_erp2005vp/helpdata/en/29/d7844205625551e10000000a1550b0/frameset.htm

Former Member
0 Kudos

Thanks jigar.

That input is very helpful. Will look into launchpad and hope there's an example or how-to guide from somebody who has implemented and documented this.

Again, thank you.

Former Member
0 Kudos

Hello jigar,

I have a follow-up question. When BW/BI users use Web Application Designers and publish BW iViews to our Portal, those iViews can also be integrated into the MSS via launchpad as well?

Thanks again.

-Jan

Former Member
0 Kudos

hi,

According to my knowledge i dont think it could be poss...b'coz the report which are displayed from Launch pad comes from the backend side. the configuration is done from backend side..which then displays report to us thru launchpad.

for example to display HCM manager Desktop..we run transaction PWPC_CONV_MDT_TO_LPA to display it in lauchpad

To display Bi report we execute program FPB_LP_WRITE_ENTRIES .

BI report are displayed as web template in launchpad. So i guess creating an ivew won't help...but creating WebTemplate for ure BI report will help you to display it in LaunchPad

Regards

Jigar Oza.

Former Member
0 Kudos

Much useful information, jigar. Thank you.

I guess we have to create a new role/workset and add it to the user for those iViews created from BEx WAD.

Former Member
0 Kudos

hi,

Already many of the reports are readily available from BW in MSS which may be useful for manager.

But still if you have specific requirement to bring some report from BI, u will need to create iView for particular BW reports. Refer following link to bring BW report :

http://help.sap.com/saphelp_nw04/helpdata/en/bd/3d1640d4642402e10000000a1550b0/content.htm

Regards,

Jigar Oza