Details
This section provides more information about different features in Information Designer
- Pop-up menus
There is a lot of functionality available by right-clicking in different parts of the Information Designer. - Details on Edit SQL
Use the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. - Details on Pivot Conditioning
Use the Pivot Conditioning dialog in Information Designer to transform the data in an information link from a tall/skinny format to a short/wide format. - Details on Prompt Groups
With prompt groups, you can specify which prompts should be dependent of each other, and which should not. This can be specified for an information link in Information Designer. - Details on Add Column
The Add Column dialog is shown when you have selected to add a filter or a prompt to an information link in Information Designer. It is also used to select columns when you want to apply a pivot conditioning. Columns that have been added to the information link are available in the drop-down list. - Details on the Save As dialog
Use the Save As dialog to save an element in Information Designer. - Details on Create Multiple Columns
Use the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. - Details on Add/Edit Column Property
Custom properties are metadata that you can use to search for columns using the following syntax:<Property name>:<Value>
. For example, IncludedColumn:True. - Details on Add/Edit Information Link Property
Custom properties are metadata that you can use to search the library by using the following syntax:<Property name>:<Value>
. For example, DataTableType:On-Demand or DataTableType:"Additional Data Table". Information link properties are transformed to data table properties when the information link is opened in an analysis. - Details on Open Information Link
The Open Information Link dialog is shown when you open an information link that contains a column configured with a prompt (a run-time filter). The dialog can take various forms depending on the type of prompt selected. - Details on Column Values
The Column Values dialog is shown if you open an information link with prompts, and then in the Open Information Link dialog, select a column and click Get Values. It is used to filter the values retrieved from the information link by fetching values from an already loaded data table in the analysis. - Details on Edit Parameter
Use the Edit Parameter dialog to define the name, data type, and value type for a parameter. - Missing parameter values
If you have the correct license, this dialog is shown when you open a parameterized information link or file and the value of a parameter has not been supplied. You can use this dialog to type a value for that parameter. - Details on Missing Information Link
The Missing Information Link dialog is shown when you open or reload an analysis file in which the path to one or more information links is no longer correct. The dialog can look different depending on whether you open the file or reload data. - Details on Create Default Information Model
The Create Default Information Model dialog allows you to specify a description and keywords for all elements created by the Create default information model pop-up menu option in Information Designer. This type of information can be used to identify all elements created by this operation at a later stage. You can also specify how to handle name conflicts with existing elements. - Details on Select Destination Folder
Use the Select Destination Folder dialog to specify where to place a new default information model. - Data Source Login dialog
The Data Source Login dialog is shown when the data source administrator has selected to use data source authentication for a data source in Information Designer (the User authentication check box on the Data Source tab in Information Designer). - Details on Edit Properties
Use this dialog to edit the properties for a library item in Information Designer. It can be reached by right-clicking on the item of interest in the Information Designer tree structure and selecting Edit Properties from the pop-up menu.
- Pop-up menus
There is a lot of functionality available by right-clicking in different parts of the Information Designer. - Details on Edit SQL
Use the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. - Details on Pivot Conditioning
Use the Pivot Conditioning dialog in Information Designer to transform the data in an information link from a tall/skinny format to a short/wide format. - Details on Prompt Groups
With prompt groups, you can specify which prompts should be dependent of each other, and which should not. This can be specified for an information link in Information Designer. - Details on Add Column
The Add Column dialog is shown when you have selected to add a filter or a prompt to an information link in Information Designer. It is also used to select columns when you want to apply a pivot conditioning. Columns that have been added to the information link are available in the drop-down list. - Details on the Save As dialog
Use the Save As dialog to save an element in Information Designer. - Details on Create Multiple Columns
Use the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. - Details on Add/Edit Column Property
Custom properties are metadata that you can use to search for columns using the following syntax:<Property name>:<Value>
. For example, IncludedColumn:True. - Details on Add/Edit Information Link Property
Custom properties are metadata that you can use to search the library by using the following syntax:<Property name>:<Value>
. For example, DataTableType:On-Demand or DataTableType:"Additional Data Table". Information link properties are transformed to data table properties when the information link is opened in an analysis. - Details on Open Information Link
The Open Information Link dialog is shown when you open an information link that contains a column configured with a prompt (a run-time filter). The dialog can take various forms depending on the type of prompt selected. - Details on Column Values
The Column Values dialog is shown if you open an information link with prompts, and then in the Open Information Link dialog, select a column and click Get Values. It is used to filter the values retrieved from the information link by fetching values from an already loaded data table in the analysis. - Details on Edit Parameter
Use the Edit Parameter dialog to define the name, data type, and value type for a parameter. - Missing parameter values
If you have the correct license, this dialog is shown when you open a parameterized information link or file and the value of a parameter has not been supplied. You can use this dialog to type a value for that parameter. - Details on Missing Information Link
The Missing Information Link dialog is shown when you open or reload an analysis file in which the path to one or more information links is no longer correct. The dialog can look different depending on whether you open the file or reload data. - Details on Create Default Information Model
The Create Default Information Model dialog allows you to specify a description and keywords for all elements created by the Create default information model pop-up menu option in Information Designer. This type of information can be used to identify all elements created by this operation at a later stage. You can also specify how to handle name conflicts with existing elements. - Details on Select Destination Folder
Use the Select Destination Folder dialog to specify where to place a new default information model. - Data Source Login dialog
The Data Source Login dialog is shown when the data source administrator has selected to use data source authentication for a data source in Information Designer (the User authentication check box on the Data Source tab in Information Designer). - Details on Edit Properties
Use this dialog to edit the properties for a library item in Information Designer. It can be reached by right-clicking on the item of interest in the Information Designer tree structure and selecting Edit Properties from the pop-up menu.
Parent topic: User interface details
Related concepts
Related reference