Search & Preview

Cube Guide

Quick Guide

  • Cube – System Requirements and Prerequisites
  • Cube – Creating reports using MS Excel
  • Cube – Error – Required assemblies Microsoft.AnalysisServices.dll and Microsoft..
Cube – System Requirements and Prerequisites

Cube – for Search (and Preview)

Search contains Cube feature, which has specific database-related requirements.
Cube is a successor of the previously known Search Intelligence module, and it powers several other features in Search.

Require a fully functional SharePoint environment.
Currently supported SharePoint platforms are:
- Office SharePoint Server 2007
- SharePoint Server 2010
- Search Server (Express) 2008
- Search Server (Express) 2010

System requirements and prerequisites for Search are the same as for a given SharePoint platform, plus few extras.
All Microsoft product is recommended to have the latest service packs and updates installed.

Search for SharePoint 2007
- Microsoft Office SharePoint Server 2007 or Microsoft Search Server (Express) 2008
- Microsoft Windows Server 2003, 2003 R2, 2008, 2008 R2, 32-bit or 64-bit
- .NET Framework 3.5 SP1 ( Search and Preview for SharePoint 2010 up to version 6.5)
- .NET Framework 4.5 SP1 ( Search and Preview for SharePoint 2010 from version 6.6)
- Microsoft SQL Server 2005, 2008, 2008 R2, 32-bit or 64-bit
- Common Requirements

  • Search for SharePoint 2010*
    - Microsoft SharePoint Server 2010 or Microsoft Search Server (Express) 2010
    - Microsoft Windows Server 2008 ×64, 2008 R2 ×64
    - .NET Framework 3.5 SP1 (4.0 is supported but not required)
    - Microsoft SQL Server 2005 ×64 SP3 CU3, 2008 ×64 SP1 CU2, 2008 R2 ×64
    - Common Requirements

Common Requirements
- Microsoft SQL Server must have the following components and settings: – Database Engine Service – Analysis Services (Cube) – SQL Server Agent (Cube) – Remote connections enabled over TCP (Cube) – Mixed mode authentication enabled (Cube)
- The account used to run the Installer should be both SharePoint Farm Administrator and local machine Administrator
- The account used to install the Cube Database should be both SQL Server Administrator and Analysis Services Administrator (Cube)
- Analysis Services must be located on the same instance as the Database Engine Service used to install the Cube Database (Cube)
- The SharePoint Farm Administrator account must be a domain account and have Administrator rights on the local machine (Preview)

Search & Preview Cube – Creating reports using MS Excel

Since the introduction of Cube feature (previously known as Search Intelligence), it is possible to use Microsoft Excel to create and view reports
based on statistics gathered by Search. For example, it is possible to view who searched for what and when.

This article describes the steps to create an example report using MS Excel 2007/2010.

  1. Open MS Excel running as a user who has access to the Analysis Services on the SQL Server where Cube was configured.
  2. In the Data menu tab select From Other Source > From Analysis Services button.
  3. Type in the name of the SQL Server and press Next.
  4. From the database, list selects Ontolica Reporting and check to connect to the specific cube or table. You should see an entry called “RECUBE” on the list. Press Next.
  5. The Select file name for saving the file and press Finish.
  6. In the Import Data popup window, you can select for example Pivot Chart and Pivot Table Report. Press OK.
  7. In the Pivot Table Field List which should appear in Excel, select the following items:
    - Search Count
    - Query String
    - Account Name
  8. A report should now be generated in Excel listing users who made searches in, the exact queries made and the number of times they were made.

Additional reports can be created by selecting different values in the Pivot Table Field List.

Cube – Error – Required assemblies Microsoft.AnalysisServices.dll and Microsoft..

During installation of Cube database, you might get the following error while trying to connect to the database on the Manage Cube Database page:

“Required assemblies Microsoft.AnalysisServices.dll and Microsoft.AnalysisServices.AdomdClient.dll do not exist on this server. Please install them into GAC”.

Cube uses the mentioned dlls to connect to the Analysis Services. However, these dll files are deployed only either with the SQL Server Analysis Services installation or by installing packages from the SQL Server Feature Pack for the specific version of SQL Server used. On a Web front-end machine which does not have SQL Server installed, you need to install additional packages from the corresponding Feature Pack.

This Microsoft knowledge base article informs which packages contain which dll files:
http://support.microsoft.com/kb/909392

Here you can find an example Feature Pack download page for SQL Server 2008:
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228de03f-3b5a-428a-923f-58a033d316e1

Please download and install the following components:
- Microsoft ADOMD.NET package
- Microsoft Analysis Management Objects package

If still having problems, install also:
- Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Installation may require to restart the machine or at least to restart the IIS server.

Need more help with this?
CONTACT US info@ontolica.com OR use our homepage

Thanks for your feedback.