As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
That's why you're getting multiple values you've joined one record in FCT_PURCH "TO MULTIPLE" records in DIM_SUPPLIER. So you get all the records you've joined to. It's called the multiplicative effect. If you only want one line, you've either got to use a SUM or remove the "TO MULTIPLE." If you don't know what the "TO MULTIPLE" is doing in your Join, I would refer you back to the basic documentation.
In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007
You also have not told us which fields you are showing in your report - are they originating from both tables or from just one? Are the keyfield(s) of both tables in the report? If not, then include them and you would have to see different field values for the keys in the second table. This is of course assuming that the join-to file has keys defined in ms sql. If no keys are defined, then duplicate values may occur, but then they will still have to be present in the join-to table.
- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007