Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BWA Attribute Mining

I'm trying to understand the mapping of integer ID's in BWA.

My cube is ZPP_C019.

Looking in the TREX attribute mining tab I see as follows (Note that I'm not showing you all the dims here):

PB1_BIC:DZPP_C0191
      Dimid			Value-59	value-117
      sid_0plant		Value-10	Value-
PB1_BIC:FZPP_C019
     $bic$zcount6
     $bic$zcount7
     key_zpp_c0191		Value-59	value-117
     key_zpp_c0192
     key_zpp_c019p
     key_zpp_c019t
     key_zpp_c019u
PB1_BI0:XPLANT
     Sid                                                    
     Plant	
PB1_BI0:SPLANT
     Sid
     Plant	

So I see the mapping correlation between PB1_BIC:DZPP_C0191 Dimid (59, 117) and the fact table PB1_BIC:FZPP_C019 key_zpp_c0191 (59, 117).

What I'm not getting is the following:

1) In the dim PB1_BIC:DZPP_C0191, the dimid (30 rows) and the sid_0plant (24 rows). When I click on each field and then "Distribution" I'm not seeing the correlational mapping. I thought I would see the same number of rows and there would be a clear link between the dimid and the sid_0plant

2) Same kind of question as 1 except that the dim PB1_BIC:DZPP_C0191 sid_0plant should have a direct mapping between the PB1_BI0:SPLANT Sid

3) Also seems to me that the PB1_BI0:SPLANT, the Sid and the Plant should have the same number of rows in it.

Sid has 21 rows and Plant 31 rows.

4) There is a table pb1_zpp_c019 shows all the characteristics and their keys like 0plant_sid and 0plant_key but this seems redundant to the above information

Maybe I'm confused over the purpose of the attribute mining tab and its NOT a window into how BWA has loaded the index (which is really what I wanted to see)

I understand that the dim table is a link between the fact table and the master data I just wanted to go in BWA and verify the mappings.

Any help in my understanding is appreciated.

Mike

Former Member
Not what you were looking for? View more on this topic or Ask a question