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!

Register Log in
  • Congratulations Mike Lewis 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

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.

Similar threads

tushargaurav
  • Locked
  • Question
date time prompt not working in arabic language in cognos
Replies
0
Views
170
tushargaurav
tushargaurav
Goutham3835
  • Locked
  • Question
Dateset in Cognos framework
Replies
0
Views
140
Goutham3835
Goutham3835
Emperatriz Stredel
  • Locked
  • Question
Two Cognos reports with two Models (Framework Manager)
Replies
0
Views
153
Emperatriz Stredel
Emperatriz Stredel
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
166
NileshDhande
NileshDhande
Komoshon
  • Locked
  • Question
Cognos admin console query service status
Replies
0
Views
139
Komoshon
Komoshon

Part and Inventory Search

Sponsor

Back
Top