BusinessObjects Web Intelligence software allows users to create queries on the backend information contained in databases, such as website databases. Users can then compile and analyse data trends to use this information to make business decisions. BusinessObjects Web Intelligence creates custom reports based on the data for convenient viewing in the form of lists, charts and graphs. Creating custom queries such as listing values associated with a class of objects in the database provides a useful way of sorting information. For example, a custom query could be created to sort data by region or type, according to its assigned characteristics.
- Skill level:
Other People Are Reading
Create a custom query to list values in BusinessObjects Web Intelligence by using the "RefValueUserResponse" command. For example, to create a custom query to see what region leads your sales, you could query [Sales Query];"Which region?" in the query textbox and the reference data would return the matching list of values such as "North";"West." You can use DataProvider() function to tell the program which database to query.
Use the "Interpolation([Value])" command to create a custom query and ask the program to fill in missing values in the output for you.
Use the "boolean Inlist(list_of_values)" command to search a list of values and see if a particular value has been included. True means the value is part of your query, and false means it is not. For example, if you were viewing a list of all states where your business has made a sale and wanted to see if "Florida" had made any sales in a particular quarter, this command would search the list of values and return an output of "true" or "false" to your query.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for