Menu
Download Free Trial

When formatting time to HH:mm:ss, charts are not properly displayed (SSAS)

Hi all,
I am working with a SSAS cube, in which I have a measure for production time. The measure value is stored in seconds, but in the cube I have a calculated measure to format it to HH:mm:ss. The format is working for flexmonster grids, however, when switching to chart mode (any of the chart options) the measure is not displayed. Bellow is the expression I am using to format the time in the SSAS cube and other information about flexmonster version.
Format expression: FORMAT(CDATE([Time Measure]/86400 – INT([Time Measure]/86400)), “HH:mm:ss”)
Flexmonster version: 2.412
The connection with the cube is made using flexmonster accelerator tool
 
Please, let me know if you need any further information.
Thanks in advance.

7 answers

Public
Tanya Gryshko Flexmonster March 28, 2018

Hello, Bruno,
Thank you for writing to us.
Could you please provide us with a sample SSAS cube with such calculated measure? Also please share your report.json file. This would greatly help us to reproduce the issue.
Regards,
Tanya

Public
Bruno Cazarim March 29, 2018

Hello Tanya,
Thanks for the answer.
 
It is tricky to provide you with the cube sample, because it is client’s data. But, I will try reproduce the issue in a .csv or json file and come back to you asap.
 
Regards.
Bruno

Public
Bruno Cazarim April 2, 2018

Hi Tanya, hope you are doing well.
Unfortuntely, I  was not able to reproduce the error in .csv or .json. Do you have any test cubes that you could use to create a calculated measure with the expression I provided? I think just by doing that you can see the issue I am facing.
 
Regards.
Bruno

Public
Dmytro Zvazhii Flexmonster April 3, 2018

Hello Bruno,
Thank you for writing. Сould you please send us your report configuration and also some screenshots describing the issue? It will give us some more information about the type of the issue.
Wating for the update from you.
Regards,
Dmytro

Public
Bruno Cazarim April 3, 2018

Hi Dmytro, thanks for the response.
Attached you can find two prints, one showing the grid example with the Prod. Time measure formatted as hh:mm:ss, this format is done in the analysis services cube, using the expression I mentioned in the first post, and other screenshot showing the blank chart view when I try to switch from grid to chart. Also, I attached the .json for this report
 
Regards.
Bruno

Public
Bruno Cazarim April 3, 2018

Hi Dmytro, it seems the report.json is not uploading, here it is:
 
{
“dataSource”: {
“dataSourceType”: “microsoft analysis services”,
“subquery”: “SELECT {[Location].[Site – Line].[Site].&[8]} ON COLUMNS FROM [MHOM-OLAP-CUBE-T]”,
“proxyUrl”: “http://localhost:50005”,
“catalog”: “TEST-DB”,
“cube”: “OLAP-CUBE-T”,
“binary”: true
},
“slice”: {
“reportFilters”: [
{
“uniqueName”: “[Calendar].[Date]”
}
],
“rows”: [
{
“uniqueName”: “[Calendar].[Day Of Month]”
}
],
“columns”: [
{
“uniqueName”: “[Measures]”
}
],
“measures”: [
{
“uniqueName”: “[Measures].[Prod. Time]”
}
]
}
}

Public
Iryna Kulchytska Flexmonster April 5, 2018

Hello Bruno,
 
Thank you very much for the screenshots and the report.
Our team is working on reproducing the issue on our side. Meanwhile, could you please do the following:

  1. Update to the newest version 2.417 by following the instructions from Updating to the latest version guide and check if the issue is reproducible in 2.417 version as well. Even if the issue is still there, it is good to use the newest version.
  2. Let us know if you use useOlapFormatting option set to true in your report or in global options of the component. We do not see it in the report you provided.
  3. If the issue is still reproducible in 2.417 version, please open a browser’s console before switching to charts, switch to charts and check if you see any errors there. Please provide us with them if you see any.

Is it possible to provide us with access to your application by URL? This will definitely help us to catch and fix the issue quicker. Any kind of sensitive info (URL, login details, etc.) can be provided via email. Please let me know if this option is feasible for you.
 
I’m looking forward to your reply.
 
Kind regards,
Iryna

Please login or Register to Submit Answer