Question Re: InfoObjects attributes in Technology Q&A

InfoObjects attributes

Former Member — Thu, 04 Jul 2013 15:24:23 GMT

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,

Re: InfoObjects attributes

Former Member — Fri, 05 Jul 2013 12:30:02 GMT

Hi Abdess,

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

Here, when defining the info object we give the attributes for that info object in the attribute tab.

For example for 0customer info object we gave customer no, customer name, customer address as attributes while we creating the 0customer info object.

0customer info object acts as a master data info object. and when loading the master data we are give the mapping to source and target fields.

Thanks,

Purushotham.

Re: InfoObjects attributes

Former Member — Fri, 05 Jul 2013 12:30:53 GMT

Hi,

Infoobjects with attributes should have a master data.

Now, master data is loaded through a datasource(could be standard or generic). Transformation needs to be created between the datasource and the master data infoobject.

For your last question, if we add new attributes to the infoobject, then we gotta have the values coming from the datasource and the corressponding fields should be mapped in the transformation

Re: InfoObjects attributes

former_member182470 — Fri, 05 Jul 2013 12:55:47 GMT

Attributes are always loaded by master data loads to the characteristics. Master data is of 3 types. Attributes, Texts and Hierarchies..Please search forum before posting. It's a basic question..

Re: InfoObjects attributes

RamanKorrapati — Fri, 05 Jul 2013 13:14:28 GMT

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

Re: InfoObjects attributes

Former Member — Fri, 05 Jul 2013 14:41:47 GMT

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,

Re: InfoObjects attributes

former_member182470 — Sun, 07 Jul 2013 10:21:54 GMT

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.

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

Re: InfoObjects attributes

RamanKorrapati — Tue, 16 Jul 2013 13:05:42 GMT

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

Re: InfoObjects attributes

Former Member — Tue, 16 Jul 2013 14:40:36 GMT

Thank you K Raman^^