Skip to Content
author's profile photo Former Member
Former Member

Workbook,Query,View

Hi,

Just want to know what is the main difference of saving a query in the BEx Analyzer as a workbook/query/view. Just getting little confused, if anyone could clear this with a simple explanation, would be very grateful.

Thanks in advance,

Anjali

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2004 at 10:02 PM

    Hi Anjali,

    The same query can be embedded in multiple workbooks. Or even, in the same workbook multiple times.

    For example, we have a certain workbook that every sales person uses. Each sales person has their own workbook. The workbook has filters for that sales person. Let's say we have 100 sales people. That means we have only 1 copy of each query, but there are 100 workbooks.

    Each workbook has 5 queries embedded in it. Really, this is only 2 queries ... one of them embedded 3 times, the other is embedded 2 times. The multiple copies of the same query is to show different views. We COULD have done this by saving different views, but we decided that for sales people, we preferred to give them the different views on different tabs in the workbook.

    So ... we have 2 queries, 100 workbooks, 500 views.

    I hope this helps.

    - Pete

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2004 at 10:04 PM

    Hi Anjali,

    Workbook is an Excelfile that can contain multiple Queries utilizing Excel funtions.

    Query is a "Collection of a selection of characteristics and key figures (InfoObjects) for the analysis of the data of an InfoProvider. A query always refers exactly to one InfoProvider, whereas you can define as many queries as you like for each InfoProvider"

    (quote SAP Help Glossary)

    View is a navigation state of a query.

    Hope that helped

    regards,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2004 at 10:26 PM

    Hello Pete & Michael,

    Thank you for the effort you guys took in explaining with an example which made things even more clear. I gave the respective points for your answers, thanks and goodluck.

    Anjali.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.