Navision 3.60 and OLAP Cubes

Phenno

Hello.

I'm trying to build OLAP cubes (SQL Analysis services) over native navision DB.

Most of the things are working, but I can't build Time dimension. It always gave me this error "Expected lexical element not found: <identifier>"

I tried playing with identifier settings in c/odbc and/or language settings but nothing helped. I read the comments on mibuso about similar errors but they all build sql commands manually.

Has anybody tried this on Nav4.0 and nodbc (which not let me connect to 3.6db)?

What are results of converting executables only from 3.6 to Nav4.0?

Phenno

I tried do create Time dimension on native 4.0 db and when I try to process dimension it gives me an error saying:

[Simba][SimbaEngine ODBC Driver]Invalid scalar function: MONTHNAME.;37000


Like, he's trying to translate month no to month name (although I don't want that at this moment). Can't find a property for that on dimension properties.

Phenno

Ok, it's manageble through dimension properties... I finally created Time dimension.

So, real question pops-out now, has anybody had problem with converting db 3.6 to 4.0 (only executables) (besides the problem that you have to not only convert but to open company)