HI All,
We have 2 ODS. One is Billing and the other is Project Sales. In the billing ODS we have billing documents that have the billing date (calmonth) and employee. The projected sales is an ODS that has for each employee for each month, their Projected Sales.
We have created an InfoSet and linked in the billing ODS the calmonth (in billing) to period field (in Projected Sales) and 0SALESEMPLOYEE (in billing) to PERNR (in Projected) ODS.
The Projected Sales ODS has exactly 1 entry for each employee for each month. i.e. employee '12345' for 200501 a projected sales of 10,000. With the above mapping the query results for projected sales is about 50X more. In other words, it shows 30 million when it should be 150,000. I think this has to do with it somehow including results from the billing ODS??
We've read help about interpreting infoset query results and it's quite confusing. It speaks of some filter option to exclude query result set, but can't figure it out.
In addition to the monthly projected sales we want to see for each employee, we want to include all the net sales they had for the same month. So you can see the mapping we did above.
Query would look like this:
Calmonth Employee NetSales ProjSales
200501 123456 220,000 10,000
The projected sales is entirely off by millions of dollars and also the net value isn't calculating correctly. I'm sure out setup is incorrect.
Can someone help us out please.
Thanks
Mike