Hello,
I need to filter a dimension by input attribute value, (in MSAS 2000 it was
done by using member properties) something like this:
filter(iif([UserAccress].CurrentMember.Attribute1 = 'Peter'.....
Any help is greatly appreciated.

hi
you can do the filtering in the 'WHERE' part

select
.... ......on columns,
.... .......on rows
from........
where [useraccess].[dimension member name].[peter]

if u have a dimension 'useraccess' with a dimension member 'names' which
store all the names
then the 'where' part will be

where [useraccess].[names].[peter]
hope u got it.

sherin


leo wrote:
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200605/1