CXO can connect to an IDL cube using the same functionality as that of Microsoft Sequel Server Analysis Server (MS SSAS). IDL adapter can be used as a free OLAP source, or it can also be used as an element of an Integration Adapter.
The connection to SSAS is managed in the System Settings specify the following fields:
IDL Server: Name or IP address of the IDL server.
Database: The name of the IDL database.
Cube: The name of the IDL cube.
Username and Password: IDL can only be accessed using windows authentication. For the CXO Design Studio the Windows account of the current logged on user will be used. The website will use the account as specified in the application pool. The services will use the service account.
Select the check button to check if the connection can be made.
Select the check button to check if the connection can be made.
To successfully run CXO on an IDL application the following additional configuration is required:
Dimension Mapping: All of the CXO-Core Dimensions need to be mapped.
Sometimes it is required to use Dimension Splits in order to get all required dimensions. Specify dimension splits first then map the dimensions.
Set the Period Frequencies table
Correct any Dimension Variable errors
You can find the Installation Prerequisites file for CXO with IDL on this page.
Limit Metadata with MDX Filters