Create a cube
To create a new cube, click File>Create and follow the prompts to connect to a database and define the required query.
Note, if you are using Info-Explorer Lite, then "create cube", "export to CSV" and "export to MS Excel" are not available
Click Create Cube from the Home tab or File > Create to create a new cube
Select the required source :
From Database
Select an existing connection string or define a new connection string, and then build a query
From Accpac (Sage 300),
Requirement! This is only available if using Optional Table module. It assumes that an Infoset exists in Sage 300 > Information Manager > Optional Tables.
From Accpac Details:
Select a Sage 300 database, and then select the Infoset/Query and check the Database Connection details from the Create Cube Screen
Use the Query builder to assist in creating your query. Refer to Query Builder
See also Using Parameters in the query
See also
