Skip to Content
0
Nov 07, 2012 at 04:51 PM

Element linking based on date

30 Views

We're running BI 4.0 SP04 patch 3. I need help with a linking issue. I have a stacked bar chart that has an item count, grouped by item name, over a finish date range. In the assign data window for the chart I have chosen the date format of mm/dd/yyyy for that dimension. Below the chart is a table with the data. The date shows on the chart in the mm/dd/yyyy format, which is also the format of the field coming from the universe. But when I mouse over the date I see mm/dd/yyyyT00:00:00. What I want to do is link the chart to the table so the data in the table filters to the chosen date. I can create the element link but when I choose a value I get no data. I suspect the date format is the issue since the input control shows the mm/dd/yyyyT00:00:00 format when chosen instead of the mm/dd/yyyy format, which the table has. How can I get the underlying format to match so the input control/element link works?

Thanks!