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.
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
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.