Navision 3.60 and OLAP Cubes

Phenno
Phenno Member Posts: 630
edited 2006-04-12 in Navision Attain
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?

Comments

  • Phenno
    Phenno Member Posts: 630
    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
    Phenno Member Posts: 630
    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)

Categories