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.
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.
The issue appear to be the way the drillthough is rendered, and how it determines the columns to display
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
Thank you for the screenshot. It would be great if you provide us the test dataset.
here is the sql table and report.json used to show the issue
i simply created tabular analysis cube with a count on col1
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?
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.
the new version looks good to me. it now pads out the nulls which is what i was expecting.
It is nice to hear that everything works fine for you.