TDecisionQuery Class

TDecisionQuery is a specialized query that prepares crosstabulated data for a decision cube.

Pascal

TDecisionQuery = class(TQuery);

C++

class TDecisionQuery : public TQuery;

File

MXTABLES

Description

Use a TDecisionQuery as the dataset of a decision cube to ensure that the data is properly prepared. TDecisionQuery allows the dimensions and summaries to be defined directly on the dataset analyzed in a decision control. It then prepares an SQL query to provide the information from that dataset in a format that can be used by a decision cube.

Decision cubes can use other types of datasets, but the information must be structured in the same way as the output of a TDecisionQuery object.

Note: In the Decision Query editor that is displayed from the Decision query component, the query is initially handled in ANSI-92 SQL syntax, then translated (if necessary) into the dialect used by the data source of the query. Use only ANSI standard SQL in the Decision Query editor. Use the dialect of the data source in the SQL property of the Decision Query.