Menu
Download Free Trial

Nulls cause drillthough display issues

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.

7 answers

Public
Dmytro Zvazhii Flexmonster 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.

Public
Michael Oborne 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

Public
Dmytro Zvazhii Flexmonster April 6, 2017

Hi Michael,
Thank you for the screenshot. It would be great if you provide us the test dataset.

Regards,
  Dmytro

Public
Michael Oborne 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

Public
Tanya Gryshko Flexmonster 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

Public
Michael Oborne April 12, 2017

 https://github.com/meee1/flexmonster_temp
please find attached the project used to create the cube

Public
Tanya Gryshko Flexmonster 4 days ago

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

Please login or Register to Submit Answer