Need some help wit this one and I am pretty new at this. I am in the arts
business am trying to show total sales for performances that occurred the day
of the show. Here is my set up. My measure is sales, I have a time dimension
to the date level and I have a Performance dimension which has the
performance date as an attribute. I was thinking of a filter looking like
[Dim perf].[Perf date] = [dim time].[date name]. but that is not working. I
am getting an error of The axis0 function expects a tuple set expression for
the argument...

Am I way off base trying to go this route? Any Ideas?

Thanks,
--
Marty

I think it's reasonable to compare strings or others than object itself. For
example,

[Dim perf].[Perf date].CurrentMember.Name = [dim time].[date
name].CurrentMember.Name

Ohjoo



"Marty" <Marty (AT) discussions (DOT) microsoft.com> wrote