data modeling

[Former Member]

Hi Gurus

would any body pl update my knowledge by clearing the following doubts?

1. what are plug ins and how they are useful?

2.what are infospoke?

3.what are the uses of different data type in Info object chracteristics?

4.use of aggregation tab given in key figure .

5.If i have to create sales revenue in report shall I go with calculated key fig or shall i give ABAP routine in transfer rule ? How will it impact the system loading and query performnance?

Thanks In advance.

[edwin_harpino · Accepted solution]

dear Ketul,

1.

what is plug in ?

http://help.sap.com/saphelp_glossary/en/67/1397422363d411ae7500a0c9ead00f/content.htm

http://help.sap.com/saphelp_glossary/en/e4/19dc37cda3d3118f360060b03ca38c/content.htm

Additional program which enhances the functionality of an existing program. Additional functions which may not be needed or are mutually exclusive are often implemented as plug-ins

The interface between mySAP.com components (for example, SAP APO, SAP BBP, SAP BW, SAP CRM) and one or more SAP R/3 systems.

The SAP R/3 Plug-In unites the plug-ins APO-CIF, CRM-R3A, BW-BCT and B2B-PRO-PI. This simplifies maintenance significantly and guarantees compatibility between the individual mySAP.com components. With SAP R/3 Plug-In, you can use several mySAP.com components simultaneously in a single system. SAP R/3 Plug-In supplies the mySAP.com component transaction data and master data in real time.

Technically, there are two versions of each release of the SAP R/3 Plug-In, a PI version and a PI-A version.

The technical names of the software components are PI and PI_A

how they are useful in bw ?

http://help.sap.com/saphelp_nw2004s/helpdata/en/28/4c553c42360a40e10000000a114084/frameset.htm

PlugIn for SAP Systems

BI-specific source system functions, extractors and DataSources are delivered for specific SAP systems by plug-ins.

Communication between the SAP source system and BI is only possible if the appropriate plug-in is installed in the source system.

service.sap.com/bi

->bi extractor plug in

2. infospoke

infospoke is used to export data from bw

http://help.sap.com/saphelp_nw2004s/helpdata/en/1e/c4463c6796e61ce10000000a114084/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/66/76473c3502e640e10000000a114084/frameset.htm

3. uses of different data type in infoobject characteristics

http://help.sap.com/saphelp_bw33/helpdata/en/b7/f470375fbf307ee10000009b38f8cf/frameset.htm

Char: Numbers and letters Character length 1 - 60

Numc: Numbers only Character length 1 - 60

Dats: Date Character length 8

Tims: Time Character length 6

4. aggregation tab in key figure

http://help.sap.com/saphelp_bw33/helpdata/en/82/f2dc37f0f12313e10000009b38f8cf/frameset.htm

5. i think the question may not exactly 'create sales revenue', but perhaps if you need to calculate e.g a keyfigure where come from other keyfigures, you can go with both ways, with advantage and disavantage, in terms of query performance, give abap routine in transfer rules may better since the calculation done before query execution, where calculated key figure (or virtual key figure) may take more query execution time since it's calculation 'on the fly'. but if this keyfigure not exist, using abap routine in transfer rules, you need to add the keyfigure and re-load data.

hope this clear some of your doubts

[Former Member · Accepted solution]

Thanks to both AHP and Sahid

My basic point for the last question is if we add it in transfer rules by ABAP programme then all the time we have to fill one additional row/column for that revenue key fig during data loading so will it impact the data loading performance?

I also believe we should do this but which time we can save more , Query run time or data loading time ? how?

[edwin_harpino · Accepted solution]

dear Ketul,

yes, this would impact to performance loading,

for simple calculation (e.g no function module needed, read table), we can do it in query level, the query performance would significantly impacted.

yes, we have to keep balance of query and loading performance.

hope this helps.

[Former Member · Accepted solution]

Thanks AHP

You are great...Guru

[Former Member · Accepted solution]

Assiged points AHP

[edwin_harpino · Accepted solution]

dear Ketul,

you are welcome

• hope not forget to assign Shahid points also, you said thanks, means his answer helps

[Former Member · Accepted solution]

Yes AHP

I have assigned points to both of you.

[Former Member]

PLUG INS ARE USED IN SAP IN ORDER TO PROVIDE COMMUNICATION BETWEEEN SAP SYSTEMS AND THE BW SYSTEMS. AFTER THE INSTALLATION OF R/3 SOFTWARE WE HAVE INSTALL PLUG INS IN THE SOURCE SYSTEMS. THEY HELP THE SYSTEMS TO COMMUNICATE.

INFOSPOKE IS AN OBJECT WHICH IS USED IN OPEN HUB SERVICE.

THROUGH INFOSPOKE DATA IS IMPORTED TO FLAT FILES, DATA BASE TABLES, BW SYSTEMS, EXTERNAL SYSTEMS. OPEN HUB SERVICE ALLOWS DISTRIBUTION OF DATA FROM DATA TARGETS IN BW SYSTEM TO FLAT FILES, DATA BASE TABLES, BW SYSTEMS, EXTERNAL SYSTEMS.

THE DATA TYPES FOR INFOOBJECTS CHARACTERISTICS

ARE

CHAR : IT ALLOWS ONLY CHARACTERS

NUMC : IT ALLOWS ONLY NUMBER CHARACTERS

DATS : DATE

TIMS : TIME

IF U USE THE AGGREGATION TAB IN THE KEYFIGURE WHAT EVER THE VALUES OF THE KEY FIGURE FOR A PARTICULAR CHARACTERISTIC IS GET ADDED OR SUMMARIZED.

U CAN CREATE A CALCULATED KEY FIGURE IN THE REPORT. OR U CAN DO IN THE TRANSFER RULES. PERFORMANCE WISE IT IS BETTER TO DO IN THE TRANSFER RULES.

ASSIGN POINTS

Message was edited by: shahid syed

[Former Member]

Ketul

1 Plug Ins

http://help.sap.com/saphelp_nw04/helpdata/en/43/6df486ac847100e10000000a1553f7/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/43/6df486ac847100e10000000a1553f7/frameset.htm

2 Infospoke

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

3 Data Type

http://help.sap.com/saphelp_nw04/helpdata/en/4f/0b3bd650bcea40bce8827930861b89/frameset.htm

Thnaks

Sat