I am calling a sql server function in universe/object, which returns a measure value based on provided date as input for that function.
I am using that measure at report level and its giving the expected value. When i am using same object with any dimension report is running continuously without giving any result.
When the measure data is aggregated by any dimension report is running continuously.
SQL code like:
select A.State, fnRevenue(A.Valuationdate) from Table A
where A.Valuationdate = '31/12/2012'
When I am aggregating reveue data with state dimension report is running continuously without any progress.
Please help me