Determinants is not working when I use casting function on one of the column.

[anand.anantula]

Hello All,

I created a query subject with 4 columns that are derived from a fact table and the columns are 2 Text Blob variables, 1 date time columns, 1 key. In order to display Blobs, I applied determinants on this dimension. The results are fine.

Business would like us to change the date time to date, then I applied the casting on date time column. Surprisingly the result set is blank any date period.

Can some one please give me suggestion?

It seems to be there is an issue with determinants when we apply casting on one of the column.

Thank you in advance.