Fetching links to set of Documents in a Table

[#1]

Hello All,

I am trying to fetch a set of documents present in either a database or a FTP location and create a table that gives alink to them on the basis of the Dimension.

For example in the below chart on the basis of the Customer ID dim(that identifies the file name) and display the link to it.

Customer_ID	Customer _Document
007	http://server/getdoc/Cust_007.doc.
008	C:\temp\temp_008.pdf

Appreciate any guidance on the same.

Cheers !

[Anonymous]

Customer_ID	Document_Location
001	Location 1
002	Location 2
003	Location 3
004	Location 4
005	Location 5
006	Location 6
007	Location 7

I would use an external excel sheet to create a link between the Customer_ID and there Document_Location as above. You can then link that sheet to your Customer table using the Customer_ID unique field. Once that is done you will be able to use the Document_Location dimension wherever you need to and it will alway filter based on the Customer_ID selected.