Understanding Component Real Time Search

Fluid components should have the real-time search configured using Pivot Grid. To configure, application developer can use Pivot Grid Wizard to define Pivot Grid models by selecting component data source. The wizard creates a query behind the scenes with the same name of the component and associates it with the model. This query is based only on the search record of the component. The keys of the search record become the prompts for the model.

Note that:

• The component data source models are always set to Chart Only view.

• Only one Pivot Grid model can be associated to the component.

• Within a database, you’ll not be able to copy the component data source models using Pivot Grid Administration, but you can copy a fluid component along with the associated Pivot Grid model between databases.

  See Copying the Fluid Component Between Databases.

  Only default view for the Pivot Grid model is associated to the component. Additional non-default views for the component model have no effect on the component search page.

• Component developers should create additional joins to the query so that component search using the Pivot Grid model return better results. For example, the developer can add more facts and filter dimensions to the query and use it in the model.

• Additional custom security-joins that are needed for the component should be performed on the auto-generated query. When the auto-generated query is modified, you must recreate the model using the Pivot Grid Wizard to include the newly joined fields.