getting data from the VIEW 1

[tandyaw]

Hi all,

I have a VIEW that combines data from 2 tables (table 1 and table 2). In the view, I have all columns from table 2 and only 2 columns from table 1 (FACTORY_ID and TYPE_ID)
In Impromptu, I'm able to pull out all view data from table 2 into the report. However, when I try to pull out the data from a column that was from table 1, I got an error message saying "Column FACTORY_ID was not found in table or view T1". The same thing happened when I tried to pull out data from TYPE_ID column.

Any idea? Am I missing anything?

Thanks in advance,
Lia

 

[griffindm]

Lia,

I often get this message when I make a change to metadata while I am still in Impromptu. I just close Impromptu and open it again, and it sees the new columns fine after that.

I hope this is what you are seeing.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ401-2487 first!

http://www.decisionsupportgroup.com