What is master and detail in webi?

[Former Member]

hi,

What is master and detail in webi?

Thanks and Regards,

Manjunath Jogin

[chemicala_srimallikarjuna · Accepted solution]

Hi,

In Designer, objects are qualified as one of three types: dimension, detail, or measure.

Dimension: Parameters for analysis. Dimensions typically relate to a hierarchy such as geography, product, or time. For example. Last Name and City_Id

Detail : Provide a description of a dimension, but are not the focus for analysis. For example. Phone Number

measure: Convey numeric information which is used to quantify a dimension object. For example, Sales Revenue

Regards

CSM Reddy

[Former Member · Accepted solution]

In webi, I jsut read that master and detial is related to create section.

Please let me know I am really confused.

[chemicala_srimallikarjuna · Accepted solution]

Hi,

After creating the OLAP Universe , we can leverage Web Intelligence to build a new report, means the designing of webi report is based on univers objects ( Dimesnion, Details,measure)

If you right click on particular column or row cells in the report , you can select "set as Section" Option.

For Example1: Right click on the cloumn Region in the report and select 'Set as section', gives you the details & master of the region.

Exmaple 2:

If a section in a report. Consider the dimensions as [Country], [State] and [Measure] as Sales and create a section on Country, you get subtotals of Sales for every country.

Regards

CSM Reddy

[Former Member · Accepted solution]

I have following doubts

1. Master and detail concept is different in webi and Universe

2. In your example 2 in webi

India

-

---

State----

---

Sales

-

---

Andra pradesh -Rs 100

Karntka -Rs 100

Kerla -Rs 100

Tamilnadu -Rs 100

-

---

Total -Rs400

Country is master and remaing are details.

is my asuumption correct?

Please let me know

[chemicala_srimallikarjuna · Accepted solution]

Hi,

Yes in this example 2 : Country is master and the rest are deatils.

pls chk this example:

To Genearte a Webi report on Customer Master the required fields are Customer and its attributes like Country , Telephone etc. (these attributes are navigational attributes) In the webi report , the fields which are L01 CUstomer, L01 Country, L01 Telephone

Master : Customer Details : Attributes of Master (Country,Telephone)

Hope this helps,

Regards

CSM Reddy

[former_member142702]

Detail objects are bound to dimension objects and have a rather descriptive role. They can be used to aggregate results (in fact the aggregation is done along the related dimension) but they cannot be used for drilling.

I would recommend to look in the universe designer guide:

http://help.sap.com/businessobject/product_guides/boexir31SP3/en/xi31_sp3_designer_en.pdf

Just search for "detail object"

Regards,

Stratos