How can download report as .TXT

[Former Member]

Hi Experts,

For the customer does need a report which contains records more that 65000, which is the limitaion of Excel 2003.

So far, i know the following solutions, but they don't fit our case:

1. Office 2007. The user will continue to use 2003.

2. Web Analyzer. No portal established.

3. Using filter to reduce the # of record. They customer has confirmed no filer will be used in this report.

Can somebody provide a way to download the report as txt file? We're using Analyzer to report.

Thanks!

Regards,

Sugie

[former_member205352 · Accepted solution]

When you say >65K and .txt.I believe its not for any analysis.

Why not use Open Hub and pull it as a file, by writing required logic in transformation ?

[Former Member]

Have you tried setting up an Access database that links to your BW one?

Regards

Gill

[Former Member]

Hi Gill,

I have no idea how to connect BW with Access, but if this is feasible, it definitly is a good solution.

Could u give more clues on how i can do this? it is done on customer computer or on BW server?

If there is some resource links, much appreciation!

Best regards,

Sugie