DSO Problem

[Former Member]

Hey BI Gurus..

I have created a DSO ..but I dont understand where do we select our datasource ...I mean how in BW 3.5 we used to select the infosource from Left window pane and all the char and key figs used to be in the ODS ....My question is where do we select the our Datasource for our DSO...

Please help

will assifgn points

[Former Member · Accepted solution]

I hope you have replicated datasource as 7.0 and not 3.x.

new NW2004s Data flow

R/3---->PSA only (using Infopackage) for all the Loads -Mandatory

PSA -

---

>ODS/Cube -->load using DTP ,create transformation first

no Datamart architecture in NW2004s

so ODS -

---

>Cube load using DTP ,creating transformation first

Once loaded to PSA in DTP you have the option of FULL or DELTA ,full loads all the data from PSA and DELTA loads only the last load of PSA.

Go through the links for Lucid explainations

Infopackage -

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/03808225cf5167e10000000a1553f6/content.htm

<b>DTP</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

Creating DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

<b>Pre-requisite-</b>

You have used transformations to define the data flow between the source and target object.

<b>Creating transformations-</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/f8/7913426e48db2ce10000000a1550b0/content.htm

<b>ODS to Cube -</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/dc87c1d711f846b34e0e42ede5ebb7/content.htm

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

hey chetan thanx buddy for your explanation

appreciate tht ...points assigned

[Former Member · Accepted solution]

Thanks Bro - Appreciate it

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Thanks Sam.

Hey chetan, I dont see you alot nowadays on SDN. Too busy with the project? Take some time out for SDN, we do need you too

[Former Member · Accepted solution]

Heah Sri, Thanks Bro , well lots of design complexities when it comes to Global BW implementations in Blue printing/requirement phase and meetings after meetings...

But I see you rocking ,so I kind a feel good and relaxed ..at times its good to be other side just watching Experts like you replying and Ravi as well,as am still Novice and Naive in this arena.

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

I know meetings suck. And on a personal note I wouldnt call you novice. You are too humble.

[Former Member · Accepted solution]

I candidly second your thought with meetings,just that top management,Principle/Partners and some managers from Deloitte knows me and my identity on SDN,just dont want to put it on records here

Chetan

@CP..

[Former Member]

right click - create transformations - source of transformation would be ur datasource. Ofcourse you need to have a 7.0 datasourceRSDS. If you have a 3.x DS, then there is nothing different to do than what we used to do in 3.5.

[Former Member]

thnx vooodi....buddy keep rocking on sdn

assigned points