Hi,
I need some help on creating reports using parent-child hierarchy in report painter.
D_Product Table Structure:
PRODUCT_ROWID PRODUCT_KEY PRODUCT_NAME PARENT_KEY
1 TOTAL SKU Consolidated Products
2 TOTAL_BRANDED Consolidated Branded Products TOTAL SKU
3 TOTAL_COMPO Consolidated Component TOTAL SKU
4 TOTAL_OTHER Other non-SKU Items TOTAL SKU
Note: The parent_key for TOTAL_SKU product is blank

MODEL:
Created dimensions with “parent-child hierarchy” for D_PRODUCT connects to a fact table (F_ORDER) using (D_PRODUCT.PRODUCT_ROWID= F_ORDER.PRODUCT_ROWID)
Unique ID : D_PRODUCT.PRODUCT_KEY
Caption : D_PRODUCT.PRODUCT_NAME
Parent Of : D_PRODUCT.PARENT_KEY

REPORT PAINTER::
Added the "product_key" in to the report from object inspector in report painter and where it is set as "Hierarchy" and included one measure "Sold_Qty" and set it as "SUM" and same measure "Sold_Qty” column is added, where set it as "FROLL"
When I execute the report, it displays the error code
“(FOC32440) ROOT RECORD IN DATA BASE IS NOT UNIQUE
BYPASSING TO END OF COMMAND”
Kindly help me on this issue.

This message has been edited. Last edited by: <Kathryn Henning>,

Are these relational tables, or are they FOCUS files?

If relational, check the generated synonyms of the two underlying tables, to see whether the declared primary key (indicated by KEYS=n in the access file, and the first n FIELD declarations in the master file) matches your understanding of the primary-key structure of each table.

Gross,

These tables are relational.

I am getting the same error,after primary keys are defined for product_row_id & product_key in the D_PRODUCT table and for Product_rowid in F_ORDER fact table.

Any luck on this?

Hi Smanicka,

There isn't much information in our knowledge base regarding this error. Please open a case on InfoResponse Online so that we can work with you on this issue.

Thanks and regards,

Kathryn