Micros Workstation 12 Month Transaction Totals?

[JonnyB82]

Hi Guys,

I have an estate review meeting later today, it has just been requested that I provide the following:

For the last twelve months, a report, showing transaction volumes for all of the Micros tills that we have on the estate with the data sorted in order of volume (highest to lowest), on a per till basis.

I have spoken to Micros Support, they have suggested that this is not possible unless we use cashiers within RES 3700, which we don't. We only keep 2 months data within our local database, however we have 13 months of data stored within MyMicros.

I have searched around within MyMicros, 'iReports' does not allow you to select Workstation as an available field, and the 'Audit & Analysis' Transaction Summary will not let me select Workstation as an option.
However, 'Audit & Analysis' Transaction Detail will let me select the Workstation, but only lets me retrieve the item types of Discounts or Tender Media, not Transaction Count.

I can't believe it can be so difficult to retrieve such a simple selection of data from MyMicros? any ideas would be appreciated.

Thanks,
Jon

 

[Moregelen]

The reason you're running into issues is that it sounds like you didn't set the system up to track using tills (cashiering). The reason this makes a difference is that in normal server operations it doesn't make any sense to track which workstation the rang in on; for one thing servers don't usually even use tills.

Did you have servers or cashiers only? If you had cashiers is there any way for you to tell which machine employees were signed into? Would they change machines during a shift? If you still have the logs you should be able to just pick a transaction and see which workstation it was on.

How, exactly, were you doing things there?

 

[JonnyB82]

Thanks for the reply, I inherited this system when I started the job (with zero Micros knowledge) a couple of years back, I wasn't part of the initial system design, so I cannot really comment on why it was setup the way it is.

As for my query, I'm not really worried about where/what till the transaction detail was added etc, purely just the amount of checks closed on each workstation for a defined period. The aim is to see if tills can be reduced in certain areas prior to a kit refresh along with the planned RES 5 upgrade.

I'm kind of getting somewhere, but as yet only for DEC 2013. I'm using the Transaction Analyser tool:
Category = Payments
Period = All December 2013
Location = All
Format and Sort > Selected Columns = Revenue Centre, Workstation, Business Date, Check Number.

I have tried exporting from TA to the Excel xls format, but it truncates at 65536 rows which equals 1st through 22nd DEC.
I'm now about to try exporting the whole months data in PDF format, then import the detail into Excel that way...
Once the data is in Excel I can remove any multiple checks numbers per WS per day (i.e where change has been given on a check), then using the count feature I should be able to obtain how many checks were closed per WS.

I was hoping to get the data from MyMicros for a 12 month period, but as that doesn't appear possible, 2 months of data from our local DB is better than none. This will at least give me an idea on which of our 35 tills are getting used the most.

 

[Moregelen]

Well.. if you do a transaction detail query in MyMicros you can specify the workstation.

 

[JonnyB82]

Yes, thats true, but unfortunately even with just 1x RVC selected it times out and errors due to there being >5000 rows of data returned

 

[Moregelen]

Have you played around with Interactive Reports? A long shot I think, but you might find an option in there that lets you build the report with workstations.

 

[JonnyB82]

Yes, had a quick play but unfortunately 'Workstation' does not appear to be an available field in any of selections, shame because this information is obviously in the MyMicros database as it is available on different Audit & Analysis reports.