BookmarkSubscribeRSS Feed
gallenhong
Calcite | Level 5

Hi All,

 

I've a few questions regarding the setup in SAS Analytical Data Builder in CS solution (v6.3).

 

1) I've a FM bridge table that consists of n-to-n relationship between account and collateral, for example X_ACCOUNT_X_COLLATERAL_BRIDGE. And i would like to bring this table into the SAS ADB for one of the Subject-of-Analysis.

 

My question is "How" can we use the bridge table in ADB? does it suppose to be brought in by InfoMap? or can I treat this as a single data source?

 

2) For a case of creating the "Subset" in ADB, which involves multiple levels from ACCOUNT_DIM, CUSTOMER_DIM and APPLICATION_DIM.

 

What will be the best approach to creating such a complex subset?

And would they need to be explicitly configured or able to share configuration, if the similar subset are to be used at different level of Subject of Analysis? For example, in account level SOA, customer level SOA, and application level SOA, sharing same subset created from InfoMap?

 

I would be happy to hear if anyone can share your comments or thoughts on these 2 questions that I have.

 

Thanks!!!