Skip to Content
avatar image
Former Member

"Show Values Error Index:0" in IDT

Dec 09, 2016 at 08:38 AM | 65 Views | Last edit Dec 09, 2016 at 09:16 AM 3 rev.

When I Right Click on a table to see table values in Information Design Tool, it shows error message "Show Values Error Index:0".

For few tables I am able to see values in data foundation layer, few tables show above mentioned error.

Environment:

Tool: SAP Information Design Tool 4.2 SP03

Database: SQL Server 2012

Connection Establishment through ODBC is successfull.

idt.png (5.0 kB)
SAP BusinessObjects - Semantic Layer
SAP BusinessObjects Business Intelligence platform | information design tool | idt | semantic layer
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Mahboob Mohammed
    Dec 09, 2016 at 07:24 PM

    Hi Shaishav,

    For the tables which you get this error, would you please see how many rows are their in those? If there are millions of rows, can you find out if there is Indexing done on them at the database level?

    Apart from that, if you've SQL Server Client tools install, can you run a simple select against those tables to get top 1000 rows, as Select top 1000 * from Tablename, please google for the correct syntax.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded