Workbook

[former_member254367]

Hi, all,

How can I insert 2 or more query into one sheet or two sheet in Bex Analyzer?

Thanks.

[Former Member · Accepted solution]

Hi Kunlun,

7.x - Use 2 analysis grid. Select the analysis grid from the BEx design tool bar in the BEx analyzer.

Double click on th analysis grid and enter the data provider as the second query which you want to insert.

In 3.x Analyzer, you would have an option to insert query in the workbook in the BEx analyzer. Click on any celll in the new sheet and then use this command.

Once you have prepared the workbook, there is a save icon, which you can use to save the workbook.

Hope it helps,

Regards,

Sunmit.

[Former Member · Accepted solution]

Hey Sunmit,

can you send me some link or document on creating workbook on 7.x

thanks

leo

[Former Member]

We are facing the same limitation 50 chars (49+1 structure for KF's) looking for a similar solution ..

pls share any bright ideas..

Jagadish

[former_member254367]

Hi, all

I have a very large query, because BW limitation(only 50 characteristics) and the bisuness user need the exact format of this query, I have to split this query into two, and combine this two into one in workbook, can you help to tell me the steps? I'm using BI 7.0 and bex 7.0..

Thanks a lot.

[Former Member]

Hi Kunal,

In BW 3.x you need to goto bex tool bar of the sheet in which you want to insert the Query and click on tools button there you will find insert query option click on it and that will open query selection screen select the Query and save the workbook..

Gurus correct me if am wrong..

Thanks

Leo