How to add custom value in Cognos Insight?

Cognos Insight is a powerful data analysis and visualization tool that allows users to explore and manipulate data to gain valuable insights. One of its key features is the ability to add custom values, which further enhances the flexibility and usefulness of this tool. In this article, we will delve into how to add custom values in Cognos Insight, along with answering some frequently asked questions.

How to add custom value in Cognos Insight?

**To add a custom value in Cognos Insight, follow these simple steps:**

1. Launch Cognos Insight and open the desired workspace or create a new one.
2. Select the desired dataset, which contains the column where you want to add a custom value.
3. Locate the column either in the Data Source View or the Data pane.
4. Right-click on the column header and select “Add Custom Value” from the context menu.
5. A dialog box will appear where you can enter the custom value you want to add. Type in the desired value and click “OK.”
6. The custom value will now be added as a separate item within the column and can be used for analysis, calculations, and visualizations.

It’s that easy! Now you can leverage custom values to enhance your data analysis capabilities within Cognos Insight.

Related FAQs:

1. Can I add multiple custom values within a single column?

Yes, you can add multiple custom values within a single column by following the same process mentioned above.

2. How can I edit or remove a custom value?

To edit or remove a custom value, right-click on the respective custom value within the column and select the appropriate option from the context menu.

3. Can I add custom values across multiple columns simultaneously?

No, custom values can only be added one column at a time. Repeat the process for each column where you want to add custom values.

4. Are custom values persistent across different workspaces?

No, custom values are specific to the workspace in which they are added. They do not persist across different workspaces.

5. Can I use custom values in calculations?

Yes, custom values can be used in calculations within Cognos Insight, allowing for further analysis and deriving insights.

6. How can I visualize data using custom values?

Once custom values are added to a column, you can easily create visualizations using these values, such as charts or graphs.

7. Can I export data that includes custom values?

Yes, when exporting data from Cognos Insight, the custom values will be included in the exported file, ensuring data integrity.

8. Is there a limit on the number of custom values I can add?

There is no specific limit on the number of custom values you can add. However, keep in mind that adding too many custom values may affect performance or data clarity.

9. Can I use custom values in filters and slicers?

Yes, custom values can be used in filters and slicers, enabling focused analysis and easy data segmentation.

10. Can I format custom values to have a specific appearance?

Cognos Insight provides formatting options for custom values, allowing you to modify their appearance based on your preferences.

11. Are custom values permanent modifications to the original data?

No, custom values are not permanent modifications to the original data. They are applied within Cognos Insight only and do not affect the underlying dataset.

12. Can custom values be shared with other Cognos Insight users?

Yes, custom values can be shared with other Cognos Insight users by exporting the workspace or through collaboration features within the tool.

Dive into the world of luxury with this video!