how to find a fild in database

[MAJLI]

is there any possibility to find in a fast way which table belong a fild in database in Cognos ReportNet ?any time i want to find a fild but i have to expand many tables to find the right one.

 

[ShanChatterjee]

You can do a right-click on the Field and see the Properties. It should say you the the TableName etc...

this helps you ?????

 

[Draoued]

In FrameWork manager, click the Search icon (if you don't see it, go through Menu View--Search).

In "Search For" box give the field name or a part of it, like COUNTRY for example, click search, you ll get the full list of all types which contains this string , the location tells you where you can find it.

If you want to narrow your search scope, use the CLASS box, for fields you can select "Query Item" to see only fields in the search result box.


If you are using Oracle database you can also use SQL+ to find fields and tables:
select column_name, table_name from user_tab_cols where column_name like 'COUNTRY%';

 

[MAJLI]

thanks for the answer,
but is another kind of problem.i dont know how to find the field?i have to create a report with reportNet and i have just the name of field.We use cognos to create the report with the fields that came from a banking system(Midas).so we know how is the name of the field(from our system)and is very difficult to find in which table is the field in our Database View?

 

[Draoued]

if you are using ReportNet, then I suppose you are using FrameWork Manager or are typing all the sql directly in report Studio ?

Why don't you create a package then ??

And import the Midas tables in Framework manager, you ll be then able to use the search, and do some renaming if needed.

I don't know anything about midas maybe there are thousand of tables, and it will not be feasable.

 

[MAJLI]

THANK YOU Draoued.
I used the sql+.and i found what i was loking for.
thanks again