Conditional Formatting without using Excel

ioscat · Post by **ioscat** » Mon Sep 10, 2012 9:20 am

Hello, forum!
Is it possible to change color in a cell on some condition? For example I set scenarios in assumptions cube and see in calculation cube values for all versions but with different font colors. Choosed scenario is light green and others are light blue or white.

David Usherwood · Post by **David Usherwood** » Mon Sep 10, 2012 10:25 am

Which of the nine-odd user interfaces for TM1 do you have in mind?

ioscat · Post by **ioscat** » Mon Sep 10, 2012 10:55 am

Our users work via Web interface.

What is "Nine-odd"?

David Usherwood · Post by **David Usherwood** » Mon Sep 10, 2012 11:36 am

Which web interface? Websheets, Webviews or Contributor?
(That's three of the 'nine-odd' - which meant 'about' nine, but waiting for someone to correct me

)

stephen waters · Post by **stephen waters** » Mon Sep 10, 2012 11:54 am

David Usherwood wrote:Which web interface? Websheets, Webviews or Contributor?
(That's three of the 'nine-odd' - which meant 'about' nine, but waiting for someone to correct me )

I will raise you at least 4 web interfaces. CX Advisor\Executive Viewer, Business Viewpoint, Cognos BI (various), Cognos Insight. Can also look at data over web using Perf Mod ( not that you would want to)

David Usherwood · Post by **David Usherwood** » Mon Sep 10, 2012 12:01 pm

Insight's not web-based - but my 'nine-odd' related to all UIs.
Looking forward to a full list that I can pick holes in

ioscat · Post by **ioscat** » Mon Sep 10, 2012 12:18 pm

omg, they arriving and arriving)

We use Contributor

ioscat · Post by **ioscat** » Tue Sep 11, 2012 4:22 am

No replies means answer "No" for the topic?

lotsaram · Post by **lotsaram** » Tue Sep 11, 2012 8:20 am

ioscat wrote:No replies means answer "No" for the topic?

Well it depends what you mean by "Our users work via Web interface."

Using a TM1 websheet which starts it's life as an Excel spreadsheet of course you can set up conditional formatting and it will work just fine on the web exactly as per Excel. But if you are using only cube views then there is no facility for conditional formats.

ioscat · Post by **ioscat** » Tue Sep 11, 2012 8:45 am

ioscat wrote:We use Contributor

is it a cube view?

David Usherwood · Post by **David Usherwood** » Tue Sep 11, 2012 9:39 am

You don't need conditional formatting to suppress zeroes - try using the format in my earlier post. You can use this in Excel and in the Perspectives cube viewer. I don't _know_ whether you can use it in a TM1 Web view. Try.

lotsaram · Post by **lotsaram** » Tue Sep 11, 2012 9:40 am

9.5.2 Contributor is built only with cube views so no conditional formatting.

If you move to 10.1.1 then you can include websheets within a Contributor application and therefore can have conditional formatting and other stuff like asymetric views, combine data from multiple cubes in a single tab, include graphics, instructions, action buttons, etc.

TM1 Forum

Conditional Formatting without using Excel

Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel

Re: Conditional Formatting without using Excel