BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

converting .UNV to.UNX using IDT in 4.1

Goto page Previous  1, 2
 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Mark P
Forum Devotee
Forum Devotee



Joined: 03 Feb 2003
ASUG Icon
Posts: 11422
Location: Manchester, UK


flag
PostPosted: Mon Oct 15, 2018 2:53 am 
Post subject: Re: converting .UNV to.UNX using IDT in 4.1

Quote:
log generated.
"Severity";"Rule Name";"Status";"Object";
"OK";"Check Parameter";"OK";"";
"OK";"Check Dependencies";"OK";"";
"OK";"Check Context";"OK";"";
"OK";"Check Loops";"OK";"";
"OK";"Check Business Object Name ";"OK";"";
"OK";"Check Query";"OK";"";

Can be ignored, all fine.


Quote:
"ERROR";"Check for Undefined Cardinality ";"The cardinality of the join "Claims_PCS".PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY in data foundation Caps_Claims is undetermined.";""Claims_PCS".PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY";
"ERROR";"Check for Undefined Cardinality ";"The cardinality of the join HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY in data foundation Caps_Claims is undetermined.";"HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY";
"ERROR";"Check for Undefined Cardinality ";"The cardinality of the join MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in data foundation Caps_Claims is undetermined.";"MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"ERROR";"Check for Undefined Cardinality ";"The cardinality of the join MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in data foundation Caps_Claims is undetermined.";"MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";


Go through all your cardinalities and set them up. This will take an hour or two but will save so much time later.

Quote:
"OK";"Check Alias Table";"OK";"";

All clear

Quote:
"WARNING";"Check Table Primary Key";"Table LF$APP_VAM_TREATMENT is missing a primary key.";"LF$APP_VAM_TREATMENT";
"WARNING";"Check Table Primary Key";"Table LF$APP_PHYSICIAN is missing a primary key.";"LF$APP_PHYSICIAN";
"WARNING";"Check Table Primary Key";"Table LF$APP_ENDORSEMENT is missing a primary key.";"LF$APP_ENDORSEMENT";
"WARNING";"Check Table Primary Key";"Table LF$APP_DOCUMENT_MAPPER is missing a primary key.";"LF$APP_DOCUMENT_MAPPER";
"WARNING";"Check Table Primary Key";"Table LF$APP_DOCUMENT_REFRENCE is missing a primary key.";"LF$APP_DOCUMENT_REFRENCE";
"WARNING";"Check Table Primary Key";"Table LF$APP_DOCUMENT_MASTER is missing a primary key.";"LF$APP_DOCUMENT_MASTER";
"WARNING";"Check Table Primary Key";"Table LF$APP_SMS_TEMPLATES is missing a primary key.";"LF$APP_SMS_TEMPLATES";
"WARNING";"Check Table Primary Key";"Table LF$APP_COMM_TRIGGERS is missing a primary key.";"LF$APP_COMM_TRIGGERS";
"WARNING";"Check Table Primary Key";"Table LF$APP_GRIEVANCE is missing a primary key.";"LF$APP_GRIEVANCE";
"WARNING";"Check Table Primary Key";"Table LF$APP_HINDSIGHTING is missing a primary key.";"LF$APP_HINDSIGHTING";

Fix them or don't - it's up to you. Important if you're using key/index awareness.

Quote:
"WARNING";"Check for Isolated Table";"Table CLAIMS.LF$APP_COMM_SMS is not joined to any other table.";"CLAIMS.LF$APP_COMM_SMS";
"WARNING";"Check for Isolated Table";"Table CLAIMS.LF$APP_COMM_LETTERS is not joined to any other table.";"CLAIMS.LF$APP_COMM_LETTERS";
"WARNING";"Check for Isolated Table";"Table Claims_Work_Queue is not joined to any other table.";"Claims_Work_Queue";
"WARNING";"Check for Isolated Table";"Table Communication_Claims is not joined to any other table.";"Communication_Claims";
"WARNING";"Check for Isolated Table";"Table Cost_MR is not joined to any other table.";"Cost_MR";
"WARNING";"Check for Isolated Table";"Table Hospital is not joined to any other table.";"Hospital";
"WARNING";"Check for Isolated Table";"Table Work_Queue is not joined to any other table.";"Work_Queue";
"WARNING";"Check for Isolated Table";"Table LF$APP_CLAIM_TAXDETAILS is not joined to any other table.";"LF$APP_CLAIM_TAXDETAILS";
"WARNING";"Check for Isolated Table";"Table DECISION_OVERRIDE is not joined to any other table.";"DECISION_OVERRIDE";


We cannot give you a definite answer on these tables - check for yourself if they should be joined to other tables or not.

Quote:
"ERROR";"Check Table Structure";"Table LF$APP_ACTIVITY referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_ACTIVITY";
"ERROR";"Check Table Structure";"Table LF$APP_ADDRESS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_ADDRESS";
"ERROR";"Check Table Structure";"Table LF$APP_CLAIM referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_CLAIM";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_PREAUTH referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_PREAUTH";
"ERROR";"Check Table Structure";"Table LF$APP_KEYEDVALUE referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_KEYEDVALUE";
"ERROR";"Check Table Structure";"Table LF$APP_ATTACHMENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_ATTACHMENT";
"ERROR";"Check Table Structure";"Table LF$APP_RELATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_RELATION";
"ERROR";"Check Table Structure";"Table LF$APP_POLICY referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_POLICY";
"ERROR";"Check Table Structure";"Table LF$APP_PARTY referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_PARTY";
"ERROR";"Check Table Structure";"Table LF$APP_COVOPTION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_COVOPTION";
"ERROR";"Check Table Structure";"Table LF$APP_EVENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_EVENTDETAILS";
"ERROR";"Check Table Structure";"Table LF$APP_CLAIMINFORMATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_CLAIMINFORMATION";
"ERROR";"Check Table Structure";"Table LF$APP_COMMUNICATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_COMMUNICATION";
"ERROR";"Check Table Structure";"Table LF$APP_CUSTOMERCALLING referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_CUSTOMERCALLING";
"ERROR";"Check Table Structure";"Table LF$APP_FINALDECISION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_FINALDECISION";
"ERROR";"Check Table Structure";"Table LF$APP_FRAUDDETAILS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_FRAUDDETAILS";
"ERROR";"Check Table Structure";"Table LF$APP_PAYMENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_PAYMENTDETAILS";
"ERROR";"Check Table Structure";"Table LF$APP_REFFERALS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_REFFERALS";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_DIAGNOSIS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_DIAGNOSIS";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_NETWORKASSESSMENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_NETWORKASSESSMENT";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_PASTILLNESS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_PASTILLNESS";
"ERROR";"Check Table Structure";"Table LF$APP_INVESTIGATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_INVESTIGATION";
"ERROR";"Check Table Structure";"Table LF$APP_REQUIREMENTINFO referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_REQUIREMENTINFO";
"ERROR";"Check Table Structure";"Table LF$APP_HOLDING referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_HOLDING";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_PREAUTHBENDETAIL referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_PREAUTHBENDETAIL";
"ERROR";"Check Table Structure";"Table LF$APP_VAM_TREATMENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_VAM_TREATMENT";
"ERROR";"Check Table Structure";"Table LF$APP_SUBEVENTDETAILS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_SUBEVENTDETAILS";
"ERROR";"Check Table Structure";"Table LF$APP_PERSON referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_PERSON";
"ERROR";"Check Table Structure";"Table LF$APP_PHONE referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_PHONE";
"ERROR";"Check Table Structure";"Table LF$APP_PHYSICIAN referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_PHYSICIAN";
"ERROR";"Check Table Structure";"Table LF$APP_ORGANIZATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_ORGANIZATION";
"ERROR";"Check Table Structure";"Table LF$APP_CLIENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_CLIENT";
"ERROR";"Check Table Structure";"Table LF$APP_EMAILADDRESS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_EMAILADDRESS";
"ERROR";"Check Table Structure";"Table LF$APP_EMPLOYMENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_EMPLOYMENT";
"ERROR";"Check Table Structure";"Table LF$APP_EDUCATION referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_EDUCATION";
"ERROR";"Check Table Structure";"Table LF$APP_RISK referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_RISK";
"ERROR";"Check Table Structure";"Table LF$APP_ENDORSEMENT referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_ENDORSEMENT";
"ERROR";"Check Table Structure";"Table LF$APP_DISABILITYHEALTH referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_DISABILITYHEALTH";
"ERROR";"Check Table Structure";"Table LF$APP_RIDER referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_RIDER";
"ERROR";"Check Table Structure";"Table LF$APP_DOCUMENT_MAPPER referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_DOCUMENT_MAPPER";
"ERROR";"Check Table Structure";"Table LF$APP_DOCUMENT_REFRENCE referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_DOCUMENT_REFRENCE";
"ERROR";"Check Table Structure";"Table LF$APP_DOCUMENT_MASTER referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_DOCUMENT_MASTER";
"ERROR";"Check Table Structure";"Table LF$APP_SMS_TEMPLATES referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_SMS_TEMPLATES";
"ERROR";"Check Table Structure";"Table LF$APP_COMM_TRIGGERS referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_COMM_TRIGGERS";
"ERROR";"Check Table Structure";"Table LF$APP_GRIEVANCE referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_GRIEVANCE";
"ERROR";"Check Table Structure";"Table LF$APP_HINDSIGHTING referenced in data foundation Caps_Claims does not exist in the database.";"LF$APP_HINDSIGHTING";

If they don't exist, delete them.

Quote:
"ERROR";"Check Derived Table";"The SQL expression for the derived table LADETAILS in the data foundation Caps_Claims is invalid.";"LADETAILS";
"ERROR";"Check Derived Table";"The SQL expression for the derived table DECISION_OVERRIDE in the data foundation Caps_Claims is invalid.";"DECISION_OVERRIDE";

Not something we can help with - your code for your derived table is wrong and needs fixing.

Quote:
"ERROR";"Check Business Object Expression";"Business object 'Claims Lf$app Keyedvalue2\Keyvalue' returns an incorrect data type.";"Keyvalue";
"ERROR";"Check Business Object Expression";"Business object 'Claims Lf$app Keyedvalue\Keyvalue' returns an incorrect data type.";"Keyvalue";
"ERROR";"Check Business Object Expression";"Business object 'Claims Lf$app Keyedvalue3\Keyvalue' returns an incorrect data type.";"Keyvalue";
"ERROR";"Check Business Object Expression";"Business object 'Claims Lf$app Claiminformation\Versionnumber' returns an incorrect data type.";"Versionnumber";
"ERROR";"Check Business Object Expression";"Business object 'Claims Lf$app Keyedvalue32\Keyvalue' returns an incorrect data type.";"Keyvalue";
"ERROR";"Check Business Object Expression";"Business object 'Party Relation\Keyvalue' returns an incorrect data type.";"Keyvalue";
"ERROR";"Check Business Object Expression";"Business object 'Hospital Id\Hospital Id' returns an incorrect data type.";"Hospital Id";
"ERROR";"Check Business Object Expression";"Business object 'Ladetails\Lastatus' returns an incorrect data type.";"Lastatus";


Simple - change the data type!

Quote:
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Ladetails\System Recommended Amt'. Check the object properties.";"System Recommended Amt";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Polnumber'. Check the object properties.";"Polnumber";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Productcode'. Check the object properties.";"Productcode";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Canonicalid'. Check the object properties.";"Canonicalid";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Claimnumber'. Check the object properties.";"Claimnumber";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Claimtype'. Check the object properties.";"Claimtype";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Subtype'. Check the object properties.";"Subtype";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Totgrossbill'. Check the object properties.";"Totgrossbill";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\System Decision'. Check the object properties.";"System Decision";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\System Recomended Amount'. Check the object properties.";"System Recomended Amount";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\System Dec Reason'. Check the object properties.";"System Dec Reason";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Remarks'. Check the object properties.";"Remarks";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Decisiondate'. Check the object properties.";"Decisiondate";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Decisiondate(D)'. Check the object properties.";"Decisiondate(D)";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Userid'. Check the object properties.";"Userid";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Decision'. Check the object properties.";"Decision";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Decision Reason'. Check the object properties.";"Decision Reason";
"ERROR";"Check Business Object Expression";"Failed to execute the expression for business object 'Decision Override\Amount'. Check the object properties.";"Amount";


Some de-bugging for you to do.

[QUOTE]"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+) in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_CLAIM.CANONICALID=CLAIMS.LF$APP_FRAUDDETAILS.PARENTCANONICALID(+)";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_REFFERALS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_VAM_TREATMENT.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_CLAIM.PARENTCANONICALID=CLAIMS.LF$APP_POLICY.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_ACTIVITY.ACTIVITYCODE=CLAIMS.LF$APP_VAM_PREAUTH.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_ACTIVITY.HOLDINGID=CLAIMS.LF$APP_HOLDING.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_PERSON.CANONICALID=CLAIMS.LF$APP_EDUCATION.PARENTCANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_DOCUMENT_REFRENCE.DOCUMENTREFERENCE=CLAIMS.LF$APP_DOCUMENT_MAPPER.DOCUMENT_REFERENCE";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_ACTIVITY.PARTYID=CLAIMS_LF$APP_PARTY2.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS.LF$APP_CLAIM.CLAIMKEY="Party_Relation".CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS.LF$APP_CLAIM.CLAIMKEY="Party_Relation".CLAIMKEY";
"WARNING";"Check Cardinality Same as Detected";"The join "Claims_PCS".PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";""Claims_PCS".PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CLAIMKEY";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS_LF$APP_RELATION3.ORIGINATINGOBJECTID=CLAIMS_LF$APP_POLICY3.PARENTCANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"CLAIMS_LF$APP_PARTY2.CANONICALID=CLAIMS_LF$APP_RELATION3.RELATEDOBJECTID";
"WARNING";"Check Cardinality Same as Detected";"The join HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"HOSPITAL_ID.CLAIMKEY=CLAIMS.LF$APP_CLAIM.CLAIMKEY";
"WARNING";"Check Cardinality Same as Detected";"The join LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"LADETAILS.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"MAX_FINAL_DECISION_DATE.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"LAST_DOCUMENT_RECEIVED.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";
"WARNING";"Check Cardinality Same as Detected";"The join MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID in the data foundation Caps_Claims has a different cardinality than the detected cardinality.";"MAX_DECISION_DATE_HCH.PARENTCANONICALID(+)=CLAIMS.LF$APP_CLAIM.CANONICALID";

regards,
Ravi/[QUOTE]
See above about cardinalities

_________________
Current version I'm using: 4.1 SP3 over Oracle. Well versed in SQL Server too, including SSIS

______________________________________
Prior versions used: BO3,4,5,6.5,XIr2,XI3, 4.1 - yes, I have been using BO since 1996!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0313 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0278)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo