Create Microstrategy Table Joins in Report

I give up!  I'm greating metrics in Microstrategy and then creating reports to verify them.
I'm viewing the Microstrategy code in SQL to confirm that it's what I want, but I keep getting "cross joins"  I've tried architech, metric join types, everything!  I have 300 metrics to verify!  Please help!  Both the microstrategy SQL code and the SQL code that I want are attached
Microstrategy
select	a12.MTD_DATE_ID  MTD_DATE_ID,
	count(a11.BOOKING_FACT_ID)  WJXBFS1
from	BOOKING_FACT	a11
	cross join	LU_MTD_DATE	a12
where	a12.MTD_DATE_ID in (20091231)
group by	a12.MTD_DATE_ID


SQL

select MTD_DATE_ID, count(booking_fact_id)   ---268
from booking_fact a
join dbo.LU_MTD_DATE b
on a.booking_date_id = b.date_id
where 
cancelled_flag =1
and mtd_date_id = 20091231
group by b.MTD_DATE_ID

Open in new window

glendawiAsked:
Who is Participating?
 
TolomirConnect With a Mentor AdministratorCommented:
you need an attribute that contains

booking_fact.booking_date_id as ID and dbo.LU_MTD_DATE.date_id as DESC

Put this attribute in the report and run the sql again.

0
 
TolomirAdministratorCommented:
see this screenshot

26.04.png
0
 
glendawiAuthor Commented:
THANK YOU so very much!!  It did the trick.  Thank you too for the pictures they really helped.  This is fantastic.  I may master this yet!
0
 
TolomirAdministratorCommented:
Glad, that I could help you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.