All of the material below has been tested on Business Objects version 5i. (Click here for Designer Notes)

• Using the "link" functionality
• Why is a numeric field summing itself?
• Prompting the user(without using the condition function in BO)
• "attempt to enter multiple values in a mono value variable" + var0001 + "Business Objects"

Using the "link" functionality

When using the link command in data provider:

Uses the link options to "join" 2 queries (similar to a union , except, there are no restrictions with matching columns)

- performs "union" between 2 variables
- when you use these variables you have to include other variables from the query in the table

e.g. I had to produce a Balance Sheet where even if the Account (e.g. Current Assets) had no records, a balance row with "Current Assets" still had to appear. The solution is to link the field that contains the definition to another table where all the types are defined.

Why is a numeric field summing itself?

e.g. a period field is summing itself

Reason: The period field had a definition of "Measure". If you change this to "Dimension" it will only display the single, distinct value.

Prompting the user(without using the condition function in BO)

e.g.
WHERE  TABLE.Name IN @Prompt('Select a Name','A','Students\Name',MULTI,FREE)

or
'ALL' IN @Prompt('Select a Namey','A','Students\Name',MULTI,FREE)

You use the option ALL in your LOV instead of selecting 270 values.

"attempt to enter multiple values in a mono value variable" + var0001 + "Business Objects"

to get around the problem Use WHERE TABLE.Name IN @Prompt('Select a Name','A','Students\Name',MULTI,FREE)