Using SQL Server scalar functions as values for Stored Procedures in FM

[brianmangan]

Hello all!

I am trying to use some UDFs (scalar) as values for stored procedures.

Setup:
Cognos BI: 10.2.1 All components installed on the same server
Database: SQL Server 2008, connected with SQL Server 2008 native client and MSFT JDBC 4.0
Query Processing: Limited Local

Model:


Query Subject (stored procedure imported via Metadata Wiz):


Imported Functions (MDW):


Exemplar Scalar Function:


Situation:
- I am not a cognos developer, just the poor schmuck stuck with this task.
- I officially have 3 days of cognos experience. Everything you see here is my own handywork, would love general feedback.
- We have to use these stored procedures
- We have to use these UDFs, yes we could write them in cognos and call it a day, DBAs are jerks.

Steps taken so far:
- Created a stored procedure that returns a single row table with the date values
- Created a bunch of calculations that pull the values from the UDFs

Possible ideas?:
- Macro calculation in the Query Subject definition for the values (what syntax?)
- Relationship (no workie)

Question:
How the heck do I get these damn Query Subjects that are modeled off of stored procedures to accept UDF scalar values?