Introduction | Information Center
Use the Data Sources page to define an existing data source that IBM Alphablox applications can access. This page describes the entries for defining a data source connecting through the OLEDB for OLAP Adapter. The OLEDB for OLAP Adapter can only be used on instances of IBM Alphablox that are running on Windows systems.
To define a data source:
show
command. A description
is not required when creating a data source definition.Enter the TCP/IP address or name of the host machine on which the data source resides.
Microsoft Analysis Services: Enter the name of the Microsoft Analysis Services cube that is being defined in IBM Alphablox.
Microsoft Analysis Services: Enter (or verify) the name of the database supplier. For Microsoft Analysis Services, the value is MSOLAP.
Microsoft Analysis Services: Enter the name of the Microsoft Analysis Services schema that the IBM Alphablox application uses.
Microsoft Analysis Services: Enter the default user name with which to access the Microsoft Analysis Services database. The name of the user must be the name of the Windows user in which IBM Alphablox is running, and that Windows user must have the "Act as part of the operating system" user right. For details on configuring this user right, see "Setting Up Microsoft Authentication for Analysis Services Data Sources" in the Administrator's Guide.
Microsoft Analysis Services: Enter the default password for the user entered in the Default User Name text box.
Enter the maximum rows allowed to return from the query in the Maximum Rows text box.
Enter the maximum columns allowed to return from the query in the Maximum Columns text box.
Applies to Microsoft Analysis Services only : Enter the maximum rows to return when a drillthrough operation is performed
in the Maximum Drillthrough Rows text box.