When I first was starting with MicroStrategy I worked with an Analyst who showed me the power of derived metrics by creating a dynamic copyright text. This method is not complex, but it was my first "ah ha" moment on the MicroStrategy platform.
Creating a dynamic copyright is easy. We will concatenate some text along with a dynamic year. The definition below contains the static information with the most recent year updating with the current year.
Metric Definition
Concat("Omar's BI Blog Copyright 2019-", Year(CurrentDate()))
The Metric Output at the bottom of my document below
And that's it!
Thanks for checking out this blog post. If you found this post helpful please consider donating via PayPal. Any contribution is appreciated!