Configuring Ontolica Cube Feature
The following steps are required to configure the Ontolica Cube, which is needed by the Ontolica Search context-aware features: Auto-suggestions, Related Queries Web Part, and Tag Cloud Web Part. Ontolica Cube can also provide reporting functionality if the Microsoft SQL Server Analysis Services (SSAS) is available. Using the SSAS Ontolica Cube enables creating custom reports on search, storage and related statistics from SharePoint that can be viewed using third party software such as Microsoft Excel. If the Ontolica Cube feature is to be used only for Ontolica search context-aware features, the SSAS support is not required. Please check the system requirements document.
To start please go to Central Administration > General Application Settings > Manage Ontolica Modules > Manage Ontolica Cube Database and install the Cube database by providing appropriate database access credentials.
To enter information about the domains, from which users will be accessing Ontolica Search pages, go to Manage Ontolica Modules > Data Processing Settings. If domains have alternative NetBIOS names, these names also need to be entered with the same IDs as for the fully qualified domain names. This will indicate that the same domain/sub-domain can be referred to using two alternative names. The default domain entries listed on the page should be kept.
To be able to use the context-aware features, all data providers need to be processed. To schedule data providers go to Manage Ontolica Modules > Schedule Data Providers. On the Schedule Data Providers page either choose the Start Processing Now option for each listed provider or click on the Process All option to process all providers at once. Data providers can also be scheduled for automatic processing on the same page. It is recommended to processes providers not more than once per day. However some providers may initially need to be processed twice to ensure that all data is processed completely. Note that data for some providers is logged at 24 hour intervals. You can observe the data processing status on the Data Processing Status page. The Data Import Status table displays rows of data for each provider. After successful processing, all values from the Row Count column in the Temporary Database Usage table will be set to 0, and Data Warehouse usage table will be filled with processed data counts. In case data values persist in the temporary table, make sure to check the configurations done on the Data Processing Settings page and also the User Profile Synchronization has been properly configured in SharePoint.