How to sort by a form that is not displayed in the document in MicroStrategy Desktop 8.x

 
今天在做document时,遇到了一个问题:document按一个attribute分组,这个attribute有三个forms: ID,DESC and SORT_ORDER,要求按照SORT_ORDER排序,但是当我右击这个属性选择sort时,只出现了ID和DESC两个属性,没有我要的SORT_ORDER,下面有两种解决办法:
How to sort by a form that is not displayed in the report in MicroStrategy Desktop 8.x

There are two methods to sort an attribute form. One is to sort at the report level using "Advance Sort" and the other is to sort at the attribute level by setting the default sort of the form.

Regardless of which level the sort is set, the form must be accessible from the "Displayed forms" and/or "Report objects form." Making the form accessible from the "Displayed form" will automatically make it accessible from the "Report objects form" as well as make the form visible on the report itself. Thus, to make the form "sort capable," the form must be accessible from the "Report objects form" regardless if it is visible or not on the grid. MicroStrategy OLAP Services is required to have the form in the "Report objects forms" only.

For an available form to be a displayed form and/or a report objects form at the report level, users must open the "Attribute Display" window.

  1. To open the "Attribute Display" window, right-click on the attribute and select "More" from the sub-menu "Attribute Forms," as shown below:

  2. Once the menu item "More" has been selected, the "Attribute Display" window will appear, as shown below:

    At this point, users will have the option to make an available form be a displayed form and/or a report objects form.

  3. Once a form has been selected as a displayed form and/or a report objects form, a user must then specify the settings to sort an attribute in the "Advance Sorting" which is located under the "Data" menu, as shown below:

For an available form to be a displayed form and/or a browse form at the attribute level, users must edit the attribute using the attribute editor.

  1. Open the attribute editor and select the 'Display' tab, as shown below:

  2. Once in the "Display" tab, users will have the option to make an available form be a displayed form and/or a browse form. Once a form has been selected as a displayed form and/or a browse form, then users must specify the settings to sort an attribute in the in form editor, as shown below:

  3. Once the default sort for an attribute form is set, the form must then be added, at the report level, to the displayed form and/or a report objects form, which can be configured in the "Attribute Display" window. To open the "Attribute Display" window, right-click on the attribute and select "More" from the sub-menu "Attribute Forms," as shown below:

    Note: After modifying an attribute, an update of the schema is necessary for changes to take effect.

  4. Once the menu item "More" has been selected, the "Attribute Display" window will appear, as shown below:

At this point, users will have the option to make an available form be a displayed form and/or a report objects form.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值