DataSources in BI 7.0

[Former Member]

Hello All,

We are just beginning to implement a BI solution in our landscape and would like to know the following:

1) Which DataSource should we be using 3.x or 7.0? What are pros/cons of using one over the another?

2) I replicate 0PLANT_ATTR datasource and BI shows that as an Emulated 3.x datasource. Is that by default or is there some way I can replicate that as a 7.0 datasource (without having to migrate the replicated 3.x datasource in BI)? I read some posts where during replication you have an option of chosing 3.x or 7.0 replication but that option does not seem to show up in my case.

3) If I have to migrate the replicated ds, is there any downside to always migrating it "With Export"?

Thanks,

Asheesh

[Former Member · Accepted solution]

1) Which DataSource should we be using 3.x or 7.0? What are pros/cons of using one over the another?

https://forums.sdn.sap.com/click.jspa?searchID=6224486&messageID=1628297

Further insights

Always good to migrate with export option to revert back to old method

Migration FAQ's

https://www.sdn.sap.com/irj/sdn/developerareas/bi?rid=/library/uuid/7c2a7c65-0901-0010-5e8c-be0ad9c0...

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

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

DTP

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

Pre-requisite-

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

Creating transformations-

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

ODS to Cube -

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

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Thanks guys for the quick response. Your comments have been very helpful.

Thanks,

Asheesh

[Former Member · Accepted solution]

welcome & Good Luck

Hope it Helps

Chetan

@CP..