Page 1 of 1
Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 8:45 am
by Wim Gielis
Hello all,
I have set up a TM1 drill-through to a system with underlying an Oracle database.
The drill-through returns the correct rows and data.
However, all data is left-aligned in the cells of the output window (when launched from the Cubeviewer for instance).
For texts and numbers that have the same number of digits, it's fine.
But for numbers like invoice amounts (small amounts and large amounts with no particular sorting), this clearly is an issue.
Users want to see the output (invoices) sorted by date, not by amount.
I don't want to store all invoice data in TM1 cube(s).
Any pointers ?
Thanks,
Wim
Re: Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 12:56 pm
by tomok
Wim Gielis wrote:Users want to see the output (invoices) sorted by date, not by amount. I don't want to store all invoice data in TM1 cube(s).
Does your drill through query have an ORDER BY clause in it?
Re: Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 1:44 pm
by lotsaram
Like Tomok said, you just need to ORDER BY on the appropriate field in the query. If you are doing the drillthrough in Excel then the user can sort by whatever field they like, but in the TM1 web presentation the output windows is static as far as I know so you have to do all the manipulation in the query.
Re: Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 2:24 pm
by David Usherwood
as far as I know so you have to do all the manipulation in the query.
Agreed.
I have found that you can do quite a bit of manipulation in the query including formatting, totals etc.
Re: Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 3:12 pm
by Wim Gielis
Hello,
Thank you for your input. I have no ORDER BY statement.
Does this mean that I have to add an ORDER BY clause, sorting numbers from small to large ? That's disappointing.
The interface that we get from Cubeviewer or TM1 Web is so limited (no buttons to sort on a column, unless I'm mistaken).
Should we insert spaces in the Oracle query to get it aligned ? The font size is not monospace so that will be complex and needlessly difficult.
Users will not copy/paste to a new Excel file and do their analysis in Excel, they see it on screen with right-aligned numbers.
Thanks !
Re: Drill-through yields left-aligned numbers
Posted: Wed Mar 09, 2016 5:12 pm
by lotsaram
If you hack the css for the drill through then you can have a much nicer looking drill-through window in terms of headers, font, borders, etc.
But I still recommend doing order by in the query, that really isn't that difficult. Just ORDER BY FieldName DESC at the end of the query