Skip to Content
avatar image
Former Member

Excel pivot table problem while sending sheet with BEx broadcaster.

Hello!s

I have a strange problem. While I'm sending excel sheet with some pivot tables with BEx Broadcaster, the source of tables in excel is changed. For example, properly working tables have a source in excel like this :

dane!$A:$U

However, something is changing Table/source like below after sending sheet with broadcaster:

[SAPBEXPRECTVYU7KMXXPDPAHD7CSUIJLZA3_0.XLSB]dane!$A:$U


So in this case, pivot tables are unusable for user. Every time it's need to be manually removed to dane!$A:$U. Anybody had the same or similar issue?

Best regards,

Adrian


excel.png (9.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Adrian,

    It appears that that the technical name for the spreadsheet on the server is being added automatically to the pivot table definition.

    Consider creating a Pivot table like display through Bex on another tab.

    John Hawk

  • Former Member John Hawk

    Hello John!
    Thanks for your response.

    Indeed, precalculation server is changing source of pivot table.

    What do you mean by "creating a Pivot table like display through Bex on another tab"? It's not clear for me :)

  • Get RSS Feed

0 Answers