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.
Quote from: gosoccer on 19 Jan 2016 04:12:56 AM
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.
Ok, my apologies. Not sure why I post it in Report Studio.
Ok, I'll try that. Thx so much.
Problem resolved.
This site is awesome!!