Custom SQL Expression - Error on table declaration (SQL Server)

Answered

Comments

3 comments

  • Avatar
    Alessandro Trinca

    Hello,

    I've solved adding all the needed tables from the source.

    Just a question: I'm using the Custom SQL Expression to avoid adding all the needed tables one-by-one, so: can I create a Custom SQL Expressione WITHOUT also adding all the tables before? because it would be an usefulness redundancy

    Thanks

    0
    Comment actions Permalink
  • Avatar
    Sam Ovenshine

    Hi Alessandro,

    Creating a Custom SQL Expression table means performing a SQL query (using Sisense's functions and syntax) on tables that already exist within your ElastiCube. If they don't already exist in your ElastiCube, that's likely the reason you're getting the 'table not declared' error. To put it another way, manual query input is executed on your database, while a Custom SQL Expression is executed entirely within Sisense on what already exists in your data model.

    If you're trying to import multiple source tables at once ("SELECT * FROM Orders; SELECT * FROM OrderDetails"), as far as I know, you don't have the ability to do that. You have to add tables one by one. Depending on your data model, you may be able to import data from within multiple tables by getting creative with your query ("SELECT * FROM Orders INNER JOIN OrderDetails ON...).

    0
    Comment actions Permalink
  • Avatar
    Alessandro Trinca

    Hi Sam,

    thanks for the reply.

    Alessandro

    0
    Comment actions Permalink

Please sign in to leave a comment.