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 |