Thank you for creating the idea "Total in Jedox drill through". To better evaluate your idea we would like to understand why you expect to see the sum of the drill-through since this is already shown in the cell where the Drill Through is applied. Our Drill Through functionality by default has a limit of 1000 rows, so in some cases depending on the number of cells behind the consolidated element the sum of the drill-through might differ with the cell value and thus generate confusion for the users.
hi!
We can extend the number of rows in drill through via config.php
https://knowledgebase.jedox.com/jedox/in-memory-db/configuration.htm?Highlight=config.php
drillthrough-mode mode C
as you see in KB it is a bit sensitive/prone to errors for you to change this so we suggest contacting support and requesting the change of the standard number of rows from 1000 to your desired number.
We hope this helps.
Thanks for the swift response. We have noticed that sometimes the total in the cube doesn't match with the total in the General Ledger system. If we can get the sum of #Value column on the top somewhere for all the rows returned that would highlight the variance. Is it possible to show the total of all the rows not just the 1000 rows shown on the report? It will be very handy otherwise we have to export the data manually to Excel and do the sum in Excel.