BW prperties in Solution Manager

[Former Member]

Hi

we have a requirement where we want to bring SAP soltion manager data from solution manager to BW system and the generate the report over. so my question is as we have the standard sources in R/3 system do we have standard data sources in soultion manage. how to do the connection between solman and bw system to bring the data in Bw system.It would be great if we can share of the data sources names which are available in solman and transaction codes to view the stanadard data sources.

Regards

PremG

[mateus_pedroso · Accepted solution]

To check how is the configuration in Solution Manager, do the following:

Go to transaction SOLMAN_SETUP => Basic Configuration => Step 4 User Data =>

Fulfill this informations firstly

Provide information for your BI configuration

Is BI installed in a separate System ? Client ?

Check this step below too of step 6.

Activate BI Source System Performed Display

Adjust BI Authorization Concept

[raguraman_c]

Hi,

Inbuilt BW Component is available in Solution Mnager, why not leverage that. There are standard BI Content avaialble for Solution Manager. Search as SM* (Technical name).

You need to run CCMBISETUP

And while running SMD Managing system configuration you need to pass the correct BI System details.

Hope this helps.

Feel free to revert back.

-=-Ragu

[Former Member]

Hi Raguraman

Thank you so much for you prompt response!!!!

Here my concern not about the BW performance.... we have a solution manager Service desk + CHARM in my landscape. whatever changes or work we are doing will create a ticket for that. Here my concern is to view the Solman service desk ticketing data is input for BW reporting system.please find the following requirent and please advise us to proceed futher.....

Like we would like to have to extract certain data from Solman (Like list of all projects, list of project status etc.) to BW system, so that we can capture this data in some cube in BW and create report over the same.

Please find the Solman service desk inputs to BW system

==============================================

Monthly Reports

1. Regional Reports

a. Project Updates

i. List of all projects started in each Region

ii. List of all projects completed in each Region

iii. Status of all ongoing projects in each Region

iv. List of ongoing issues in each Region

b. Support Updates

i. Ticket taxonomy

1. Break/fix

2. Small enhancements (< x hours)

3. Large enhancements

ii. Ticket process

1. New tickets over the period

2. Closed tickets over the period

3. Current Backlog

2. Global Tower Reports

a. Project Updates

i. List of all PMO projects started in each Region

ii. List of all PMO projects completed in each Region

iii. Status of all ongoing PMO projects in each tower

iv. List of ongoing issues impacting PMO projects in each tower

b. Resource Allocation

i. Work Types

1. % capacity spent on project work

2. % capacity spent on support work

a. Break/fix

b. Small enhancements

c. Large enhancements

3. % capacity spent on training

ii. By Business Unit: % capacity spent on

1. By Region Unit: % capacity spent on

1. Asia customers

2. Europe customers

3. Americas customers

iv. If RTL leveraged non-Harman resources, then

1. Total hours

2. Functions performed

3. Ongoing issues with provider(s)

c. Outstanding Global Service Provider Nomination

3. Global Reports

a. Resource Allocation

i. Work Types

1. % capacity spent on project work

2. % capacity spent on support work

a. Break/fix

b. Small enhancements

c. Large enhancements

3. % capacity spent on training

ii. By Business Unit: % capacity spent on

iii. By Region Unit: % capacity spent on

1. Asia customers

2. Europe customers

3. Americas customers

iv. If GTL leveraged non-Harman resources, then

1. Total hours

2. Functions performed

3. Ongoing issues with provider(s)

b. Outstanding Global Service Provider Nominations

4. Resource Updates

a. New Hires

b. Status of open reqs

c. New openings

d. Ongoing resource issues

Regards

PremG