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

Restricting F4 help values to the values in InfoProvider

Hi,

I am using BW 3.5.

1. In my query I have restricted 5 characteristics with variables. The system prompts for values for these variables while running the query. In those variables F4 help I could see all the values from Master data. I would like to show only the data in the infoprovider in the F4 help. How can I do this in 3.5?

2. Can I publish a view to a Role?? or only Workbooks & queries can be published?

Thanks in advance. Answers will be rewarded with points.

Thanks,

RK

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Apr 08, 2008 at 06:26 AM

    Goto RSA1 and double click on your infoobject

    From the Business Explorer tab for the option Query Def. Filter Value Selection select Only values in Infoprovider.

    This should solve your first problem.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Can you elaborate your 2nd question?

      For the 1sy question can you also make this setting InfoProvider specific,

      If it is an ODS then double ODS, right click IO and select object specific properties

      OR

      For the cube double click the cube, from the menu select, extras -> structure specific properties

      OR

      In BI 7 this setting can be done directly in the query designer in the properties of the IO

      Edited by: sam hennry on Apr 8, 2008 11:12 AM

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 03:14 PM
    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.