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

No Value in Bex-Workbook planning query IP BW 7.0

Hello Planning experts

I just like to confirm my understanding:

Even in case there are no planning data available a planning enabled query will still show editabel planning rows. Therefore it is not necessary to create as a workaround '0' values with a function.

Thanks and welcome every answer, which helps me to understand

Christian

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 09:29 AM

    Hi,

    It is not always that you get new input ready rows for a planning query; it depends on your query's design. As an example, if you have a time characteristic like 0calday above the keyfigures in columns, and no data present for the query to fetch, you wont get input ready rows.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      There are two ways in which you can create a query with 12 columns - one for each month.

      One is to create 12 individual restricted KFs - restricted by each month; this will work fine for you even if you dont have any data that the query can display when it is run. You will get blank rows to enter new combinations.

      The other way is to have just one KF in columns and put 0calmonth above it and restriction 0calmonth to 'jan-dec' in filter so that it leads to 12 columns being displayed. In this case, if there are some records already that the input query can display, then you will be okay (you can edit those rows being displayed and also enter fresh combinations in the input ready row below them). But if there is no data present, then the output will be the message saying 'no data found' and no input ready new row will appear.

      Hope I am more clear this time.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:54 AM

    hi

    Yes it will show editabel planning rows if u have configured ready query inpur or planning enabled

    srin

    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.