Skip to Content
author's profile photo
Former Member

about exporting query result to excel

Hi all,

I take the report result to an excel file and at this point I am being asked for my user name and password of BW login, repeatedly for many times, based on the amount of data it contains. Its quite irritating, as i need to fill that each time, it asks for that. So kindly suggest me, how to deal with this.

Regards,

Naveen.A

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Oct 05, 2005 at 06:38 AM

    Hi Naveen,

    Try checking with the Basis person also with regard to it if some parameter needs to be set for this problem.

    Hope it helps.

    Cheers

    Anurag

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 05, 2005 at 06:41 AM

    Hi Naveen,

    Not sure that understood what you exactly meant. But will try to help. When you execute query in BEx you can save a workbook detaching it from a server. In this case all reporting information will be kept without further updating from a server. The client will just open the wb and see all information. Certainly, he will not be able to make drilldowns. But for this you save your wb as a view with all drildowns already done.

    Best regards,

    Eugene

    Add comment
    10|10000 characters needed characters exceeded