We have a loop, which I believe is needed to get accurate results. However, I can't figure out how to use it in a query. Here are the three tables in the universe that are in the loop.
When I build a query, I need information from each of these three tables, and I need all three joins to be included.
Without any contexts, I get this error:
"Incompatible combination of tables. (IES 01507)"
I read somewhere that I might be able to use a context and include all three joins in it. However, that causes a different error:
"The multi-part identifier "test_types.allocate" could not be bound." And it appears that the query contains no joins in it.
Any thoughts or suggestions?
Thank you
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
On one of the reports used with this universe, we need to show a sum of the "allocate" field in the test_types table for each lwrs record. The example below shows the records for lwr_id 2382232. The users are expecting to get 3 for the allocate sum. However, without the link between lwrs and test_types, the sum would return 10.
Alternatively, if I used the link between lwrs and test_types, and take out the link between lwrs and tests, the sum would return a much larger number, because there are many records in the tests table with these three tt_id numbers (shown below in the obj_id column).
The only solution I can think of is to use a derived table, which joins the tests and test_types table together, and then join that to the lwrs table. This doesn't sound like too difficult of a solution, but it seems like there should be a mechanism to handle this without needing a derived table.
| User | Count |
|---|---|
| 86 | |
| 10 | |
| 10 | |
| 9 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.