- Business Intelligence with MicroStrategy Cookbook
- Davide Moraschi
- 376字
- 2021-07-23 15:32:03
Selecting which forms are displayed
When browsing the attribute elements in Data Explorer | System Hierarchy , we noticed that the DESC form is always shown but by default the ID is hidden. To change this behavior and decide how the attribute will appear to the end user, we will modify the settings in the Display tab of the Attribute Editor. These settings will affect the way attribute elements are displayed also in dynamic selections and filters which we'll cover in Chapter 8, Dynamic Selection with Filters and Prompts.
Getting ready
You need to have completed the previous recipes to continue.
How to do it...
Let's see how to do it:
- In the Schema Objects | Attributes folder, double-click on the Customer attribute.
- Select the Display tab, you will find a shopping cart like the one shown in the following screen capture:
- In the right part of the cart, select the EMAIL form and remove it from both Report display and Browse by clicking on the small < buttons.
- Click on Save and Close and update the schema.
Now if you go to Data Explorer | System Hierarchy, you'll notice that the e-mail address is gone. If you still see it, that's because MicroStrategy Desktop keeps a local cache of attribute elements to speed up the application; in this case you need to refresh the elements. Click on the View menu and select Refresh (F5).
How it works...
This setting affects the default behavior of the entire project when browsing the attribute. You will still have the possibility to change the display forms on a per report basis.
There's more...
You may want the elements sorted by code, for example, instead of DESC.
You can do this from the Modify Attribute Form window. Refer to the screen capture:

There are two comboboxes down on the right-hand side named Report sort and Browse sort.
If you change the second one to Descending (in the screen capture I am sorting the Year attribute), you will see the years' elements sorted backwards. This is especially useful when the users have to select from a dynamic list of years, and you want the most recent to be shown first.
- 自愿審計動機與質量研究:基于我國中期財務報告審計的經驗證據
- 資本的眼睛
- Splunk:Enterprise Operational Intelligence Delivered
- Big Data Visualization
- 陜西文物年鑒·2015
- 財務建模與綜合估值:數據研磨、模型校準、動態估值
- Salesforce Essentials for Administrators
- 下一場全球金融危機的到來:明斯基與金融不穩定
- Amazon EC2 Cookbook
- 政府采購評審專家工作指南
- Windows Server 2016 Administration Fundamentals
- 內部審計數字化轉型:方法論與實踐
- TIBCO Spotfire for Developers
- 基本建設財務核算管理與審計
- Oracle Enterprise Manager Cloud Control 12c:Managing Data Center Chaos