SXe Reporting against Live

What do others that are running SXe use to report against live throughout the day? Do any of you sync Phocas during the day?


We do sync some data to Phocas throughout the day. There’s two things you have to take into consideration. 1st is the time it takes to sync. There’s a lot of things you can do with sync to get the actual sync time down. We have an hourly sync that runs and syncs some data in a matter of 30 seconds or so. The second piece is the rebuilding of the database. Depending on how much data is in the database, and how you have the time periods defined, and how many dimensions, this can take from minutes to hours. It definitely takes some thought and planning on what data you want to see throughout the day.