Mark cells for Plan and Actual in TM1 Web and Architect

[EP_explorer]

I want to show cells for Plan and Actual for users visually in Tm1 Web (Contributor, Application) and Architect.

01.jpg (189.62 KiB) Viewed 3084 times

I uploaded the image which can illustrate ideas
1. Visually by colours
Blue is Plan, Green is Actual
Is it possible to do something like that? I think it is problematic - the one thing which comes to mind is use annotations for Actual for example

2 Using formats (different for cells with Plan and Actual)
But I have no idea how I can realize it. It seems I can't use format for cells - only for elements of dimension

may be you can give some ideas?
Tm1 Web (without any Excel sheets) and Architect is obligatory.

[David Usherwood]

Quite unfortunate that you rule out the solution which gives you what you want ie to use Excel conditional formatting in a Websheet. Any reason to exclude this standard piece of functionality?

[declanr]

As David has pointed out, websheets are the perfect way to do this.

In a cubeviewer you can't colour format cells so that option is out and you won't be able to put an "A" in front of a numeric cell; so that option is out.
The one thing I could think of that might work is having an extra string row in all of your views (note that I think this idea is ghastly) and populate that with "Actual" or "Forecast" but even that wouldn't work if you are wanting to show multiple versions on different rows... plus the users could move the dims/elements around in a cubeviewer and ruin it anyway.

Essentially you are stuck with websheets for this or relying on the users being knowledgeable enough to work it out.