Hi,
Please help me.
I want to put 2 conditions in my where clause but it doesn't work

SELECT NON EMPTY
{ [Measures].[NbRapports]} ON COLUMNS,
{ [rapport].CHILDREN} ON ROWS,
{ descendants([date].[Tous les date],[date].[Jour],LEAVES) } ON PAGES
FROM cube_RS
WHERE ([Serveur].[Tous les Serveur].[1234])AND [date].[Année ].[2005]

Thanks in advance,
Oliver

You can't have the where clause contain a dimension that you are also
selecting. try this ( i haven't validated that this works ):

SELECT NON EMPTY
{ [Measures].[NbRapports]} ON COLUMNS,
{ [rapport].CHILDREN} ON ROWS,
{ descendants([date].[Année ].[2005],[date].[Jour]) } ON PAGES
FROM cube_RS
WHERE ([Serveur].[Tous les Serveur].[1234])



"TRYP" wrote:

Thanks for the answer it works very good....

I have an other problem now

SELECT NON EMPTY
{ [Measures].[NbRapports]} ON COLUMNS,
{ [rapport].CHILDREN} ON ROWS,
{ descendants([date].[Tous les date],[date].[Jour],LEAVES) } ON PAGES
FROM cube_RS
WHERE ([Serveur].[Tous les Serveur].[1234])AND [User].[Oliver]

Thanks in advance


*** Sent via Developersdex http://www.developersdex.com ***