TM1 Forum

Is it possible in TM-1 do such things
1. apply some style - bold or for example Italic for some elements in subset or dimension (some sort of format)
2. do the same thing for date - some lines are bold - where I want and others - are as usual

for example


Region1 1 2 3
Region2 1 2 3
Region3 1 2 3


May be possible not in Architect but in some clients - Application Web or Insight

If you create an Excel worksheet, you can use any kind of formatting that Excel supports, including conditional formatting. I would imagine there would be a way to do what you want in Excel -- there's very little you can't get done with a little imagination!

Many of Excel's formatting features work in Websheets, but you may have to play around a bit to get it to work.

Insight may one day do what you want, but the current version does not as far as I know.

I don't think this can be done in TM1 Cube views if that s what the OP had in mind.

In Excel, it could be done in so many ways as Lazarus said.

I would just add that If the element to format is determined by data / conditions / position in hierarchy / rules calculations,
you could consider to create a specific attribute to generate a reference you could use to support your conditional formatting in Excel.

Hope this helps,
Kind Regards,

Olivier

Thank you for answers.

I wanted to format elements based on elements attributes indeed but in web clients not in Excel
It is pity if it is impossible

EP_explorer wrote:I wanted to format elements based on elements attributes indeed but in web clients not in Excel
It is pity if it is impossible

It is possible with websheets? They are web clients but using Excel formatting. Much better than Web views. Very quick and simple though they may need a bit of fine tuning between Excel and Websheet versions.