Interview Question #9: Governing VLDB Properties

Question

Which of the following VLDB properties govern the length of a SQL string as well as the time a SQL pass takes to execute? (Select all that apply).

A.  SQL Time Out (Per Pass)

B.  Preserve All Lookup Table Elements

C.  Result Set Row Limit

D.  Maximum SQL/MDX Size

E.  Allow Index on Metric

Answer

Both

A.  SQL Time Out (Per Pass)

and

D.  Maximum SQL/MDX Size

 

Maximum SQL/MDX Size and SQL Time Out (Per Pass)

The Maximum SQL/MDX Size and SQL Time Out (Per Pass) VLDB Properties govern the length of a SQL string as well as the time a SQL pass can take to execute.

Maximum SQL/MDX Size sets the maximum size (in bytes), on a pass-by-pass basis, of the SQL that the ODBC driver sends to the warehouse. Or, in the case of MDX, it sets the maximum size of the MDX that is sent to multidimensional cube sources such as SAP BW, Hyperion Essbase, or Microsoft Analysis Services.

If a pass exceeds the limit, the report execution terminates and an error message displays:

I9-1

The possible value for this VLDB property is any valid integer. The default value is 0 (No limit).

SQL Time Out (Per Pass) sets the maximum duration allowed (in seconds) for each SQL pass (even intermediate passes). If any pass of SQL runs longer then its allocated time, the report fails and an error message displays:

I9-2

The value you enter to define this VLDB property must be an integer.

MicroStrategy Course Where You Will Learn About This Topic

MicroStrategy Engine Essentials Course

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s