asked on March 28, 2018
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.
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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
⋅ 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]"
}
]
}
}
⋅ 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:
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.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