Learn about Attribute View in SAP HANA

This page explains, in simple terms, what a Attribute view is in SAP HANA

http://saperrors.com/2012/06/12/attribute-view-at-a-glance/

Data Replication into SAP HANA

The below are the resources I studied which are discussing Data Replication in SAP HANA.

http://sapignite.com/replication-techniques-for-sap-hana/

https://www.experiencesaphana.com/videos/1084

http://www.dwbiconcepts.com/database/28-hana/129-sap-hana-appliance.html

http://noreports.com/sap-hana-replication-and-slt-sap-landscape-transformation-replication/

http://saperrors.com/2012/06/06/loading-data-from-flat-file-into-sap-hana-db-the-ever-simplest-way-with-sps04/

Create a Local Repository for BO Data Services

The below pics show the activity that happens when you create a Local repository for BO Data Services 4.1

Troubleshoot SAP BODS Installation Errors

When we started installing SAP BODS client on our local systems to be connected to the SAP BODS server on a remote server, we faced a lot of errors, which we solved one by one.

First and foremost, the user account using which SAP BODS client is being installed should have administrator privileges. 

Also check out the supported environments before proceeding with installation.

The below error indicates that either the system name, port number, user name or password is wrongly typed!! It is obvious from the error message itself

The below error is a bit tricky to understand as it says something and the fix for it is something else altogether!! It says something failing at the SQL server side but it is not the exact issue here.

To fix this, you have to update 'hosts' file in your Windows PC. It normally can be found in C:\WINDOWS\system32\drivers\etc. Edit it in Notepad and add an entry at the end of the file. Example is give below. First part is the IP address of the BODS Server and second part is the fully qualified name of BODS Server

XXX.YYY.ZZZ.WWW       BODS-SERVER-NAME

Will get back with solution.

We upgraded from Win XP to Win 7 to fix this.

Installed MS Office 2010 on the server to fix this.

The Repository is upgraded to fix this issue.

Install SAP BusinessObjects Data Services 4.0 SP1

To learn SAP BO Data Services, don't we need to software installed first??? So lets install BODS.

1. Navigate and find the setup.exe file and run/double-click it to begin installer

2. Installer begins

3. Choose  the language

4. Make sure you have admin rights/access on the machine before starting installation, else, the 'Administrative Privileges' component will fail.

5. Installer continues

6. At the end of installation, the software requires a system restart, so better close all applications now itself

7. Accept the EULA

8. Type in the Keycode

9. Choose a location to install SAP BODS

10. Choose a language pack

11. Select the required features

12. If this is standalone installation, skip the configuration part, else browser/select  the location of DSConfig file

13. Installer ready to install SAP BusinessObjects Data Services 4.0 SP1

14. Installer continues

15. Installer continues

16. Installer continues

17. Installer continues

18. Installer continues

19. Installer finishes installing SAP BusinessObjects Data Services 4.0 SP1

 20. Restart the machine

We will look at configuring this with IPS some other day... :-)