Page History

It is external simple extension to expand all reports below at once.

• In web browser create new bookmark "Add page..."
• In URL paste: javascript:(function()%7B%24(".expand-control").each(function()%7B %24(this).trigger("click")%3B%7D)%7D)()
• Save bookmark

Thanks to this solution all report will expand at once after clicking bookmark. Now searching by CTRL+F is much simpler.

Standart report

Image Added

Description:

• Report allows to follow up Cashiers sales and selected activities.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store: Default all
• Operator: Default all
• Include VAT: Allows to decide if Vat Default allInclude VAT: Allows to decide if Vat is included in sales amount or not; default yes.

Output:

One page per store

One row per cashier

Columns:

• No: Operator number
• Name: Operator name
• Turnover inc VAT/ Turnover ex VAT
• Receipts: number of reciepts
• Returns
• Deleted receipts
• Deleted item lines
• Receipts on hold
• Deleted on hold
• Null: Number of drawer opening without any transaction
• Ovr. prc.: Overriden price count
• Scan: Number of scanned articles
• Waste: Breakage amount
• Discount: Discount quantity
• Scan %: Scan divided by Quantity of sold items

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

Image Added

Description:

Report lists sales per customer.

Selections:

• Date from - Default today
• Date to - Default today
• Store - Default all

Output:

• Summary totals at the end of new hierarchy level for cashier.
• Report has a total summary at the end of table for all cashiers.

Columns:

Customer number

Number - Operator number

Cashier - Cashier name

Customer - Customer name

Quantity

Price pr. Art. - Price per article

Disc. p. item - Discount per item

Discount

Discount % - Discount percentage

Gross profit % - Gross profit percentage

Hidden parametes:

• pCustomer - parameter takes selected customers and shows sales for them

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists package sales.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all

Output:

Packages grouped per store. One row per package. Report has a summary for each column (all stores and packages).

Columns:

• Buttons for expanding and collapsing all drilldowns
• Package num. – Package number
• Package name
• Quantity
• Cost – Cost package
• Unit price Amount package price
• Turnover
• VAT – VAT amount
• Gr. prof. – Gross profit
• Gr. prof. % - Gross profit percentage
• % of total – Percentage of total sales of packages

Interactive sorting:

Everything except Cost, unit price and % of total

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per weekday.

Selections:

• Year – Default current year
• Week – Default select a single week

Output:

Report shows 5 tables with sales per week: Company shops, CS Organic, Francise shops, Totalorganic and total. Each table has a summary at the end of table on each column for each type of store and last total table for all summaries.

Columns:

• Store – Store name
• Store num. – Store numer
• Rank
• Sales this week
  • Mon-Sun – Sales in particular day
  • Quantity
  • Antall besøk – Number of visits
  • Sum week sales
  • Total Sales YTD – Total sales year to date
• Budget
  • Budget Budget diff – Budget difference
  • Budget YTD – Budget year to date
  • Budget diff. YTD – Budget difference year to date
• Last year
  • Week sales LY – Week sales last year
  • Week sales LY diff. – Week sales last year difference
  • Sales last year YTD – Sales last year, year to date
  • Sales LY diff. – Sales last year difference
• KPI
  • Num of trans. – Number of transaction
  • Num of trans. LY diff. – Number of transactions last year difference
  • ATV – Average transaction value
  • UPT – Unit per transaction
  • Group % - Article group sales ratio, percentage
  • Gr. prof. % - Gross profit percentage
  • Konv. Rate – Konverteringsrate – Conversion rate

Clarifications:

Negative values are marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per cashier in stores.

Selections:

• Date from – Default today
• Date to – Defaul today
• Store – Default all
• Article EAN – Default all
• Item list – Default all

Output:

1. Report shows sales all cashiers in selected stores. Report table has a summary on each column. There is one page per store.
2. Report has a bar chart for each table. X axis is total sales and gross profit bars for each cashier, and y axis is sales and gorss profit amount.

Columns:

• Seller name – Cashier name
• Seller nr – Cashier number
• Total Sales
• Quantity
• Customers – Number of customers
• ATV – Average transactions value
• UPT – Units per transaction
• Gr. prof. % - Gross profit percentage
• Makeup % - Makeup Article group sales percentage
• Item List % - Item list sales percentage
• Gifts % -  Gift sales percentage

Interactive sorting:

Interactive sorting on all columns excepts Makeup %, Item list % and Gifts %

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers from stores and their sales.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Item list- Default all
• Article group – Default all
• Article EAN – Default all

Output:

• Reports lists all cashiers fom selected stores and their sales for customers for selected period of time, item list and article group.
• Report has a total summary at the end of list for each column.

Columns:

• Seller name – Cashier name
• Seller nr – Cashier number
• Total Sales -Total Amount
• Customer – Number of receipts
• ATV – Average transaction value
• UPT – Units per transaction
• Gr. prof. % - Gross profit percentage
• Makeup % - Article group sales percentage
• Item List % Gifts % - Gift sales percentage
• Item group sales

Interactive sorting:

Everything except Makeup %, Item list%,  Gifts % and Item group sales

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists besteller items in stores.

Selections:

• Date from – Default today
• Date to – Default today
• Count – Default 10
• Store – Default all
• Area – Default all
• Group – Default all
• Subgroup – Default all
• Measure – Default Amount

Output:

Report lists selected number of bestellers items including their quantity and amount in selected stores and period of time.

Columns:

• Item num. – Item number
• EAN
• Item name
• Quantity
• Amount
• Gross profit
• Gross profit %

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists staff discount for employees.

Selections:

• Date from – Default today
• Date to – Default today
• Stores – Default all

Output:

Summary totals in the beginning  of new hierarchy level for Employees. Summary in the beginning of table for each column for all Employees.

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Employee – Employee number and name
• Date
• Item num. – Item number
• Item name
• Quantity
• Discounts – Employee discounts
• Discount % - Employee discount percentage
• Sales amount GP % - Gross profit %

Interactive sorting:

Interactive sorting on all columns except Date, Item num. and Item name.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists type of discounts in stores

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Discounts – Default all

Output:

Summary totals at the end of new hierarchy level for stores.

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Store num. – Store number
• Store – Store name Discount type
• Quantity
• Discounts
• Discount % GP % - Gross profit percentage

Interactive sorting:

Interactive sorting on Store num. and Store columns

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists discounts of items in stores.

Selections:

• Date from – Default today
• Default to – Default today
• Stores – Default all
• Discounts – Default all

Output:

• Report shows for selected stores all discounts of items and percentage discount and gross profit of items in selected period of time.
• Summary for each column.
• One row per item number within selected date range

Columns:

• Date
• Item num. – Item number
• Item name
• Quantity
• Discounts
• Discount %
• GP % - Gross profit percentage

Interactive sorting:

• Date
• Discounts
• Discount %
• GP %

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists inventory adjustments in stores.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Transaction type – Default all

Output:

• Report shows adjustments of products with reason codes in selected stores.
• Every store and reason code has a summary of quantity and total cost.
• One page per store.

Columns:

• Buttons for expanding and collapsing all drilldowns
• Item
• Quantity
• Net price
• Net cost price
• Total cost

Clarifications:

Item Transactions are used, filtering based on Reason Codes dim.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers turnovers at a particular day.

Selections:

• Date – Default today

Output:

Report is presented as file to csv export without any colors.

Columns:

• Operator Number
• Operator Name
• Retail Store num – Retail store number
• Retail Store Name
• Hour – Hour of day
• Qty. – Quantity Amount
• UPT - Units per transaction
• ATV - Average transactions value
• Sales Selected Month

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists stores turnovers at a particular day.

Selections:

• Date – Default today

Output:

Report is presented as file to csv exportwithout any colors.

Columns:

• Retail Store num – Retail store number
• Retail Store Name
• Hour – Hour of day
• Quantity
• Amount UPT - Units per transaction
• ATV - Average transactions value
• Sales Selected Month

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers turnovers on a particular day per receipt.

Selections:

• Date – Default today

Output:

Report is presented as file to csv exportwithout any colors.

Columns:

• Cashier_number
• User_name – Cashier name
• Store_number Store_name
• Hour_of_day
• Receipt_id
• Singlesale_grandtotal - sale Amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales statistics with drilldown.

Selections:

• Date from – Default today
• Date to – Default today
• Stores – Default all
• Operator – Default all
• Item Identifier – Default all

Output:

• One page per store.
• Report has a summary for all selected stores at the end of report.
• Summary totals in the beginning of new hierarchy level for:
  • Store
  • Item group
  • Subgroup

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN
• Item name
• Item ID
• Total Campaign – Campaign sale quantity
• Share – Percentage turnover with tax
• % - Pecentage of campaign sale

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales table by cashiers for each store and summary sales table by stores.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Article group – Default all

Output:

• Report shows sales table for cashiers in store.
• One page per store.
• The second table for all stores is at the end of report.
• Report has a summary totals for each column in both tables.

Columns:

• For cashiers:
  • Number – Cashier number
  • Cashier name
• For stores:
  • Store – Store number and store name
• Number - Quantity Sales amount
• Discount % - Discount percentage
• Gr. prof  % - Gross profit percentage
• Gross profit

Interactive sorting:

Interactive sorting on Cashier name, Number and Gross.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales for selected storse in selected period of time. 

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all

Output:

• Report lists total sales, one store per row.
• Report sum up every column.

Columns:

• Store num. – Store number
• Store name Total sales
• Quantity
• Customers
• ATV – Average tranaction value
• UPT – Units per transaction
• Gr. prof. % - Gross profit percentage
• Makeup % - Article group sales percentage

Interactive sorting:

Interactive sorting on all except Makeup %.

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per week.

Selections:

• Year – Default current year
• Week – Default current week

Output:

Report shows 5 tables with sales per week: Company shops, CS Organic, Francise shops, Totalorganic and total. Each table has a summary at the end of table on each column for each type of store and last total table for all summaries.

Columns:

• Store – Store name
• Sales
  • This year – This year sales week
  • Last year – Last year sales week
  • Diff % - Difference percentage
• Budget
  • Budget
  • Diff – Difference between sales week and budget week
  • Diff % - Difference percentage
• Customers
  • This year – Receipt count week this year
  • Last year – Receipt count week last year
  • Diff – Difference between this year and last year
  • Diff % - Difference percentage
• UPT – Unit per transaction
  • This year
  • Last year
  • Diff % - Difference percentage
• ATV – Average transaction value
  • This year
  • Last year
  • Diff % - Difference percentage
• Makeup
  • This year
  • % - Makeup sales week over sales week
  • Last year
  • Diff % - Difference percentage
• Gross profit
  • GP % - Gross profit percentage
  • Gr. prof – Gross profit

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists average sales per customer.

Selections:

• Period – Default Year
• Year – Default current year
• Month – Default current month
• Week – Default current week
• Date – Default today
• Store – Default all

Output:

Values are shown in thousands. Report has a summary on each column for all stores, for stores in each team and total summary on the end of table.

Columns:

• No  -Store number
• Name – Store name
• Customer Year/Accumulated
  • Quantity – Receipt quantity
  • Last year – Receipt quanity last year
  • Index – Quantity of customers to the customers last year
• Average Year/Accumulated
  • Sales – Net amount
  • Last year- Net amount last year
  • Index – Net amount to the last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists bestseller products in each store.

Selections:

• Date from – Default today
• Date to – Default today
• Count – Default 10
• Team – Default all
• Profile – Default all
• Store – Default all
• Sort – Default best
• Accumulation – Default: OverAll + Store
• Measure – Default: Amount

Output:

Report lists bestseller items with quantity and gross profit for seleected period of time for each selected store, one page per store.

Columns:

• EAN
• Item name
• Quantity
• Amount in thousand
• Gross profit
• Gross profit % - Gross profit percentage

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists campaign sales statistics.

Selections:

• Campaign group – Select a single value
• Store – Default all
• Department – Default all
• Area – Default all
• Group – Default all

Output:

• Report shows summary for each column at the end of table.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group
  • Item

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Department – Department number and name
• Item area – Item area number and name
• Item group – Item group number and name
• Item – Item number and name
• Quantity
• Sales – Net amount
• Gross profit
• Gr. profit % -Gross profit percentage

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists mixmatch list of articles for stores.

Selections:

• Date from – Defualt today
• Date to – Default today
• Store – Default all
• Mixnumber – Defaul select a single value
• Non sale – Default No
• From EAN – Default empty
• To EAN – Default empty

Relevant parameters:

• pTopXMix – parameter declare max number of mix numbers, default 100

Output:

Report shows total summary on each column at the end of the table.

Columns:

• EAN
• Item name
• Total sales – Quantity total
• Mix sales – Quantity mix
• Sales – Quantity difference between total and mix sales

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per product group as a difference report per week.

Selections:

• Year – Default current year
• Week – Default current week
• Store – Default all
• Department – Default all
• Article Area – Default all
• Article group – Default all

Output:

• Report has a summary totals on each column on the end of report table.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Department No - Department number
• Department Name
• Item area No - Item area number
• Iteam area Name
• Item group No - Item group number
• Item group Name
• Week/Year
  • Sales – Net amount
  • Last year – Net amount
  • last year Index LY – Sales divided by last year sales

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per product group as a difference report per week

Selections:

• Year – Default current year
• Week – Default current week
• Store – Default all
• Department – Default all
• Article Area – Default all
• Article group – Default all

Output:

Report shows list of items in selected stores and their sales per week and per year with last year comparison. Report has a summary on each column on the end of report table.

Columns:

• EAN
• Item name
• Week/Year
  • Sales – Net amount
  • Last year – Net amount last year
  • Index LY – Sales divided by last year sales

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists number of sales every quarter for each store and total number of sales for all stores.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Default avaible from the list
• Weekday – Default all
• Hour from – Default 8
• Hour to – Default 18

Output:

• Report shows number of sales every quarter table in selected period of time (date and hours) for each store.
• One page per store.
• Second table shows numbers of sales all stores together and it's at the end of report.
• Report has a summary totals for each column in both tables

Columns:

• Time – Next quarters of selected period of hours
• Sales – Net amount
• Customers num – Customer number transactions
• Items – Quantity of items

Clarifications:

All used values in report are selected for: not deleted Status, stock type article and for regular sales.

Source:

• Lindbak POS Reporting DW

Image Added

Description:

Report lists sales per store with differnce report per day

Selections:

• Date – Default today
• Team – Default all Profile – Default all Store – Default all
• Department – Defualt all
• Area – Default all
• Group – Default all
• Not Comparable Store – Default empty, select a multi value

Output:

Report shows sales for selected stores with summary for all teams and each team seperately. Report has a total summary on the end of each column.

Columns:

• Store No – Store number
• Store Name
• Ej. jmf - Not comparable Store
• Day/Week
  • Sales – Sales net amount
  • Budget – Budget amount
  • Last year – Sales last year
  • Diff. budget – Difference sales and budget
  • Diff. LY – Difference last year
  • Index budget
  • Index LY - Index last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with differnce report per day

Selections:

• Date – Default today
• Department – Default all
• Store – Default all
• Article area – Default all
• Article Group – Default all

Output:

• Report has a summary on the end of each column.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group

Columns:

• Buttons for expanding and collapsing all drilldowns
• EAN
• Item name
• Day/Week
  • Sales – Sales net amount
  • Last year – Sales last year
  • Diff. LY – Difference last year
  • Index LY – Index last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store as a difference report per month.

Selections:

• Year – Current year
• Month – Current month
• Team – Default all
• Profile – Default all
• Store – Default all
• Not comparable store – Default select a multivalue
• Department – Default all
• Area – Default all
• Group – Default all

Output:

Report has a summary totals on each column on the end of the report. Report is divided on selected teams, and at the beginning of report, to all teams. Selected teams have total summaries rows for columns and total compared summaries.

Columns:

• No – Store number
• Name – Store name
• Ej. Jmf – Not comparable Store
• Sales – Sales net amount monthly/yearly
• Budget – Budget monthly/yearly
• Last year – Sales last monthly/yearly
• Diff. budget – Difference budget monthly/yearly
• Diff. LY – Sales last year difference monthly/yearly
• Index budget – Index sales month over budget monthly/yearly
• Index LY – Index Sales last year month over sales last year month monthly/yearly

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per month.

Selections:

• Year – Default current year
• Month – Default current month
• Store – Default all
• Department – Default all
• Article Area – Default all
• Article group – Default all

Output:

• Values are shown in thousands. Report has a summary for each column.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN
• Item name Month/Year
• Sales – Net amount sales
• Last year – Net amount sales last year
• Diff. LY – Difference last year
• Index LY – Index last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per week.

Selections:

• Year – Default current year
• Week – Default current week
• Team  – Default all
• Profile – Default all
• Store – Default all
• Department – Default all
• Area – Default all
• Group – Default all

Output:

Values are shown in thousands. Report has a summary for all stores and for stores in each team. Report has also total summary on the end of table.

Columns:

• No – Store name
• Name – Store name
• Week/Year
  • Sales – Net amount
  • Budget Last year – Net amount last year
  • Index budget – Bugdet divided budget last year
  • Index LY – Index last year, sales over last year sales

Source:

• Lindbak POS Reproting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per week.

Selections:

• Year – Default current year
• Week – Default current week
• Store – Default all
• Department – Default all
• Article Area – Default all
• Article group – Default all

Output:

• Values are shown in thousands Report has a summary on each column on the end of table.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN
• Item name
• Week/Year
  • Sales – Net amount
  • Last year – Net amount last year
  • Index LY – Sales divided by last year sales

Clarifications:

Item name is marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists mix sales for articles in a particular store.

Selections:

• Date from – Default today
• Date to – Default today
• Store From – Select a single value
• Mixnumber – Select a single value
• Non sale – Default false

Output:

Report has a mix sales summary at the end of report.

Columns:

• EAN
• Item name
• Mix sales - Quantity

Source:

• Lindbak POS Reporting DW

CO-1069

Image Added

Description:

Report lists sales per store including VAT with difference report per day.

Selections:

• Date – Default today
• Team – Default all
• Profile – Default all
• Store – Default all
• Department – Defualt all
• Area – Default all
• Group – Default all

Output:

Report shows sales for selected stores with summary for all teams and each team seperately together with compared total. Report has  a summary on the end of each column.

Columns:

• Store No – Store number
• Store Name
• Item name
• Day/Week
  • Sales – Sales amount
  • Last year – Sales last year
  • Diff. LY – Difference last year
  • Index LY – Index last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference report per month.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Profile – Default all
• Store – Default all
• Department – Default all
• Area – Default all
• Group – Default all
• Not comparable store – Default select muliple values

Output:

Report has a summary totals on each column on the end of the report. Report is divided on selected teams, and at the beginning of report, to all teams. Selected teams have total summaries rows for columns and total compared summaries.

Columns:

• No – Store number
• Name – Store name
• Ej. Jmf – Not comparable Store
• Sales – Sales net amount monthly/yearly
• Budget – Budget monthly/yearly Last year – Sales last monthly/yearly
• Diff. budget – Difference budget monthly/yearly
• Diff. LY – Sales last year difference monthly/yearly
• Index budget – Index sales month over budget monthly/yearly
• Index LY – Index Sales last year month over sales last year month monthly/yearly

Clarifications:

Identical to report 0049, but with date from-to instead of year and month.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per month for each store and comparison month from last year.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Department – Default all
• Article Area – Default all
• Article Group – Default all

Output:

• Report shows sales per month and per year in stores in comparison to year before.
• Report has a summary for each column.
• Summary totals in the beginning of new hierarchy level for:
  • Store
  • Department
  • Item area
  • Item group

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN
• Item name
• Sales – Net amount for month and year respectively
• Last year – Net amount for month/year in a current date year before
• Diff. LY – Difference between current date and date year before
• Index LY – Index current date to a date year before

Source:

• Lindbak POS Reporting Cube (OLAP)

CO attached to PBI #12200

Image Added

Description:

• Report allows to check Nonsale quantity among stores and cashiers.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store: Default all
• Operator: Default all

Output:

One row per item showing quantity of nonsale transaction on given item. Total per each cashier and per each store.

Columns:

• EAN
• Item name
• Quantity

Sorting:

• Store number
• Cashier number

Source:

• Lindbak POS Reporting cube (OLAP)

PBI: 12060, IN94

Image Added

Description:

Report lists amount and quantity of different discounts made by cashiers.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Single value, availe from the list

Output:

• After expanding cashiers, list of receipts.
• One row per receipt.
• Summary totals in the beginning  of new hierarchy level for Cashier.
• Report has a summary for all cashiers in store on each column.

Columns:

• Buttons for expanding and collapsing all drilldowns
• Receipt – Receipt id
• Date – Date of transaction
• Amount – Amount of discount
• Quantity – Quantity of discounts

Source:

• Lindbak POS Reporting Cube (OLAP)

PBI: 39373

Image Added

Description:

Report lists cashier statistics.

Selections:

• Date from – Default today
• Date to – Default today
• Retailstore – Default all
• Operator – Default all

Output:

• Report shows list of cahiers in each store.
• One page per store
• Report has a summary for each colum at the end each store table

Columns:

• Cashier – Cashier number and name
• Turnover – Turnover amount
• Receipts – Receipts quantity
• Qty - Quantity Amount
• Null – Null sales with open drawer
• Ovr. prc. – Overriden price quantity
• Scan – Scanned articles
• Lottery – Tender type finance amount and quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1043

Image Added

Description:

Report lists bestseller items by sales in a store.

Selections:

• Date from – Default today
• Date to – Defualt today
• Store – Select a single value
• Hete soner – Select a single value
• Toppen Disk – Select a single value
• Fron Disk – Select a single value
• Bakvegg Disk – Select a single value

Output:

Report shows three tables: 10 best items, Best 10 items in my store and Best 5 stores in country. The table best 5 stores in my country is divided on other tables: Best 5 stores in my team, best 5 stores compared to last year % and best 5 stores compared to last year. Report has also gauge panel with number of customer in this week and last year.

Columns:

• 10 best items/Best items in my store
  • Item num. – item number
  • Item – Item name
  • Sales – Sales amount
• Best 5 stores in my county and in my team
  • Rank – Main rank
  • Store – Store name
  • Sum of ranks – Rank total
  • Sales – Item lists sales
  • % of total – Percentage of total item lists sales over amount
  • Sales chg. % - Sales change percentage year to year

Clarifcations:

% of total column has blue bars inside of rows to present percentage amount of total item sales.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1044

Image Added

Description:

Report lists detailed information about Breakage and complaint items. Its quantity, amount, breakage and compplaint by team and store and grouped by worst registered items.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all

Output:

Report is devided in 6 sections:

1. List of breakage and complaint items, its reason codes with quantity and amount.
2. Table of breakage and complaint items quantity grouped by team and store.
3. Bar chart with worst 20 item registered with complaints and breakage.
4. List of breakage and complaint items. (Section 4 chart)
5. Bar chart with complaints and breakage per item group.
6. List of item groups and amounts for breakage and complaint. (5 chart)

Columns:

• Section 1
  • Transaction type
  • Reason code
  • Quantity
  • Amount
• Section 2
  • Store – Store number and store name preceded by team group
  • Breakage – Quantity of Breakage items
  • Complaint – Quantity of Complaint items
  • Total – Total quantity of breakage and complaint items
• Section 3
  • X-axis – Item number, quantity and amount bars
  • Y-axis – Left axis quantity, right axis amount
• Section 4
  • Item num. – Item number
  • Item name
  • Quantity – Item transaction quantity
  • Amount – Item transaction net amount
• Section 5
  • X-axis – item group, complaint and breakage bars
  • Y-axis – Item transaction net amount
• Section 6
  • Item group
  • Amount for breakage
  • Amount for complaint

Clarifications:

Chart from section 3 is presented as list in section 4 and chart from section 5 is presented as list in section 6.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1045

Image Added

Descriptions:

Report lists dashboard about sales in cashregister per store.

Selections:

• Date- Default today
• Store – Default all
• Include VAT – Default Yes

Output:

Report shows three tables:

1. First and second table shows accumulated sales from week and current day.
2. Third table shows differences current day Report shows two gauge panels with sales to budget ratio week and day

Columns:

• Accumulated current day/week
  • Sales – Sales amount
  • Sales until 24 – Sales amount before 24
  • Sales until 24 LY – Sales amount before 24 last year
  • Budget – Budget amount with tax
  • Average sales
  • Average sales last year
• Differences current day
  • Open drawer count
  • Returns qty. – Quantity of returns
  • Returns (total) – Total returns amount
  • Cancelled receipts

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1047

Image Added

Description:

Report lists week sales statistics for all stores.

Selections:

• Date from – Default first day of the current week
• Date to – Default today
• Team – Default all
• Include VAT – Default Yes

Output:

Report has a summary at the end of each column.

Columns:

• Rank – Store rank
• Store – Store name Sales
• Sales – Sales amount or net amount
  • Budget – Budget amount or Budget amount plus tax amount
  • Last year – Sales last year
  • Difference budget % - Difference budget percentage
  • Difference sales % - Difference sales percentage
• Average sale/Customers – Number of customers
  • This year
  • Last year
  • Customers diff. % - Customers difference percentage

Interactive sorting:

Interactive sorting on columns: Difference budget %, Difference sales %, Average diff. and Customers diff%.

Source:

• Lindbak POS Rerporting Cube (OLAP)

CO: 1048

Image Added

Description:

Report lists sales statistics for teams and stores seperately.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Item list – Default all
• Report type – Default sales amount
• Item group – Default all

Output:

Report shows two tables. First table has a list of teams and summary row for all teams, second table shows list of stores and has summary at the end of each column.

Columns:

• Rank
• Team – Team name
• Store – Store name in a second table
• Sales amount
• Customers num – Number of customers
• Items – Items quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1046

Image Added 

Description:

Report lists bestseller items.

Selections:

• Date from – Default today
• Date to - Default today
• Hete soner – Hot zones
• Toppen Disk – Top disk
• Fron Disk – Front disk
• Bakvegg Disk – Real wall disk
• Team – Default all
• Report type – Default Salg pr. 100

Output:

Report shows bestseller items in teams and in stores in tw otables. Report has a total summaries for both tables at the end of each column.

Columns:

• Rank
• Team (Second table store) – Team or Store name
• Sum plasseringer - Total placements
• Hete soner - Hot zones
• Rank
• Hele disken  - Whole disk Rank
• Fokusprodukter - Focus products
• Rank
• Bestselgere - Bestsellers
• Rank

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 1137

Image Added

Descriptions:

Report lists dashboard about sales in cashregister per team.

Selections:

• Date- Default today
• Team – Default all
• Include VAT – Default Yes

Output:

Report shows three tables:

1. First and second table shows accumulated sales from week and current day.
2. Third table shows differences current day Report shows two gauge panels with sales to budget ratio week and day

Columns:

• Accumulated current day/week
  • Sales – Sales amount
  • Sales until 24 – Sales amount before 24
  • Sales until 24 LY – Sales amount before 24 last year
  • Budget – Budget amount with tax
  • Average sales
  • Average sales last year
• Differences current day
  • Open drawer count
  • Returns qty. – Quantity of returns
  • Returns (total) – Total returns amount
  • Cancelled receipts

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-1135

Image Added

Description:

Report lists  month sales statistics.

Selections:

• Year – Default current year
• Month from – Default current month
• Month to – Default current month
• Team – Default all
• Include VAT – Default Yes

Output:

Report shows two tables, first one shows sales statistics for all teams, second sales statistics for stores. Report has a summary totals at the end of the second table on each column.

Columns:

• Rank Team/Store
• Sales
  • Sales – Sales amount/net amount
  • Budget – Budget amount/Budget amount plus tax amount
  • Last year – Sales last year
  • Difference budget % - Difference budget percentage
  • Difference sales % - Difference sales percentage
• Average sale/Customers – Number of customers
  • This year
  • Last year
  • Customers diff. % - Customers difference percentage

Interactive sorting:

Interactive sorting on columns: Difference budget %, Difference sales %, Average diff. and Customers diff%.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO - 1207

  Image Added

Description:

Report lists  average sales for teams and stores.

Selections:

• Date from – Default first day of the current week
• Date to – Default today Team – Default all

Output:

Report shows two tables, first for all teams, second for stores in these teams. Report has a summary on the end of the each column.

Columns:

• Rank
• Team/Store – Team name or Store name depends table
• Average sale
  • This year – Sales amount
  • Last year – Sales amount last year
  • Difference – Difference between last year sales and this year sales

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists promotion item sales.

Selections:

• Date from – Default today
• Date to – Defualt today
• Stores – Default all
• Department – Default all
• Article Area – Default all
• Article Group – Default all
• Article Subgroup – Default select a single value
• Item number – Default empty

Output:

Report has a table with number of product lines per receipts with total summary at the end of each column. Report has also chart with amount of number of receipts and net amount. Report has a short table with sales statistics and column with share of total sales at the end of report.

Columns:

• Table: number of product lines per receipts Number of lines
  • Num of receipts – Number of receipts
  • Quantity
  • Net amount
  • Share
  • Avg. quantity – Average quantity
  • Avg. amount – Average amount
• Second table:
  • Quantity
  • Net amount
  • Num of receipts – Number of receipts
  • Avg. quantity – Average quantity
  • Avg. amount – Average amount
• Column:
  • Andel bonger med salg av drager - Share of bongs with sales of kites
  • Andel av totalsalg stk via bonger m/drager - Share of total sales via vouchers with kites
  • Andel av totalsalg kr via bonger m/drager - Share of total sales NOK via vouchers w/carriers

Source:

• Lindbak POS Reporting Cube (OLAP)
• Lindbak POS Reporting DW

Image Added

Description:

Report lists basktet analysis

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Department – Default all
• Article area – Default all
• Article group – default all
• Article subgroup – Default select a single value
• Item number – Default empty

Output:

Report has a total summarty at the end of report on each column.

Columns:

• Item num – Item number
• Item name
• Quantity
• Net amount
• Gross profit
• Gr. prof. % - Gross profit percentage

Interactive sorting:

Interactive sorting on each column.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists security statistics of cashiers in stores.

Selections:

• Date from – Default all
• Date to – Default all
• Team – Default all
• Store – Default all
• Operator – Default all

Output:

Report shows statistics of cashiers after expanding stores. Summary totals in the beginning  of new hierarchy level for Store.

Columns:

• Buttons for expanding and collapsing all drilldowns
• Store – Store number and store name
• Diff. balance – Difference balance in store between balance amount, tender amout and cash bank
• Returns qty. – Returns quantity Returns amt. – Returns amount
• Deleted receipts quantity
• Deleted unfinished receipts
• Deleted receipts amount
• Receipt copies – Receipt copies quantity
• Open drawer – Open drawer quantity
• Employe disc. – Personal discount quantity
• Employee disc. amt. – Personal discount amount
• Breakage – Breakage amount in store
• Turnover sum – Turnover amount
• Deposit refund received qty – Deposit refund received quantity
• Deposit refund received – Deposit refunt received amount
• Deleted sales qty – Deleted sales quantity
• Deleted sales amount
• Total amount – Card payment

Interactive Sorting:

Interactive sorting on all columns except deleted unifinished receipts and deleted receipts amount.

Clarifications:

Report has two buttons to expand and collapse all stores.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists data for floor planning system.

Selections:

• Date - Default today

Output:

Report shows sales data for floorplanning.

Columns:

• StoreNumber
• Date
• Amount
• CustomerCount – Receipts quantity
• Quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists daily total net amount for a store.

Selections:

• Date – Default today
• Retail store – Possible to select one store or all available
• Workstation – Default all

Output:

One page per store. Each table has a summary of each column.

Columns:

• Workstation
• Net amount
• Items per purchase
• Net amount per customer

Interactive sorting:

Interactive sorting on all columns

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sale per cashier in each store.

Selections:

• Date from – Default today
• Date to – Default today
• RetailStore - Possible to select one store or all available
• Workstation – Default all

Output:

Report shows quantity and amount of sales for each cahier in selected store. There is a summary for each column.

One page per store

Columns:

• Seller nr – Operator number
• Seller name – Operator name
• Quantity
• Amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists item group sales.

Selections:

• Date from – Default today
• Date to – Default today
• RetailStore - Possible to select one store or all available
• Workstation – Default all

Output:

Report lists item group quantity and amount for selected stores, one page per store. There is a summary for each column.

Columns:

• Grp. no. – Item group number
• Item group
• Quantity
• Amount

Interactive sorting:

Interactive sorting on all columns

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists items pick in selected store and workstation.

Selections:

• Date/Time From – Default today
• Store – Default select a single value
• Workstation – Default all
• Articlegroup – Default all

Output:

Report shows items in items group for selected store and workstations.

Columns:

• Model nr – Model number
• Item name
• Color
• Size
• EAN
• Price
• Quantity
• Stock
• Item group

Source:

• Lindbak POS Reporting Cube (OLAP)
• Lindbak POS Reporting DW

Image Added

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations and settlement per each workstation on following pages. Report is divided in subreports wchich will be described separatly.

Selections (applies to all subreports):

• Date from – Default today
• Date to – Default today
• Retail store – Default select a single value
• Workstation – Default all

Output:

One page per workstation. First page with report table contains all workstations.

Subreports:

Source:

Lindbak POS Reporting Cube (OLAP)

CO: 190361, RTC-16608

Image Added

Description:

Report lists number of members with and without bonus points and pie chart.

Selections:

• Loyalty program – Default loyalty program

Output:

Report shows number of members  with and without bonus points and pie chart which related to table.

Columns:

• Total number of members
• Number of member with bonus points
• Number of member without bonus points
• Total bonus point amount

Source:

• Lindbak POS Reporting Cube (OLAP)

CO190338, RTC-16610

Image Added

Description:

Report lists bonus rollout statistics.

Selections:

• Year from – Defualt previous year
• Year to – Default current year
• Bonus Rollout Name – Default all
• Loyalty program – Default loyalty program