Year and date level in DMR model asking string data type for _memberCaption

[inu]

Hi

In DMR model, there are levels for hierarchy. All level need to be set as both "businesskey" cum "_membercaption".
I set both for Quarter and month level. but not able to set for "year" level and "date" level, because of data types are not string type.

   What should i do , in this case. can i change the data type in Framework Manager itself. or i need to do anything else.
Because of this i m getting error while publishing the package.

Thanks and Regards
Inam

[navissar]

Hi there,
You can create a string by casting the field. For instance, "cast([year],varchar(4))".

[inu]

Hi Nimrod Avissar

Thank you for your response as to the point.
Where i need to write "cast([year],varchar(4))" in Framework Manager, to convert date datatype to string datatype. so that it will work properly.

Is there any other way by means, if i dont chage the data type, and one more data item put into same level as a "_membercaption". then what will happen. Please clear my daughts, i cant find these stuffs in users guide.

Regards
Inam

[navissar]

Right, I'm not sure I understood everything. To answer your question, you can create a new query item and cast the desired field to string there.
On a more general note, I think you should get some training (Preferably in a language you're comfortable with) and/or read the documentation through - the answer to your question here is definitely documented. I don't think you can get complex modelling right based only on forum Q&A.
Good luck.

[MFGF]

Hi Nimrod Avissar

Thank you for your response as to the point.
Where i need to write "cast([year],varchar(4))" in Framework Manager, to convert date datatype to string datatype. so that it will work properly.

Is there any other way by means, if i dont chage the data type, and one more data item put into same level as a "_membercaption". then what will happen. Please clear my daughts, i cant find these stuffs in users guide.

Regards
Inam

When you are defining the attributes for a level, you can either drag them in if they are based simply on an existing query item, or you can use the Add link at the bottom to create an expression to derive the attribute. In this case you would probably do this and use the cast() function when deriving the attribute you intend to use as the membercaption.

Cheers!

MF.