Im in the process of creating a new universe. Ive connected to a SQL Server database no problem, but when I come to select the tables/fields which I require it seems to only make available fields with a number value. Any ideas why?
OK...it seems to only like char, int, float and alike..it doesnt recognise nvarchar or varchar. More importantly, it deosnt recognise datetime or smalldatetime. The data we are using is highly dependent on dates.....is there any way around this?
Even with this you should be able to create the object manually for nchar or nvarchar and it should recognize datetime or smalldatetime. Did you try creating an object and setting the datatype to Date???
Yeah, tried that. The fact still remains however that fields brought from SQL Server with type datetime or small datetime are not recognised. Surely it would be defeating the object of using such a tool if I were to create the fields from scratch in BO?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.