Showing results for 
Search instead for 
Did you mean: 

How can I insert Query in a Workbook

Former Member
0 Kudos


I am new in BI 7.0. I am trying to insert a query in a workbook. but the tools button is not giving me the option to insert query like 3.X

How can i insert query in 7.0

Can anybody please give me the step by step instruction.

Thanks in Advance

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

1. Open BEx ANalyzer.

2. Create new excel workbook by hitting the "New" icon in Excel.

3. Logon to a backend BI system.

4. Click the design mode icon.

5. Put your mouse on a cell and insert a table.

6. Assign a dataprovider to this table.

7. Switch off design mode.

Hope it Helps



Former Member
0 Kudos

Hi Sudheer,

In the workbook open a new sheet and go into design mode and drag and drop the analysis item(table), now you can assign the new query as data provider to this table.

Note: The new bex analyzer functionality is some what similar to WAD here you have flexibility of dragging and dropping objects just like in WAD.