Skip to Content
avatar image
Former Member

Creating Text Variables to use in BEx Broadcaster

Creating Text Variables to use in BEx Broadcaster OR How to Broadcast reports (Excel output format) and dynamically generate each Excel file name

Hello,

I'm new into posting to this forum, but I always come here when I need some answers and I find them almost everytime.

But now I couldn't find a solution for my problem so I decided that maybe you can help me.

I'm using BEx Broadcaster (I'm working on a SAP BW 7.0, SP17) to broadcast to SAP Portal some Excel files generated from a query.

I use Filter Navigation, because the query provides me with information regarding Sales Orders from all my customers and I need to broadcast an Excel file per customer. This is working perfectly, meaning, with this query I put the Broadcaster generating an Excel file per Customer.

The problem is that I needed that each Excel file had a different name on it.

For example, for Customer1 the Excel file name should be something like Customer1_SalesOrder.xls, for Customer2 it should be Customer2_SalesOrder.xls and so on.

At the present, the Broadcaster generates each Excel file using the technical name of the Query that originated the file. You can use some stardard text variables that broadcaster has available, but these standard text variables don't solve my problem. I needed to create my own Text Variables so I could have the Customer ID on the file name.

Can someone give me a light on this?

Points are obviously awarded.

Thanks,

Cristina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 07, 2008 at 04:42 PM

    Hi Cristina,

    maybe you can use a pair of variables, one customer exit to provide de file name on base to another variable that contain the customer.

    Maybe this helps

    Natalia.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2008 at 06:36 PM

    Your problem sounds interesting, keep it posted if you get any solution on this. Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 07, 2008 at 07:09 PM

    Hello,

    Thank you for the answers, it has been a while since I posted this question and this requirement was dropped, but thank you for your suggestion anyway.

    Anyway, the problem is that in Bex Broadcaster you are not allowed to use, for the filenames, variables except the ones that system provides you...and this is extremely limited. And, apparently, you can not add your own variables to this list of variables that Broadcaster gives you.

    But again, thanks for your answer on this. If I ever come across with this problem again, I'll update this thread.

    Add comment
    10|10000 characters needed characters exceeded