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
Why do you concant the site# and the description in a data item and use it as a display value?
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!.
Could you clarify the following
[site id] and and [site name] are members of an hierarchy or attributes of it?
yes, that is correct.
Which one of two
Member of a hierarchy?
Attributes?
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
Try
caption([dsCube-].[xxx].[xxx].[SITE_ID])+caption([dsCube-].[xxx].[xxx].[SITE_NAME])
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
The following worked Picter,
])||+caption. Just added the || before the + sign and it is working. Not sure why??
Thank you so much. :)
I am glad that I help you overcome your difficulty.
Yes. Now, I'm big time stuck on something else. I'll start the request or reply again.
Thx so much!!