You can create a connection to a Microsoft SQL Server Analysis Services data source to access and query multi-dimensional cubes.
To learn how to create a connection to Analysis Services data sources, see Create SQL Server Analysis Services Connections.
When you create a new connection to a Business Intelligence or NoSQL data source, Toad automatically maps the data source objects. Toad gathers metadata from these objects which is cached (in a hidden table) and retained between sessions for one week. After one week, all objects are automatically refreshed.
During this initial mapping process, Toad maps only metadata. The actual data in each column is mapped as needed, such as when you execute a query.
Manually refresh object metadata
You can manually refresh object metadata at any time. In the Object Explorer, right-click an object and select Refresh All.
|Consideration / Limitation
|Queries are stored in Local Storage
|The Queries you create and save are stored locally in Local Storage. Therefore, you cannot share your Queries with others, and you cannot access the Queries created by other Toad users.
|Dimensions, Hierarchies, and Levels
Dimensions can have sub-levels called Hierarchies. And a Hierarchy can have sub-levels called Levels. These are all displayed in a tree-view in the left pane when a Cube is opened in the Database Explorer (Viewer).
A Dimension can have multiple hierarchies or none. A Hierarchy can have multiple Levels or none.
|In the Object Explorer, to display the list of Cubes, select any view option except the Connection Treelist. The Object Explorer view Connection Treelist does not display the list of Cubes, because Cubes cannot be used in a cross-connection query.