MS SQL Server OLAP - CrossJoin with Period

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

CrossJoin with Period

bdomain@elv.enic.fr

2006-01-31, 7:24 am

Hello,

I would like to make a query which gives following results:
Period 1 | Period
2
Account CA Ev Count | CA Ev
Count
abcd 500 10 | 1235
15
ghjty 123 20 | 456
20

And my period 1 is a set of date: for example:
[EVENEMENT].[Temps Num=E9rique].[ANNEE].&[2005].&[4].&[12].&[49] AND
[EVENEMENT].[Temps Num=E9rique].[ANNEE].&[2005].&[4].&[12].&[51].&[352]

My period 2, is the same but for the year 2006 for example.

How can I do in a query to have this result, I know how to do it in
cube browser but not in a MDX query

Thanks for your help,
Betty

Sponsored Links