Question Re: How SAP Data Services Works in Technology Q&A

How SAP Data Services Works

Former Member — Tue, 07 Sep 2010 07:17:28 GMT

Hi Experts,

I am working on SAP BI , some supporting activities are expecting to come on SAP Business Objects , support will be mainly on SAP Data services ( SDS ) , since I am new to BO and don't know what is SDS and how it works , what could be the support activity on SDS.

I searched a lot but couldn't get the clear picture. Kindly help me to understand.

I would also appreciate if someone can also explain how SAP BO report works with SAP BI.

Thanks ,

sukhi

Re: How SAP Data Services Works

former_member59816 — Tue, 07 Sep 2010 07:24:22 GMT

Hi,

You can follow the below user guide and the tutorial for more information on how Data services works:

http://help.sap.com/businessobject/product_guides/boexir32SP1/en/xi321_ds_designer_en.pdf

http://help.sap.com/businessobject/product_guides/boexir32SP2/en/xi321_ds_tutorial_en.pdf

And regarding the SAP BO working with BI, you can follow the different guides from the below BOE location:

http://www.sdn.sap.com/irj/boc

Regards,

Noor.

Re: How SAP Data Services Works

Former Member — Tue, 07 Sep 2010 11:28:46 GMT

Is there in any difference in SAP BusinessObjects DATA INTEGRATOR and SDS,

Thansks.

Re: How SAP Data Services Works

gowdatimma_ramu — Wed, 29 Sep 2010 13:41:50 GMT

Hi,

As per my understanding the SAP Data Services is a combined release of Data Integrator and Data Quality, so this includes some additional Data Quality Transformations.

Regards,

Ramu.

Edited by: Gowda Timma Ramu on Sep 29, 2010 7:20 PM

Edited by: Gowda Timma Ramu on Sep 29, 2010 7:38 PM

Re: How SAP Data Services Works

Former Member — Wed, 29 Sep 2010 14:14:54 GMT

*SAP BO reports on SAP BI:*

As we are creating OLAP cubes/Infocubes in SAP BI, same way BO has Universe.

Universe is based on direct Infocube/ Multiprovider/DSO(ods) and BEx query.

Universe Designer:

Only thing is one has to establish connection to access SAP BI system. To do this job, while choosing datasource, you have to select SAP Business Intelligence 3.x -- Client. And next screens it will prompt for User logon credentials to access SAP BI system. Once, connection is tested OK. Click next and it will list out all the OLAP Cubes available in SAP BI system and select the relavant one and click on next - next -- Finish.

Now you have created Universe on top of SAP BI system. Then Export the Universe to Server.

Open Infoview to start Web Intelligence report(s) and choose the Universe from the list of universes then it will take you to WebI Query panel , in that drag the Objects(Dimension/Detail/Measure) to result objects pane to see them in BO Report and to filter data use Query filters pane or do it in Report level.

Once you are in WebI report level , you will get lots of options to see your reports in different styles.

For better customizations: Use BEx queries based on Infocube. (In BEx query properties, one has to Check Allow OLAP access enabled)

BODI -->> BODS

After SAP aquiring BO and the latest version released with BODS(Data Services), It's basically ETL process, do the job same as what we exactly do to create Infocube. (Extraction of data , transformations and loading) and with additional transformations introduced.

Thank You!!

Re: How SAP Data Services Works

Former Member — Tue, 12 Oct 2010 15:37:42 GMT

Thanks everyone, this thread was posted on behalf on my colleque, This was very useful, thanks all once again.