Hi,
I would like to raise an issue regarding snapshot data output. I have created a small database to illustrate the issue. Situation
We want to monitor stock, we have enabled a daily snapshot to provide the “Syncmoment”. The design is very simple as below:
Please take note of highlighted rows as will be discussed below. I have assigned the syncmoment as the date and then built the database.
With this generated we see these results:
The highlighted amounts (TOTAL) is where the issue arises. The total is adding up each day to give you a total, with stock on Part A we had 100 which then went to 50, therefore the total based on the date range above would be actually 0 not 50. These are known as semi-additive measures, where the total is actually the latest value based on the date range. If for example I changed to the 16 & 17th only, the total would be 50. The total that Phocas is displaying is a simple sum of the periods being reported on. This causes numerical inaccuracies in the results. Since there is no means of turning off the total column (raised as another feature request here) there needs to be a means of the total displaying the correct value or disabling the total all together.
Please let me know if I am missing something on snapshot data as in its current structure it makes stock analysis difficult to display to end users.
I’m pretty sure if you raise this with your contact at Phocas they will be able to sort it.
I have a stock database that has both an Inventory Balance Stream (As at x date - the same as you’re showing above) and a Movement Stream (showing the net movement of that balance in the month).
When I select the Movement Stream I automatically get a Total Column, however when I switch to the Inventory Stream, the total disappears as it is at that point irrelevant.
So I had this same issue, and checked the box hoping to be able to report on sales vs inventory again, after enabling snap shots in inventory, and now my inventory value doubled and I can’t revert it. I tried rolling back the database. Unchecked the roll forward, and rebuild, and nothing is fixing it. I feel like I will have to uncheck snapshots and rebuild thus losing all of my historical inventory snaps. Any help is appreciated, all of my dashboards for the executive team are now incorrect.
Appears reverting back two checkpoints ago and rebuilding now got me back to where I started thankfully. However, how do I enable the ability to look at current inventory vs sales for those items over a time range, without the inventory values adding up once I get past a month. I am scared to check that box now.
I’m trying to understand how it works and can’t find the right setup for this? I have the Balance Brought Forward checked, snapshots ticked as Monthly in Sync. SyncMoment as in Date dimensions. Do I miss anything in the setup?
