adding navigational attribute in Info Object.

[former_member195748]

My staging layer is as below.

Data source1-> DSO1

Data source2-> DSO1

Data Source 3->DSO1

From DSO1 : there are 3 Transformaitons.

DSO -> Info Object “ABC”

DSO1- > DSO2.

DSO1 -> DSO3.

That means. DSO1 , is supplying data to ABC info object and 2 more DSO's.

I need to Enhance Data Source 1, with Field “X”  add it in DSO and then add that field in Navigational attribute of IO “ABC.

I dont need this field “X” in DSO2 and DSO3.

Question :

1) I want to understand its effect on Transformations if I add field in DSO1.

Data source2-> DSO1

Data Source 3->DSO1.

DSO1- > DSO2.

DSO1 -> DSO3.

2) Will all these be inactive ( assuming yes, )

     a. Do I need to retransport all the transformations.

     b.And if Yes, I assume we need to transport DTP’s too.

3) Does adding of navigational attribute affect any other Cubes and DSO  or transformations ,containing the main Info Objects. "ABC"..

Note:  This new navigational attribute is not used in any of the old cubes. it wil be used in new design.

[RamanKorrapati · Accepted solution]

hI,

1. If add any field to DSO1, then incoming and outgoing transformations will go inactive.

2. a. Yes.

    b. Yes.

3. No, but info ABC object transformations may go inactive.

Thanks

[former_member195748]

Hi Rama,

Thanks for replying, But what if i dont transport the DTP, I think the DTP gets automatically activated when the process chain runs. Am i correct?

[RamanKorrapati]

No and never. your process chain will be failed and dtp will be inactive.

[Former Member]

Hi Rama,

The DTP gets automatically activated when PC runs,but some times i have seen them not getting activated and causing issues,Its better if you adjust Transformations to Transport DTP's as well.

Regards,

Kiran :KL

[RamanKorrapati]

Yes, always better to transport connected objects other wise we may face problem.

other wise better to infrom to bw prod team, so that they can recheck about effecting objects and will take proper actions. like activating objects thru standard programs. other wise loads will fail.

its quarter end coming, so careful with transports and effecting objects.