Active Forms - Column Color and Row Title Dimension

Post Reply
ViRa
Regular Participant
Posts: 155
Joined: Tue May 14, 2013 1:53 pm
OLAP Product: Cognos BI, TM1
Version: 9.5.2 - 10.1.1
Excel Version: Excel 2003

Active Forms - Column Color and Row Title Dimension

Post by ViRa »

Hi all,

I've been trying to find solution to two of my requirements but haven't been able to. I've gone through the User Guide - Chapter: Active Forms as well. I'd appreciate if you could please assist me with this -

1) Is there a way to format the column header color? I've tried making several changes in the 'Format Area' but those get applied only to the rows.
2) When a view is generated in Active Forms, the title dimension names for the rows are not displayed. Is there a way to display the row dimension's names?

Please let me know. Appreciate your time and help.

Thanks
Active Form.JPG
Active Form.JPG (80.78 KiB) Viewed 2749 times
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Active Forms - Column Color and Row Title Dimension

Post by declanr »

1/ The column header isn't part of the formatting area. So you can just format it as you would a normal excel cell.

2/ I've always just typed them in if I have wanted them; you could probably come up with a dynamic formula but unless you have hundreds of row dimensions it would be just as quick to type the names in yourself (same as for 1, you can do anything you want outside of the named ranges.)
Declan Rodger
ViRa
Regular Participant
Posts: 155
Joined: Tue May 14, 2013 1:53 pm
OLAP Product: Cognos BI, TM1
Version: 9.5.2 - 10.1.1
Excel Version: Excel 2003

Re: Active Forms - Column Color and Row Title Dimension

Post by ViRa »

Thanks a lot Declan for your guidance and time.
Post Reply