Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cognos DMR Package - Cartesian Product

Status
Not open for further replies.

Srin

Technical User
Jun 14, 2017
1
SG
DMR package Model is as below

Product Dimension
Product_ID
Product_Name
Prod_Price

Order Fact
Date_key
Prod_key
Metric1
Metric2

Date Dimension
Date_key
Month_WithYear
Week

In Report Studio when pull Month_WithYear, Product name, Metric1, Metric2, Prod_price

Above report is generating some caretesian value for Pord_price, but metric1 and metric2 are coming properly.

Could some one help on this

Thanks
Srini
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top