QlikView SAP Templates known as "SAP Qlikstart Templates" are pre-built QlikView applications to be used with QlikView SAP Netwaver connector. QlikStart templates provide a sample set of key information deliverables for your SAP™ modules that combine data extraction scripts, pre defined calculations and a variety of sample analyses in a front end application combining dashboards, charts and reports. QlikStart templates contain value for both IT and the business, for IT a series of predefined extraction scripts with table joins and calculations provide valuable insight. The business user can start using the predefined reports to analyse their business within a very short time.
SAP_PS_QlikStart
You can download SAP Qlikstart Templates here. The link contains a 29 MB Rar file which has three documents for each template below : two QlikView qvw files for data extraction and actual application and a document to explain how to setup these QlikView SAP templates.
If you do not have a licensed QlikView application, you will not be able to open these applications. Fortunately some of the templates are also available online for you to experiment with using nothing more than your browser. We have added explanation and link for such templates below. The QlikView applications in the template are:
SAP_AP_QlikStart
This QlikStart for SAP Accounts Payableallows you to rapidly analyze the following KPIs:
- Analyze each suppliers A/P status.
- Make an action on inactive accounts
- Analyze amounts by buckets
- Analyze days of sales outstanding
- Ad Hoc analysis of aged debt
SAP AP – Accounts Payable allowing you to analyse aged debt, DSO and payment information by company, business area, supplier plus many others. Business questions answered include:
- What percentage of my company suppliers have an aged debt of over 150 days?
- What is the payment profile of my suppliers?
- What is the Overdue payment and DSO split for my companies and suppliers?
- Plus the ability analyse individual payment items down to document number.
Click on the image below to access the browser based application.
 |
| SAP AP – Accounts Payable QlikView Template |
SAP_AR_QlikStart
This QlikStart for SAP Accounts Receivable allows you to rapidly analyze the following KPIs:
- Analyze each suppliers A/R status.
- Make an action on inactive accounts.
- Analyze amounts by buckets
- Analyze days of sales outstanding.
- Ad Hoc analysis of aged debt
This QlikStart for SAP Controlling allows you to rapidly analyze the following KPIs:
- Analyse actual and planned costs by company
- Analyse cost centre variance
- Analyse profit centre details
- Drill down to individual account code details
- Analyse account and activity cost items
This QlikStart for SAP HR allows you to rapidly analyze the following KPIs:
- Analyze Company Employee Distribution
- Identify Employee Demographics
- Monitor Employee Absentees
- Analyse Pay and Hours
- Be Empowered to Make Faster More Accurate Decisions
This QlikStart for SAP Materials Management allows you to rapidly analyze the following KPIs:
- Analyze purchase order spend and quantity
- Analyze requisitions over time and by plant
- Analyze reminders/urging documents
- Overview of physical inventory
- Analyze invoiced purchase orders
- Analyze deliveries by qty and time
SAP MM – Materials Management – Purchasing allowing you to analyse supplier purchase order spend, requisitions, documents,physical inventory by supplier, plant, purchasing organisation plus many others. Business questions answered include:
- How much do my purchasing organisations spend annually?
- Which plant has the highest purchase requisition amount?
- What are the invoice numbers for my highest purchase order values?
- Plus the drill down capability to individual purchase order numbers.
 |
| QlikView Template for SAP MM |
SAP_PP_QlikStart
This QlikStart for SAP Production Planning allows you to rapidly analyze the following KPIs:
QlikStart for SAP Production Planning allows you to rapidly analyse the following KPI's:
- Analyze production orders by plant and material
- Analyze routings by type and operation
- Analyze capacity requirements by work centre and plant
- Analyze capacity details
- Analyze work centre breakdowns by plant
- Analyze BOM components
This QlikStart for SAP Project Systems allows you to rapidly analyze the following KPIs:
QlikStart for SAP Project Systems allows you to rapidly analyse the following KPI's:
- Analyze actual and planned project costs
- Analyze project spend by company and WBS
- Analyse project cost variance
- Analyze network schedules and time scales
- Drill down to WBS elements and networks
- Analyse completed milestones
SAP_SD_QlikStart
This QlikStart for SAP Sales and Distribution allows you to rapidly analyse the following KPI's:
- Analyze Billing by company,division,sales organisations
- Analyze Billing by fiscal trends
- Analyze deliveries by company,division,sales organisations
- Analyze sales roders by company,division and sales organisations
- Drill down to individual sales ordersAnalyze on time and late deliveries
SAP SD – Sales and Distribution allows you to analyse billing, sales orders, shipments and schedules by company, division, customer, sales organisation plus many others. Business questions answered include:
- Who is my best customer from a sales perspective and which product do they buy?
- How many deliveries are late / on time?
- Which Materials and divisions generate the highest margin?
- How is the billing compared to last year and how does it trend over time?
- Plus the ability to drill down to individual sales order and billing document line item detail.
Click on the image below to access the browser based application.
SAP_FI_GL_QlikStart
 |
| SAP Sales Disribution QlikView Template |
This QlikStart for SAP General Ledger allows you to rapidly analyze the following KPIs:
QlikStart for SAP General Ledger allows you to rapidly analyse the following KPI's:
- Analyse chart of account hierarchies
- Analyse YTD ledger details
- Analyse customer and vendor positions
- Drill down to individual account code details
- Analyse document number and line details
No comments:
Post a Comment