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

Pl let me know in which suitaition the Zero values used in DP book

Hi All,

Pl let me know in which situation/Scenarios the Zero values used
instead of Null/Blank in DP Planning book,

Regards

kkk

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 11, 2012 at 05:18 AM

    Only if you set "zero Allowed" for the key figure in the Planning book.

    What then this means is 0 and Blank are treated diffently during disaggregation.

    A change at higher level (e.g. Product) may apportion something to an erstwhile "blank" key figure at some level of disaggregation (e.g. when you select Product x Customer) , particularly if there was no data originally recorded/calculated at that level (of Product x Customer). But if "0 allowed" is checked in the planning area and YOU set a value of 0 at this selection level in some cell(s) of this key figure, then this value will always remain zero at that level (Product x Customer) and all granular levels below it (e.g.Product x Customer x Customer's uncle) even after a subsequent change at another (higher) level (e.g. Product or Product Family or Brand or some grouping higher than that).

    Hope this is easy for you to visualize now.

    Thanks

    Guru

    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.