Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.

Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.

Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.

Oracle date data types include the timestamp.  

You can cast it to date using cast ({query item}, date) or use the split functionality.

Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.

Oracle date data types include the timestamp.  

You can cast it to date using cast ({query item}, date) or use the split functionality.

Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.

Oracle date data types include the timestamp.  

You can cast it to date using cast ({query item}, date) or use the split functionality.

Hi Dagur, thanks for your question.

In Cognos Analytics Dashboards you can achieve a similar outcome by using filter widgets. Here is how to create a filter widget.

If your data type is a 'date', the filter widget will provide a calendar picker for you to select a date range. If your data type is 'time', it will show a time picker to select a time range. And if your data type is 'dateTime', it will show a calendar picker and a time picker to select both a date and time range.

In Dashboards you can also 'brush' and 'slice' other visualizations on the same tab by selecting one or more data points on a visualization. Buddhi's suggestion of the Data player and List are examples of this 'brushing' and 'slicing'. As another example, if you have a Column visualization that has columns for each date, and you multi-select the columns you want (manually or use the Select tool to select multiple columns), then it will instantly 'brush' across the dashboard to highlight those dates any other visualization on your tab that is showing the same dates. Additionally, it will also 'slice' out data on other visualizations where the date data is not being used, and will show only the data that is related to the dates you selected on the Column visualization.

Hope this helps.