duplicate dimensions -
10-09-2003
, 07:44 AM
Hi, I'm a MDX newbie, but I'd appreciate some help.
Here's my basic query,
SELECT [Source].[Vch Source].members ON ROWS,
[month].members ON COLUMNS
FROM [Sessions]
WHERE ([Source Type].[x Source Type].[Search Engine], [year].[2003])
but it gives me.
duplicate dimensions across (independent) axes - when calculating a
query axis
Do I have to create another time dimension on my cube, or is there a way
to just limit the year in MDX.
Thanks for you assistance.
Ephraim. |