Monday, August 25, 2008

The Siebel Analytics attempts to execute query using the W_INS_CLAIM_F table by default.

How to remove the Default Join Path from LTS:

i): By Default when Employee name is selected the join path traverse to insurance fact ratter than expected Join Path.


ii): This Issue Arises when we have both the horizontal and vertical in the siebel analytics RPD.

iii): The requirement was to Get the name of the Sales Rep based on the Login from employee and their associated territory.


iv): This has been fixed by removing the reference in the Insurance Source of the FACTS (W_INS_CLAIM_F) table in the content tab of the LTS to the Horizontal dimensions so that it will choose the most economical sources as what is expected.

v): Employee and opportunity Relation is Many to many between these two. so the relation goes like the parent held position id in s_contact and row_id in the s_opty tables to the Intersection table of S_opty_postn through the Opty_id and Position_id).

2 comments:

Anonymous said...

Great Job done.

Anonymous said...

Thanks for the post

Siebel Analytics Interview Questipns

Priya