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 Forms - Column Color and Row Title Dimension
-
- 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
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.)
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
-
- 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
Thanks a lot Declan for your guidance and time.