BW Reports in SRM Portal

[Former Member]

Hi experts,

How i can bring BW Reports in to SRM Portal?

We have EP, BW and SRM system in our Landscape. Currently EP and BW are using BW as Datasource.

We have a new requirement in which we need to build some SRM related Reports in BW and bring to SRM Portal.

Please suggest me the best method.

Regards

Baby

[Former Member]

EP(enterprise portal) would be your window for SRM & BW access.

You need to integrate BW with SRM

build reports in BW

then provide links in SRM screens to view these reports

& SRM business packages you should import on EP

this task shld be performed by 3 guys together SRM consultant, BW consultant& EP consultant

BR

Dinesh

[Former Member]

Hi Dinesh,

Thank you for the reply.

The first session of your reply will solve my question. I need these reports in SRM Portal. So i need to look at SRM, BW Integration only. is n't?

Can tell me some more details, like how to handle permission, user mapping. Or any helpful document on SRM-BW integraton.

Regards

Baby

[former_member183819]

srm has very limited functionality on reporting part. please allign yourr self. SRM 5.0 7.0 7.0.2 Procurement Account Assignment Overview of Purchase Order Value per Requester Self-service, plan driven and service procurement 0SR_C02_Q001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Account Assignment Cost Center Overview Self-service, plan driven and service procurement 0SR_C02_Q002 MM* and SRM SRM 5.0 7.0 7.0.2 Auctions Auctions Analysis Sourcing with Live Auction 0SR_LAC1_Q0001 SRM SRM 5.0 7.0 7.0.2 Auctions Auction Items Analysis Sourcing with Live Auction 0SR_LAC1_Q0002 SRM SRM 5.0 7.0 7.0.2 Auctions Bidders Analysis Sourcing with Live Auction 0SR_LAC1_Q0003 SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Procurement Value Analysis Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Procurement Values per Service Provider Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0002 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Supplier Information Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0003 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Key Performance Indicators Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0004 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Price Trend Analysis per Product Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0005 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Number of Suppliers per Country Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0006 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) ABC Analysis for Suppliers (Lorenz Curve) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0007 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) ABC Supplier Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0008 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Success of an SRM Project Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_Q0009 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Sales Values (for Supplier) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_SUS_Q0001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Overview (multicube aggregate) Sales Values per Service Provider (for Supplier) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC01_SUS_Q0003 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Purchase Order Document Analysis Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q0001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Maverick Buying Analysis Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q0002 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Workload per Purchasing Group Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q0003 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Pareto Analysis According to Purchase Order Volume (Chart) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q0004 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Pareto Analysis According to PO Volume per Category Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q0005 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Confirmation Document Overview Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q2001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Open Items (Confirmations) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q2002 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Invoice Document Overview Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q3001 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Excessive Invoices Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_Q3002 MM* and SRM SRM 5.0 7.0 7.0.2 Procurement Document Overview (Multicube) Sales History (for Supplier) Self-service, plan driven and service procurement. Spend Analysis 0SR_MC02_SUS_Q1002 MM* and SRM SRM 5.0 7.0 7.0.2 Attributes of bids List of Bid Invitation Attributes Sourcing with RFx 0SR_QUODA_Q002 SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation w. purchasing volume Vendor Portfolio with PO Value and Overall Score Supplier Evaluation 0SR_VE_M1_Q001 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation w. purchasing volume Total Eval. / Purch. Order Value of Vendor over Time Supplier Evaluation 0SR_VE_M1_Q002 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Vendor Evaluation of Vendor by Product Category Supplier Evaluation 0SR_VE_M2_Q001 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Vendor Evaluation of Vendor by Product Category and Product Supplier Evaluation 0SR_VE_M2_Q002 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Vendor Submitted Evaluations (Vendors) Supplier Evaluation 0SR_VE_M2_Q003 MM* and SRM SRM 5.0 7.0 7.0.2 Auction Details Detailed Analysis of Bids by Category Sourcing with Live Auction 0SRM_LADS1_Q0001 SRM SRM 5.0 7.0 7.0.2 Auction Details Auction Details Sourcing with Live Auction 0SRM_LADS1_Q0002 SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Invoice Mandatory Evaluations for Invoices Supplier Evaluation 0SRV_IS1_Q001 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Invoice Optional Evaluations for Invoices Supplier Evaluation 0SRV_IS1_Q002 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Invoice Open Evaluations (Invoices) Supplier Evaluation 0SRV_IS1_Q003 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Goods Receipt/Service Confirmation Mandatory Evalns for Goods Receipts/Service Confirmations Supplier Evaluation 0SRV_IS2_Q001 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Goods Receipt/Service Confirmation Optional Evalns for Goods Receipts/Service Confirmations Supplier Evaluation 0SRV_IS2_Q002 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Goods Receipt/Service Confirmation Open Evaluations (Goods/Service Confirmations) Supplier Evaluation 0SRV_IS2_Q003 MM* and SRM SRM 5.0 7.0 7.0.2 Vendor Evaluation - Vendor Submitted Evaluations for Suppliers Supplier Evaluation 0SRV_IS3_Q003 MM* and SRM. regards Muthu br muthu mail to business id for spread sheet format of ythose reports

[Former Member]

"So i need to look at SRM, BW Integration only. is n't?" - Yes

"how to handle permission, user mapping." - Role of EP consultant

"any helpful document on SRM-BW integraton" - Config guide of

SRM Spend analysis available on service.sap.com or SOLMAN

BR

Dinesh

[Former Member]

Hi Govid,

Thank you for the reply.

We are currently working in a Datawarehousing (BW & EP) System. We need to develope some reports on SRM Data in BW and deliver to SRM Users.

So i am looking at a configuraiton point of view, how to implement this. If some guide in this direction it will be more helpful.

Regards

Baby