Basics of Information Design Tool – Part 2 – Properties

In this Document, we can see different properties that we can set under Connection layer, Data Foundation Layer and Business Layer in a Project in Information Design Tool.

1. Connection Properties:

Connection Pool Mode:

3 types of Connection Pool Modes are here.

1. Keep the conncetion active for:

     This option allows us to manually set the Pool Timeout for the connection.

2. Disconnect after each transaction:

     If we select this option then, Once the query executed, session will be disconnected.

3. Keep the connection active during the whole session (Local Mode Only):

     During the whole session connection will be active.

You can set “Pool Timout Minutes”, if you opted for the 1st option.

We can set:

Array Fetch Size

Array Bind Size

Login Timeout

1. Array Fetch Size:

     This parameters allows us to set the optimum number of rows that are permitted in a FETCH.

2. Array Bind Size:

     Array Bind size is the area in memory that a connection server stores a batch of data. based on this size the number of rows that that can be loaded in a single operation will be decided.

3.Login Timeout:

      Login timeout specifies the time before the connection attempt timeout.

under Connection Parameters (Here, we are considering Relational Connection).

We add or delete different “ConnectInit” Parameters.

This is a Connection Initialization Parameter, In DB2, this can be used to send SQL statements before the actual query to be executed in the database.

This parameter is highly dependent on Database.

For Oracle connections, Hints can be used for Oracle optimizer.

2. Data Foundation Properties:

Data Foundation Layer Properties Tab, provides the facility to select different SQL Options, such as:

• Allow Catesian Product
• Multiple SQL Statements for each context

• Allow Catesian Product:
  • This option prevents or allow the occurrence o Cartesian Product.

• Multiple SQL Statements for each context
  • If we select this option then, atleast one SQL statement will be generated for each context. This option is helpful in resolving the join path problems.

Under SQL Option, Edit Parameters button list out the query script parameters. we can Add, Delete or Modify the value of the query script parameters.

ANSI92:

     This allows ANSI-91 convention for joins in From clause.

BEGIN_SQL:
     SQL staments can be prefixed with BEGIN_SQL.

END_SQL:
      This is to append a string to SQL

JOIN_BY_SQL:

     It allows to combine split queries into one sentence, allows multi pass SQL processing to work.

Data Foundation Summary lists the number of tables, contexts, joins, Derived tables, list of values, parameters, standard tables, tables, view.

3. Business Layer Properties:

Edit Parameters button under Business Layer Properties, enables us to Add, Delete or Modify the value of the query script parameters.

Business Layer Summary window displays Business Layer items as well as Data Foundation Layer items.

Business Layer items include, number of Attributes, Business Layer Items, Business Layer Objects, Business Layer Views, Dimensions, Filters, Folders, List of Values, Measures, Navigation Paths, Queries etc.

Business Layer query options, provides the facility to select multiple options, such as:

• Query Limits:
  • Limit size of result set to __ rows.
  • Limit execution time to __ minutes
  • Warn if cast estimate exceeds __ minutes
• Query Options:
  • Allow use of subqueries
  • Allow use of union, intersect and minus operations
  • Allow complex operands in query panel
  • Multiple SQL statements for each measure