This is a little “don’t” that I stumbled upon recently.
Don’t create metric aliases that contain operators such as “-“, “+”, and so long. Although MicroStrategy allows you to do so, the database application (Oracle, Teradata,…) will nag you about expecting “something between – and ,” and of course, the report will stop executing.
Wednesday, April 22, 2009
Subscribe to:
Post Comments (Atom)
Great tip sorin. For readers: This is about the Metric Alias in metric editor (Metric Column Option) not the Report editor (Report Data Option).
ReplyDeleteAlso, the Metric column alias can't be more than 16 characters and one can play with the setting of underlying fact's column alias for same effect.