Skip to Content

How to maintain Time dimension for Year Budget in sap bpc NW

Hi Experts,

I need a help on time dimension as my customer is doing a Year wise Budget and they are maintaining any record or the data month wise.

So in there present budget system they are doing yearly budget like below given image

Like in above report i have account dimension where i have maintained all expenses and income so this Travel Expanse and Man Power Expanse i will have it from Account dimension.

But in the time dimension how to have only year Like

FY 2016 Approved Budget - This is previous year Proposed budget by budget department (CFO)

FY 2017 Budget Request - This is present year budget request requesting by store and department

FY 2017 Budget Proposed - This will be the present year budget approved by budget department (CFO).

I have time dimension like below given ..

or i have to maintain a time dimension like below ..

But please make a note that my client is not using any where JAN feb March or quarterly calculation ..they only doing year wise display and insert values through input template so i think in time i have to maintain only year things but my question is how i can have ..

FY 2016 Approved Budget - This is previous year Proposed budget by budget department (CFO)

FY 2017 Budget Request - This is present year budget request requesting by store and department

FY 2017 Budget Proposed - This will be the present year budget approved by budget department (CFO).

from one time dimension and for next year it should change to

FY 2017 Approved Budget - This is previous year Proposed budget by budget department (CFO)

FY 2018 Budget Request - This is present year budget request requesting by store and department

FY 2018 Budget Proposed - This will be the present year budget approved by budget department (CFO).

Like that ..

I am working on SAP BPC 10.1 NW ..

Thanks in advance ,..

Ravi

10jan.png (17.1 kB)
10jan-2.png (9.5 kB)
capture3.jpg (142.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 10, 2017 at 10:05 AM

    Never use member id's with spaces inside: Not Approved Budget but APPROVED_BUDGET etc...

    Looks like you want to work simultaneously with 3 categories:

    APPROVED_BUDGET

    BUDGET_REQUEST

    BUDGET_PROPOSED

    No issues!

    You can also copy data between categories...

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 10, 2017 at 09:26 AM

    Sorry, but it's absolutely incorrect idea to use TIME dimension members for different budget versions. Use CATEGORY type dimension for this purpose!

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim,

      I think so ..But will you please help me on this and i am thinking to have in category dimension but how i will put below things in CATEGORY ..

      FY 2017 Approved Budget - This is previous year Proposed budget by budget department (CFO)

      FY 2018 Budget Request - This is present year budget request requesting by store and department

      FY 2018 Budget Proposed - This will be the present year budget approved by budget department (CFO).

      currently i am having CATEGORY DIMENSION AS below given ..

      So if please correct me if i want maintain

      FY 2017 Approved Budget - This is previous year Proposed budget by budget department (CFO)

      FY 2018 Budget Request - This is present year budget request requesting by store and department

      FY 2018 Budget Proposed - This will be the present year budget approved by budget department (CFO).

      into CATEGORY then my CATEGORY WILL BE(Please refer below screen) ..

      Please suggest ..

      Thanks in advance ..

      Ravi

      capture5.jpg (34.3 kB)
      capture6.jpg (46.9 kB)