If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with file size of cognos active reports (.MHT)

Started by guns, 14 Dec 2012 07:21:12 AM

Previous topic - Next topic

guns

Hello,
We are developing cognos active reports in .MHT format and are designed to be viewed on iPads.

We are generating these reports from flat files that have about 500 rows and 19 columns of data and we observed that the final .MHT file size is around 15 MB.

The question I have is what is causing the .MHT file size to be this big? I have tried removing all filters, formatting and logos but it wasn't of much help. Is it something to do with the bulk of the data itself? Is it possible that data which is 60KB in size in .txt format, bloats upto 15MB in size in .MHT format?

MFGF

It's really driven by the iterations of cards within decks, and the amount of stuff you are including with each card. If you have the crosstab on a data deck driven by regions (for example) and you have 100 regions, your crosstab is rendered 100 times within the MHT. If you nest this into another data deck for years and you have 10 year cards, then you end up with a total of 1000 cards so your crosstab is rendered 1000 times. We'd need to know more about the structure and objects in your report to say what is causing the mht to be this large.

Cheers!

MF.
Meep!

pmartins

Hi MF.,

I have a question for you :)

Let's assume the 100 regions, 10 years data set. But let's suppose that not all combinations of region/year have data. It seems to me that you cannot tell the Active Report to not generate a card in such case. Do you agree?

We would need to be able to "nest" card values in the data deck...

Pedro

pumccg

Make sure you are re-using queries whenever possible. If you don't, and you could hve, it may be including the same data many times.

CognAsh

Hi Pedro

You should not nest decks - in your example of 100 products and 10 years where you do not have data for each year/product combination you should simply add both the product line AND year to the drop zone of the data deck. This will then only create cards for products and years for which there is data.

Ash