Skip to Content
avatar image
Former Member

Workbooks.. PLz explain

Hi experts,

Can someone please explain me the concept of Workbook. As to how i can use this concept to displat two or more queries

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Oct 20, 2008 at 05:31 AM

    Hi,

    To create the workbook, execute teh query in excel, make any settings to the query properties if reqd (like adjust columns, refresh on open) and then save as a workbook.

    There is no real limit to the number of queries you can keep in one workbook, but you need at asses how many actually make sense to do that...generally we create one workbook for one query, but there are also cases where people have more, like 5 or 8 in different tabs of the workbook.

    A query is the technical definition of the report structure.Consider a workbook as an excel file in which one or more queries can be embedded. You can refresh the workbook after connecting to the BW system, and the query (ies) in it will be refreshed and will be populated with current data. The reason for creating workbooks is that using the same query, different report formats can be saved for future reuse. Also users can set up their own report formats and save as workbooks in their favourites.

    You can also see here for realted info about queries and workbooks:

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

    Regards

    Pcrao.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 05:32 AM

    HI,

    Work book is nothing but a excel work book where in you can populate query results in the seperate sheets.

    You can have each query in sheets. So you can have mulltiple queries to populate the query results in different sheets where in they are inserted.

    Regards,

    anil

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 05:34 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 05:37 AM

    A workbook can contain the results of one or more queries, the queries can appear on multiple worksheets or one a single worksheet.

    A workbook can be formatted to the user's requirements (logos, fonts, styles etc.) and can contain Excel native formatting and other Excel features such as pivot tables, filters.

    When a workbook is saved the current navigation state is also saved. This means that when the user reaches a useful navigation state they can choose to save the workbook so that next time the workbook opens at the same position. The user can also choose whether to refresh the data automatically when the workbook next opens or to open the workbook with the old (frozen) data first, the user cold then choose to manually refresh the data.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 20, 2008 at 07:05 AM

    Hi Manpreet,

    Workbooks are nothing but the statical view of query results, which is been displayed using MS-excel.

    you can include multiple query results according to your requirement. using the toolbar of Bex Analyzer you can include Radio buttons, labels, Charts etc. all the elements are user friendly. you just have to drag-drop these elements.

    Regards

    Vivek Tripathi.

    Add comment
    10|10000 characters needed characters exceeded