Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

excel files

Status
Not open for further replies.

cogdev

MIS
Nov 30, 2001
85
US
I am running a report against an excel file. If I go back and add an additional column to the excel spread sheet, how do I get the catalog to update atuomatically?

 
CogDev,

It doesn't. Impromptu catalog definitions are static, and must be modified by hand to incorporate changes or additions to the underlying metadata.

Regards,

Dave Griffin


The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
[pc2]
Want good answers? Read FAQ401-2487 first!
 
Hi CogDev,

I can only make a suggestion here, that you could investigate but, I stand to be corrected. Dave, maybe you can add someting to this.

What you can do is to connect to the spread sheet in Transformer and refresh / modify your columns via Script Editor. I saw something to this extend in the past but I can not help you with the code.

:)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top