I am trying to create a report that would combine similar data from 2 different databases. We have multiple businesses with the same data that run sales by month, but I’d like to show a combined sales amount.
Is this possible or of not can I close and modify one of the databases to include both sites?
To the best of my knowledge, the only way to merge data from two different sources/databases is two add them to the same database within the Designer.
It can be done as both a single stream (but ensure you have some property or dimension that allows you to distingiush the two sources from each other) or as two separete streams - your data and need should be considered. With the latter, a Custom Mode table/chart can be used to add nubmers from two separete streams together.
I’m in a similar situation, only more in-depth. I’m curious if there are any videos related to establishing this modified Stream. I am attempting to collect data from our Sales monitored area & our Purchasing (which falls under AP for us.) I gather that all of the files are established within Eclipse and then relayed (Synced) to Phocas so my focus in Phocas is to break down data without recreating the wheel in Eclipse. My role as Pricing Analyst seems to fall just a little out of the scope of how the system is developed but I know there is a path.
The videos I have found on Design and Syncing data just doesn’t go into depth enough to get a full understanding of how the initial structure was established.