BEx Analyzer - Questions on Functionality

[Former Member]

Hi All,

Is there any function in BEx that allows data from a single Query, to be display in Multiple Tab Sheets, differentiated by one of its dimensional value? For e.g., my query display total sales by department. 3 lines of data are displayed.

Dpt Sales

A... 100

B... 200

C... 300

Normally these data will be displayed in a single sheet only, but one of my client claims that it is possible to have these 3 lines, seperately displayed in 3 different sheets, in the same Excel workbook - with just a few simple clicks.

Currently the solution i can think of is - create new sheets manually, the newbie way...

Please help - please tell me whether it is really possible / which button i am supposed to click?

[Former Member · Accepted solution]

Hi Heng,

You can insert the same query (or any other queries) on other sheets in the workbook. So if your client wants Dept A on Sheet 1 and Dept B on Sheet 2 and Dept 3 on Sheet it can be done. Insert your query three times on Sheets 1,2 & 3. Make the appropriate selections from the free characteristics area to select Dept A on Sheet 1, Dept B on Sheet 2 etc. etc.

Then make sure on the properties of your queries that you do NOT enable Return to Global Definition on Refresh, this will ensure that your departmental settings per sheet are maintained. Save your workbook then and that should sort the issue for you.

Regards

Gill

[Former Member · Accepted solution]

HI Gill,

That's what i did - manually add in 3 sheets, assign each sheet with the selection as needed.

My client claims that it is possible to make it "automated", without manually defining. Data will be seperated automatically based on one of the dimensional values as selected, on different worksheets in the same workbook.

[Former Member · Accepted solution]

Heng,

Bar using macros when your query has run to copy the data to other sheets I've never heard of such automatic feature in BW.

Regards

Gill