-
Date filter
hai all
i am now facing a problem with date range problem
i want to give a date range dynamically for that i have gave it as a member. but it dont gives the previous year member data. my query is here (food mart)
WITH MEMBER [Time].[Condition] AS 'AGGREGATE([Time].[1998].[Q1].[1] : [Time].[1998].[Q1].[2])'
MEMBER [Measures].[Prev Amt] AS '( [Measures].[Amount], Time.PrevMember)'
SELECT { [Measures].[Amount], [Measures].[Prev Amt] } ON COLUMNS,
[Store].[Store State].MEMBERS ON ROWS
FROM Budget
WHERE ([Time].[Condition])
if i gave Time.1998 here, it would give me the correct result
thanx in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|