Creating workbook

[Former Member]

Hi

i am tring to create workbook in BI 7.0 version. I opened one report and saved as Workbook. Now when i tried to insert one more query in workbook, the previous query is not seen and the new query is executed.

My procedure

1. Exectued the query and saved as workbook

2. In excel sheet created a new worksheet and in that i executed a new query

3. The previous query is gone and new query is being displayed.

Is creating workbook is different in 7.0 compared to 3.x.,,if yes can anyone plz provide me the documentation on that...

Regards

Annie

[Former Member · Accepted solution]

Hi,

Try to include the new query in the new work sheet on the same work book.

Vivek

[Former Member · Accepted solution]

Hi,

I tried it and i could insert the query by creating the new data provider and giving the seperate query.It worked.

But the issue is i could not see header of the report or buttons like table, chart and filter. How do i incorporate those in the second query in the workbook.

it was very easy in earlier version but this version is a bit of pain not very straight forward.

Regards

annie

[Former Member · Accepted solution]

Hi,

Open the workbook and select Workbook Settings button from the Design Tool box,

In the general tab, select checkbox allow Refresh Function for Individual queries

for ur first question :

from the workbook settings , select Data Provider tab, Click on create dataprovider button to include different queries.

REDDY

[Former Member · Accepted solution]

Hi

Narendra: I tried your way, but still i couldnt get those buttons, header of the report.

And also

I tried to put the button the report, its says "couldnt access MS visual Basic". In sap help it say we need to make MS visual basic as a trusted.

We do this by tools> macros> trusted.

But in my excel there is no option of TOOLs. I am on MS excel 2007.

Regards

Annie

[Former Member · Accepted solution]

Hi Annie,

In MS Excel 2007, select Developer menu, and clcik on Macro Security, button.

In that set Macro setting to Enable All.

and check the checkbox, Trust Access to VBA Project.

Once this is done u can insert buttons onto worksheet.

To insert Query Description in the sheet , select the cell where u want to place,

Clcik on insert Text button,

right click on the Text button and select Properties option.

in the constants tab, select Display query description.

I don't have clue about including those chart and info buttons. If u findout the solution, plz let me know the same.

REDDY

[Former Member · Accepted solution]

Hi,

i couldnt find "Developer" Menu in xcel 2007...In menu bar there is not like that in my xcel.

I could see only

1. Home

2. Insert

3. Page layout

4. Formulas

5. Data

6. Review

7. View

8. Add-ins

Regards

Annie

[Former Member · Accepted solution]

Hi

Do v need to have VBA installed in our system to enable macro settings?

I dont have VBA currently in my system.

REgards

Annie

[Former Member · Accepted solution]

Hi,

VBA is default installation with Excel.

I don't have much idea about Excel 2007.

Try to search in customize toolbar.

REDDY

[Former Member · Accepted solution]

Have the same problem!

I cannot insert a new complete template like in BEx 3.5.

Instead, your create your page elements one by one, using the Design toolbar.

A lot of pain, agree with you!

I would like to discuss this with one the guys that developed the new tool!

[Former Member]

Annie,

Let me see If I can answer your Question.

In the 7.0 Analyzer every time you do an Open Query you are going to get a new Workbook.

The Steps you have taken is patially correct. The reason you see your 1st Query Disappear is that you have only 1 Data Provider Created in the Workbook. Try this and let us know if this works for you. Only draw back here is that on Second Sheet you have to Pretty much design your own Layout

1) Open Bex Analyzer

2) Open Query and Insert the First Query you want. This should create the Default Layout for you.

3) Insert New Worksheet.

4) Pick a Cell on this new Sheet.

5) From the Design Toolbar, Click on Analysis Grid. This will drop and Grid Item on the New Sheet.

6) Right Click on the Grid to Show Properties.

7) Add a New Data Provider and attach to your Second Query.

😎 Exit Design Mode.

You should now have a Workbook with 2 Sheets and 2 Different Queries. Like I mentioned before you will have to create rest of the template looking at the Items on Table Sheet if you want same look and feel on both sheets

Hope this helps.

Datta.

[former_member205352]

Also in the steps you mentioned :

The second step is wrong.You should not execute the query instead you need to tools--->insert the query.This was BW 3.5 method.Anywayz for BI 7.0 check the below thread.

/thread/346645 [original link is broken]

Hope this helps.