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

Static reports / suppressed rows for missing data

I've the following problem: We are analysing planning data for customer/product relations on a monthly level.

For certain customer/product relations no planning data exists for some future month - especially if the product e.g. is planned quarterly.

For that case in the source data there is no record for the key month/customer/product -> as a result the period is dropped from the report.

What we want is a STATIC report that always shows e.g. 12 month - even if there is no data for this key combination.

I've tried a lot of combinations of structures, cells .... but the BEX Explorer always dropes months without planning data out of the report.

I would be very happy if someone can provide a solution for this problem.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 16, 2005 at 04:04 PM

    Have you also tried a 12 month structure...a structure with 12 selections where each one is restricted to one month/period? In this case, the empty month will not be removed from the report...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Stefan,

      "How To"-Guides provide Step-by-Step instructions to make your BW implementations quicker, cheaper, and easier.

      Each "How To"-Guide covers a specific functional area, with the overall goal to make the product simpler and easier to use.

      "How To"-Guides are prepared jointly by experienced SAP consultants and SAP development, and can be shared freely between customers, partners and SAP internals.

      take a look to www.service.sap.com/bw -> Services & Implementation -> HOW TO... Guides or in SAP BW InfoIndex...

      I don't understand if you still need this particular How-To doc or if you have already received it !

      ...and please remember to reward the answer that helped you !

      Bye,

      Roberto

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.