Now, for example,Say I had orders spread over several shipments and each shipment could have several transactionsassociated with them.
And each order is realted to other entities like this:
|_____Shipping (one to many with Order)
|_____Transaction (one to many with Shipping)
In one report, I simply want to see a count of orders for each customer for the current week and year-to-date.
The problem is that there is no Order entity in the source DB, I have to derive some sort of unique identifier based on the shipping info.
So that report would be something like this:
Current Week Order Count
Test Account 2
In a 2nd report, I might want to drill down from an order, and see the transactions grouped by shipping method for example.
Should I have Order, Shipment AND Transaction measure groups?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.