Quick reference

Here is a quick overview of the main topics covered in this chapter.

Object	Usage	Creation
Scripted calculation view	Like a graphical calculation view, this allows development of complex data models, combining data from several sources, and presenting the data in one coherent place.	Quick Launch | Calculation view | Create. Give Name and Description values, select SQLScript. Write the appropriate script, define the output parameter, and activate.
CE functions	These allow us to interact with the database, and the data we have read from it, without writing SQL.	CE_OLAP_VIEW: This reads an analytic view CE_COLUMN_TABLE: This reads a database table (column table only) CE_PROJECTION: This creates a projection on data read into a scalar variable CE_CALC: This creates a calculated column in a projection CE_JOIN, CE_LEFT_OUTER_JOIN, and CE_RIGHT_OUTER_JOIN: This joins two scalar variables together CE_UNION_ALL: This creates a union of two scalar variables (which have the...