OBIEE 11g Group By

Question

I have a Table with columns

Business_Date
MonthYear
Amount
25-Sep-2016Sep201634325.4526-Sep-2016Sep201642532.3401-Oct-2016Oct201667243.3602-Oct-2016Oct201699347.87

i want to display data in report as like

MonthYear
Max(Amount)
Sep201642532.34Oct201699347.87

i've tried MAX(AMOUNT BY MONTH) but it now works for me

can anyone help me with this.

Thanks in advance,

Uma Mahesh.

Uma Mahesh · Answer

Thanks for your support Thomas

Thomas Dodds · Answer

So you have mixed logical dimensional attributes?   you should have a fact (amount) joined to both a date (year, month, date) and an account (account number, first name, last name, etc) dimension.

OBIEE requires at the very least a well-formed logical star model to perform to its advertised features and performance levels.

Uma Mahesh · Answer

hi Thomas,

Thanks for Quick reply

but i have some dimension columns too in that table like ACCOUNT_NO

what i want exactly is a Report With ACCOUNT_NO filed and MAX of AMOUNT AS Per Dates in a MONTH