SAP HANA Cloud Integration SAP : Part -01

What Is SAP HANA Cloud Integration?

CPI-DS is a cloud-based data integration tool for batch & scheduled data integration between on-premise applications and the SAP cloud platform. If you all aware about ETL tools such as SAP BODS, MS SSIS, CPI-DS is also ETL tool which operates on Cloud with limited Functionality.

If you aware about SAP IBP, IBP is the one that we are using mostly SAP CPI-DS. IBP runs on Separate server and it needs data to be pumped periodically from SAP ERP or LOB systems.


I will give you a brief introduction about CPI-DS interface

1.      Once you registered with SAP for CPI-DS, you will receive an activation email. You need to activate your account and once get activated you can see the screen as follows

Organization name is very important. So, make sure to put your Organization Name as it is mandatory.

2.      Once you log in, following is the screen that you are going to see

3.     You can see overall states of the interfaces with DashBoard

4.     One of the important configurations is DataStores.  Here you can define source systems and target system that you are planning to define as source and target for your Interface

1     Once all are in place, you can start creating your first Dataflow.

We will discuss more about Dataflows and its operation in next coming section.

Thanks

What is new in SAP Enhancement package 8

SAP ERP 6.0 Enhancement Package 8 is, after EhP7, the next Enhancement Package following the concept of quarterly shipments. This Enhancement Package delivers innovations to our installed base ERP customers and can support them as a foundation for their conversion to S/4HANA.


Please Check this Link

Prune Data in Union Nodes in SAP HANA

      Pruning data in union view nodes help optimize the query execution. You create a pruning configuration table, which specifies the filter conditions to limit the result set, and prune data using this table.

      For pruning data in union view nodes, create a pruning configuration table that the tool must refer to, and define this table in the view properties

• Create configuration table as follows in HANA data base

CREATE COLUMN TABLE "HANADEV"."PRUNE_UNION" (

     "SCHEMA" NVARCHAR(100),

              "CALC_SCENARIO" NVARCHAR(100), 

"INPUT" NVARCHAR(10),

   "COLUMN" NVARCHAR(20),

"OPTION" NVARCHAR(10),

"LOW_VALUE" NVARCHAR(20),

     "HIGH_VALUE" NVARCHAR(20) ) 

• create calculation view  with union node as follows
  

• once created it, set created configuration table to hana calculation view. set Pruning Configuration table  as "HANADEV"."PRUNE_UNION"

• now run Plan Viz 

here you can see,  only,  the relevant  record has been fetched from relevent Node 

Code Blocks Not Allowed in SharePoint 2010

Recently been doing some quick prototyping some web-parts, regular aspx, and master pages in sharepoint and just been using inline code blocks. then i got an error message as follows

 

"An error occurred during the processing of /_Path. Code blocks are not allowed in this file."

 

In order to work around this I had to edit the web.config  as follows.

 

<SharePoint>

  <SafeMode MaxControls="200" CallStack="false" DirectFileDependencies="10" TotalFileDependencies="50" AllowPageLevelTrace="false">

   <PageParserPaths>

 

  <PageParserPath VirtualPath="~/pages/*" CompilationMode="Always" AllowServerSideScript="true" />

    </PageParserPaths>

  </SafeMode>

 

 

 

Error on web service

have you encounterd  an error as "The test form is only available for requests from the local machine"  on  web your services.

 

If so, simply open the web config file and add the following, you will be able to access the test form outside of the localhost:

<configuration>
    <system.web>
    <webServices>
        <protocols>
            <add name="HttpGet"/>
            <add name="HttpPost"/>
        </protocols>
    </webServices>
    </system.web>
</configuration>
that's it!!!! ;-)

 

 

Configuring Excel Services in SharePoint 2010

visit : http://mssharepointtips.com/tip.asp?id=1041 to see confiuration of  Ecxell services

Deleting Duplicates comparing columns in SQL Server

Hi,
    Today let's see how to remove Duplicates row comparing Particular Columns. Following would be the SQL code that facilitates you to get job done.

  SELECT *

   FROM (

         SELECT col 1, "Your Coloum 1
                col 2, "Your Coloum 1
                col 3, "Your Coloum 1
                col 4, "Your Coloum 1
                col n, "Your Coloum n
               ROW_NUMBER() OVER
                               (
                               PARTITION BY [col 1(colum 1 that you need to delete duplicates )],
                                                        [col 2(colum 3 that you need to delete duplicates )],
                                                        [col n(colum n that you need to delete duplicates )],
                                      ORDER BY [col 1],[ col 2] DESC  or ASCS) AS RowCountNo
                                          FROM [dbo].[Table]
               ) AS X
         WHERE RowCountNo = 1

Thats all lol... :-)