Business Intelligence with MicroStrategy Cookbook

Using functions in an attribute form

When defining an attribute form, we're not limited to column names: as said, we can use constants or choose from a huge list of functions ready to use. These functions are meant for the most common uses: arithmetic, date manipulation, string functions to name a few. Let's see an example with the Customer attribute.

Getting ready

We are going to use the DimCustomer table for the next recipe. This table has a primary key (CustomerKey) and two description fields (FirstName and LastName).

How to do it...

Follow these steps to create a new attribute:

1. As in the previous recipe, go to the Attributes folder and right-click on the right pane.
2. Select New | Attribute from the context menu.
3. Create the ID form with the CustomerKey ...