Use the cube specification to name the database at which the query is directed. A cube specification consists of the FROM keyword followed by delimited or nondelimited identifiers indicating an application name and a database name.
The first identifier should be an application name and the second one should be a database name. For example, all of the following are valid identifiers:
Sample.Basic
[Sample.Basic]
[Sample].[Basic]
'Sample'.'Basic'
[FROM [<cube_specification>]] <cube_specification> ::= '['<ident_or_string>.<ident_or_string>']' |<delim_ident>.<delim_ident> <delim_ident> ::= '[' <ident> ']' |<ident_or_string> <ident_or_string> ::= '<ident>' |<ident>
If [FROM [<cube_specification>]]
is omitted from a query, the current
database context is assumed.
Sample.Basic
is the cube specification in the following hypothetical query.
SELECT ... FROM Sample.Basic
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |