Establishing a Time Dimension and getting BMT-MD-2047 When Deploying

[gosoccer]

Hi folks, :) :) :( :(

In the way of establishing a Time Dimension, I'm facing the following error:

I have the date dimension established in my Business View. I have build the Time Dimension from the Subject Query called Date_Dimension.

The Time Dimension is in my Presentation View but when I try deploying the package, I'm getting the following error:

BMT-MD-2009 This package will publish 'Query Item' '[Presentation View].[Time Dimension].[Time Hierarchy].[Date].[DATE_DESC]', 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

DT_ID(INT)    DATE_DESC (DATE)           YR(VARCHAR (12))    MO (VARCHAR (12))   QTR (VARCHAR (12))   QTR (VARCHAR (12))
1212              2015-09-01                                   2015                        APRIL                      3                                 WEDNESDAY

I get a feeling the DATE_DESC needs to be converted to String from a Date Data Type by getting it added as a calculation to the Subject Q with a different name? Would that cause an issue with the Dimensions?

Please help if you can?

Thanks a lot for your time.

[MFGF]

Hi folks, :) :) :( :(

In the way of establishing a Time Dimension, I'm facing the following error:

I have the date dimension established in my Business View. I have build the Time Dimension from the Subject Query called Date_Dimension.

The Time Dimension is in my Presentation View but when I try deploying the package, I'm getting the following error:

BMT-MD-2009 This package will publish 'Query Item' '[Presentation View].[Time Dimension].[Time Hierarchy].[Date].[DATE_DESC]', 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

DT_ID(INT)    DATE_DESC (DATE)           YR(VARCHAR (12))    MO (VARCHAR (12))   QTR (VARCHAR (12))   QTR (VARCHAR (12))
1212              2015-09-01                                   2015                        APRIL                      3                                 WEDNESDAY

I get a feeling the DATE_DESC needs to be converted to String from a Date Data Type by getting it added as a calculation to the Subject Q with a different name? Would that cause an issue with the Dimensions?

Please help if you can?

Thanks a lot for your time.

Hi,

This appears to be an issue with modelling DMR in Framework Manager. Why did you originally post it in the Report Studio board? I have moved it to the Framework Manager board for you.

You can't use an item with a Date or Numeric data type as a member caption in DMR. This is what the error is telling you. Member captions need to be character strings (char or varchar). You will need to use a calculation to cast the date item to a char or varchar

eg cast([DATE_DESC], varchar(10))

This can then be used as your member caption attribute. You can either do this calc in the underlying query subject, or you can add a calculated attribute to your Day level that does it.

Cheers!

MF.

[gosoccer]

Ok, my apologies. Not sure why I post it in Report Studio.
Ok, I'll try that. Thx so much.

[gosoccer]

Problem resolved.
This site is awesome!!