BO Web Intelligence date does not diaplay in line chart

[former_member1215211]

We are using SAP BusinessObjects BI Platform 4.2 Support Pack 5.

I am new to SAP BO and I am trying to build a line chart with the following data but date does not get display in chart.

We are collecting 5 second performacne data of network interface and tryin gto build a report. timestamp consist date with hh:mm:ss. so there will be 12 samples per minute and some values might be null. lt_TimeStamp is grayed out when I try to select as an object. Any help will be appreciated.

[amitrathi239]

Create Dimension variable on "it_TimeStamp" object and try.

[former_member1215211]

Thanks Amit. That worked.

Now, I am trying to plot data for certain date/time period. e.g. last 5 minutes, last 30 minutes, last hour, last day etc.

Since these are not aggregated data, probably I won't be able use out of day functions.

As these data can have 12 samples within a minute (5 sec interval).

How can i generate charts which shows only last five minutes of data?

I tried using lt_TimeStamp as a prompt to enter a data/time but it did not work. Looks like format of lt_TimeStamp is different than the prompt value. So the comparison does not work for e.g. lt_Time_stamp greater than <Date prompt>

Now that prompt date format (2/11/2019 8:52:41 PM) is different than lt_TimeStamp (2019/02/11 18:10:20) and probably that's the reason it does not work right.