thank You Steve,

But what would be the mdx query?

I tried,

SELECT NON EMPTY { [Measures].[Sales] } ON COLUMNS, NON EMPTY { ([Dim Employee].[Franchise Name].[Franchise Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME...

when i added the campaign key to the fact table i got the data between start and end date.

But now i want the data between precampaigndate and start date

I tried...