CreateFromQueries
The
CreateFromQueries verb
creates an .mdc file for each PowerCube in the model by retrieving
data from only specific data sources. There is no user interface equivalent.
If no data sources are specified, nothing happens.
If one or more of the specified data sources are not set for PowerCube Creation on the General tab of the Data Source property sheet in the user interface, an error is issued. This can occur with structural data sources because they do not contain transactional data.
For other ways to create and update .mdc files, see CreateFromCubes, CreateFiles, and UpdatePowerCubes.
The syntax is as follows:
CreateFromQueries [objQueries]| Argument |
Description |
|---|---|
| objQueries |
Specifies one or more data sources that are used to create .mdc files for the PowerCubes. Data sources can be identified by object name or object identifier. |
Example
This example creates .mdc files from the All Staff Count (Excel) data source.
CreateFromQueries "All Staff Count(Excel)"