InfoObjects attributes

[Former Member]

Hi everybody,

I have some doubts on attributes of infoObjects and I'll be gratiful for you to answer my questions?

1- How SAP gets values for InfoObjects attributes, lets take an example:

DataSource_A ---Transformation--->InfoCube_B, in the Transformation we are mapping dataSource fileds to InfoCubes InfoObjects (Characteristics and Key figure). My question is: For InfoObjects that contain ohter attributes, how SAP gets values for these attributs ...?

2- Since SAP gets values for those InfoObject attributes, I beleive there are somehere transformations to map fields from source system to those InfoObjects attributs (That are also InfoObjects). where can I display those transformations ? are they scheduled automatecally?

3-I know that we can add attributes to any InfoObjects, how can I get values for the new added attribut?

Any answers, documents or URL would be helpful.

Thank you.

Abdess,

[RamanKorrapati · Accepted solution]

Hi Abdess,

I  think you were very familiar with BW, you did lot of extractions on generic as well as transaction loads also.

like how we loads data to cube ,same way we can load to master data info objects(if have attributes).

Creating data source for master data, we need to choose right radio buttons at RSO2(for generic).\

Data source----> info object,same as Data source --> cube.

transformations, mapping, info and dtp are common.

2. When you click on transformations between info object master data source, you can see them. if objects resebles same, they will mapped automatically, if not, set to map.

3.  if source have field, we can add in attribute and map. load them. or we can do enahancement from source as you aware(think so).

Thanks

[Former Member · Accepted solution]

Hi K Raman, I thank you for your response and for remembering me

Actually, I have worked on BW objects many times, but it were only on transformations that brings transactionnal data ...And I always wondered how InfoObjects Nav/Dis attributes, text and hierarchy are getting filled! Because on those transformations, we mapped only dataSource fields to Characteristics, knowing that those characteristic contains other information (Nav/Dis Attributes, text, hierarchy ) ...I didn't know that there are also transformations for master Data ...

It's the first time I work on adding some other attributes to a standard InfoObject! And the master data is a new concept for me ...

The raison is that the standard InfoCube that I am working on (0FIAR_C03) dosen't contain all the characteristics that meet our client needs, for example: Sales Organisation, Sales employe ...Etc.

I have thought, to enhance the dataSource (0FI_AR_4) that brings data for this infoCube, but I eliminate this alternative, because it slow down the ERP system ...And I beleive that all BI tasks must be on BW server ...

I have also thought of making joins between 0FIAR_C03 and 0SD_C03 using the 0DOC_NUMBER like a key of join ...

Now, I have thought to simply add the 0DOC_NUMBER to the InfoCube 0FIAR_C03 as a characteristic and add all the fields that meet our client needs as navigational attributes to the 0DOC_NUMBER ...And I will use the DataSource 2LIS_11_VAHDR as a DataSource to fill the 0DOC_NUMBER attributes.

Kindly advise me if I am going on right way!

ABdess,

[former_member182470 · Accepted solution]

HI,

I hope you did not understand my earlier reply.  I repeat Attrobutes, Texts An Hierarchies are loaded via Master data loads.

They will have transformations between master data datasources and Infoobjects and its attributes.

You can actually do the same.

Now, I have thought to simply add the 0DOC_NUMBER to the InfoCube 0FIAR_C03 as a characteristic and add all the fields that meet our client needs as navigational attributes to the 0DOC_NUMBER ...And I will use the DataSource 2LIS_11_VAHDR as a DataSource to fill the 0DOC_NUMBER attributes.

Go to the main infoobject in RSA1-->infosources and see they will be having Attributes-->Transfer rules/Transformations. You have to load these main infoobjects which are part of your cube. Automatically, all the attributes will be accessed when you tick them if your attrs are navigational. Display attributes are tightly attached to the characsteristics.

Please search for Attributes and navigational attributes docs in SCN for complete understanding.

Regards,

Suman

[RamanKorrapati · Accepted solution]

Hi Abdess,

Master data was unique and rarely changes.

Attributes, text and hierarchies are part of master data.

Attributes are use when you want display/navigational attributes at bex level.

Text - its contains description of attribute objects

Hierarchy - When you want report on hierarchy levels, we use this.

Coming to your 0DOC_NUMBER, add this object to 0FIAR_C03 and map transformations form source to cube level or at cube level you can maintain routine to fill.

if you want use any attributes at filter level bex, then you need declare as navigational attribute only.

Display attribute's are not possible to restrict or any selections.

Required objects are attributes of 0doc_number, then always first load master data and attribute change run. then  you can load transaction data.

You can add 0FIAR_C03 and 0SD_C03 into info set or multi provider as per suitable conditions.

Thanks

[Former Member · Accepted solution]

Thank you K Raman^^