Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

About SQL Server Analysis Services Data Sources

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.

Toad Automatically Maps Object Metadata

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.

Considerations and Limitations with Analysis Services Connections

Consideration / Limitation Description
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.

Displaying Cubes 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.

 

Related Topics

Related Documents