Modifications in report.

[Former Member]

Hi mates,

I want to modify existing report , which is there in <b>production</b> and <b>dev</b> system. Could you tell me in which system( pro or dev) it is better to change the report, why?

Regards.

hari

[Former Member · Accepted solution]

Hi,

This is really make more problems in future not only technical wise, business wise also.

Assume this situation:

Today your touching the query in production for small change. All will work fine. User also will accept. In future, user will come to you for changing small thing in info provider itself like query change.

Then that time you dont have any way to go with dev to QA and prod for change. Coz already u did some change in production directly. User dont know whether you are doing the change in query or Info Provider. This will create more risk coz it may delete the data in production system. So hole business may be collapsed.

They will not accept the risk. Coz they dont know about landscapes. They know only small change and big change. So dont change users mind. Maintain the sequence.

As a BW Consultant, we only know the risk. So there is only one way for doing change that Dev to QA and the Prod.

Regards,

Vivek V

[Former Member]

Hi Hari,

You've got very good suggestions on why it's very important to make changes to any object in Dev and then move it to QA and Prod. I'd also like to add another reason of why this rule should be followed - for SOX (Sarbanes Oxley) purposes and if there are any internal audits done on the practices follwed by the Software team, there'll be just too many red flags for you to go back and justify to the auditors why changes were done in prod rather than follow the norm. I always found myself in a similar situation with business users saying "oh we dont have time, why dont you do the changes in Prod" etc, but explaining them clearly the procedures and the risk associtaed with it, they eventually stopped asking me that question and plan ahead of time to request for any changes.

Best Wishes....

[Former Member]

the usual practice is to change in DEV and transport to PROD. even though u have the system open for developing queries for power users - or who ever

[Former Member]

Hi,

We need to follow some rules here. We do any modifications in DEV and do the testing in QA ,if we are getting required results in QA, then only we need to import into production.

With rgds,

Anil Kumar Sharma .P

[Former Member]

Hi Anil and voodi,

Thanks for your prompt reply.

Yes we all know any changes in existing objects we need to do changes in dev system and transport to pro system, but some times for small changes people ask me changes in production system. I hope that is time saving or is there any particular reason?

hari

[Former Member]

yeah that is to save time - avoid approval process etc ..... you can ask BASIS guys to open the system for queries .. then u can directly go and chnage the queries .. but make sure to maintain a consistency between all the landscapes ....

[Former Member]

Hi,

Ofcourse it may save your time now. But one day it will take double of this saved time,if you keep on going to modifications in Prod directly.

If you feel that it saves time, why we need a such landscape in which we have DEV,Qa and PROD.Why can not we have only onw PROD. It reduces the cost also.

It is 100% wrong to make changes in PROD. Assume we did some changes to Query in PROD directly. ans assume we did a little change in DEV and imported that change into PROD, then you will loose all changes that you did in the production directly.

So Remember that no body is exception to the principles and rules we decided.So for anybody's request of change we need to come DEV only.

With rgds,

Anil Kumar Sharma .P