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 to create a straight table with alla dimensions and expression (measure)

and List box for any dimensions and try more selections.

[alec1982]

straight table works fine and tried to update the values on the sql form.. all working but on the chart I get the error.

[antoniotiman]

Can You share Your chart ?

[alec1982]

Here are couple of screenshots from the dim and exp

[antoniotiman]

I think there are many records.

Try to add other dimensions and reduce the selection by selecting in list table

[alec1982]

thank you Antonio but didnt work.. the table is very small.. I couldn't export to excel but here is a screenshot of the full table in a table box.

When trying to use a chart table and add any of the dimensions below and sum of Benchmark value I get the error as show above in my previous reply.

[antoniotiman]

I'm sorry Alec.

Maybe Codepage is not correct.

Regards,

Antonio

[alec1982]

Thank you Antonio.. I looked at the community too.. it seems many people have the same issue but no answer..