I have certain user defined functions in my database.
Can we include User Defined Functions in the Report Model.
Thank you,
Can we include User Defined Functions in the Report Model
Hot Topic
- Xpath/Xquery SQL question
- Microsoft SQL Server 2005 Reporting Services -- Error 1303
- Using a sproc as a source within Dataflow
- Dynamic Connection String
- Detecting an Analysis Service and Uploading a cube during Install
- Service problems after SP1 upgrade
- Management Studio doesn't run!
- Right-Click Table -> Import data GONE??
- How to excute package in sequence
- SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?
SQL Server
- Calculated Measures using AMO
- SELECT in a table takes FOREVER
- Blank Error Messagebox Displayed at startup
- Merge Replication - Weird Conflicts for no reason
- Using Rank() inside a stored procedure
- Sql query for helpdesk application
- Querying multiple tables for rows
- Problem with Stored Procedure
- split partition log files costs too much space.
- Ambiguous Complex Type definition with XML Source. Workaround?
Can we include User Defined Functions in the Report Model
lagu2653
Hi-
You can create custom expressions within a model using any combination of the supported semantic query functions in Model Designer. For example, you could create Employee.BirthWeek in a model by using the semantic query function Week(Employee.Birthday). The Employee.BirthWeek could then be consumed by reports through Report Builder.
However, you cannot create custom functions in code and reference them in a model. The underlying query translator would not be able to translate arbitrary code into T-SQL.
Hope that helps.
Thanks, Jon