Automatic refrush of BW Query
Hi SAP Gurus,
I have a question. I have a workbook with two queries. Each query has three different Characteristic value variables (one for month, one for year and the other to select a Hierarchy element.) The hierarchy has 400 nodes. User need to select the node for which he needs the report.
The problem here is the user does not want to select each and every hierarchy node. He would like to automate this report. That means, if he selects values for only month and year, the report should run for all the 400 nodes separately and saves as different sheets in the workbook.
Can anyone shed some light on this please?
Thanks a lot in advance!