Search results for query: *

We are a small insurance company and we are looking at ETL tools for building conformed data marts. We already have Cognos Impromptu and Powerplay. Our production system will be about 50 GIG total database size using SQLServer on Win2k. Our transaction volume should be less than 5 GIG/day...

Thanks, The database we're using is updated weekly and while we can't change the current structure of the database, we can add tables. I think we'll create a table every week instead of a view to increase performance.

I found a way to do the union by writing my own query in the edit sql box, but this limits me to having to write the entire query in SQL.

Is there any way to perform a union operation in impromptu? The situation I have is that I have two large tables and I need some info from one and some info from the other. ie. Table1 = Health Claims Table2 = General Claims The data in Table1 is at a more detailed level than Table2. What...

I need to do a multi-page layout in a single report. Can this be done with impromptu? For instance, I need 3 subreports on page 1 and 3 different subreports on page 2 of the same report. In other reporting packages I would just insert a page break and begin the next pages layout, but impromptu...

How can I insert a page break between subreports? My users have requested a complicated report that consists of a series of subreports. What I want to be able to do is to create a multi-page report with each page having a different set of sub reports. ie. Health on page one, Dental on page...

As far as I know impromptu can only connect to one "datasource" at a time. The only exception to this is hot files. Impromptu can connect to one datasource and many hotfiles at the same time. If you need to connect to many datasources (ie. multiple databases) then I think you have...