Diffrance between saved views and workbooks

[Former Member]

Hello Friends,

Good Morning ..

Could any one please tell me what is the diff between saved view and Workbooks. .?

It will be nice help for me.

Thanks .

[Former Member · Accepted solution]

Hi Jain,

Do not know if your question is already answered. Let me give you my thoughts on this subject ... start with what is a query.

A query definition is saved on the server. Never anywhere else.

Although people say a workbook contains a query (or several queries); it does not. It contains a reference to a query. The workbook can be saved on the server; or anywhere else that you might save an Excel workbook.

What happens if someone changes the query definition on the server? Answer: the next time you refresh the query in the Excel workbook, the new query definition replaces the old query definition in the workbook. Maybe. It depends on what change was made.

For example, if someone added a Condition to the query definition, the workbook will be virtually invisible to this. The Condition is available; but, is not implemented in the workbook. (Until the user of the workbook manually adds the view of the Condition and then activates it.)

For example, if someone changed the definition of a KF in the query definition, the revised KF will show up in place of the old KF in the workbook.

But ... if, for example, someone deleted the old KF and added a new KF, we get a different story. Now the old KF no longer appears (it does not exist); but, the new KF does not appear (it was not marked to be visible in the workbook).

About workbooks as views ... OK, a workbook may very well have a certain "view" of the query (drilldown, filters, et cetera). And, if the workbook is saved to the server in a Role where everyone can access it, this is good. But, if the workbook is saved to one's favorites, then this "view" is only accessible to that individual. Which may be good. Or may not.

A "saved view", on the other hand is stored on the server. So, it is available to all.

If you navigate in a workbook you can back up. You can back up, though, only as far as you navigated in the current session. You cannot back up to where you were in the middle of last week's session. Unless you saved that navigation state as a "saved view". Then, you can jump to that view at any time.

The downside of saved views is that they are easy for anyone to set up and difficult for most to delete.

- Pete

[Former Member · Accepted solution]

This is an excellent descritpion, i have always enjoyed the depth of your explanations, By the way if possible can you please email me the documentation on VBA, I am getting some requests that will require me to use VBA with bex, my email, sap_bi@hotmail.com. Greatly appreciate your help.

[Former Member]

Hi Akshay,

We use workbooks for excel formating,like font changes, lay out changes etc...

Workbooks into which queries are inserted are no different in appearance than other Excel workbooks.

They can be saved as files, copied, sent and (using Excel functions) edited however you like and even supplemented with other data.

Views are primarily used for BW Web Reports, it is similar to the concept of workbooks is for BEx. A local view can be accessed only within a workbook in which it was saved, where as a global view can be accessed globally in the system, it is not attached to a workbook. Only Global view can be used in BW Web Templates.

check out these help docs....

http://help.sap.com/saphelp_nw04s/helpdata/en/0d/af12403dbedd5fe10000000a155106/content.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/3a/89883989676778e10000000a11402f/content.htm

[Former Member]

Hi Akshay,

Try this links .

http://help.sap.com/saphelp_nw04/helpdata/en/3a/89883989676778e10000000a11402f/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a555de09411d2acb90000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/f1/0a5550e09411d2acb90000e829fbfe/content.htm

Hope it helps,

Regards,

Parth.

[Former Member]

Hi!

Workbooks can contain 1 or more queries or views inside it, you can use additional functions like drilldowns, radio buttons, maps, pictures. Views on the other hand are generated from a query.

R,

Adwin

[Former Member]

Hi,

Views can be used in WAD as Data provider. So those workbooks saved as views are nothing but workbooks which can used in the web templates.

With rgds,

Anil Kumar Sharma .P