i have a query that counts the number of stores that both exist in two dimension:
nonemptycrossjoin(descendants(dimlocation.currentmember,9,leaves),descendants(dimtargetset.currentmember,9,leaves)).count
dimlocation is a parent child dimension while dimtargetset is a star schema...
later i realized that im only counting the stores with data and excluding stores with no data in the count.. i tried crossjoin only but it doesnt return the correct count...
is there any way i could count them? im using as 2000... thanks...
any ideas?|||See this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2139906&SiteID=1
Best regards
- Jens
No comments:
Post a Comment