How to list values in web intelligence

Written by kristina blasen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to list values in web intelligence
Web Intelligence allows businesses to track business and customer data and characteristics. (computer girl image by PD-Images.com from Fotolia.com)

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:
Easy

Other People Are Reading

Instructions

  1. 1

    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.

  2. 2

    Use the "Interpolation([Value])" command to create a custom query and ask the program to fill in missing values in the output for you.

  3. 3

    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.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.