Date Formatting in I5Chart( SAP MII 14.0 SP05) not working

[Former Member]

Hi Experts,

I am using I5Charts in SAP MII 14.0 SP05 and facing few issues with that.

Issue 1: In case, I pass data source to my I5Chart as an SQL Query. It gives JSON Parse error.

So I created a BLS which calls my SQL and then passed BLS to Xacute Query and set this Xacute as a source to I5Chart and Charts displays fine with it.

Issue 2: I am not able to set the date format for X-axis inI5Chart.

My SQL has a datetime field based on which I am getting data from my source.I am using this date time as X axis on chart. Once I set the format underTemplateCategories--> X-Axis-->Date Format and Time Format.

I5Chart does not convert the datetime field as per the format I specified.It uses the default xml date format which is retrieved from my SQL Query. Previosuly,I have used ICharts and it do convert the date to the format we mention.

Although I have a work around to change the dateformat while retrieving data from source in SQL but I don't want to do that as different plants may want different date format.

Please advise, if I am missing any particular setting leading to this issue or this is a bug with I5Charts. Also want to know, if any one has faced the
same issue with I5Charts .

Attaching my I5Chart image for a reference.

[swapnil_mohite]

Hi Kirti,

You need to alter additional settings in Chart Area to make it work -

Check with the above settings and let me know if it works.

Regards,

Swapnil

[Former Member]

Hi Swapnil,

I can see that you are using tag query to generate this chart. Tag query formats the date correctly but issue exists when we have underlying query as SQL to generate this chart

I also tried using tag query and it works fine if I mention setting as use local format, but same setting does not work for sql.