MDX Cube Specification

An MDX cube specification indicates the name of the Essbase database being queried.

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'

Syntax

[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>

Notes

If [FROM [<cube_specification>]] is omitted from a query, the current database context is assumed.

Example

Sample.Basic is the cube specification in the following hypothetical query.

SELECT
...
FROM Sample.Basic