Direct Discovery Ending with error

[hariprasadqv]

Hi All,

I'm testing Direct Discovery for one my app. Here is my code. can you please mark the defect in that

DIRECT QUERY

DIMENSION

Country,

`KPI Name`

MEASURE

`Value KPI`

FROM `Internal_Performance`;

I'm loading data from .mdb file through OLEDB connection.

Thanks in Advance

[antoniotiman]

Hi,

Try to use

Native('KPI Name') as "KPI Name"

and

Native('Value KPI') as "Value KPI"

Regards,

Antonio

[hariprasadqv]

Hi,

Here is the code and Error

DIRECT QUERY

DIMENSION

"Country",

NATIVE('KPI Name') as "KPIname"

MEASURE

NATIVE('Value KPI') as "ValueKPI"

FROM "Internal_Performance";

Thanks

[antoniotiman]

Remove " from Country and Internal_performance

[hariprasadqv]

OOOps. still issue remains.

[skharlapenko]

by doing this: `KPI Name` do you want to receive a string "KPI Name" or a column named "KPI Name". If the former, then you don't have enough quotes, if the latter then in case of MDB - it's NATIVE('"KPI Name"') or NATIVE('[KPI Name]')