Multiple Items to Display in a Dimensional Hierarchy Checkbox

[gosoccer]

Friends,
I need to show the specific site# and description as a part of a value prompt (checkbox).
It's working just fine with one value chosen to display but i need to show two values to the
user as a part of the checkbox listing.

Let me know if there is an easy way of doing this if both Site# and Site Descriptions are in the Same Level and available.

Thx so much

[pricter]

Why do you concant the site# and the description in a data item and use it as a display value?

[gosoccer]

pricter,
I am using the following in the data item but get an error,
[dsCube-].[xxx].[xxx].[SITE_ID]||[dsCube-].[xxxx].[xxx].[SITE_NAME]

  The operands of '[dsCube-].[xxxx].[xxxx].[SITE_ID] || [dsCube].[xxxx].[xxxx].[SITE_NAME]' cannot be converted to consistent dimensional object.

Do you by any chance know the correct sentence?
Thank you so much!.

[pricter]

Could you clarify the following

[site id] and and [site name] are members of an hierarchy or attributes of it?

[gosoccer]

yes, that is correct.

[pricter]

Which one of two

Member of a hierarchy?
Attributes?

[gosoccer]

There is a Dimension/Hierarchy as below,
Location Dimension
   Location Hierarchy
      SITE_ID    level
      SITE_NAME level
Under each, there are the members like 12121 for site id and Tawson for site_name

[pricter]

Try

Code Select Expand

caption([dsCube-].[xxx].[xxx].[SITE_ID])+caption([dsCube-].[xxx].[xxx].[SITE_NAME])

[gosoccer]

OK
Created the Data Item and selected the Data Item a part of the Checklist - Display Value but it is showing me the caption and not the value
of each SITE_NAME.
The DISPLAY VALUE is showing me,
data item1
data item1
data item1
for the three sites that is show their site_id and site_name

[gosoccer]

The following worked Picter,
])||+caption. Just added the || before the + sign and it is working. Not sure why??
Thank you so much.  :)

[pricter]

I am glad that I help you overcome your difficulty.

[gosoccer]

Yes. Now, I'm big time stuck on something else. I'll start the request or reply again.
Thx so much!!