sql db UDF as Universe measure object

building semantic layer
1

I have an UDF created on a SQL server which I want to use in a universe measure object.
But here this UDF is built by table columns and varibales like startdate and enddate.

when i insert in report its defaultly calling startdate and enddate where user can enter date range.
here is it possible can i call date objects in UDF? thats fine.but when i want to display
previous month or fiscal year report. how do can i achieve?
do i need to create previous month or fiscal years conditions using calender table columns fields?

any suggestions are greatly appreciated.

Thanks
P

sownu (BOB member since 2009-08-27)

2

Hi guys,
in detail…i’m attaching screenshot.

please your suggestions are greatly appreciated.

Thank you
PV
post.doc (42.0 KB)

sownu (BOB member since 2009-08-27)

3

HI guys,

in betterway my quesiton is like this: how to pass condition values to function parameters?

or
stored function with parameters passed by prompt or condition???

thank you

PV

sownu (BOB member since 2009-08-27)

4

You can call the UDF by passing prompt values (same prompt texts as used in the condition objects)
To do this create an object and try this

 Function_name(@variable('your prompt text'))

.

haider :es: (BOB member since 2005-07-18)