How to create a synonym for an SAP BW - ODS object


Technique

Product: Reporting Server
Release: 8206
Primary OS: Windows
Solution Date:

Problem

How to create a synonym for an SAP BW - ODS object.

Solution

You cannot create a synonym directly against an ODS object.

A BW Query (BEx) needs to be created first.

It is under the BEx Query that you can list an ODS object, then a synonym is created against the BEx Query.