This section illustrates Magnify indexing by feeding the Car file. In this example, multiple rows will be aggregated into a single row in order to rollup data according to a single dimension to create a more robust, inclusive or higher-level search result. For example, this is the difference between showing a single search result for an entire order or a search result for each item purchased in an order.
Note: This file is installed with the WebFOCUS Reporting Server under the ibisamp application directory.
Note: If you are not licensed for Active Technology, select HTML instead. In that case, you will not be able to run the aggregation reports.
Note: Notice how multiple rows in the Car data can be used to describe a single entity based on the rollup level. In this case, there are Countries and Cars. Depending on the use case, each entity can be created as its own search result. This is done by using the highest-level field as the primary BY field. Columns are named accordingly to identify where to aggregate values across multiple rows. For example, aggregating on the COUNTRY field will generate five search results, one for each country. Therefore, separate searches for Jensen and Jaguar will both return the same search result for England.
At another level, the Car data has 18 individual models. However, if users are to search on any model, only a single car type search result would be returned.
For example, rolling up Model By Car reveals that there are 10 cars. Thus, 6 rows of data found for BMW will be aggregated into a single search result.
DELIMITER. Used internally to separate a list of values generated by the Format Magnify procedure in order to aggregate multiple rows into a single search result. This value should be a unique value not found anywhere in the content that is being indexed.
BATCHSIZE. Incremental number of records to feed to Magnify at a time.
Note:
Note: You must set the ASNAMES setting to MIXED in order to preserve case-sensitivity.
Note: The following steps give you hands-on experience in recreating this procedure by starting fresh. This step can be skipped in order to follow along, similar to the hands-off approach in the Movies tutorial.
Column |
Column Title |
Purpose |
---|---|---|
SEARCHTITLE |
SearchTitle |
Format Magnify Reserved Alias Name (Case Matters) |
SEARCHID |
MagnifyID |
Format Magnify Reserved Alias Name (Case Matters) |
COUNTRY |
C1_Country |
Category |
BODYTYPE |
M3A_Body_Type |
Multiple Category |
MODEL |
M4A_Model |
Multiple Category |
WARRANTY |
M6A_Warranty |
Multiple Category |
STANDARD |
M5A_Features |
Multiple Category |
MPGRANGE |
M7A_MPG_Rating |
Multiple Category |
COUNTRY |
S_Country |
Searchable Content |
CAR |
S_Car |
Searchable Content |
MODEL |
SA_Model |
Aggregated Searchable Content |
BODYTYPE |
SA_BODYTYPE |
Aggregated Searchable Content |
WARRANTY |
SA_WARRANTY |
Aggregated Searchable Content |
STANDARD |
SA_STANDARD |
Aggregated Searchable Content |
WF_INDEX_UNIQUE_KEY |
<not needed> |
Magnify Meta Tag |
TITLE_URL |
<not needed> |
Magnify Meta Tag |
LINK_URL1 |
<not needed> |
Magnify Meta Tag |
LINK_DISPLAY_NAME1 |
<not needed> |
Magnify Meta Tag |
S_HARDCODED |
<not needed> |
Searchable content (last because it is a TX field type) |
For more information on using Magnify meta tags and Format Magnify reserved names, see the Magnify Developer's Guide.
Note: Each Car will include multiple rows as part of its single search result, thereby searching either the Jaguar V12XKE Auto or XJ12L Auto will return the aggregated Jaguar search result.
Note: If you receive an error, see Magnify Error Handling in the Magnify Developer's Guide.
Note that not every row is sent to Magnify. Fifty-one rows are aggregated into 34. As part of the Magnify output, the 34 records are further aggregated into 10 search results.
http://host:port/wfcontext_root/search
where:
Is the machine name and port number where WebFOCUS is installed.
Is the WebFOCUS application root.
Note: Sample or default URLs are for informational purposes only and may not resolve correctly, if at all.
To return to the Magnify interface, the default URL is:
http://localhost:8080/ibi_apps/search
WebFOCUS |