Provided there is only one item in the Members list, you have the option in the Define Members dialog box to use a "partial field member name" (you cannot use this feature if there is a concatenation of field entries). As a result, you can edit the name of the item appearing in the underlying table in order to make it appear in PowerOLAP® as you wish: for example, beginning with the fifth character and ending with the tenth character. One practical example of this is to remove unwanted preceding characters from Member names—e.g., from the Date entry "2000_01" one might want only the "01", to signify January.
To use Partial Field Member Name:
1. For the Dimension you want to modify, confirm that there is only one item in the Member list, then from the Define Members dialog box, check the Partial Members check box option.
In the demonstration Cube, for the Customers dimension, the right side of the Define Members dialog box will look as follows:
.png)
2. Click Next.
The Partial Fields dialog box appears, as in the following figure:
.png)
On the left, the Initial Values are listed—meaning the Member entries as they appear in the underlying relational table. By manipulating the Lower Value index and Higher value index boxes (boxed together above), you can change the appearance of the Members as reflected in the Partial Values list on the right.
3. For example, type 10 into the Lower value index box.
Note the Members' appearance in the Partial Values list. For this example, reset the Lower value index to 1.
4. Use the Higher Value index scroll bar to reach 15.
The following figure shows the Members of the Customers dimension with Lower value index set to 1 and Higher value index set to 15.
.png)
5. When you have settled on the appearance of the Partial Values, click Next.
6. Click Next through the successive dialog boxes to reach the Relational Dimension Summary dialog box. You will see that the summary records that the option for Partial Fields is On.
Click Finish if you wish to effectuate the Partial Fields choices you have made.
[If you use the Partial Fields option, you will be able to confirm the new appearance of the Members within PowerOLAP® by opening a new Slice that shows Members of the Dimension in columns or rows.]
[Note that for the present demonstration, you can click Cancel to exit from the Modify Relational Dimension routine.]
Important
Note that by changing the Member name, which is what the Use Partial Field
Member Name feature accomplishes, you may affect other "Define Member"
choices you have made, particularly if you are Modifying a Relational
Dimension. For example, if you use Partial Field Names you will have to
re-create a Rollup so that it is composed of the Members as they now appear
in "partial" format. Failure to make Member name changes throughout
the Cube will result in an error log.