MS SQL Data Warehousing - MDX Select Cast types

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MDX Select Cast types

leo

2005-12-28, 8:23 pm

Hello everyone !

.... I'm trying work some datas in the database, but one column return
type adVariant when I make my select, I don't know mdx very well, but
in SQL I can make a CAST to others types, Can I do this in MDX ?
Convert the type adVariant to double, integer ?
This column had rows with numbers and rows with null value (this is the
reason for the type appear adVariant). If exist some 'magic' way to
convert this column to type I want, please help...

Thanks folks!

Sponsored Links