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

More lines in plan query

Hi experts;

By default, my plan query only have one line to add new records.

How can I have more lines?

Thanks in advance.

Ricardo

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:23 PM

    HI Ricardo,

    Please check on the properties of the characteristics used in the query -> go to Advanced Tab and ensure Access Type for Result Values is set to master Data and also Query Execution for Filter Value Selection is also set to Values in Master Data Table .

    If this is not set more lines will not appear on the query level.

    Hope this helps

    Raja

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 06:48 PM

    Hi Raja;

    The question is that mark those options i'll have all the possible master data combinations in my layout. So, the layouts take a long time to open.

    I only want to have, for example, 20 lines were i can input new records, like in bps layouts.

    Is this possible?

    Best regards;

    Ricardo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 07:35 PM

    Hi Raja;

    I see your point of view. But there are a lot of combinations of marter data and the customer don't want to filter (variable use) in the layout.

    In bps, I run this the program UPP_SET_DEFAULT_DUMMIES to add more planning lines. By this way, the customers make simple copy-> paste from their files to the system (not carrying about the order).

    In IP there isn't any thing similar?

    Thanks in advance.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 10:18 AM

    Hi,

    There are two cases - one while running plan query in web and one in excel.

    In case of web, you use an analysis item to display the plan query. In the properties of the analysis item, you can set the number of blank lines that you want to see.

    In case of excel, only one line will appear. When you enter data in this line and save, it moves up and a fresh input line appears. In case you want to enter more lines, you can just enter them one below the other starting from the balnk line and planning will pick them up.

    Hope this helps.

    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.