creation of reports

dnat · Post by **dnat** » Wed Apr 08, 2009 2:38 am

Hi

We have got some requirements to create reports.

We have to compare a file and a table and based on the conditions , we have to give the count.

For example

Col A in file matches Col A in table and Col B in file matches Col B in table--count of this

Col C in file matches Col C in table and Col D in file matches Col D in table--count of this

After getting these outputs, they have to be input in an excel file where the prestored macros/functions are available to calculate the other values.

so, if we input these values in Col A in excel, then other columns will be calculated automatically.

Since the server is in unix, we cannot input this to excel. But is there a way to do that?

sima79 · Post by **sima79** » Wed Apr 08, 2009 4:22 am

You could load your data into a another database table and then use some VBA code to pull the data into your Excel spreadsheet. You will need to have the database client and API software installed on your local PC. Once you have retrieved it you then can manipulate the data however you like in Excel. It also makes refreshing the data a breeze by re-running the VBA code.

The other option is to create a common separated file and FTP this across to your local PC.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 08, 2009 7:36 am

Use a reporting tool.

DataStage is an ETL tool. DataStage is NOT a reporting tool. Never was, never was intended to be, never will be.

kduke · Post by **kduke** » Wed Apr 08, 2009 10:15 am

Do a search on completeness. I have developed a series of jobs to calculate measures like this and report on them. You could easily modify my reports and jobs to meet you needs. Completeness is an attempt to do a "sanity check" on a data warehouse. These are simple QA checks to see if all the rows got to the target.

If I was outputing to Excel then I would output to XML. XML can be displayed in Excel.