Create Data Source

A data source is a database connection from which cube data is loaded. Cubes can pull data from multiple data sources, even if those sources use different database technologies, such as SQL Server, IBM DB2, or Oracle. This flexibility allows you to consolidate data from various systems into a single cube for unified analysis.

Data sources can be configured as dynamic, updating regularly when the cube refreshes, or static, loaded only during the initial refresh. Configuring data sources appropriately ensures that cubes contain the correct data and updates run efficiently.

You can refresh data source data at any time by clicking Refresh Screen Data in the Options panel.

Make the cube editable

1. In the Administration page, select OLAP Manager from the sidebar.
2. In the cube list, select the cube where you want to create a data source.
3. Clear the In Production checkbox.
4. Click Save.

Create a data source

1. In the Options panel on the right, click the Navigation icon.
2. Select Data Sources.
3. In the Options panel, click the Add a Data Source icon.
4. In the Data Source Selection panel, fill in all required settings.
5. Click Save and Edit to open the Data Source Editor.

Data Source Selection settings

Setting	Description
Description	Text label identifying the data source.
Data Source	Source connection from the list of data sources configured in SEI.
Dynamic	Refresh behavior that determines whether source data is refreshed regularly and included when the cube is refreshed. If cleared, the data is static and loaded only during the initial refresh (for example, legacy system data).
Active	Usage status that determines whether the data source is used during cube Refresh or Load All process. If cleared, the source is ignored for refresh/load operations but any data already in the cube remains.
Group By	Data grouping method that writes records to a temporary table (suffix _T) by grouping all dimensions. This reduces the number of records but may affect initial load performance because grouping is applied at that stage. This method is useful when the cube has fewer dimensions than the source data. For example, if a cube contains Year, Period, Customer, and Product dimensions but the source is an invoice detail file, instead of writing 50 million invoice detail rows into the temporary table, only data grouped by Year, Period, Customer, and Product is written.

Delete a data source

1. In the data source list, select the data source you want to delete.
2. In the Options panel on the right, click the Actions icon.
3. Select Delete Data Source.
4. In the confirmation message, select the confirmation option, and then click Yes.