Search found 2 matches

Go to advanced search

by senthil72
Thu Jul 23, 2009 4:32 am
Forum: Business Intelligence (BI)
Topic: Discoverer Query
Replies: 2
Views: 3294

Hi,

You can reframe this query:

Code: Select all

Select Account_id, Max(To_date(Substr(period_name,-6),'MON-YY')) PERIOD from GLFV_ACTUAL_BALANCES
where account_id = 1100
group by account_id

Only thing you will have problem in Adj-Dec-07, Adj-Dec-08 values..

Regards,

Senthil K
by senthil72
Thu Jul 23, 2009 4:22 am
Forum: Business Intelligence (BI)
Topic: need help ..Function in Discoverer
Replies: 3
Views: 3477

Hi,

Let us know some example, what exactly you are looking for?

Regards,

Senthil K

Go to advanced search