Skip to Content
K D

Free characteristics in Webi? & variable screen from bex to webi

Hello,

Where would you add the free characteristics while designing the webi query? Is there such a concept as free char in webi, free char has been great help for our end users.

Also when you are creating universe on a bex query, would all the variables that you have created in variable screen come over as pre defined filters in Webi? Like if you have variable for a single mandatory fiscal year or Selection option variable for Funds Center how would these come over in webi?

Please let me know. Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2011 at 10:42 AM

    Hi,

    the basis concept of free characteristics in webi can be found from XI SP3 on, with a feature called "query stripping". Having that enabled, will only send the needed dimensions to the backend, as opposed to all dimensions in the webi query.

    You add the "free characteristic" to the webi query then.

    All BEx variables will transform into the BO counterparts, e.g. in BEx a single mandatory variable on fiscal year, will become a single mandatory prompt in webi. Here some interesting links for you:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e058e44e-9497-2b10-f9b8-aab169b017a2

    http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/008d15dc-f76c-2b10-968a-fafe5a121129

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Victor,

      Need clarification on Query stripping. How it works. Correct me if my understanding is wrong..

      We are dragging 5dim obj and 2measure obj to Result Objs pane.On execution, BO requests data(from BW) for those 5dim and 2measure obj and displays the report and stored in microcube cache. Now the property 'Query Stripping' is enabled and the user removes one of the column(dim obj) from the report. So on refresh, BO requests data from cache only for 4dim obj and 2measure obj eventhough microcube has 5dim,2measure obj..Is this correct? Is this how the performance improves bcos of Stripping property?...So Does it mean Query stripping helps only in these scenarios...?

      Pls clarify i could not fully grasp how the system improves the performace bcos of Query Stripping property and its working nature.

      Many thanks in advance.

      Regards,

      Kesavan.

  • author's profile photo Former Member
    Former Member
    Posted on Mar 22, 2011 at 12:14 PM

    Hi,

    It may be helpful to you:

    http://wiki.sdn.sap.com/wiki/display/BOBJ/OptimizequerywithQueryStrippinginWeb+Intelligence

    All the Best,

    Madhu...

    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.