SAP BW - Change server in Query Editor

[BIfanatic]

Hi everyone,

When creating new reports we start on our SAP BW test server. However, when we want to move the report to production, we still experience difficulties with transferring the tables from test to SAP BW production. For instance, measure ID's different across servers and we have not found a good way yet to cope with this.

Does anyone have any tips or best practices?

[v-chuncz-msft · Accepted solution]

@BIfanatic,

Take a look at The Advanced Editor if available, otherwise, you might need to change your test server accordingly.

[BIfanatic]

So, changing the code in the editor is the easiest way to facilitate this?

[v-chuncz-msft]

@BIfanatic,

If a better way, I'm willing to learn.