BMT-MD-2028 level have a role of 'Caption' specified (DMR)

[gosoccer]

Hi folks,
I am getting the following error after deploying the package that includes the Dimension/Measure related to my DMR based Framework Model.

BMT-MD-2028 None of the query items in this level have a role of 'Caption' specified. At least one query item must have this role specified because it will be used to display the members in IBM Cognos 10.

If I select the memberCaption from the Specify Roles, I get a different error,

BMT-MD-2009 This package will publish 'Query Item' '[DMR].[Date Dim].[YR].[DT_DESC].[DT_ID]', which contains the following errors.

        BMT-MD-2047 Cannot assign the "_memberCaption" role to this query item because its data type is not "string". Either change the query item expression to be of type "string" or create a new string calculated item and assign the role to it.


Any help would be appreciate it.

[RichardP]

Hi

In your FM Model - for the LEVEL can you mention which column you have used for your Member Caption ?
and most importantly - is it a character datatype or numeric?
I believe the MEMBER CAPTION column must be a String...and if the column you wish to use is an INT etc - then you must cast it to a string...
to_char, etc

Also... I have sometimes witnessed where there is a FM glitch - not sure how - but TWO columns are selected as a Member Caption, and you must de-select and re-select one to get around the issue.
Hope this helps

[gosoccer]

Yes, thank you Richard. I was hoping that there was a different way to handle it but you right, that is what I did and I can publish now.

I'm opening another Question in a minute concerning the use of Crosstabs and getting 6 months data to show for each month.

Thanks so much.