Hallo

I need help with the following. I've developed an application for
analysis and one of the fundamental functions is to be able to select
multiple members in a background dimension (the "Where" in the mdx
query. My application works fine if i don't restrict permissions in the
dimension. But when i remove the All level and only allows one member on
the second level (using dimension security) the user gets an error
indicating that the Aggregation Member cannot be found. An example of
the query is as follows:

WITH MEMBER [Kostnadsställe.Ansvar].[ Aggregation] AS ' AGGREGATE( {
[Kostnadsställe].[Ansvar].[Ansvar].&[820].&[27031.820],
[Kostnadsställe].[Ansvar].[Ansvar].&[820].&[27032.820] } ) ',
SOLVE_ORDER = 0 SELECT { [Bokföringsdatum].[Hela tidsperioden] } ON
COLUMNS , { [Ansvar].[Administration].[Level 03].[820 Urban Holmberg] }
ON ROWS FROM [Ekonomi] WHERE ( [Kostnadsställe.Ansvar].[ Aggregation],
[Measures].[Saldo] )



I shuld also mention that everything works fine if the user only select
one member in the background dimension (Where-clause)



A quick answer is greatly appreciated.

Thanks

Andreas Åström


--
Posted via http://dbforums.com

Hallo out there,

If you need more information to respond to my question just say so. I'm
sure that someone has a good answer to myc question.

Regards

Andreas


--
Posted via http://dbforums.com