BW very very important doubts

[Former Member]

Hi Ravi,

I have few question and doubt in SAP BW

Qurestion1) What is infoObject?. Is we defining perticular business object as InfoObject. But in actual situation we are making tables if we are saying in broad way we are making table in background if we make infoObject. One table for Master data, text data, Hirarchy data. At the same time we SID table is creating automatically and this Sid table is connecting to the above table. Please would you please clear my doubt.

Q2) What is InfoSource?, In definition Infosource is the quantity of InfoObject. That means combining of two three infoObject is called as Infosource or what?. If we go on creating Infosource we are selecting any one InfoObject in Updates then how come we saying more than one InfoObject termed as Infosource?.

Q3) What is ODS?, there are three types of table in ODS but it is saying how can we check in system using SE16. Please explaing.

Q4) What is line Item, Line Item attribute, what is Display attribute. If we creating charecteristic in this charecteristic we are creating another attribute only, that means each attribute is field in Charecteristic and that attirbute is display attribute unless if we define as navigational attibute.

Could you explain Navigational attirbute and with well seen figure explain me

[former_member188975]

Hi,

Your understanding of an InfoObject is correct. Tables are created in the background when you activate an InfoObject, and these are used in the background for storing data. But you never refer to table by table when creating cube or queries: Just use the InfoObject.

Not sure about what you mean by " we are selecting any one InfoObject in Updates then how come we saying more than one InfoObject termed as Infosource?." InfoSource is one of the objects in the dataflow. Yes it is a collection of InfoObjects, and InfoSource is assigned to the data target to create the update rules. In the Update rules, you map the InfoObjects of the InfoSource to those of the data target so that the data can flow.

If you read about the ODS object, it is composed of 3 tables. And as with any table, you can look up the contents of these in SE16.

Yes, any attr is display unless you switch it to navigational.

For details on navigational attr, search the forum as there are many detailed discussion with great examples.

Arun asked you to refer to help.sap.com as it contains that basic info for all these terms. There are also other documents on data modeling in the BI area of SDN that can help you sort out such concepts. If you read through these, it will help to build your concepts.

Hope this helps...

[Former Member]

Hi Gupta,

In terms of creating Infosource, how many infoobject you will select in direct update. So I have read the definition of Infosource is the quantity of InfoObjects. We are creating InfoSource we are selecting only one infoObject in Infosource, I have seen there is no othere option to add more than one InfoObject in InfoSource.

Otherthing is that the data flow into the ODS, would explain me the data flow details in ODS. How data is flowing into three tables. What is the use of ODS as compare to InfoCube. I understood theODS is used for Transactional data or detail reporting but how it is going to be detail reporting.

I am confuse between line item and line item attributes. Would you explain me I would be appriatiate for this

Thanks

Happy

[former_member184494]

happyman,

For q 2,3 and 4 you can get all your answers from the help portal at help.sap.com . If there is anything you cannot get from the help portal - please post the link that you went through to understand the same and what struck you as strange / complex.

Arun

[Former Member]

Mr.Arun,

Would you please read the things very carefully, I will not get on help.sap.com.

Thanks

Happy