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

Save Zero value using EVDRE input schedules


Requirement is to store a zero value against dimension members.

Is there any way of storing Zero value using EVDRE input templates?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Nov 10, 2009 at 07:40 AM

    When you are using input schedule actually into database you are sending the diference.

    For example

    if you have 10 into database for account1 and in your input schedule you want to have 0 for your account1.

    Actually into database it will be sent -10.

    If you don't have anything into datbase for account1 you can not send 0 from input schedule because the system can not send 0 to database.

    Design of BPC was not done to store 0 values into databse.

    More than that every time when you will du a full optimize 0 values will be deletedfrom fact table.

    To conclude this stage 0 values can not be stored into BPC fact table.

    Kind Regards

    Sorin Radulescu

    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.