How SAP Data Services Works

[Former Member]

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

[Former Member · Accepted solution]

*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!!

[Former Member]

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

[former_member59816]

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.

[Former Member]

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

Thansks.

[gowdatimma_ramu]

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