hi all,
can anyone help where can we do Level Formatting, Attribute Formatting and rule-based formatting in 9.5?
i could find it in 9.1 and prior ( http://public.dhe.ibm.com/software/dw/d ... in_tm1.pdf ) , is any doc which discuss the same in 9.5.
thank you.
Advanced Dynamic Formatting
-
- Posts: 19
- Joined: Mon May 16, 2011 12:15 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2010
Advanced Dynamic Formatting
Best Regards,
Guntupalli
Guntupalli
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Advanced Dynamic Formatting
As I recall, dynamic formatting related to Dynamic Slices. These appeared in 9.1 and were very poor indeed. They have been replaced by Active Forms in 9.4+, and these are documented in the User Guide. My view is that they are an improvement on Dynamic Slices (how could they not be) but I still wouldn't push them too hard, especially with nested row dimensions.
-
- Posts: 19
- Joined: Mon May 16, 2011 12:15 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2010
Re: Advanced Dynamic Formatting
thanks David,
but i want to C-level elements in the 'Model' dimension needs to format, with colored backgrounds and indentation, according to their level in the dimension hierarchy. N-level elements are not indented and use an italic font.
i didn't find the option 'Edit Element Formats' to do, can you please let me know.
Regards,
but i want to C-level elements in the 'Model' dimension needs to format, with colored backgrounds and indentation, according to their level in the dimension hierarchy. N-level elements are not indented and use an italic font.
i didn't find the option 'Edit Element Formats' to do, can you please let me know.
Regards,
Best Regards,
Guntupalli
Guntupalli
-
- MVP
- Posts: 3651
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Advanced Dynamic Formatting
... and you won't, because that option doesn't exist in the excel report authoring front end. However everthing that you describe that you want to do can be achieved VERY EASILY using active forms. I suggest that you actually try it out. With a bit of excel knowledge combined with some creativity active forms can be very versitile when it comes to formatting.guntupalli wrote:i didn't find the option 'Edit Element Formats' to do, can you please let me know.