01/20100
Konzerv BI: adatpiacok
A cím az SAP Rapidmarts előre csomagolt adatpiac megoldásaira utal, amellyel nulla vagy minimális adattárház oldali fejlesztés mellett, különböző forrásrendszereinkből kinyert adatainkat előre elkészített adatpiacba tölthetjük, majd az áttöltött adatokon (illetve az azokra épített univerzumon) futtathatjuk jólfésült előregyártott riportjainkat. Mindezt az SAP olyan varázsszavakkal ajánlja a nyájas BI bevezetésért felelős projektmanager figyelmébe, mint az alacsony TCO és a soha nem látott ROI (ez a kijelentés a kishíján 20 lepedős ár tekintetében piciny túlzásnak tűnik :).
A rapidmartok a BO Data Integrator ETL eszköz addon komponenseként érhetőek el, a támogatott forrásrendszerek az SAP, Oracle E-Business Suite, Siebel (elvileg, de ez SDN-en nem elérhető) és a PeopleSoft.
Rapid Mart a BI stack-ben
A különböző forrásrendszerek egyes funkcióihoz külön rapidmartokat telepíthetünk, amelyek tartalmazzák a létrehozandó adatpiac DDL-jét, az azokat töltő BODI jobokat, az univerzumot és az arra épülő előre legyártott BO riportokat. A töltőeljárások további testreszabásával természetesen újabb adatkörök is riportálhatóvá tehetőek, de ez BODI / ABAP / PLSQL illetve adattárház és univerzum oldali fejlesztést igényel.
A rapidmartok által lefedett adatkörökről a rapidmartok installcsomagjába rejtett business guide szolgál bővebb információval, mi most eláruljuk, hogy milyen riportokra számíthatunk egy-egy konzerv adatpiac telepítése után. A sample riportok listáját szorgosan idepublikáltuk, mivel ez az összesítés - legjobb tudomásunk szerint - sehol máshol nem lelhető fel.
SAP
SALES rapidmart
Sales Orders
• Sales Order Discount Analysis
• Number of Deals Trend Analysis
• Bookings vs Returns
• Returns Trend Analysis
• Top 10 Bookings
• Booking Trends
• Top Sales Reps by Quarter
Deliverables and On-Time Delivery
• On-time Delivery Trends
• On-time Delivery Details
• On-Time Delivery Summary
• On-Time Delivery Top 10 Customers
• On-Time Delivery Top 10 Documents
Billing
• Operational Revenue per Quarter
• Bookings vs Billings
• Credit Memo Analysis
• Credit Memo Customer Detail
• Credit Memo Trends
Backlog
• Backlog Analysis
Schedule Lines
• Sales Orders Scheduling Efficiency.
Sales Order History
• Deleted Sales Order Audit
Document Flow
• Sales Order History Document Flow
Invalid Documents
• Sales Order Data Validation
• Billing Data Validation
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
PURCHASING rapidmart
Purchase Requisition
• Requisition Listing
• Requisition Analysis
Purchase Document
• Purchase Order Listing
• Purchase Order Details
• Top 10 Purchased Item Analysis
• Purchase Order Statistics
Purchase Pricing
• Purchase Pricing Conditions
• Purchase Pricing Condition Trend
Purchase Schedule Line
• Goods Receipt Scheduling Efficiency
Invoice Receipt
• Invoice Receipt Detail
• Receiving Plant Trend Analysis
Purchase Document History
• Purchase Cycle Detail
• Purchase Cycle Trend Analysis
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
PROJECT SYSTEMS rapidmart
Milestone
• Milestone Overview
• Milestone Statistics
Network (Production) Order
• Network Order Details
• Network Order Analysis
Network Relationship
• Network Relationship Overview
Project Cost
• Project Balance Trend Comparision
• Project Balance Trend by Period
• Project Balance Variance Trend
• Project Cost YTD Trend Analysis
• Project Cost Period Comparison
PRT Assignment
• PRT Assignment Listing
• PRT Details
Order Operation
• Project Structure Planning
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
PRODUCTION PLANNING rapidmart
Work Center
• Work Center Cost Details
Capacity
• Capacity Requirements Listing
• Capacity Intervals of Availability
MRP Results
• MRP Listing
Planned Order
• Planned Order Analysis
• Planned Order Listing
Reservation
• Reservation Costing Analysis
• Reservation Listing
• Reservation Details
Routing
• Routing Listing
• Routing BOM Statistics
Bill Of Materials
• Production BOM Listing
• Production Multilevel BOM Detail
Production Order
• Production Order Details
• Production Order Analysis
Production Operation
• Production Order Operation Listing
• Production Order Operation Details
• Production Operation Variance Analysis
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
PLANT MAINTENANCE rapidmart
Service Notification
• Notification Listing
• Notification Details
• Notification Statistics
• Equipment Failures Analysis
MTBR MTTR
• MTBR MTTR Analysis
• MTBR MTTR Listing
Service Order
• Service Order Analysis
• Service Order Listing
Service Operation
• Service Operation Detail
• Service Operation Analysis
• Service Operation Listing
Service Confirmation
• Service Confirmation Listing
• Service Confirmation Details
• Service Confirmation Performance
Service Order Cost
• Service Cost Balance Trend Comparison
• Service Cost Balance Variance Trend
• Service Cost YTD Trend Analysis
Service Master
• Functional Location Characteristics
• Equipment Characteristics
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
INVENTORY rapidmart
Material Movement
• Material Movements
• Material Movement Trends
• Material Document Listing
• Material Movement Inventory by Plant
Inventory
• Inventory Analysis
• Inventory Daily Snapshot
• Change in Inventory
Batch Inventory
• Batch Inventory Availability
Physical Inventory
• Physical Inventory Plant Variance
• Physical Inventory Trend
Stock Valuation
• Stock Valuation
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
HR rapidmart
Employee Administration
• Employee Listing
• Company Employee Analysis
• Employee 360 Overview
• Employee Change History (Valid Between Dates)
• Employee 360 Snapshot (As Of)
Leave Entitlement
• Leave Entitlement Listing
• Leave Entitlement Details
Benefit Enrollment
• Benefits Participation
• Benefits Participation Details
• Benefit Enrollment Analysis
Employee Wage
• Wage Analysis
• Employee Wage History
• IDES Sample Employee Wage Summary
Payroll
• Payroll Run Details
• Employee Payroll Details
• Payroll Trend Analysis
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
COST CENTER rapidmart
Cost Details
• Transaction Summary by Material
• Transaction Detail Listing
• Top 10 Vendor Cost Accounting Docs
Cost Summary
• Cost Center Actual-Planned-Variance
• Cost Center Activities
• Cost Summary Trend by Cost Center
• Cost Summary Trend by Cost Element
• YTD Cost Drilldown by Activity and Cost Center
• Cost Summary Actuals Analysis
• Cost Summary Rolling 12 Periods vs. Period Comparison
Profit Center Details
• Profit Center Detail Trend Analysis
Profit Center Summary
• Profit Center YTD vs. Period Trend Comparison
• Profit Center YTD Trend by Account
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
ACCOUNTS RECEIVABLE rapidmart
Accounts Receivable Details
• Discount and Payment Trend Analysis
• Discount Trend Analysis
• Late Payment Trend Analysis
• AR Customer Item Listing
• Accounts Receivable Expected Cash Flow Ranking
• Aging Receivables Ranking
• Receivable Amounts Past Due Aging
• Receivables Paid Late Ranking
• Receivables Paid Late Trend Analysis
• Open Receivables Targeting
• Unapplied Payment Analysis
Account Receivable Summary
• AR Revenue Trend Analysis
• Top 10 Customer AR Revenue Analysis
• AR Revenue Year Trend Comparison
• Cumulative AR Activity Period Trend
• Revenue Rolling 16 Periods versus Period Comparison
• DSO Analysis
• 360 Customer Snapshot
• 360 Customer Trend
Invalid Documents
• Customer Item Validation
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
ACCOUNTS PAYABLE rapidmart
Vendor Items
• Discount and Payment Trend Analysis
• Discount Trend Analysis
• AP Expected Cash Disbursements Ranking
• Aging Payables Ranking
• Payables Amounts Past Due Aging
• Open Payables Targeting
• Unapplied Payment Analysis
• Days to Pay Profiling on Closed Items
• Employee Benefits Expenses
• Invoice Threshold Summary List
• Payments On Hold (Payment Block)
• Spend Analysis Trend
• AP Vendor Item Listing
• Top 10 Vendor Invoices
Vendor Summary
• AP Expenses Trend Analysis
• Top 10 Vendor AP Expense Analysis
• AP Expenses Year Trend Comparison
• Cumulative AP Activity Period Trend
• Expenses Rolling 16 Periods vs Period Comparison
• DPO Analysis
• Vendor 360 Snapshot
• Vendor 360 Trend
Checks Fact
• Payment Summary
Vendor Financial Documents
• PO Accounting Posting Details
Purchase Order and Purchase Order History
• Top 25 Purchase Orders
• Purchase Order History
Invalid Records
• Vendor Item Validation
SAP Master Data Reports
• Activity Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Profit Center Hierarchy Data Discovery
• Cost Element Hierarchy Data Discovery
• Internal Order Hierarchy Data Discovery
• Functional Area Hierarchy Data Discovery
• GL Account Hierarchy Data Discovery
• FS Account Hierarchy Data Discovery
• Project Element Hierarchy Data Discovery
• Equipment Hierarchy Data Discovery
• Functional Location Hierarchy Data Discovery
• Work Center Hierarchy Data Discovery
• BOM Hierarchy Data Discovery
• Organization Unit Data Discovery
• Position Data Discovery
ORACLE
HR rapidmart
Employee assignment
• New Hire report
• Employee TurnOver
• Employee Listing Report
• Salary Administration
• Employee Headcount
Payroll Run
• Payroll Activity Summary by Department
Payroll Balance
• Assignment within Government Reporting Entity Year to Date
Employee Absence
• Yearly Employee Absence by Department
• Yearly Employee Absence by Reason
Benefits Enrollment
• Benefits Enrollment Summary
• Company Benefits Structure
• Company Benefits Structure Rates
Employee Training
• Employee Training Attendance by Department
SALES rapidmart
Order
• Top 5 Customers
• Bookings and Returns for a Selected Customer By Product
• Backlog Details by Operating Unit by Product
Shipment
• Average Order-to-Delivery Cycle by Customer by Product
• Delivery Dates Deviation by Operating Unit by Customer and Shipping Method
Billing
• Company Revenue by Operating Unit by Sales Rep
• Invoice Summary by Operating Unit by Month by Product for the Current Year
PURCHASING rapidmart
Purchase requisition
• Requisition Listing
• Requisition Accounting Analysis
• Requisition Accounting Hierarchy Analysis
Purchase order
• Purchase Order Listing
• Purchase Order Details
• Top 10 Purchased Item Analysis
• Purchase Order Statistics
• Purchase Order Accounting Trends
Purchase Receipt
• Receiving Transaction Detail
• Shipping-Receiving Location Trend Analysis
Purchase Order History
• Purchase Order History
• Purchasing Cycle Trend Analysis
Hierarchy Data Discovery
• Account Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Company Hierarchy Data Discovery
• Project Hierarchy Data Discovery
• Product Hierarchy Data Discovery
PROJECTS rapidmart
Budget Line
• Budget Line Analysis
Budget Summary
• Budget Summary Analysis
Expenditure
• Expenditure Cost
• Expenditure Cost Trend Analysis
• Expenditure Revenue
• Expenditure Revenue Trend Analysis
Event
• Event Distribution Analysis
Project Asset
• Project Asset Listing
Project Summary
• Project Summary Analysis
• Project Summary Cumulative Trend
Project Txn Summary Trend
• Project Txn Summary Trend
• Project Txn Summary Top 10 Analysis
Hierarchy Data Discovery
• Account Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Company Hierarchy Data Discovery
• Project Hierarchy Data Discovery
• Product Hierarchy Data Discovery
Inventory rapidmart
Material
• Stock Issue and Receipt by Item Category
• Subinventory Transfer Summary
Inventory Snapshot
• Inventory Snapshot
Physical Inventory
• Physical Inventory Approved Adjustments
Reservation
• Current Reserved Items
GL rapidmart
Budgeting and Balances
• Cost Center Period Actual-Planned-Variance
• Cost Summary Trend by Cost Center
• GL Balance Sheet Trend by Year-Period
• GL Balance Variance Trend
• Account YTD Trend Analysis
• GL Account Balance Period Drill-down Analysis
• GL Accounts by Cost Center Drill-down Analysis
• GL Income Statement by Line - Period Comparison
• Income Statement Line Trend
Journal Entry
• Journal Transaction Listing
• GL Journal Details
• GL Posting by Source
• GL Analysis by Source
• GL Entry Source Trend Analysis
• Manual Postings Audit
Intercompany Transactions
• Intercompany Reconciliation
Hierarchy Data Discovery
• Account Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Company Hierarchy Data Discovery
• Project Hierarchy Data Discovery
• Product Hierarchy Data Discovery
Invalid Currency Conversions
• GL Balances Currency Validation
• Journal Entry Currency Validation
FIXED ASSETS rapidmart
Asset Books
• Current Assets Listing
Asset Distribution
• Asset Distribution by Location
Asset Depreciation
• Depreciation by Category
Asset Transaction
• Transaction History by Transaction Type
Asset Retirement
• Asset Retirement
• Asset Retirement Distribution
Asset Invoice
• Vendor Invoice Listing
FEDERAL FINANCES rapidmart
Journal Entry
• List of Unposed Account Payables transactions
• General Ledger Detail Trial Balance
• Total Year Activity
Account Budgeting and Balances
• Status Of Funds
• Agency Expenses by Object Class
Budget Execution
• Budget Execution Transactions not Transferred to GL
• Available Appropriation Parameters
Payables
• Prompt Pay or Accounts Payable Aging
• Top Spending Accounts List
Commitment and Obligation
• Unliquidated Obligations Aging
• Purchase Order Listing
CONTRACT rapidmart
Contract Line
• Customer Lifetime Contract Listing
• Contract Status
• Contract Hierarchical Display
Contract Rule
• Contract Rules Validation Report
Contract Billing
• Year-to-Date Contract Billing Activity by Customer
• Pending Contract Billing Transactions
Contract Sales
• Service Contract Bookings
• Contract Sales Credits and Booking by Sales Reps
ACCOUNTS PAYABLE rapidmart
Invoice Line
• Overall Company Expense Trend Analysis
• Top 10 Vendor AP Expense Analysis
• Vendor Invoice Detail
Invoice Accounting Distribution
• Spend Analysis Trend
• AP Posting Detail
• Unposted AP Invoices
• AP Expense Trend Analysis
• Top 10 General Expense Transactions
• Vendor Expense Trend Analysis by Product Segment
Invoice Summary
• YTD Vendor Invoice Statistics
AP Payment Schedule
• DPO Ranking
• Open Payables Targeting
• 360 Vendor Snapshot
• 360 Vendor Trend
• Discount Trend Analysis
• Late Payment Trend Analysis
• Payables Amounts Past Due Aging
• Days to Pay Profiling on Closed Items
• Invoice Threshold Summary List
• AP Duplicate Invoices
• Open Vendor Invoices
• AP Payment Listing
• AP Duplicate Invoice Detail
Payables Check
• AP Check Detail
Invoice Hold
• On Hold Invoice Analysis
Invoice Payment
• Payment Summary
Invoice Payment Distribution
• Payment Trend Analysis
Hierarchy Data Discovery
• Account Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Company Hierarchy Data Discovery
• Project Hierarchy Data Discovery
• Product Hierarchy Data Discovery
ACCOUNTS RECEIVABLE rapidmart
Payment Schedule
• AR Discounts & Payments
• DSO Ranking
• AR Open Customer Invoices
• Open Receivables Targeting
• 360 Customer Snapshot
• 360 Customer Trend
• Discount Trend Analysis
• Late Payment Trend Analysis
• Receivable Amounts Past Due Aging
Billing Invoice Distribution
• Overall Company Revenue Trend Analysis
• AR Invoice Posting Detail
• Unposted AR Invoices
• AR Revenue Trend Analysis
• Top 10 Customer AR Revenue Analysis
• Customer Revenue Trend Analysis by Product Segment
Cash Receipts
• AR Cash Receipt Detail
Receipt Application
• Unapplied Receipts Listing
• On-Account Aging Analysis
Dunning Activity
• Customer Dunning Listing
• Top 10 Delinquent Customers
• Collector Efficiency Ranking
• AR Dunning Activity Trend Analysis
Hierarchy Data Discovery
• Account Hierarchy Data Discovery
• Cost Center Hierarchy Data Discovery
• Company Hierarchy Data Discovery
• Project Hierarchy Data Discovery
• Product Hierarchy Data Discovery
PEOPLESOFT
HR rapidmart
Job Transaction
• Employee Turnover
• Headcount by Department
Absence History
• Absence by Department
Training
• Training Course Attendance
Benefit
• Benefit Plan Summary
Payroll
• Monthly Payroll by Location
GENERAL LEDGER rapidmart
Journal Entry
• Journal Detail Report
GL Balances
• Asset Account Trial Balance
• Period Net Activity Drill
• Actuals Profit and Loss Report
Budget Sections
• Actual V Budget Report
• Budget Profit and Loss Report
ASSET MANAGEMENT rapidmart
Asset Books
• AssetListing
Asset Transactions
• AssetHistoryTransactions
Asset Deprecation
• Depreciation report
Asset Accounting
• AssetAccountingEntries
Asset Retirement
• RetirementReport
ACCOUNTS RECEIVABLE rapidmart
Billing
• Customer Invoice Details
• Invoice Line Details
Payment Schedule
• DSO by Customer
• Receivables Aging
• Cash Flow Details
Cash Receipt
• Payment Status Detail
• Item Line Payment Analysis
ACCOUNTS PAYABLE rapidmart
Voucher Summary
• Open Invoice Details
• Item by Supplier Details
Distribution Line Selection
• Payables Distribution
• Top 10 Spending Accounts
Open Liabilities
• On-hold Payment Detail
• Aging Category Analysis
Payment Section
• Top 10 Supplier Payments
• Payment Register Analysis
A bejegyzés trackback címe:
Kommentek:
A hozzászólások a vonatkozó jogszabályok értelmében felhasználói tartalomnak minősülnek, értük a szolgáltatás technikai üzemeltetője semmilyen felelősséget nem vállal, azokat nem ellenőrzi. Kifogás esetén forduljon a blog szerkesztőjéhez. Részletek a Felhasználási feltételekben és az adatvédelmi tájékoztatóban.