Hello Experts,
What I’m attempting to do is create a line chart that maps the time of day a particular batch job starts across a given date range. So the X-Axis is date, the Y-Axis is time (the data source has a 24 hour time format, but AM/PM would be fine too). I am loading a data source from a BEx query that provides the desired data. The name and date are attributes that function as expected. The time key figure (measure) however, loads as expected to the data source, it is displayed as expected in the crosstabs, but it will not plot on a chart. We are running Design Studio Release 1.6. Please advise if there is a way to get the time measure to plot as I am looking for it on this requirement as well as several others for our organization.
In the below screenshot you can see the default info chart (line chart) that Design Studio creates when loaded with the data source containing a Time key figure as the measure. You can see that by default it charts the date correctly along the X-Axis, but then puts decimals between 0 and 1.2 on the Y-Axis. My expectation would be the Y-Axis should contain a measure of time. Below the chart is a crosstab from the same data source as the chart so that you can see the data points that should be plotted. Notice NOTHING is plotted on the chart.
In the next screenshots you can see that I changed the format of the Y-Axis to force it into a time format to match the time format in the data source. It did format the Y-Axis as a 24 hour clock, but still nothing is plotted.
Below is a screenshot of the initial view of the data source. I have filtered the number of ‘job names’ and the date range just for the sake of a smaller dataset to present for example.
Finally, here’s an example of what I would expect the chart to look like. Or something similar to this (done in excel).
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
Hi Ian,
By changing the data model, they are probably referring to how your time key figure has been defined in BW, as shown below, with regard to the Type/Data Type settings in particular:
Can you check how it has been configured in your system and we can then determine next steps based on that? Perhaps you could post a screenshot to confirm? At this stage my suspicion is that your data modelling is probably correct and that the problem is really a bug with the way the chart handles Time key figures but let us see.
Regards,
Mustafa.
Mustafa,
Thank you for the reply!
It looks to me like the key figure data type is stored as TIMS. Do you think we should try changing it to the DEC type to rule that out?
Hi Mustafa,
My apologies for the delayed response. I had some vacation time and then some other work priorities so this one got put on the back burner for a few days.
We did try to change the time key figure like you had suggested. However when we change it to type DEC, we get the below short dump every time we try to load data...
Also in the meantime, SAP did provide a more helpful update on my OSS ticket (pasted below). Based on that, it seems your speculation about the values needing to be numeric was right on point. We will work on finding a good way to convert the time format and give it another shot.
Hi Ian,
After many tests, I have found the solution for your case.
We know that the VALUE AXIS is numeric, right? Changing the format of the number shown there will change only the visual aspect of the number, but the number remains in the backgroung. When you put time data there, the application does not know how to adjust it into the screen, since chart background still numeric and is receiving a timestamp to be shown. Chart consider it as incompatible data.
Here is how we make it accept your data:
In the Chart VALUE AXIS, the number 1 represents 24 hours, 0 represents 0 hours. You should convert your HH:MM:SS from your query to a number, as below:
0 = 00:00:00
0.33333 = 08:00:00
0.5 = 12:00:00
1 = 00:00:00 (a complete day cycle)
How?
A day have 86400 seconds.
If you have a recorded time of 08:00:00, it will be 28800 seconds, right?
So, dividing 28800 by the total amount of seconds in a day will result in the number equivalent to the position.
28800 / 86400 = 0,3333333333333333
0,3333 will be understood as a position in the chart and the application will be able to handle it properly(and you can keep using hh:mm:ss format in chart).
Hi Ian,
Thanks for the update. Good to see SAP came back with a constructive suggestion. Out of curiosity, I tried the approach. Here are my findings:
1) Creating a key figure of Type Time with DEC did not allow me to set decimal places, so when the data was loaded, the values were rounded to zero. Instead, I created a key figure of type Number with Floating Point (FLTP) and maximum decimal places. The test InfoCube looks like this:
2) The data source based on the BEx Query looks like this:
3) And the resulting InfoChart in SAPUI5 M Mode looks like this:
For some reason I didn't get the option to set the value axis label format to the time format HH:MM:SS, as in your original screenshot. Let me know if you have better luck.
Regards,
Mustafa.
Okay, now we're in business! I had assumed the pick list values were fixed without realising we can type in our own custom formatting as well:
| User | Count |
|---|---|
| 75 | |
| 9 | |
| 8 | |
| 7 | |
| 7 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.