How can I insert Query in a Workbook

[Former Member]

Hi,

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

[Former Member]

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

Chetan

@CP..

[Former Member]

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.