Skip to Content
0
Former Member
Apr 07, 2013 at 04:45 PM

Calling sql server funciton in universe measure object

20 Views

Hi All,

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

Thanks,

Narendar