direct discovery issue

[alec1982]

Hi all,

I am trying to use direct discovery to load data from SQL but it is not working for me.

Currently, the script is as follow

TableA:

SQL Select

User,

City,

Country,

Sales,

Margin from table xyz;

working fine but when I add DIRECT SELECT I get error..

TableA:

DIRECT SELECT

User,

City,

Country,

Sales,

Margin from table xyz;

Any idea?

Best,

Alec

[antoniotiman]

Try

DIRECT QUERY

DIMENSION

User,

City,

Country

MEASURE

Sales,

Margin

from YourTable;

[alec1982]

Thank you! here is the actual query but still not working

SS:

DIRECT QUERY

DIMENSION

A.Id,

A.MainTableId,

A.Customer

MEASURE

A.Sales

FROM XYZTable A INNER JOIN Table2 B on A.MainTableId = B.Id

    Where A.Customer = 'ABC';

[antoniotiman]

Which is Your QV version ?

[alec1982]

11.2 sr 10

[antoniotiman]

Join Feature has been added to QV 11.20 SR 10 (see Release Notes).

But i didn't try this.

Regards,

Antonio

[Anonymous]

Try get the data from SQL View and make join in View.

[alec1982]

not sure if I can do join within the view.. how can I do that? I clicked on select and able to make a select query from the sql view but that's about it..

[Anonymous]

You will find all informations in this MS article

CREATE VIEW (Transact-SQL)

[alec1982]

thank you Dimitri but this is out of my control zone. any other solution?