Last 4 weeks from the list in the designer.

building semantic layer
1

Hi team,

I have a query like
select max(FRD_DIM_STK_DATE.TXN_WEEK) from FRD_DIM_STK_DATE
and the reult of this is 2009-33,
Now, how can i modify my query to get the values of 2009-29,2009-30,2009-31,2009-32,2009-33.

Here TXN_WEEK is the character date filed.

Many thanks for your cooperation and help.

Sreenivas

sreeb (BOB member since 2009-01-05)

2

Have you tried the TOP keyword?

SELECT TOP 5 FRD_DIM_STK_DATE.TXN_WEEK
FROM FRD_DIM_STK_DATE
ORDER BY FRD_DIM_STK_DATE.TXN_WEEK DESC

Lugh (BOB member since 2009-07-16)