2034349 - SAP HANA Business Layer Wizard Only Displays Local Connections

Symptom

• The New SAP HANA Business Layer wizard automatically create a single-source data foundation and business layer but only the local connections are available.
• when publishing a Hana Universe built with the wizard it says no secure connection
• Cannot publish hana business layer

Environment

• SAP BusinessObjects Business Intelligence platform 4.1 SP3
• Information Design Tool (IDT)

Reproducing the Issue

1. Create relational connection to HANA
2. Create a shortcut in the local project
3. Right Click the Project and select New Hana Business Layer
4. Enter the Business Layer name
5. The data Foundation is auto populated
6. The shortcut (.CNS) connection is not visible.
7. Create a local Connection (.CNX)
8. Repeat the above work flow. 
9. Select the .CNX connection.
10. Generate the Data foundation and Business Layer
11. Right Click on the Business Layer and publish to the Repository
12. Error message occurs

Cause

The New SAP HANA Business Layer wizard to automatically creates a single-source data foundation and business layer based on selected SAP HANA information models.  However, only local connections are visible.  This means that a universe can only be created or published locally.  the information is documented in the Information Design Tool Guide.

Resolution

1. In the local project area create a local connection (.CNX)
2. Publish the local connection to the repository.
3. Create the connection shortcut when prompted.
4. Create the universe using the new Hana Business Layer Wizard and Select the local Connection. (.CNX)
5. Open the Data Foundation
6. Change the connection to the shortcut connection .CNS
7. Save
8. Right Click on the Business Layer and publish the universe.

See Also

The Information Design Tool Guide Section 3.3.1 Creating relational resources on SAP Hana information models.
Here is a link to the online portal page,  please select appropriate version and guide.
http://help.sap.com/bobi/