Page History

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

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

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

Standard report

Image Added

Standard report

Image Added

Standard report

Image Added

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

Image Added

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

Image Added

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 

Image Added

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

Image Added

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

Image Added

Image Added

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)

Image Added

Image Added

Description:

Report allows to follow up store settlement: on first page settlement for all selected workstations and settlement per each workstation on following pages. Report is divided in 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

Image Added

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

Image Added

Description:

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

Selections:

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

Output:

One page per store

One row per cashier

Columns:

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

Sorting:

• No sorting

Source:

• Lindbak POS Reporting cube (OLAP)

Image Added

Description:

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

Image Added

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)

Image Added

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)

Image Added

Description:

Report lists sales per customer.

Selections:

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

Output:

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

Columns:

Customer number

Number - Operator number

Cashier - Cashier name

Customer - Customer name

Quantity

Price pr. Art. - Price per article

Disc. p. item - Discount per item

Discount

Discount % - Discount percentage

Gross profit % - Gross profit percentage

Hidden parametes:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists package sales.

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

Everything except Cost, unit price and % of total

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per weekday.

Selections:

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

Output:

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

Columns:

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

Clarifications:

Negative values are marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per cashier in stores.

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers from stores and their sales.

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

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

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists besteller items in stores.

Selections:

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

Output:

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

Columns:

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

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists staff discount for employees.

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists type of discounts in stores

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

Interactive sorting on Store num. and Store columns

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists discounts of items in stores.

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

• Date
• Discounts
• Discount %
• GP %

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists inventory adjustments in stores.

Selections:

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

Output:

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

Columns:

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

Clarifications:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers turnovers at a particular day.

Selections:

• Date – Default today

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists stores turnovers at a particular day.

Selections:

• Date – Default today

Output:

Report is presented as file to csv exportwithout any colors.

Columns:

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

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists cashiers turnovers on a particular day per receipt.

Selections:

• Date – Default today

Output:

Report is presented as file to csv exportwithout any colors.

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales statistics with drilldown.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

Interactive sorting on Cashier name, Number and Gross.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Interactive sorting:

Interactive sorting on all except Makeup %.

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per week.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists average sales per customer.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists bestseller products in each store.

Selections:

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

Output:

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

Columns:

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

Source:

Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists campaign sales statistics.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists mixmatch list of articles for stores.

Selections:

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

Relevant parameters:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Clarifications:

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

Source:

• Lindbak POS Reporting DW

Image Added

Description:

Report lists sales per store with differnce report per day

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with differnce report per day

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

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

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per month.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per week.

Selections:

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

Output:

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

Columns:

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

Source:

• Lindbak POS Reproting Cube (OLAP)

Image Added

Description:

Report lists sales per store with difference per week.

Selections:

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

Output:

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

Columns:

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

Clarifications:

Item name is marked red.

Source:

• Lindbak POS Reporting Cube (OLAP)

Image Added

Description:

Report lists mix sales for articles in a particular store.

Selections:

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

Output:

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

Columns:

• EAN
• Item name
• Mix sales - Quantity

Source:

• Lindbak POS Reporting DW

CO-1069

Image Added

Description:

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

Selections:

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

Output:

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