Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

"The XML view is projected but it is not reachable from a root view" validating a PowerCenter mapping
Problem Description
When validating a PowerCenter ​mapping containing an XML target the following error message is returned:

The XML view [X_A] is projected but it is not reachable from a root view​
Cause
​This error occurs if PowerCenter is not able to find a path from the root view to the view "X_A".
Solution

To resolve this issue, if the view "X_A" has a Hierarchy relationship to the root view or descendants of the root view, make sure that all the appropriate Foreign Key columns are projected.

Example​

The following columns exist in the XML Target definition:

  • X_STORE - XPK_STORE, SNAME
  • X_PRODUCT- XPK_PRODUCT, FK_STORE, PNAME 
  • X_SALES - FK_PRODUCT, YTDSALES 
In the mapping:

  • X_STORE - XPK_STORE, and SNAME are projected
  • X_PRODUCT- XPK_PRODUCT, FK_STORE, and PNAME are projected 
  • X_SALES -YTDSALES is projected, and FK_PRODUCT is not projected.

When the mapping is validated the following error occurs,

... The XML view [X_SALES] is projected but it is not reachable from a root view.

Since FK_PRODUCT is not projected, PowerCenter is not able to find a path from the root view to the X_SALES view. Projecting the FK_PRODUCT column resolves the issue.​

More Information
Applies To
Product: PowerCenter
Problem Type: Connectivity
User Type: Administrator
Project Phase: Configure
Product Version: PowerCenter
Database: XML
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:7/7/2020 3:11 AMID:14277
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)