erics44 (3/3/2015)
HiI have written this MDX
select {[Date].[Calendar Year].[2014], [Date].[Calendar Year].[2015]} on columns
, [Holidays].[Start Date].members on rows
from Cube
and i get something like the following results (sorry i dont know how to upload and image.
---------------2014-------------2015
2010-01-07----£100-------------£0
2010-01-08-----£0--------------£100
as you can see the dates dont relate to the year
could anyone help in sugesting where im going wrong please
thanks in advance
The most likely cause is that there is no relationship defined between that Start Date and your date dimension. Have a look at the "Dimension Usage" tab in BIDS/SSDT and make sure you have the relationship defined.