Calling sql server funciton in universe measure object

[Former Member]

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

[CdnConnection · Accepted solution]

Narendar,

     If you want to use SQL functions, you best bet is to create Derived Table and then add it to the structure so it can be used with the other Dimensions.

Regards,

Ajay