Skip to main content

Featured post

Golf Solutions Designed at Barnham Broom Golf Club in Norfolk

 Many sports tend to be biassed towards one sex or another. For example, football is a sport dominated by men and does not become much more masculine than rugby! On the other side of the fence, netball definitely falls into the women's category. However, there are some sports that share gender gracefully, which appeal to both men and women. Reddit live streaming Golf is undoubtedly one of these sports and has no age limits. Spread across courses in the UK you will find some unlikely groups of people bound by their love for this great outdoor sport. Some will play every day, while others will only play on the weekends, perhaps as a way to relieve the stress of a difficult week at the office. No golfer tends to join a club and membership packages vary widely in price. Most golf clubs simply offer standard packages with the assumption that one size fits all and offers a bit of flexibility. However, some offer more realistic membership packages, considering how much you will be playing...

QlikView SAP Template

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.

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 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
SAP_CO_QlikStart 
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
SAP_HR_QlikStart
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
SAP_MM_QlikStart
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.
Click on the image below to access the browser based application.

QlikView Template for SAP MM
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
SAP_PS_QlikStart 
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.

QlikView SAP Sales Disribution Template
SAP Sales Disribution QlikView Template
SAP_FI_GL_QlikStart 
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

Comments

Popular posts from this blog

What is JEDOX?

Jedox is a Self Service Business Intelligence, Analytics and Performance Management platform developed by Jedox AG based in Freiburg im Breisgau/Germany. With a modular structure, JEDOX platform uses Microsoft Excel as its user interface on the one hand and a Jedox-specific spreadsheet on the other, both of which can be used in all common browsers. Jedox is unique in a sense that while most business intelligence solutions try to replace MS Excel based analysis and planning process entirely with their platform (and usually fails to do so because at one point things are exported to Excel), Jedox puts the powerful MS Excel sheet in the heart of their solution. By doing this they provide a familiar interface to users while enhancing business intelligence capabilities far beyond MS Excel. This is actually what JEDOX offers in a nutshell : Excel Plus. The modular architecture of JEDOX has a cell-oriented, multi-dimensional in-memory OLAP server that has been especially designed for...

Hands on Power BI Workshop in Singapore - Dashboard in a Day

Power BI Dashboard in a day is a hands-on workshop for Business Analysts, covering the breadth of Power BI capabilities. At the end of the workshop you will Understand the value of Power BI Have basic exposure with the product to be able to use it when they return to their office Understand how Power BI differentiates from the competition and become Power BI advocates in their organization Know what the next steps to learn more about Power BI and become part of the community. The workshop is 200 SGD per attendee. See below for the agenda. Date       : 15 February 2019 09:00 AM - 05:00 PM Venue     :  87 Beach Road Chye Sing Building #03-01 Singapore, Singapore 189695 Agenda  : Morning – Introduction to Power BI and Power BI Desktop overview – Power BI Desktop – Lab – Lunch and demos Afternoon – Power BI Service overview – Power BI service – Lab – Bring your own data and build dashboards – Q&A

QlikView for Salesforce.com

Salesforce is the of the most popular cloud based Customer Relationships Management (CRM) product available in the market today. Organizations today invested in Salesforce.com today can also enjoy the business intelligence interfaces provided for them to make sense of Salesforce data. But leaving CRM functionality in Salesforce.com while integrating the data from Salesforce into a more flexible but third party BI platform has definite advantages. For example, you can blend data from Salesforce and other in-house systems to analyze it together. QlikView provides a Salesforce connector which can extract data into QlikView to develop powerful analysis, reports and dashboards and empower users with rich and interactive visualization. These dashboards in return will help you to improve key CRM KPIs like sales forecast accuracy, pinpoint cross-sell and up-sell opportunities and achieve more customer centric service and support delivery. You can instantly try out how a QlikView dashboard for...