In this example, an Essbase outline that supports duplicate member names contains the member name “Albany” under the New York and California members in a Market dimension and in a Customer dimension:
Customer | |___California | | | |___Albany | |___New York | |___Albany Market | |___California | | | |___Albany | |___New York | |___Albany
With duplicate member name support, Essbase can display “Albany” under New York and California in the Market and the Customer dimensions on the worksheet.
For this example, assume that on the Display page of the Essbase Options dialog box, only the “Show Qualified Member Names as Comments” option is selected. In Excel, the “Comment Indicator Only” option is selected.
In the worksheet, using the example of the duplicate name “Albany,” if you hovers over the indicator for Albany, New York, in the Market dimension, the cell comment reads:
<esskey>[Market].[New York].[Albany]</esskey>
If you hover over the comment indicator for Albany, New York, in the Customer dimension, the cell comment reads:
<esskey>[Customer].[New York].[Albany]</esskey>
In the two examples above, because each member, Albany, had a parent, New York, the dimension level, Customer and Market, was the level that uniquely identified the member, Albany.
Further, if you hover over the comment indicator for Albany, California, in the Customer dimension, the cell comment reads:
<esskey>[Customer].[California].[Albany]</esskey>
In a complex worksheet, the cell comment enables the user to easily pinpoint a member combination.
Using the above examples, if you select the “Show Qualified Member Names on Sheet” option on the Display page of the Essbase Options dialog box, for the instances of Albany in the Customer and Market dimensions, the qualified member name is displayed directly on the worksheet.
Note: | To show qualified member names as comments, you must enable the “Comment Indicator only” option in Excel. |