Skip to Content

Daily Level Planning in BPC 10

Hi Friends,

I have a requirement for Daily Level Planning in BPC 10. I thinkin to maintain the TIME dimension at Daily level which rolls up to weekly and monthly.

And my another Idea is maintain two dimensions such as "Daily" and 'TIME".

Could you please suggest which is better way to do? and Have anybody perform Daily Level Planning in BPC?

What are the things need to consider?

Thank you in Advance Friends!


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Aug 20, 2015 at 03:13 AM

    Hi Kumar

    Is planning going to happen daily or at the day level? I have understood your requirement as the latter one.

    It is better to have a single dimension with time hierarchy for easier reporting. The data volume would be huge when planning at day level and you must really be specific when creating input forms to restrict output data set as much as possible.

    You should also check on versioning of daily plan if it is required in BPC. If you have to version, better keep a separate model for that and limit it to latest 5-6 plans. Other plans can be backed up in BW. I hope you are having BPC on HANA for better performance.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Karsten

      I agree to your comments regarding design. Everything eventually boils down to the way design has been done. However, I would not rule out the possibility of versioning daily snapshots till the final requirement says so. That is always a consideration. The original post did ask for things to consider.

  • Posted on Aug 27, 2015 at 04:43 AM

    Hi Gajendra and Karsten,

    Thank you for replied and your Answers really are great and very helpful.

    Thank you so much.


    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.