asked on April 4, 2017
When opening a drillthough with data that contains nulls, the drillthough column alignment is not correct.
data is transposed into the incorrect column.
Ive checked the response provided by analysis server, and the column are not included in the response if the column value is null.
⋅ April 4, 2017
Hello Michael,
Thank you for your question. Could you please share the datasource with us where the issue occurs, so we can reproduce it on our side?
It will help us a lot in our further investigation.
Best regards,
Dmytro.
⋅ April 6, 2017
The issue appear to be the way the drillthough is rendered, and how it determines the columns to display
http://imgur.com/ASC9igY
i can provide the test dataset for this if required
as you can see col3 is missing from the header, also the data where col3 is null is shifted left
⋅ April 6, 2017
Hi Michael,
Thank you for the screenshot. It would be great if you provide us the test dataset.
Regards,
Dmytro
⋅ April 7, 2017
here is the sql table and report.json used to show the issue
http://s000.tinyupload.com/index.php?file_id=21697912896160767529
i simply created tabular analysis cube with a count on col1
⋅ April 7, 2017
Hello Michael,
Thank you for providing the SQL table and report.json. However, we need more information to create a cube with your data. Could you please provide it or send us drill through response from the server?
Regards,
Tanya
⋅ April 12, 2017
https://github.com/meee1/flexmonster_temp
please find attached the project used to create the cube
⋅ April 19, 2017
Hello Michael,
Thank you for sending additional files. The files helped us to fix the issue. Please download this package containing the fix and test with your project. We would be thankful if you shared the feedback with us.
Regards,
Tanya
⋅ April 24, 2017
Hi,
the new version looks good to me. it now pads out the nulls which is what i was expecting.
Michael
⋅ April 25, 2017
Hello Michael,
It is nice to hear that everything works fine for you.
Best regards,
Dmytro.
