Details This section provides more information about different features in Information Designer Child Topics:Pop-up menusThere is a lot of functionality available by right-clicking in different parts of the Information Designer. Details on Edit SQLUse the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. Details on Pivot ConditioningUse 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 GroupsWith 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 ColumnThe 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 dialogUse the Save As dialog to save an element in Information Designer. Details on Create Multiple ColumnsUse the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. Details on Add/Edit Column PropertyCustom 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 PropertyCustom 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 LinkThe 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 ValuesThe 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 ParameterUse the Edit Parameter dialog to define the name, data type, and value type for a parameter. Missing parameter valuesIf 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 LinkThe 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 ModelThe 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 PropertiesUse 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 menusThere is a lot of functionality available by right-clicking in different parts of the Information Designer. Details on Edit SQLUse the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. Details on Pivot ConditioningUse 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 GroupsWith 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 ColumnThe 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 dialogUse the Save As dialog to save an element in Information Designer. Details on Create Multiple ColumnsUse the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. Details on Add/Edit Column PropertyCustom 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 PropertyCustom 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 LinkThe 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 ValuesThe 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 ParameterUse the Edit Parameter dialog to define the name, data type, and value type for a parameter. Missing parameter valuesIf 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 LinkThe 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 ModelThe 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 PropertiesUse 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 detailsRelated conceptsElements treeData sources treeTabsRelated referenceIcon explanationsHomeAccessing dataData from databasesInformation DesignerUser interface detailsDetails
Details This section provides more information about different features in Information Designer Child Topics:Pop-up menusThere is a lot of functionality available by right-clicking in different parts of the Information Designer. Details on Edit SQLUse the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. Details on Pivot ConditioningUse 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 GroupsWith 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 ColumnThe 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 dialogUse the Save As dialog to save an element in Information Designer. Details on Create Multiple ColumnsUse the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. Details on Add/Edit Column PropertyCustom 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 PropertyCustom 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 LinkThe 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 ValuesThe 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 ParameterUse the Edit Parameter dialog to define the name, data type, and value type for a parameter. Missing parameter valuesIf 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 LinkThe 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 ModelThe 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 PropertiesUse 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 menusThere is a lot of functionality available by right-clicking in different parts of the Information Designer. Details on Edit SQLUse the Edit SQL dialog in Information Designer to fine tune your SQL queries, pre-updates, and post-updates. Details on Pivot ConditioningUse 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 GroupsWith 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 ColumnThe 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 dialogUse the Save As dialog to save an element in Information Designer. Details on Create Multiple ColumnsUse the Create Multiple Columns dialog to create multiple column elements at the same time in Information Designer. Details on Add/Edit Column PropertyCustom 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 PropertyCustom 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 LinkThe 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 ValuesThe 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 ParameterUse the Edit Parameter dialog to define the name, data type, and value type for a parameter. Missing parameter valuesIf 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 LinkThe 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 ModelThe 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 PropertiesUse 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 detailsRelated conceptsElements treeData sources treeTabsRelated referenceIcon explanationsHomeAccessing dataData from databasesInformation DesignerUser interface detailsDetails