Planning Object Structure and Navigational Attribute

[Former Member]

Dear ALL,

I have Planning Object Structure which is active and there is already a Custom Characteristic (ZLOC) created with lot of data in it. There are already 3 navigational attributes attached to this characteristic (ZLOC). I would like to add 2 new (ZMOD and ZPROD) Navigational attributes to ZLOC. Both ZMOD and ZPROD are existing infoobjects

1. ZPROD does not have any master data

2. ZMOD does have master data

As I understand you can add Nav Attribute to ZLOC. But my question is do we have to do any thing to Planning Object Structure ?

Secondly if we add new nav attribute in RSA1 in BW how will it flow to APO DP ?

Please help since I am new.

Thank you very much.

Regards

Sanjiv

[kenneth_snyder · Accepted solution]

you sure these links to help.sap.com work?

I have access to help.sap.com but the links never work.

Ken Snyder

[Former Member · Accepted solution]

Let me give you the path, on how to access the matter.

Demand Planning --> Demand Planning Process --> Extracting Data from Planning Area .

Hope this helps.

Regards,

Suresh Garg

[Former Member · Accepted solution]

try with https in these links instead of http it might work

[Former Member · Accepted solution]

I am so happy that everybody is helping me out in this difficult situation. Thank you everybody and for quick replies. I wish I can give more points to everybody.Thank you so much.

I am trying to understand all this. I shall consolidate and try these.

I wanted to confirm my understand that, while adding existing infoobject as a navigational attribute two areas needs to be taken care

1. CVC

2. Live Cache : Time series --- which if required can be taken as a back up and then loaded

Please correct me if I am wrong.

Regards

Sanjiv

[Former Member · Accepted solution]

All you need to do is Go to masterdata for the Characterisitic in the POS and add the new navigational Attribute in it and maintain the values

Then you reactivate (without deinitializing the MPOS) as mentioned in the link for realignment

You should be able to see the new CVCs

If you understand the way NAv attribs work...

You have a table 1 for CVCs with say Char Fields A and B

and you have another navigational table2 with Char A as the Key and chars C and D

When you display CVCs you pull data from table 1 and the join with table 2

So you have char values of A, B, C and D populated - except that C and D are there on account of their relation with A

this is in contrast to creating a CVC with values for A,B C and D independently

if you search in https://service.sap.com/notes for notes on Navigational Attributes you will find a couple of notes with some more explanation

[Former Member · Accepted solution]

Experts/Friends,

Thank you once again. Let me try this and get back to you all. I am keeping this thread open if needed.

Regards

Sanjiv

[Former Member · Accepted solution]

Dear ALL/Visu/Harish,

As per your advise I have added (ZPROD) navigational attribute to my Custom Characteristic (ZLOC). I have not reached to apply hierarchy change.

The version of ZLOC custom characteristic (infoobject) is in revised status.

1. Should I activate ZLOC (custom characteristic - infoobject) ?

2. I also went to Infoobjects and went to "Apply Hierarch/Attribute chane". It went to another screen in which I selected the button "With Selected Info Object" and clicked on Display/Change InfoObject List to select my info object ZLOC. But I do not see any info objects in the pop up to select and execute the change ? Please advise.

Please help since I am stuck at this stage.

Thank you once again for all the help.

Regards

Sanjiv

[Former Member · Accepted solution]

Dear ALL,

Any update on my 2 questions ?

Regards

Sanjiv

[Former Member · Accepted solution]

Hi Sanjiv.

You are now in a position to activate the new version of the custom characteristic, then re-activate (without de-acvtivating) the MPOS.

After this, the navigational attributes should be available to use as normal.

Don't worry about the hierarchical change transaction as you didn't change any of the existing value assignments for the attributes.

rgds, M

[Former Member · Accepted solution]

Thank you everybody. The problem is solved.

Regards

Sanjiv

[Former Member]

Hello Sanjiv -

The Navigational Attributes come attached to the characteristics that you choose. To add the characteristics you have to deinitialize the planning object structure. so before you deinitialize the planning object structure you need to take a back up of the data associated with the same. after that initialize the planning object structure. there is no other way as far as my knowledge goes.

The data will flow accordingly to the characteristics that you have selected. Navigational attributes are just for slicing and dicing (view purpose only). so it will not affect anything.

Hope this helps.

Regards,

Suresh Garg

[Former Member]

Suresh,

Thank you for your reply. Clarifiying to my question, ZLOC (Infoobject/Custom characteristic) is already added and also has 3 navigational attribute attached to it. All I want is to add 4 th and 5 th navigational attribute to ZLOC. So this (4 th and 5 th) would be additional attribute to the existing 3 navigational attribute to the main infoobject/custom characteristic ZLOC.

Hope I am clear and get some easy solution other than deinitializing the planning object structure.

Thank you in advance.

Regards

Sanjiv

[Former Member]

Hello Sanjiv -

You have to de-initialize the POS before you can add new navigational attributes thats the only way that you can work (Gurus correct me if i am wrong). You have to take backup of your planning area as i have already stated in my previous post.

This is because you are adding new attributes and they need to be covered in your planning area and planning book. and if you dont have the required data then there is no use planning.

Hope i am able to clear the doubts that you have.

Regards,

Suresh Garg

[Former Member]

Hello Suresh/All,

Thank you for the reply. Sorry for replying late but..

My further question is what are the steps involved in back up of the master data. How do I do it ?

Thank you once again. Please reply.

Regards

Sanjiv

[srinivas_krishnamoorthy]

May be I misunderstood, you are talking about the backup of CVC combinations ? Well when you back up DP planning area into the infocube, you can always reload all CVC combinations from backup infocube. Let me know if you were looking for something else.

[Former Member]

Thank you. My question is,

1. Yes CVC. Is there any other way of taking back up of the CVC ? How do I create backup infocube ?

2. What about Time series data ?

Regards

Sanjiv

[Former Member]

Hello Sanjiv -

here is a link that will clear your doubts in regards to create backup infocubes and time series data.

http://help.sap.com/saphelp_scm50/helpdata/en/8f/9d6937089c2556e10000009b38f889/frameset.htm

hope this helps.

Regards,

Suresh Garg

[Former Member]

Hi

i dont think you need to do any deactivation of the POS to add nav attributes

Navigational attribute being an independent table attached to the infoobject can be changed and maintained independent of the main MPOS

You go to mainatain Masterdata in RSD1 for the the infoobject and add the new navigational attribute

ONce you have maintained the Attribute values you just need to reactivate the MPOS (without deactivating it) and you should be able to get the new set of navigational attributes and the values...

i suggest you try this with some dummy characterisitics before you do this on the one you are going to work on...

In case it does not work and you have to reactivate the MPOS completely then

you just regenerate the CVCs from the info provider you used previously since your main characteristics are going to be the same.

If you still want upload CVC from the previous MPOS, using /SAPAPO/MC62 , you can download into a worksheet from the display option and upload it back using the create option

take a look at this link for adding a new characterisitic- this involves backing up a planning area

[Former Member]

couple of help links that could be useful

http://help.sap.com/saphelp_scm50/helpdata/en/53/963f58d62c4537af344b10b54c2056/content.htm

http://help.sap.com/saphelp_scm50/helpdata/en/58/2b8e39e1ba3541e10000000a11402f/content.htm

[Former Member]

Hi Suresh,

I am not quite sure if it's true about your statement "You have to de-initialize the POS before you can add new navigational attributes thats the only way that you can work". Becasue you donot add navigational attributes to planning object structures. All you generally do is to add the master characteristic that has all those attributes. the attributes automatically appear depending on what they are, navigational or display.

To my knowledge, what I would do is to add the navigational attributes to the infoobject in BW and apply the hierarchy attribute change. The navigational attributes are also not part of the CVCs.

Here is a link on how to do that <a href="http://help.sap.com/saphelp_scm50/helpdata/en/53/963f58d62c4537af344b10b54c2056/frameset.htm">realignment</a>

I believe what you said is correct if you are adding a new characteristic in the Planning Object Structure.

The best way is to try and see if it's working.

I request any one to please donot hesitate to contend or correct what I said above.