Active report data size limitations

[mantvman]

What are the data size limitations of active reports (Cognos analytics 11.0.9) ? and is it possible to build an active report based on 3 tables each with approximately 145 fields and 9 million lines?
i.e about 2 to 4 Gigs of Data
Can it be done on line and not so the active logic can be used however the data is no all in the report?  i.e build a report that looks active but does not contain on al the data ?

[MFGF]

What are the data size limitations of active reports (Cognos analytics 11.0.9) ? and is it possible to build an active report based on 3 tables each with approximately 145 fields and 9 million lines?
i.e about 2 to 4 Gigs of Data
Can it be done on line and not so the active logic can be used however the data is no all in the report?  i.e build a report that looks active but does not contain on al the data ?

Hi,

If you really do mean an Active Report, then it will need to contain all the data it requires. Their purpose is to deliver summarised overview data. Generally I would suggest the maximum size you should consider is 8 to 10 Megabytes. If you have 2 to 4 Gigabytes of data, this is not going to work. Do you really need to add all 9 million rows from each table, or are you looking for a summarised data set aggregated from those 9 million rows? What are you trying to achieve with this?

MF.

[mantvman]

Unfortunately, my customer does not want to use self-service.
Also Power Play is to complex for him...
Each filed describes different indicators and he is looking for some kind of combination and then a defined event that he then goes out to investigate.
He has specific filed combinations that he wants to see effected by different searches
He wants it all in a reports where he can filter in all data .
He has specific filed combinations that he wants to see effected by different searches
How ever putting all prompts using Java is very complex, and using active tools would make it much easier

[MFGF]

Unfortunately, my customer does not want to use self-service.
Also Power Play is to complex for him...
Each filed describes different indicators and he is looking for some kind of combination and then a defined event that he then goes out to investigate.
He has specific filed combinations that he wants to see effected by different searches
He wants it all in a reports where he can filter in all data .
He has specific filed combinations that he wants to see effected by different searches
How ever putting all prompts using Java is very complex, and using active tools would make it much easier

What about having the data in database tables (appropriately indexed for speed) and using a dashboard to deliver the visualizations? Would that work?

MF.

[mantvman]

Unfortunately, my Customer needs the end results in Excel as he sends it out to external organizations

[Lynn]

Unfortunately, my Customer needs the end results in Excel as he sends it out to external organizations

An Active Report isn't going to fit the bill then in any case if Excel output is required.

A pre-authored report with prompts would allow the desired filtering and subsequent output to Excel. What do you mean when you say "putting all prompts using Java is very complex"? Nothing you've described sounds out of the range of what regular report authoring can achieve. Or perhaps I still don't fully understand your situation.