Skip to Content

BO Web Intelligence date does not diaplay in line chart

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.

ytkvh.png (18.2 kB)
ucmjx.png (28.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 31, 2019 at 03:29 PM

    Create Dimension variable on "it_TimeStamp" object and try.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 11, 2019 at 08:55 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.