cancel
Showing results for 
Search instead for 
Did you mean: 

Question on extraction

Former Member
0 Kudos

Hi <b>B</b>est and <b>W</b>ise gurus,

While studying the properties of the business content infocube <b>0FIGL_C01-General ledger:Transaction figures</b>, I came to know that in its Datasource <b>0FI_GL_1</b>, the extraction method is <b>F1</b> and the extract structure is <b>DTFIGL_1.</b>

1)What is F1 extraction method? Guess there are some more extraction methods . Can anybody throw some light on them.

2)In R/3, while checking the properties of the datasource in RSA5,the extract structure DTFIGL_1 has its direct access property defined as <b>1 indicating extractor does not support preaggregation.</b>

Other options in direct access are

<b>2 Extractor supports preaggregation

D Virtual access not possible.</b>

Can anyone explain them?

Any documents related to this can be sent to vbalji_007@yahoo.com

Thanks in advance.

Regards,

Balaji

Message was edited by: balaji vijayakumar

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi dear,

what you see is the content of field VIRTCUBE of ROOSOURCE table...

If it contains the value '1' or '2', the datasource is released for remote access, if it contains the value 'D', the dataSource is locked for remote access.

If the value is empty (' '), the attribute has not yet been assigned and the datasource is also locked for remote access. (OSS NOTE 326482).

The aggregation behaviour means what it says: if the datasource performs any aggregation while it extracts or if you upload data with the same granularity (I'm talking always about virtual access!)

Bye,

Roberto

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi gurus,

Thanks a lot for your replies.

But my second question still remains unanswered.

Regards,

Balaji

Former Member
0 Kudos

Hi dear,

take a look to my weblog...

/people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

Hope it helps!

Bye,

Roberto

Former Member
0 Kudos

Hi,

Pls find the document in your inbox.

Regards,

Amit