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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TolomirAdministratorCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.