workbooks,queries,reports

[Former Member]

hello guys

I am reading SAP material about Reporting.....

in which realtime situations,do we use workbooks.....?

Can anyone give example of somequeries and workbooks together...?

thank you....

BR,

BI U

[Former Member · Accepted solution]

Hi

Workbooks contain the Formatted Query Outputs, they contain Active Link for the Queries that are embedded into them. Through this Active Link it traces all the Technical changes made to the queries when we refresh the work book it gives the Output of changes done with Query.

In real time the User Roles are assigned with the Work books with the relevant queries, to make sure that we are restricting the Data set which is not supposed to be available for the Unauthorized Users. Most probably the Financial Queries will be Restricted with Roles by giving them Work books with required set of result output.

help.sap.com would be the best source to see the work books.

http://help.sap.com/saphelp_nw70/helpdata/EN/2d/955a73da4d6d41a0a6128caf274ce8/frameset.htm

Hope it helps

[Former Member]

HI,

Queries are the technical definition that you create using chars and KFs based off an InfoProvider. When this query is executed, it is embedded into a workbook.

The workbooks can be saved on the BW server and they contain an active link to the query that allows you to refresh them and navigate throught them.

You can insert more than one query in a workbook and apply special formatting too.

look into this....

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

Thanks/Tarak

[former_member205352]

Workbooks are just formatted versions of your queries.

As addition you can do references,include graphs,do VB coding etc in workbooks.

For eg : Try installing some BI contents of workbooks and queries.