This content has been marked as final. Show 6 replies
I think its you sent me email with samilar Q.
If you are doing in BMM you need to understand the schema
assuming you got fact,day, custmer tables
and these joined as star.
you need to create a metric on fact as min(day.date) and set content tab to customer level
for this you might have to map day dim to fact using fact source properties add day table.
once you done as I said:
just pull mindate metric in answers run it and check physical sql that should be like
select min(date),cust_name from
where 2 joins goes
group by cust_name
Hope this helps, if helps mark