Skip to Content

How to delete or add master data (Dimensions) from front end In Input template

Hi Experts,

I have requirement to delete or add new master data from input schedule. Is it possible is yes then how ?

for an example i am having in M_Store user define dimension i am having STORE1 , STORE2 ...STORE 20 .

Now user want to delete STORE2 or want to add new store STORE21 from input schedule and after deletion he want to only remove that STORE2 but not history like for budget 2016 he used that STORE2 to enter values and if we remove data from calculation on that case the budget 2016 will display a wrong budget so in my requirement user can see history also .

Thanks

Ravi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 04, 2016 at 01:53 PM

    Sorry, but you are explaining the strange scenario! We are using BPC, not Excel :)

    You need a very serious reason to delete master data - transactional data has to be deleted before deleting master data.

    In some cases you can use Time Dependent Hierarchy to move base members between parents.

    P.S. You have a lot of unclosed questions with answers. Please accept the correct answers and close questions!

    P.P.S. AND PLEASE! Use correct tag: SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim,

      Thanks for reply i will take about the points which you have mentioned.

      What is this Time Dependent Hierarchy to move base members between parents ?

      Is it possible that if Store 1 is having a period to active for next 5 year and after 5 year transaction data will be there but while selecting the master data Store 1 will be not get appear ?

      I want to hide it on according to time basis is it possible ?

      Please explain ..

  • Dec 04, 2016 at 02:08 PM

    If you want to add master data in Excel you will have to implement badi: https://archive.sap.com/documents/docs/DOC-4276

    And then you can use VBA to pass data to DM with badi: http://go.sap.com/documents/2015/07/f8fac683-547c-0010-82c7-eda71af511fa.html

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2016 at 09:24 AM

    "What is this Time Dependent Hierarchy to move base members between parents ?" - please read BPC documentation and search yourself!

    "Is it possible that if Store 1 is having a period to active for next 5 year and after 5 year transaction data will be there but while selecting the master data Store 1 will be not get appear ?

    I want to hide it on according to time basis is it possible ?"

    This is NOT possible!

    You can only move it to another parent like NOTUSED.

    Add comment
    10|10000 characters needed characters exceeded

    • You have closed the question with the reason: The question is answered, right answer was accepted

      Strange!

      You will not wind a better answer anyway...

      Looks like you need to read BPC documentation and then explain the customer that it's not possible to do what he wants.