Page 1 of 1
Advanced Dynamic Formatting
Posted: Thu Jun 23, 2011 9:06 am
by guntupalli
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.
Re: Advanced Dynamic Formatting
Posted: Thu Jun 23, 2011 10:40 am
by David Usherwood
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.
Re: Advanced Dynamic Formatting
Posted: Thu Jun 23, 2011 3:00 pm
by guntupalli
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,
Re: Advanced Dynamic Formatting
Posted: Thu Jun 23, 2011 3:55 pm
by lotsaram
guntupalli wrote:i didn't find the option 'Edit Element Formats' to do, can you please let me know.
... 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.