TM1 Forum

Hi Everyone,

Does anyone know how to format the page that opens when you select drill thru in tm1web?
Default table format looks like Bold Times New Roman with 0 padding for header and rest
being Arial Normal displayed in a bland b&w theme.

Not sure if it's possible to find a style sheet to modify..


Thanks

Ow c'mon guys, there must be a way to apply styles to the dataset header (Fields). The default formats are terrible..

To be fair Yeon I think relational drill-through is a fairly uncommonly used feature in TM1Web so probably no one has been too fussed about it. When you find the style sheet (I'm sure it's there somewhere) please report back as it might be helpful to others

Relational drill-through makes much more sense from a value-adding application point of view in Excel where accountants can drill through from from the GL cube direct to the DR & CR transactions that aren't stored in TM1 for example, or to go from a stock cube to inventory balance postings or from a daily sales cube to sales docket transactions, etc... Then it is useful to instantly facilitate analysis and visibility of ERP data. In a web application its just a grid of numbers, what't the user going to do other than copy and paste into Excel? ... and if that's the case why not just do the drill-through in Excel to start with?

EV does offer an ability to format the relational drill-through output, and EV also has a really nice feature of automatically re-querying the drill on context of cell change in the side-by-side OLAP cube window. This I think can add value in a web app but TM1Web relational drill I'm not convinced.

Okay, what i've found so far is in ..\inetpub\wwwroot\tm1web folder, the page RelationalDialog.aspx has a few style sheet references;
the drill.css seem to change stlyes for the data section (.cell{ } class) and for the rest of the page such as the data header, not sure where it is..

you're probably right about using excel for drill, and it's easier to apply format with vba event. (btw, i still don't know your real name Lotsa )

lotsaram wrote:To be fair Yeon I think relational drill-through is a fairly uncommonly used feature in TM1Web so probably no one has been too fussed about it.

But maybe if the output didn't look so shoddy then more people would be enthusiastic about using it?

rmackenzie wrote:

lotsaram wrote:To be fair Yeon I think relational drill-through is a fairly uncommonly used feature in TM1Web so probably no one has been too fussed about it.

But maybe if the output didn't look so shoddy then more people would be enthusiastic about using it?

This is the only reason my old employer used Executive Viewer. Utilized relational drills heavily but it's lack of practical usefulness killed it for us.

Well, It seems there is an enhancement request with IBM that someone put in a while ago to enable websheet style edits.

Meanwhile, I'll just have to match the stlyle in the cell grid section using drill.css ...