MemberCaption expression

[backhandx]

Hi all,
I am investigating an existing framework which normally works.
In the dimensional layer, the modeler of the framework created the member caption attributes like this ( see the attached file please):

[path of the attribute ][BusinessKey] + || [path of the attribute ][Label]. ( without using cast function)

These two attributes are from the same hierarchy H where we were creating the member Caption.
I am wondering if is this a proper way to create member caption?
Thanks

[MFGF]

Hi all,
I am investigating an existing framework which normally works.
In the dimensional layer, the modeler of the framework created the member caption attributes like this ( see the attached file please):

[path of the attribute ][BusinessKey] + || [path of the attribute ][Label]. ( without using cast function)

These two attributes are from the same hierarchy H where we were creating the member Caption.
I am wondering if is this a proper way to create member caption?
Thanks

That would work if the BusinessKey attribute is a character value, but not if it was some sort of numeric. Is the concatenation a + or a || - you are showing both? Would it make sense to have the business key and label concatenated together with nothing between them?

MF.

[backhandx]

Actually the Concatenation is done by:   || ' - ' ||.
But I'm getting this error in the box below:

QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object '.[H].[H].[Business Key]' that does not exist.

Although it works in report.

[MFGF]

Actually the Concatenation is done by:   || ' - ' ||.
But I'm getting this error in the box below:

QE-DEF-0030 Expression parsing error.
QE-DEF-0359 The query contains a reference to at least one object '.[H].[H].[Business Key]' that does not exist.

Although it works in report.

Hi,

I'd expect to see an expression like this:

[Namespace].[Dimension].[Hierarchy].[Level].[Attribute1]  || ' -' || [Namespace].[Dimension].[Hierarchy].[Level].[Attribute2] 

Your expression doesn't appear to conform to this?

MF.

[CognosPaul]

It's been a long time since I've worked with DMR, but isn't it usually better to build the captions with references to the relational dim table?

Code Select Expand

[Namespace].[Table].[Field] + ' - ' + [Namespace].[Table].[Field2]

[backhandx]

Hi,

I'd expect to see an expression like this:

[Namespace].[Dimension].[Hierarchy].[Level].[Attribute1]  || ' -' || [Namespace].[Dimension].[Hierarchy].[Level].[Attribute2] 

Your expression doesn't appear to conform to this?

MF.

Actually it is defined as you mentionned. Is it proper to do it this way?