Skip to Content
author's profile photo Former Member
Former Member

Selection Fields in Transfer Structure of InfoSource

Hi all,

We have an InfoSource which uses an 8-Data Source (so a generated Data Source from an ODS object in our own BW System). Under this InfoSource we have created an InfoPackage which uploads data into an InfoCube. The problem is that the tab "Data Selection" of our InfoPackage is empty - so we can't fill in any selections 'cause there are no selection fields.

If we look at the Transfer Structure of the Info Source, none of the fields listed there are selection fields (so the switch 'Selection' is always empty in the Transfer Structure). For InfoSources which use DataSources from R/3 we can maintain this switch in R/3 and so specify if a certain field has to be a selection field or not. But how to do this for an 8-DataSource which exists only in BW?

Thanks in advance,

Ioana

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2004 at 10:34 PM

    The datasources are available in BW, so if you want to edit the datasource, you can use transaction code RSA6 in BW. This will allow you to edit the data source.

    You can also use the menu path SBIW--> Post processing of datasources --> Edit datasources and application component hierarchy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 02, 2004 at 08:02 AM

    Is it your BW a 2.x Release?

    Then it shold be normal: in fact ODS Export DS do not permit to use "selection fields", while InfoCube's do!

    Bye

    GFV

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2004 at 12:23 AM

    Ioana

    There is a work around.

    The selection capability of the field in the transfer structure is determined by the content of the field SELECTION present in the table ROOSFIELD. For a generated (export) DataSource its not possible to change the selection setting in RSA6. So here's a work around:

    1. Suppose the field in the transfer structure is MATERIAL. Change the contents of ROOSFIELD-SELECTION to 'X' for the record in ROOSFIELD with the keys as the DataSource, version = 'A' and Field name = MATERIAL.

    Note: You might have to write a program to do this as the table cannot be edited directly.

    2. Replicate the DataSource from the source system which in this case will be the BW system itself

    The field MATERIAL will now be available in the "Selection" tab in the InfoPackage.

    Caveat: If you regenerate the export DataSource of the object, your setting in ROOSFIELD will be reset and you'll need to run this above procedure again.

    Hope this helps.

    Shantanu.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2004 at 04:00 PM

    Ioana

    You are right. The field doesn't show up in the selection tab in an init InfoPackage.

    Why do you want to restrict data during a delta initialization?

    If you are selecting data in order to set up multiple parallel data loads for mutually exlusive ranges in order to reduce the over-all load time, I recommend full load(s) followed by an initialization without data transfer.

    Shantanu.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Shantanu,

      Let's say for example you don't want to gather 'deleted' (STORNO = R) records from the 'base ODS' to the reporting target --> it would have been nice. But full load followed by init without data is also satisfactory

      Thank you very much

      Ioan

  • author's profile photo Former Member
    Former Member
    Posted on Jun 03, 2005 at 09:54 PM

    I'm running into the same situation where for the init from an ODS, there is no selection criteria available.

    This is not the case though for doing an INIT from a Cube. I would like to use an ODS that contains the data for sending data to a data mart, and do an INIT load with selection criterial on particular sales orgs. Then when deltas are run it should pick up updates for documents.

    Anyone have any way that you can get selection criteria for init/delta loads from the export datasource from an ODS?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.