IDT - One object (dimension) to display all columns of a table.

[Chinmay_K]

Hello,

I am trying to create a object (dimension) in Information Design Tool (4.1 and 4.2) and Universe Design Tool(3.1) which will display all columns of a table but I am getting error 'Expression contains multiple attributes'.

For example:-

I have a table "Employee" having below columns:-

Name, Address, Age, Salary, Birth date

I want to create only one object (dimension) say 'Employee' which will display all the columns of table "Employee".

Is this possible in SAP IDT or UDT?

[Chinmay_K]

I am using Oracle database

[bulent_ozgul]

what database are you using?

for example, if your database is SQL Server, create a derived table and insert this code:

Select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where table_name = 'Employee'