Recently found the export file size (from ARC) is much bigger than the same view export from TM1web cube view. it seems more obvious for large/bigger view, e.g. I have data export view having around 5000 rows * 40~50 columns (with both numbers and text), ARC export file size around 5~6MB, where the same view exported from TM1web only around 1MB.
Also it seems it is much slower in ARC export, not sure if it is because a larger file need to be prepared?
It is a Native View, ARC version is 2.2. actually above is tested from our timesheet/expense cube.
I see. I can understand in terms of the performance. but still surprise in file size, because when checking the content, are the exactly same, xls format.
cool, didn’t know .xlsx can be unzipped. actually I was wrong, both files are .xlsx.
It seems TM1Web has better compression ratio? the original sheet1.xml is actually bigger. 8.8M => 1M
where ARC export didn’t do any compress 5.4M => same size of the .xlsx file.