Creating SQL Queries (Optional)

Instead of creating tables or views to select data for retrieval, you can write SELECT statements as you perform data loads.

Note:

Creating SELECT statements in Essbase is usually slower than creating a table or view in the source database.

The SQL Statement box in the Open SQL Data Sources dialog box provides Select, From, and Where text boxes that help you write SQL queries. You can specify multiple data sources, filter the display of records, and specify how records displayed in Data Prep Editor are ordered and grouped.