List of reports

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.

Standard Report

Description:

• Report allows to follow up cashiers sale performance.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store: Default first available (from list of stores ordered by store number)
• Operator: Default all
• Price channels - Default all

Output:

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

• EAN
• Item name
• Quantity
• Discount % - Share of discount amount in original prize
• Gross profit
• Gross profit % - (gross profit)/(sales ex. VAT)
• Sales amount - sales inc. VAT

Sorting:

• EAN (default)

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

• Report allows to follow up cashiers sale performance.

Selections:

• Date from: Default today
• Date to: Default today
• Retail store from: Default first from store list
• Retail store to: Default first from store list
• Operator from: Default 0
• Operator to: Default 999999

Output:

Item sale statistics showed individually per each cashier (with number between Operator from and Operator to) per each stores (with number between Retail store from and Retail store to).

Additionally there are totals for each cashier and each store.

Columns:

• EAN
• Item name
• Quantity
• Discount % - Share of discount amount in original prize
• Gross profit
• Gross profit % - (gross profit)/(sales ex. VAT)
• Sales amount - sales inc. VAT

Sorting:

• EAN (default)
• Qunatity (interactive)
• Gross profit (interactive)

Source:

• Lindbak POS Reporting DW

Standard report

Description:

Report is devided one page per store and shows cashiers sale statistics. On the last page there is summary for all selected stores.

Selection:

• Date from: Default today
• Date to: Default today
• Retail store from: Default first from store list
• Retail store to: Default first from store list
• Operator from: Default 0
• Operator to: Default 999999

Output:

• One row per one cashier showing his/her sales performance
• On the last page: one row per store without division per cashier

Columns:

• Number: Cashier number
• Cashier name
• Number: Quantity of sold items
• Cust#: Number of receipts
• Sales amount: Sales amount inc. VAT
• Discount %: Share of discount in original price
• Gr. prof.%: Share of Gross profit in Net amount.
• Gross profit
• Price pr. Art.: (Sales amount) / (Number (of all items sold))
• Sale pr. cust.: (Sales amount) / (Cust#)
• Items pr. Cust.: (Number (of all items sold)) / (Cust#)

Sorting:

• Pages (stores) by store number
• Rows:
  • Number (of items sold) - interactive
  • Gross profit - interactive

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report is divided one page per store and shows cashiers sale statistics. On the last page there is summary for all selected stores.

Selection:

• Date from: Default today
• Date to: Default today
• Retail Store: Default all, multivalue (possibility to select more than one store)
• Operator: Default all, multivalue (possibility to select more than one operator)

Output:

• One row per one cashier showing his/her sales performance
• On the last page: one row per store without division per cashier

Columns:

• Number: Cashier number
• Cashier name
• Number: Quantity of sold items
• Cust#: Number of receipts
• Sales amount: Sales amount inc. VAT
• Discount %: Share of discount in original price
• Gr. prof.%: Share of Gross profit in Net amount.
• Gross profit
• Price pr. Art.: (Sales amount) / (Number (of all items sold))
• Sale pr. cust.: (Sales amount) / (Cust#)
• Items pr. Cust.: (Number (of all items sold)) / (Cust#)

Sorting:

• Pages (stores) by store number
• Rows:
  • Number (of items sold) - interactive
  • Gross profit - interactive

Source:

• Lindbak POS Reporting DW

Standard report

Description:

Report allows to follow up sales statistics per cashier and per vendor (supplier). Report is devided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

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

Output:

• One section per each cashier showing sales statistics divided per each vendor (supplier) with not null sale amount.

Columns:

• Vendor number
• Vendor name
• Items: Quantity of sold items
• Discount %: Share of discount in original price
• Gross profit
• Gr. prof.%: Share of Gross profit in Net amount.
• Sales amount: Sales amount inc. VAT

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up sales statistics per cashier and per vendor (supplier). Report is divided sections per each selected cashier. Each section shows sales statistics per vendor.

Selection:

• Date from: Default today
• Date to: Default today
• Retail store from: Default first from store list
• Retail store to: Default first from store list
• Operator from: Default 0
• Operator to: Default 999999

Output:

• One page per store. One section per each cashier showing sales statistics divided per each vendor (supplier) with not null sale amount.

Columns:

• Vendor number
• Vendor name
• Items: Quantity of sold items
• Discount %: Share of discount in original price
• Gross profit
• Gr. prof.%: Share of Gross profit in Net amount.
• Sales amount: Sales amount inc. VAT

Source:

• Lindbak POS Reporting DW

Standard report

Description:

Report allows to find given number of best or worst selling items per store, per cashier on multiple levels (amount, quantity, net cost, gross profit).

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Default all
• Number of items: Number of best or worst items to display - default 5
• Sort type: worst or best - report will display given number of worst or best selling items - default best
• Sort measure: amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount
• Article group: Default all

Output:

One page per each store. One section per each cashier. Inside the section selected number of best (or worst) selling items for given cashier.

Columns:

• Qunatity
• Amount: Sales amount inc. VAT
• Net Cost
• Gross profit
• Gr. profit %: Share of Gross profit in Net amount

Sorting:

• Selected sort measure

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to find given number of best or worst selling items on multiple levels (amount, quantity, gross profit, etc.) per selected hierarchy level (department,item area, etc.)

Selections: 

• Date from: Default today
• Date to: Default today
• Store: Possible to select one store or all available; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
• Grouping: Selection of hierarchy level for which number of best items will be displayed. Possible selections: Department, Article area, Article group, Article sub group, Store; default Area.
• Count: Number of best or worst items to display - default 10
• Sort type - worst or best - report will display given number of worst or best selling items - default best
• Sort measure - amount/quantity/net cost/gross profit/gross profit % - set the measure on which the items are sorted. - default amount

Output:

Sale statistics for selected number of best or worst items per selected grouping (store or hierarchy level) sorted by selected sort measure with totals on higher levels (e.g. for grouping: article area there are totals for department and store, but for grouping: depratment there will be only total per store)

Columns: 

• Dept.: Department number
• Area: Item area number
• Grp.: Item group number
• Srg.: Subgroup number
• EAN
• Model/ItemID: Article identifier (ItemID - see clarifications)
• Item name
• Quantity
• Amount: Sales amount inc. VAT
• Net cost
• Gross profit
• Gr. prof. %: Share of Gross profit in Net amount

Sorting:

• Selected sort measure

Clarifications:

• Article identifier: Possible to select Item ID or Model. Only name of column is changed - field is always Item ID
• Totals for given level are always placed in the end of list of items belonging to given level.

Source:

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

Standard report

Description:

Report allows to comapare sales between two selected stores.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store ref: Reference store; default first from store list
• Retail store comp: Store to compare; default first from store list
• Statistics: Expands drill down to selected level; possible selections:
  • Item: expands to area level
  • Model: (as in print screen, expands to lowest level - item). It also changes column No from EAN to ModelKey
  • Group: expands to group level
  • Area: expands to area level
  • Department: expands to department level
• Department: Default all
• Article area: Default all
• Article group: Default all
• Article subgroup: Default all

Output:

Sales statistics per all item ierarchy levels (department, area, group, subgroup, item) expanded as selected in Statiscitcs parameter.

Report is devoded in 3 sections:

• •  per 1. store
  •  per 2. store
  •  difference between selected stores

Columns: 

• No: EAN (or Model key if Model was selected for Statistics parameter)
• Name: Article name (or Model name if Model was selected for Statistics parameter)
• Cost: blank (should be Net cost)
• Sales amount: Sales amount inc. VAT
• Gr. prof.: Gross profit
• Gr. prof %: Share of Gross profit in Net Amount

Sorting:

• No sorting

Clarifications:

• In difference section columns are caltulated as simple subtruction on columns from store 1 minus store 2

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report gives detailed sales statistics with campaign sales statistics included.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey). 
• Price channels: Multivalue; default all

Output:

Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item.

Totals in the begining of new hierarchy level for:

• • Store
  • Department
  • Item area
  • Item group
  • Subgroup

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: on item level it is share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total). On totals level: sum of Campaign sale % from item level which doesn't sum up to 100%
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Hidden parameters:

• pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection
• pUseLongItemText: Default false. If set to true Item name will be changed to Article Long Name

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report 

Description:

Report gives detailed sales statistics with campaign sales statistics included with easier access to needed information than 0012.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey). 
• Subvendor: Multivalue; default all
• Vendor: Multivalue; default all
• EAN list: Allows to add specific items ignoring other selections; default blank
• Expand to: Expands drill down to selected level; default Area
• Include Nonsale: If Include Nonsale was box checked, nonsale data will be included to statistics.
• Price channels: Multivalue; default all

Output:

Sale statistics for all items with not null sale (or sale + nonsale if include nonsale box checked) amount narrowed down only by selections. One row per item.

Totals in the begining of new hierarchy level for:

• • Store
  • Department
  • Item area
  • Item group: if you clicked on item group you would be moved to report 0014_SalesStatisticsPrArticles_std with saved selections and you will be able to see sales statistics for items in given item group.
  • Subgroup

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: Share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total)
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Hidden parameters:

• pAllowedPriceChannelsKeys: Default all. If changed it will narrow down possible Price channel selection

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report gives detailed sales statistics with campaign sales statistics per article with grouping only per store.

Selections: 

• Date from: Default today
• Date to: Default today
• Retail store: Multivalue; default all
• Profile: Multivalue; default all
• Department: Multivalue; default all
• Article area: Multivalue; default all
• Article group: Multivalue; default all
• Article subgroup: Multivalue; default all
• Article identifier: Possible to select Item ID or Model (ModelKey).

Output:

Sale statistics for all items with not null sale amount narrowed down only by selections. One row per item. One page per store.

Columns: 

• EAN
• Model/ItemID: Article identifier (Item ID or ModelKey)
• Item name: Item name (will change to Article Long Name if pUseLongItemText was switched true)
• Quantity sold Total
• Quantity sold Campaign: Sold item quantity in campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Turnover with tax Total
• Turnover with tax Share: Share of sales amount inc. VAT for given item (group, area, ...) in all sales for given store.
• Campaign sale Total: Sale amount inc. VAT for campaigns with discount keys: CampaignPrice, Group, MemberPrice
• Campaign sale %: Share of campain sales for given item in all sales for the item (Campaign sale / Turnover with tax Total)
• Gross profit Total
• Gross profit Total %: Share of Gross profit in Net Amount
• Gross profit % exc. campaign: Share of gross profit for all sales except campaigns in Net amount for all sales except campaigns
• Gross profit Campaign: Gross profit for Campaign sale Total
• Gross profit Campaign %:  Gross profit Campaign/ Net Amount for campaign sales

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 12 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Store: Single value; default first available from the list.
• Operator: Multivalue; default all
• Price channels: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

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 15 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from: Default today
• Date to: Default today
• Store: Single value; default first available from the list.
• Workstation: Multivalue; default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Standard report

Description:

Report lists sales per hour bar chart.

Selections:

• Date – Default today
• Stores – Default all

Relevant parameters:

pHourFrom and pHourTo – use to set hours on x axis of bar chart.

Output:

X axis represents hours from 8 to 18. Y axis is sales amount.

Columns (bars):

• Current day – Selected Date
• Last week - Default the same day of week as Date week before
• Last month - Default the same day of week as Date month before
• Last year - Default the same day of week as Date year before

Source:

• Lindbak POS Reporting Cube (OLAP)

Standart report

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 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)

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 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
• Manual Discount Amount
• Manual Discoun percent.: Discount Amount divided by Original amount
• 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)

Description:

Report lists each cashier sales in stores.

Selections:

• Date from -Default today
• Date to -Default today
• Article EAN – Default all
• Store – default all

Output:

1. Report table has a summary for each column. One page per store.
2. Each report table has a 3d round bar graph with total sales and gross profit. X axis is cashier name, y axis is amount of total sales and gross profit.

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
• Skincare % - Skincare article group sales percentage

Interactive sorting:

Interactive sorting on all except Makeup % and Skincare %.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists items, their quantity and amount for selected, specific values.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Group – Default all
• Sort – Default: Best
• Accumulation – Default: Total + Store
• Measure – Default: Amount
• Count – Default set 10

Output:

Report shows bestsellers or worst sold items and their quantity and sum amount for selected store (one store per site) and period time.

Columns:

• No – Item id
• Name – Article name
• Quantity
• Sum - Amount
• Gross profit
• Gr. prof. % - Gross profit percentage

Clarifications:

Report can show counted number of products, Accumulation and can be measured by amount, quantity or gross profit.

Source:

• Lindbak POS Reporting Cube (OLAP)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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)

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

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)

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)

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)

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)

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)

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)

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

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)

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)

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

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

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

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

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

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

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

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

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

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

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

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

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)

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

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)

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)

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)

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)

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)

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)

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

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

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

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

Output:

Report shows statistics about bonus rollout. Report has a table and a redeemed by check value chart.

Columns:

• Table
  • Check value Number/Sum
  • Not redeemed
  • Redeemed
  • Expired Issued
  • Sales Num of receipts – Number of receipts in sales
  • Sales Average sale
• Redeemed by check value chart
  • x-axis – three type of bars: not redeemed, redeemed and expired
  • y-axis – percentage of check value

Source:

• Lindbak POS Reporting Cube (OLAP)

RTC-16609

Description:

Report lists bonus rollout redeemed percetange chart.

Selections:

• Year from – Previous year
• Year to – Current year
• Bonus Rollout Name – Default all
• Loyalty program – Default loyalty program

Output:

• Report shows chart with percent of checks redeemed graphs. On x-axis are days passed from issued date, on y-axis is redeemed amount percentage.
• Graphs represents total issued amount for values: 50, 100, 150, 200, 250, 300+

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 190338

Description:

Report allows to follow up bonus rollout checks usage and sales made using bonus checks.

Selections:

• Year from (default last year)
• Year to (default current year)
• Bonus rollout name (default all) - report shows data for available rollouts within selected period
• Loyalty program

Output:

Bonus checks usage and sales statistics grouped per store. Report lists all the stores in which checks were issued or redeemed.

Columns:

• Store - StoreNumber - Store name
• Number redeemed - Number of redeemed bonus checks issued in selected rollout(s)
• Sum redeemed - Sum of redeemed bonus checks
• Redeemed of total issued % - Share of redeemed bonus checks number for store compared to issued bonus checks number for all stores
• Average sale - Average sale inc. VAT made using bonus checks

Sorting:

• StoreNumber

Clarifications:

• Check is considered redeemed even if it was only partialy used
• Check is conntected to the store in which it was redeemed, not issued

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report lists weekly sales statistics with last year comparison.

Selections:

• Year – Default current year
• Week – Default current week
• Team – Default all Profile – Default all
• Store – Default all
• Department – Default all
• E-commerce Store – Default store number 7

Output:

Report shows stores sales statistics with less and more than 1 year of operation. Report has a summary for for stores with less than 1 year operation and total summary for all stores at the end of each column.

Columns:

• No – Store number
• Store – Store name
• Week N/So far this year – Number of week
  • This year – Sales amount this year
  • Last year – Sales amount last year
  • Diff – Difference between sales this year and sales last year
  • GP % - Gross profit percentage
  • Gr. prof % LY – Gross profit percentage last year
• Collect@ Store
  • % This week – Percentage of sales between collect at store and sales amount
  • % This week LY - Percentage of sales between collect at store and sales amount last year
  • % So far this year – Percentage of collect at store sales so far this year
  • % So far LY – Percentage of collect at store sales so far last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists month sales statistics with comparison so far to this year.

Selections:

• Year – Default current year
• Month – Default current month
• Team – Default all
• Profile – Default all
• Department – Default all
• Store – Default all
• E-Commerce Store – Select a single value

Output:

• Report shows two tables, first one for selected month, secon for this year.
• Report separates stores with less than 1 year of operation and with more than 1 year of operation.
• Report has a summary for each column for selected stores.

Columns:

• No – Store number
• Store – Store name
• Budget - Budget amount, monthly/yearly
• Turnover – Sales amount, monthly/yearly
• Diff. – Difference between budget and turnover, monthly/yearly
• Diff % - Percentage difference between budget and turnover, monthly/yearly
• Turnover LY – Turnover last year, monthly/yearly
• Diff % -  Difference between Turnover and Turnover last year, monthly/yearly
• GP % - Gross profit percentage, monthly/yearly
• GP % LY – Gross profit percentage last year, monthly/yearly
• SCN % - Percentage scanned article over quantity, monthly/yearly
• Sale/cust – Sales amount over receipt count, monthly/yearly
• Avg qty. – Average quantity, monthly/yearly

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales per hour and per department for selected two dates.

Selections:

• Date 1 – Default today
• Date 2 – Default tomorrow day
• Store – Default all
• Department – Default all
• Store type – Default all
• Include VAT – Default Yes

Output:

• Report shows report table with turnover and gross profit for two dates with differences.
• Report has a summary of each column.
• Report has also two bar charts. First bar chart shows turnover per hour, second shows total turnover.

Columns:

• Hour – Each hour of a day
• Turnover – Turnover sales
• Gr. prof. % - Gross profit percentage
• Diff. sales – Difference sales
• Diff. sales % - Difference sales percentage
• Diff GP % - Difference gross profit percentage
• Turnover per hour chart
  • X-axis – hour time for Date 1 and Date 2
  • Y-axis – Sales amount
• Total turnover chart
  • X-axis – Total time for Date 1 and Date 2
  • Y-axis – Sales amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists total sales for selected stores in selected period of time.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Profile – Default all
• Store – Defult all
• Department – Default all

Output:

Report shows total sales statistics with comparison to last year. Report has a summary for each column.

Columns:

• No – Store number
• Store – Store name
• Net cost – Net cost amount
• Sales – Sales amount
• Sales LY – Sales amount last year
• Diff % - Difference percentage between sales amount and sales amount last year
• Sales LY nxt.day – Sales amount last year next day (if date from is equal date to)
• Gr. prof. – Gross profit
• GP % - Gross profit percentage
• GP % LY – Gross profit percentage last year
• Diff % - Difference percentage between gross profit and gross profit last year
• Items – Items quantity
• Customers – Customers quantity
• Item/cust – Item per customer quantity
• Sale/cust – Sale per customer amount
• % C@s of sales – Collect at store of sales percentage
• % Change C@S LY – Change collect at store of sales from last year percentage

Interactive sorting:

Interactive sorting on all columns except Number store and store name.

Source:

• Lindbak POS Reportinf Cube (OLAP)

Description:

Report lists customer club sales in stores in selected period of time including turnover, gross profit and average quantity sold.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Defult all
• Department – Default all

Output:

Report has a summary for each column. Report has a turnover bar chart. On x-axis are: total, not customer club, customer club and employess bars. On y-axis is sales amount.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – Total amount
  • Not cust. Cl. – Not customer club amount
  • Cust cl. – Customer club amount
  • Employees – Sales employees
• % of total sales – Percentage of total sales
  • Not cust. Cl. – Not customer club amount
  • Cust cl. – Customer club amount
• Gross profit % - Gross profit percentage
  • Total – Total amount
  • Not cust. Cl. – Not customer club amount
  • Cust cl. – Customer club amount
  • Employees – Sales employees
• Average quantity sold
  • Total – Total amount
  • Not cust. Cl. – Not customer club amount
  • Cust cl. – Customer club amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists loyalty statistic per week in selected year.

Selections:

• Loyalty program -Default 1
• Year – Default today
• Week- Default 4

Output:

Report shows new members in period and new members years to date in this year and last year for each store in selected year and week

Columns:

• Store – Store name
• This year
• Last year
• Diff % - Percentage difference between this year and last year

Source:

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

Description:

Report lists article item types.

Selections:

• Article type – Default all
• Assortment – Default all

Output:

Report shows list of items by type of item.

Columns:

• EAN
• Item name
• Item number
• Sort code
• Assortment
• From date
• To date

Source:

• Lindbak POS Progress

Description:

Report lists loyalty club sales in stores in selected period of time including turnover, gross profit and average quantity sold.

Selections:

• Loyalty program – Default loyalty program
• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Defult all
• Department – Default all

Output:

Report has a summary for each column. Report has a turnover bar chart. On x-axis are: total, not member, member and employess bars. On y-axis is sales amount.

Columns:

• No – Store number
• Store – Store name
• Turnover
• Total – Total amount
• Not member – Not sales customer club
• Member – Sales customer club
• Employees – Sales employees
• % of total sales – Percentage of total sales
• Not member – Not sales customer club
• Member – Sales customer club
• Gross profit % - Gross profit percentage
• Total – Total amount
• Not member – Not sales customer club
• Member – Sales customer club
• Employees – Sales employees
• Average quantity sold
• Total – Total amount
• Not member – Not sales customer club
• Member – Sales customer club

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists members for selected parameters.

Selections:

• Loyalty program – Default loyalty program
• Date from – Default today
• Date to – Default today
• Sales from – Minimum sales amount on member
• Sales to – Maximum sales amount on member
• Top X (X=) – Number of top members
• Top X based on – Selection of measure on which Top X is selected
• Department – Default all
• Article group – Default all
• Sales store – Default all
• Gender – Default all
• Age group – Default 0
• Employees – Default exclude
• Not active members – Default exclude
• Only if accepts email – Default false
• Only if accepts SMS – Default false
• Per household – Default true
• Only OBOS members – Defaukt false
• EAN list – Default empty
• Assortment – Default all
• Vendor – Default all
• Brand – Default all
• Show only members that accepted 'Data analysis' – Default true

Output:

Report shows members list with all details about each member for many selections.

Columns:

• Member number
• Social ID
• Honorific
• Name
• Address
• Zipcode
• City
• Country
• Birth date
• Email
• Mobile
• Phone num. – Phone number
• Member store
• Barcode URL
• Amount
• Items Number of lines
• Num of receipts – Number of receipts

Clarifications:

Report table is too large to fit on one page and part of it is moved to the next page. Selection TOP X (X=) is responsible for number of rows displayed in the table.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sent sms.

Selections:

• Date from – Default today
• Date to – Default today

Output:

Report shows sent sms, where was created and to who.

Columns:

• Created
• Sent
• To
• Body

Clarifications:

Report is from MessageService database.

Source:

• Lindbak POS Message Service

Description:

Report lists sales statistics about each sold item in stores.

Selections:

• Date from – Default first day of the current month
• Date to – Default last day of the current month
• Store – Default all
• Vendor – Default all
• Assortment – Default all
• Subvendor – Deffualt all
• EAN list – Defaul empty

Output:

Report lists statistics about sold items, quantity, campaign sale and gross profit. Table has a summary for each column to sum up all selected stores in period of time.

Columns:

• EAN
• Item name
• Item ID
• Quantity sold
  • Total – total quantity
  • Campaign – Campaign sale quantity
• Turnover with tax
  • Total – Total amount
  • Share – Single amount to total amount in percentage
• Campaign sale
  • Total – Campaign sale
  • % - Campaign sale percentage
• Gross profit
  • Total
  • % - Gross profit percentage
  • % exc. campaign – Gross profit in percentage excluding Campaign
  • Campaign – Campaign gross profit
  • Campaign % - Campagn gross profit percentage

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists Cashier security statistics.

Selections:

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

Output:

Summary totals in the beginning of new hierarchy level for stores. After expanding,there is list of cashiers.

Columns:

• Buttons for expanding and collapsing all drilldowns.
• Store – Store number and store name
• Turnover – Turnover amount
• Amount
• % - Percentage of amount
• Null – Null sales
• Deleted item lines – Deleted item lines quantity
• Receipts on hold – Receipts on hold quantity
• Qty - Quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists giftcards reconciliation between stores.

Selections:

• Date from – Default today
• Date to – Default today

Output:

Report has two tables, first is Transaksjoner (Transactions), second is settlement. Report tables are empty, due to empty database.

Columns:

• Transactions table:
  • Team issued – Team number issued
  • Teamname – Team name issued
  • Issued store – Store number issued
  • Storename – Store name
  • issued Number – Media identifier Issued amount
  • Issued – Date issued
  • Team used – Team number used
  • Teamname – Team name used
  • Used in store – Store number used
  • Store name – Store name used
  • Used amount
  • Used date
  • Type
• Settlement table:
  • Payer – Team name issued
  • Receiver – Team name used
  • Amount – Amount used Type – Transaction type, giftcard or credit note

Source:

• Lindbak Retail

Description:

Report lists weekly sale statistics with comparison to last year.

Selections:

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

Output:

Report shows stores sales statistics with less and more than 1 year of operation. Report has a summary for for stores with less than 1 year operation and total summary for all stores at the end of each column.

Columns:

• No – Store number Store – Store name
• Week N/So far this year – Number of week
  • This year – Sales amount this year
  • Last year – Sales amount last year
  • Diff – Difference between sales this year and sales last year
  • GP % - Gross profit percentage
  • Gr. prof % LY – Gross profit percentage last year

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists total sales for selected stores in selected period of time.

Selections:

• Date from – Default today
• Date to – Default today
• Department – Default all
• Team – Default all
• Profile – Default all
• Store – Defult all

Output:

Report shows total sales statistics with comparison to last year. Report has a summary for each column.

Columns:

• No – Store number
• Store – Store name
• Net cost – Nety cost amount
• Sales – Sales amount
• Sales LY – Sales amount last year
• Diff % - Difference percentage between sales amount and sales amount last year
• Sales LY nxt.day – Sales amount last year next day (if date from is equal date to)
• Gr. prof. – Gross profit
• GP % - Gross profit percentage
• GP % LY – Gross profit percentage last year
• Diff % - Difference percentage between gross profit and gross profit last year
• Items – Items quantity
• Customers – Customers quantity
• Item/cust – Item per customer quantity
• Sale/cust – Sale per customer amount

Interactive sorting:

Interactive sorting on all columns except Number store, store name and net cost.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists price guarantee reconciliation between stores.

Selections:

• Date from – Default otday
• Date to – Default today

Output:

Report has a two tables: Transactions and Settlement. Report tables are empty, due to empty database

Columns:

• Transactions table:
  • Team sold – Team key sold
  • Teamname – Team name sold
  • Store sold – Store key sold
  • Storename – Store name sold
  • Receipt – Transaction id sold
  • Sold date – End date time sold
  • Team returned – Team key returned
  • Teamname – Team name returned
  • Store returned – Store key returned
  • Store name – Store name returned
  • Discount
  • Date returned – End date time returned
• Settlement table:
  • Payer – Team name payer
  • Receiver – Team name receiver
  • Amount – Amount to pay

Source:

• Lindbak POS Reporting DW

CO: 176619

Description:

Report shows all items which were not counted during inventory since given date.

Selection:

• Not counted since - Shows items that are not counted since this date. Default same date last month.
• Retail store - Only available for HQ users. Default first available store.
• Supplier - Filter result on supplier. Default all
• Item group - Filter result on item group. Default all
• Brand - Filter result on brand. Default all
• Show total only - If selected it will only show total, not any items. Default not selected.

Output:

All items which don't appear on last stocktaking. First row is total where under EAN there is a number of all items not counted.

Columns:

• Supplier - Supplier name
  
• EAN - EAN number
  
• Item number - Item number
  
• Item text - Item text
  
• Quantity - Last number in stock -Shows quantity from last stocktaking
  
• Net cost - Last Net cost - Shows total netcost for item from last stocktaking

Sorting:

• EAN

Source:

• Lindbak Retail database

CO: 225452

RTC-28001

Description:

Report lists changes in bonus balance and how much bonus is issued and used over a period of time

Selection:

• Loyalty id - Loyalty program, default 1
• Date From - Default today
• Date To - Default today
• Store - Default all

Output:

Bonus checks overview. For each store sum of issued, redeemed, spent, expired and balance bonus checks with number of sales and members who got/used bonus. Next table with issued amount and member with bonus independent of chosen period. Total sum of each column for all selected stores.

Columns:

• Members with bonus - Number of members with bonus amount balance greater than 0 (independent of chosen period)
• Issued amount - Total bonus amount issued (independent of chosen period)
• Store num - Store number
• Store name - Store name (default sorted on this column)
• Total - The sum of issued amount in the selected period
• Ordinary sales - The sum of bonus amount issued after purchases in the selected period
• Manual checks - The sum of bonus amount issued manually in the selected period
• Spent bonus - total sum of redeemed amount in the selected period
• Expired bonus - Total sum of amount that expires in the selected period (check expiration date is between date from and date to)
• Receipts paid with bonus - Number of sales (receipts) paid with bonus checks in the selected period
• Members who used bonus - Number of unique members who have used bonus, redeemed transaction in the selected period
• Member who got bonus - Number of unique members who got bonus, issued transaction in the selected period
• Bonus balance - Sum of not-expired bonus amount at the end of the selected period

Clarifications:

• Receipts paid with bonus column shows count values selected on distinct member number and distinct transaction date, it resolves issues with the same transaction id at different webshops.
• All data is based on FactMemberTransaction.

Source:

• Lindbak POS Reporting DW

Description:

Report lists sales per VAT code in all stores.

Selections:

• From date – Default today
• To date – Default today

Output:

Report has total summary at the end of table.

Columns:

• No – Store number
• Store – Store name
• Sales per VAT code
• 25%/0%/15%/8%
  • Tax amount
  • Sale inc. VAT – Sale including VAT
• Total
  • Sale inc. VAT – Sale including VAT
  • Turnover
  • Diff. - Difference

Source:

Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales compared to reference item

Selections:

• Store – Default select a single store
• Date – Default today
• Målegrunnlag – Reference item
• Salgsfokus – Focus item

Output:

Report shows sales compared to reference for selected store in selected date.

Columns:

• PLU – Price look-up code, EAN
• Quantity – Article name
• Item name
• % achieved – Percentage of achieved items

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists ranking of sold items per hour.

Selections:

• Team – Default all
• Store – Default all
• Date from – Default today
• Date to – Default today
• Article group – Default all
• Type – Default Top
• Top X – Default 10 top items

Output:

Report shows top X items sold per hour. Hour column is dependent from sales and will avaible if item will sold.

Columns:

• Rank – Ranking position
• PLU – EAN item
• Name – Article name
• Quantity

Clarifications:

Report can show all hours and sales made in selected period of time. It can be full 0-24. To better presentation of report, some hour columns was cut from table manually.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists ranking of bestseller items, best cashiers and stores in the country and in a particular store.

Selections:

• Date from – Default today
• Date to – default today
• Store – Default store number 103
• District – Default Team number 25

Output:

Report is divided on 6 tables:

1. Top 10 items in the country in all stores
2. Top 10 items in the store (default 103)
3. Top 10 cashiers in the country in all stores
4. Top 5 cashiers in the store (default 103)
5. Top 5 stores in the country
6. Top 5 store in district (default chosen District 25)

Columns:

• Table 1 and table 2
  • EAN
  • Item name
  • Quantity
• Table 3
  • Store – Store number
  • Store name
  • Cashier – Cashier number Cashier name
  • Amount
• Table 4
  • Cashier – Cashier number
  • Cashier name
  • Amount
• Table 5 and Table 6
  • Store – Store number
  • Store name
  • Amount

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists customer club sales in stores in selected period of time including turnover, gross profit and average quantity sold.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Defult all
• Department – Default all

Output:

Report has a summary for each column. Report has a turnover bar chart. On x-axis are: total, not customer club, customer club and employess bars. On y-axis is sales amount.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – Total amount
  • Not cust. Cl. – Not customer club amount
  • Cust cl. – Customer club amount
  • Employees – Sales employees
• % of total sales – Percentage of total sales
  • Not cust. Cl. – Not customer club percentage of total sales
  • Cust cl. – Customer club percentage of total sales
• Gross profit % - Gross profit percentage
  • Total – Total amount
  • Not cust. Cl. – Not customer club gross profit
  • Cust cl. – Customer club gross profit
  • Employees – Sales employees
• Average quantity sold
  • Total – Total average quantity sold
  • Not cust. Cl. – Not customer club average quantity sold
  • Cust cl. – Customer club average quantity sold

Clarifications:

Same as 0104, but uses customergroup rather than customer number for identifying customer club members

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists free items form stampcards.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• EAN list – Default empty
• Order number list – Default empty

Output:

Report shows table with divided vendors. Each vendor has a list of stores.

Columns:

• Date – Transaction date
• Store num. - Store number
• Store name
• CouponID
• EAN
• Order number
• Item name
• Amount
• Quantity

Source:

• Lindbak POS Reporting DW

CO-10565

Description:

Report lists cash register statistics for stores.

Selections:

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

Output:

• Report shows 4 tables: Turnover, Workstation settlement, Payment in/out and Statistics/Control. Each table contains the relevant statistics.
• Report contains total to bank amount value.
• Report shows also signature section for cashier and store manager.

Columns:

• Total for store  - Total statistics for store, all workstations
• Total tender amount – cash, paymentcard, bonuscheck, papergiftcards, invoice, klarna
• Total balance cash amount
• Total change amount
• Received cash Lindbak
• Total payment In/Out cost
• Number of receipts – Returns, deleted, discount, article lines
• Workstation number – Statistics for selected workstations

Clarifications:

Total to bank amount is balance cash amount without change amount value.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists all departments (concepts) per month for all stores.

Selections:

• Date from – Default today
• Date to – Default today

Output:

Report shows all Stores with all departments, turnover, quantity and gross profit. Report at the end creates total summary table for all stores and departments.

Columns:

• Store – Store number
• Store name
• Concept – Department
• Turnover inc VAT – Turnover including VAT
• % of turnover – Percentage of turnover
• Quantity
• GP % - Gross profit percentage

Clarifications:

Due to large report with all stores, screenshot of report was cutted to reasonable size.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists weekly takings in all departments in stores.

Selections:

• Date from – Default sunday two weeks ago
• Date to – Default sunday one week ago

Output:

Report shows weekle takings in stores in each department. Report has a total summary at the end of table. Report has also one total column at the end of each store row.

Columns:

• Store no – Store number
• Store name
• Department columns – Amount for each department in store
• Total – Total amount for store

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists weekly sales statistics for all stores.

Selections:

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

Output:

Report shows sales statistiscs about all stores in selected week. It shows Sales this week, Budget, Last year, Consept % of sales and KPI. Report has a summary at the end of each column.

Columns:

• Store – Store name
• Store num. – Store number
• Rank
• Sales this week
  • Mon – Sun columns- Sales amount every day in selected week
  • 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 amount last year
  • Week sales LY diff. – Week sales amount to week sales last year difference
  • Sales last year YTD – Sales last year, year to date
  • Sales LY diff. – Sales to last year sales difference
• Consept, % of sales
  • Accessories – Sales week accessories to sales week
  • Kids – Sales weeks kids department
  • Monsoon – Sales weeks monsoon department
• KPI – Key performance indicator
  • Purchasing customers – Number of transactions
  • Purchasing customers LY – Number of transactions last year
  • Items – Items quanity
  • Items LY – Items quantity last year
  • ATV – Average transaction value
  • ATV prev. year – Average transaction value previous year
  • UPT – Units per transaction
  • UPT prev. year – Units per transaction previous year
  • Gr. prof. % - Gross profit percentage
  • Gr. prof. % LY – Gross profit percantage last year
  • Visitors LY – Customers in week last year
  • Conv. Rate LY – Conversion rate last year between quantity weekly and customers in week
  • Visitors – Customers in week
  • Conv. Rate – Conversion rate between quantity weekly and customers in week

Clarifications:

Negative values are marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists Inter-branch-transfer form.

Selections:

• Date from – Default first day of the current month
• Date to – Default today

Output:

Report shows Inter-branch-transfer of goods between stores. Report contain information table and three rows: season, total quantity and date items sent. Season rows is an empty cell.

Columns:

• Sending Store
• Receiving Store
• 10 Digit Code – Extract numbers from EAN
• Quantity – Item transaction quantity
• Avg Net Cost Price – Average net cost price

Source:

• Lindbak POS Reporting DW

Description:

Report lists international stock adjustments form.

Selections:

• Date from – Default today
• Date to – Default today

Output:

Report shows store and authorisation details. Report shows which country is related to table. Report has also legend above table with reason code numbers. Report table has a total summary on value column.

Columns:

• Store number
• SKU – Stock keeping unit
• Reason Code
• Qty – Quantity
• Invoice Number
• Value – Costprice multiplied by quantity

Source:

• dsProgress

Description:

Report lists item statistics.

Selections:

• Date from – Default today
• Date to – Default today
• Team – Default all
• Store – Default all
• Department – Default all
• Article area – Default all
• Article group – Default all
• Article subgroup – Default all
• Season – Default all

Output:

• Report has a two buttons, one expanding all drilldowns, second for collapse all drilldowns.
• Totals in the beginning of new hierarchy level for:
  • Department
  • Item area
  • Item group
  • Subgroup
  • Model
  • Color
  • Size

Columns:

• Buttons for expanding and collapsing all drilldowns
• EAN
• Item name
• Season – Season number
• Unit price Items sold
• Value - Amount
• Gross profit
• GP % - Gross profit percentage
• Discount % - Discount percentage
• Received – Docking transaction in period
• Stock – Stock quantity
• Wks of cover – Weeks of cover, Stock quantity divided by quantity

Source:

• Lindbak POS Reporting Cube (OLAP)
• Database Progress

Description:

Report lists sale statistics for selected stores in selected period of time.

Selections:

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

Output:

Report has a summay total on each column.

Columns:

• Store – Store number and store name
• Omsetning (Turnover)
  • Dette år (This year) – Sales amount
  • Forrige år (Previous year) – Sales amount last year
  • Differanse (Difference)
• Budsjett (Budget)
  • Budsjett (Budget) – Budgeted amount including VAT
  • Diff mot budsjett (Difference against budget) – Sales amount wihout budgeted amount
• Solgte varer (Sold items)
  • Dette år (This year) – Items sold quantity
  • Forrige år (Previous year) – Items sold quantity last year
  • Differanse (Difference)
• ATV - Average Transaction Value
  • Dette år (This year)
  • Forrige år (Previous year)
  • Differanse (Difference)
• UPT – Units per transaction
  • Dette år (This year)
  • Forrige år (Previous year)
  • Differanse (Difference)
• Handlende kunder (Customer)
  • Dette år (This year) – Number of customers
  • Forrige år (Previous year) – Number of customers last year
  • Differanse (Difference)
• Konvertering (Item/Customer)
  • Dette år (This year) - Item per customer quantity
  • Forrige år (Previous year) - Item per customer quantity last year
  • Differanse (Difference)
• BF i % (Gross profit percentage)
  • Dette år (This year) – Current gross profit
  • Forrige år (Previous year) – Gross profit last year

Clarifications:

Negative values are marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales statistics from selected country.

Selections:

• Country – Default select Norge, Sweden or Finland
• Year – Default current year
• Week – Default select a single value

Output:

Report shows sales statistics for all countries. Report has a total summary at the end of table on each column and Organiske butikker uten 2266 summarize.

Columns:

• Store – Store name
• Store num – Store number
• Rank
• Sales this week
  • Mon-sun – sales for each day
  • 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 – Slaes last year,  year to date
  • Sales LY diff. – Sales last year difference
• Consept, % of
  • Accessorize – Accessorize sales over week sales
  • Kids – Kids sales over week sales
  • Monsoon – Monsoon sales over week sales
• KPI
  • Purchasing customers – Receipts count week
  • Purchasing cusomers LY – Number of transactions last year
  • Items - Quantity
  • Items LY – Quantity last year
  • ATV – Average transaction value
  • ATV prev. year – Average transaction value previous year
  • UPT – Unit per transaction
  • UPT prev. year – Unit per transatcion previous year
  • Gr. prof. % - Gross profit percentage
  • Gr. prof. % LY – Gross profit percentage last year
  • Visitors LY – Customers in week, last year
  • Conv. Rate LY – Conversion rate last year
  • Visitors – Customer in week
  • Conv. Rate – Conversion rate

Source:

• Lindbak POS Reporting Cube (OLAP)

PBI:120761

Description:

Report lists new members per store.

Selections:

• Loyalty program – Default loyalty program
• Year – Default current year
• Calculate per – Default month
• Period – Default current period
• Date from – Default beginning of the current week
• Date to – Default today
• Team – Default all
• Store – Default all

Output:

Report shows list of new members in selected period of time with comparison dates range. Report has a summary for teams and total summary for all teams and stores. Report only list a store if there are sales in at least one of the periods (this period, last period or same period last year).

Columns:

• Store
• This period/Last period/Same period last year
  • Number of customers and new members
  • New members %
  • New members

Source:

• Lindbak POS Reporting Cube (OLAP)

PBI:120758

Description:

Report lists recruitment goal for selected stores.

Selections:

• Loyalty program – Default loyalty program
• Year – Default current year
• Week – Default current week
• Retail store – Default all

Output:

Report shows list of recruiment goals through week.

Columns:

• Store number and store name
• Period
• Monday - Sunday
• Chosen period – summary for whole week
• So far this year
• Achieved recruitment goal – Percentage of achieved recruitment goal
• This year – Percentage recruitment this year

Source:

• Lindbak POS Reporting Cube (OLAP)

CO:10169

Description:

Report lists postal codes in store.

Selections:

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

Output:

Report shows postal codes, their quantity and period in stores.

Columns:

• Store – Store number
• Store name
• Period
• Postal code
• Quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

CO10145

Description:

Report lists statistics about cashiers in stores.

Selections:

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

Relevant parameters:

pBalanceTenderType – setting tenders for for balance to type cash

Output:

Report show statistics about quantity and amount from receipts, items, giftcards and discounts for cashiers in selected stores and period of time.

Columns:

• Store No – Store number
• Store name
• Cashier No – Cashier number
• Cashier name
• Sales ex/VAT – Net amount
• Receipts Qty – Receipts quantity
• Complaint Qty – Return quantity
• Complaint Amount – Return amount
• Returns excl. reclamations Qty – Returns excluding reclamation quantity
• Return excl. reclamations Amount – Returns exluding reclamation amount
• Deleted item lines Qty – Deleted item lines quantity
• Deleted item lines amount
• Receipts on hold Qty – Receipts on hold quantity
• Receipts on hold amount
• Deleted on hold Qty – Deleted receipts on hold quantity
• Deleted on hold amount – Deleted receitps on hold amount
• Null – Null sales
• Scanned – Scanned articles percentage
• Credit note Qty – Issued credit note quantity
• Credit note amount – Issued credit note amount
• Gift card Qty – Gift card quantity
• Gift card amount
• Diff – Balance difference
• Personnel discount Receipts
• Personnel discount Amount
• Line discount Qty – Line discount quantity
• Line discount Amount
• Open drawer – Open drawer quantity

Interactive Sorting:

Interactive sorting on all columns except Returns excl. reclamations, Deleted item lines gift card, and open drawer

Clarifications:

Report table is too large to fit on one page and part of it is moved to the next page

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales statistics of selected stores.

Selections:

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

Output:

Report shows simple sales statistics (net amount and quantity) for selected stores and selected period of time. Report has a summary for each column.

Columns:

• No – Store number
• Name – Store name
• Net amount – Sales net amount
• Qty – Quantity of receipts

Clarifications:

Report has a 2 textboxes above report table to show dates about printing and data updating.

Source:

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

Description:

Report lists mix coupons in selected period of time for selected stores.

Selections:

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

Output:

Report shows sales statistics about mix coupons. Report has a summary at the end of each column.

Columns:

• Mixno – Mix number
• Mix text – Mix name
• Receipts with mix
• Amount in mix ex. VAT – Amoint in mix excluding VAT
• Share mix receipts
• Avg. amount in mix receipts ex. VAT – Average amount in mix receipts excluding VAT
• Avg. sales customer – Average sales amount
• Gr. prof. % mix - Gross profit percentage mix
• Gr. prof. % total – Gross profit % total

Clarifications:

Report calculate values for all articles in store. It means it doesn't take only mix articles sold in store, but all articles. As an example look on gross profit % total.

Source:

• Lindbak POS Reporting Cube (OLAP)

Descriptions:

Report lists all manual discounts for all Cashiers in selected stores.

Selections:

• Date from – Default today
• Date to – Default today Store – Default all
• Operator – Default all
• Reason code – Default all

Output:

Report lists item number with manual discount per cashier name in selected stores. Quantity and Discount are summed up at the end of report.

Columns:

• Store – Store number
• Number – Operator number
• Cashier name – Cashier full name
• Item num. – item number
• Item name
• Quantity
• Reason code
• Discount - Discount of article
• Discount %

Sorting:

• Interactive sorting on all columns

Source:

• Lindbak POS Reporting cube (OLAP)

CO: 10637, PBI#119080

Description:

Report lists cashiers settlements.

Selections:

• Date from – Defualt today
• Date to – Default today
• Store  - Default all
• Workstation – Default today

Output:

• Report shows information about cashier's settlement in selected stores and period of time.
• One page per store.
• Summary totals in the beginning  of new hierarchy level for workstations.
• Report has a summary for each column for each store table.

Columns:

• Buttons for expanding and collapsing all drilldowns
• Workstation/Operator – Workstation name and operator number and operator name after expanding
• Sales – sales amount
• Invoice – Invoice tender amount
• Lottery tickets – Finance tender amount
• Bal. lottery tickets – Finance balance amount
• Diff lottery tickets – Difference balance amount
• Number of coupons
• Coupon amount
• Used giftcards – Received gift cards amount
• Used credit notes
• Returned qty. – Returns quantity
• Returned amt. – Returns amount
• Cash – Received cash amount and drop amount
• Balance cash amt. – Balance cash amount
• Cash diff – Cash difference

Clarifications:

Columns with balance and difference values are used only for workstations.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-79777, PBI#149117

Description:

Report lists staffing planning report for selected hours in particular date period.

Selections:

• Store – Default first single selection
• Date from – Default today
• Date to – Default today
• Weekday – Default all
• Hour – Default all
• Report type – Default workstation

Output:

Report shows time tables with sales and quantity statistics for workstations. Every table has a summary for each column.

Columns:

• Time – Selected hour
• Sales – Sales net amount for workstations
• Number of goods – Items quantity for workstations
• Num of receipts – Number of receipts for workstations
• Total per cash register
  • Sales – Net amount sales
  • Number of goods – Items quantity
  • Num of receipts – Number of receipts

Clarifications:

Report type can be workstation or cashier. Negative values are marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-96179

Descriptions:

Report shows detailed customer club sales.

Selections:

• Date – Default today
• Store – Default all

Output:

Report lists receipts with price and number of items for selected stores and particular day.

Columns:

• Store – Store number
• Workstation – Workstation number
• Cashier – Cashier number
• Receipt
• Member number
• Sales incl. VAT – Sales including VAT
• Sales excl. VAT – Sales excluding VAT
• Items – quantity of items

Source:

• Lindbak POS Reporting DW

Description:

Report lists customer club sales in stores in selected period of time including turnover, receipts, gross profit and average quantity sold.

Selections:

• Loyalty program – Default loyalty program
• Date from – Default today
• Date to – Default today Team – Default all
• Store – Defult all
• Department – Default all

Output:

Report has a summary for each column.

Columns:

• No – Store number
• Store – Store name
• Turnover
  • Total – Total amount
  • Cust cl. – Customer club amount
• Turnover ex. VAT – Turnover wxcluding VAT
  • Total – Total amount
  • Cust cl. – Customer club amount
  • Share
• Receipts
  • Total – Total receipts quantity
  • Cust cl. – Customer club receipts quantity
• Gross profit % - Gross profit percentage
  • Total – Total amount
  • Not cust. Cl. – Not customer club gross profit
  • Cust cl. – Customer club gross profit
• Average quantity sold
  • Total – Total average quantity sold
  • Not cust. Cl. – Not customer club average quantity sold
  • Cust cl. – Customer club average quantity sold
• Average sales ex. VAT – Average sales excluding VAT
  • Total – Total average sales
  • Not cust. Cl. – Not customer club average sales
  • Cust cl. – Customer club average sales

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 54553, PBI#133702

Description:

Report lists sale statistics in stores by brand, departments and articles groups.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Brand – Default all
• Department- Defualt all
• Article group – Default all

Output:

• Report shows sales statistics about articles.
• Report has a summary total for each column at the end of table.
• Totals in the beginning of new hierarchy level for:
  • Brand
  • Department
  • Item group
  • Model

Columns:

• Buttons for expanding and collapsing all drilldowns.
• EAN/PLU – Main EAN
• Item name
• Color/Size – Color/size description about article
• Quantity sold total
• Quantity sold campaign
• Turnover with tax total
• Turnover with tax share
• Campaign sale total
• Campaign sale % - Campaign sale percentage
• Gross profit total
• Gross profit total % - Gross profit total percentage
• Gross profit % exc. Campaign – Gross profit % excluding campaign
• Gross profit campaign
• Gross profit campaign % - Gross profit percentage

Clarifications:

Negative values are colored red

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-54553, PBI#133703

Description:

Report lists sales statistics for selected day.

Selections:

• Date – Default today
• Store – Default all
• Department – Default all
• Article group – Default all

Output:

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

Columns:

• Model nr – Model number
• Model name
• Brand
• Quantity – Sales quantity
• Sales amount inc. VAT – Sales amount including VAT
• GP – Gross profit
• GP % - Gross profit percentage
• Average price
• Ordinary price
• Campaign price
• Cost price per item
• This month – Quantity sold this month
• Last month – Quantity sold last month
• Last 12 months – Quantity sold last 12 month
• Number in stock – Current stock quantity
• Ordered/In order – Orderer/In order stock quantity

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists club customer sales statistics.

Selections:

• Team – Default all
• Store – Default all
• Date from – Default today
• Date to – Default today
• Member – Default empty
• Subvendor – Default all
• Brand – Default all

Output:

Report shows list of articles for every customer in store with sales statistics. One store per page.

Columns:

• EAN
• Store – Store number and store name
• Customer – Customer number and customer name
• Item name
• Item num. – Item number
• Model nr – Model number
• Brand
• Quantity
• Amount
• Cost – Net cost
• Gross profit
• Gr. Prof. % - Gross profit percentage

Source:

• Lindbak POS Reporting Cube (OLAP)

CO-109712

Description:

Report lists internal transfers with net cost.

Selections:

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

Output:

• Report shows netcost for both sending and receiving store.
• Totals in the beginning of new hierarchy level for:
  • Store
  • Receiving store
  • Department
  • Item area

Columns:

• Buttons for expanding and collapsing all drilldowns
• EAN
• Item name
• Color – Color of item
• Size – Size of item
• Number – Operator number
• Date
• Net amount
• Quantity
• Senders costprice
• Receivers costprice
• Deviation costprice
• Amount GP % - Gross profit percentage

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 156791. Based on report 0709.

Description:

Report allows to follow up store settlement: on first page settlement for all selected cashiers (if all cashiers are selected it equals whole store settlement) and settlement per each cashier on following pages. Report is divided in 9 subreports which will be descriped separatly below.

Selections (applies to all subreports): 

• Date from - Default today
• Date to - Default today
• Store - Default select single store
• Operator -Default all

Subreports:

Source:

• Lindbak POS Reporting cube (OLAP)

Description:

Report lists inventory values per iteam areas.

Selections:

• Store – Default select a single store
• Stocktaking – Default select a single value

Output:

Report has on the beginning informations about inventory date and selected store. Report has a summary for inventory values at the end of table.

Columns:

• Item area
• Area name
• Inventory value
  • Cost price
  • Ex. VAT – Excluding VAT
  • Sales amount inc. VAT – Sales amount including VAT

Source:

• Lindbak Retail

CO-167575

Descriptions:

Report lists broken and waisted items.

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Subvendor – Default all
• Article area – Default all
• Article group – Default all
• Transaction type – Default all
• Reason code – Default all

Relevant parameters:

• pTransactionTypesToExclude - Comma separated list of transactions types not to show in list of transaction types.

Output:

Report shows items, their transaction type with price and quantity for selected stores and their subvendors.

Columns:

• Store – Store number and store name
• Subvendor – Subvendor number and subvendor name
• EAN
• Item name
• Item number
• Number - Cashier number T
• ransaction type
• Reason code
• Date - Date of transaction
• Net price
• Quantity
• Net price total – Total net price number of items

Clarifications:

Report allow to show same items with different transaction types and sum up of quantity and price. It happens under each selected subvendor,  which is placed under selected store.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 162073

Description:

Report lists sales and comparison dates sales by product area.

Selections:

• Date from – Default today
• Date to – Default today
• Compare date from - Default the same day of week as Date from year before
• Compare date to - Default the same day of week as Date to but year before
• Article area – Default all
• Article group – Default all
• Store – Default all
• Report type – Default area

Output:

Report shows sales by product area or group with comparison sales in selected period of time and stores. Report has a summary for each column.

Columns:

• Article area – Article number and name
• Sales incl. VAT – Sales including VAT
• Sales ex. VAT – Sales excluding VAT
• Total % - Total amount percentage
• Quantity
• Price pr. Art. – Price per article
• Amount – Gross profit Amount
• % - Gross profit percentage
• Diff. - Difference
• Diff % - Difference percentage

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists top sales per item wirh compare date

Selections:

• Date from – Default today
• Date to – Default today
• Compare date from – Default one year ago
• Compare date to – Default one year ago
• Stores – Default all
• Article area – Default all
• Article group – Default all
• Grouping – Default by Area
• Number of items – Default 10
• Sorting – Default by Best
• Measure – Default by Sum
• Include VAT – Default True
• Vendor – Default all
• Subvendor – Default all
• EAN list – Default empty space
• Price channels – Default all

Output:

Report's table is divided on item areas and has total summary at the end of table on each column.

Columns:

• Area – Article area
• Grp. – Article group
• EAN
• Item name
• Article info – Article label text
• Selected date/Selected compare date
  • Quantity
  • Turnover
  • Gross profit
  • Gr. prof. % - Gross profit percentage

Interactive sorting:

Interactive sortinge on all columns.

Clarifications:

Negative values are marked red.

Source:

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

Description:

Report lists sale statistic of items in stores

Selections:

• Date from – Default today
• Date to – Default today
• Store – Default all
• Vendor – Default all
• Assortment – Default all
• EAN list – Default empty
• Subvendor – Default all

Relevant parameters:

pArticleIdentifier – Parameter identifies ItemID of article

Output:

• Report shows statistics about items, quantity, campaing and gross profit for selected stores in period of time.
• One row per article.
• Report has a summary of each column.

Columns:

• EAN
• Item name
• Item ID
• Quantity sold Total
• Quantity sold Campaign
• Turnover with tax Total
• Turnover with tax Share
• Campaign sale Total
• Campaign sale % - Campaign sale percentage
• Gross profit Total
• Gross profit % - Gross profit percentage
• Gross profit % exc. Campaign – Gross profit percentage excluding campaign
• Gross profit Campaign
• Gross profit Campaign % - Gross profit campaign percentage

Interactive sorting:

Interactive sorting on all columns

Source:

• Lindbak POS Reporting Cube (OLAP)

Description:

Report lists sales and comparison dates sales by product area.

Selections:

• Date from – Default today
• Date to – Default today
• Compare date from - Default the same day of week as Date from year before
• Compare date to - Default the same day of week as Date to but year before
• Article area – Default all
• Article group – Default all
• Store – Default all
• Price channels – Default all
• Report type – Default area

Output:

• Report shows sales by product area or group with comparison sales in selected period of time and stores. Report has a summary for each column.

Columns:

• Article area – Article number and name
• Sales incl. VAT – Sales including VAT
• Sales ex. VAT – Sales excluding VAT
• Total % - Total amount percentage
• Quantity
• Price pr. Art. – Price per article
• Amount – Gross profit Amount
• % - Gross profit percentage
• Diff. - Difference
• Diff % - Difference percentage

Interactive sorting:

Interactive sorting on all columns.

Source:

• Lindbak POS Reporting Cube (OLAP)

CO: 190620

Description:

Report allows to follow upcoming and ongoing campaigns and also browse expired campaigns.

Selections: 

• Date from - Default today
• Date to - Default today
• Store - Default all
• Apply date filter to - Start date (Date from <= Start date <= Date to)/ End date (Date from <= End date <= Date to)/ Ongoing (Date from <= End date and Date to <= Start date) - default Start date
• Status  - Expired/Active/Not approved - default all
• Include profile campaigns -default false

Output:

One row per campaign

Columns: 

• Store
• Campaign group
• Campaign ID
• Campaign name
• Status - Expired/Active/Not approved
• Start date
• Start time
• End date
• End time
• Created by

Sorting:

• Interactive sorting on all columns except time

Source:

• dsProgress

CO: 191144

Description:

Report allows to follow up article sales and waste grouped per store and per (item group or item area).

Selections: 

• Date from - Default today
• Date to - Default today
• Store - Default all
• Article area - Default all
• Article group - Default all
• Reason Code - Default all
• Grouping - item area or item group - Default Item area
• Exclude items without breakage - Default false

Output:

Article sales and waste statistics grouped per store and per item group or item area sorted by highest Lost amount. There is a page break per each store and total all stores in the bottom of last page. If Exclude items without breakage parameter is set to true there will be only items with breakage.

Columns: 

• Buttons for expanding and collapsing all drilldowns.
• ItemNo - Item number
• Item name
• Sales quantity - number of sold items
• Sales ex. VAT - sales amount ex. VAT
• Net cost - net cost of sold items
• Waste qty - number of broken items
• Lost amount - net cost of broken items
• Breakage % - share of Waste qty in Sales quantity
• Lost amount % - share of Lost amount in Net cost