June 11, 2003 at 5:07 pm
We wanted to use one of these functions (PV) as part of a query.
From the BOL it seems that a) I need analysis services installed on the SQL Server and b) I install Excel on the same machine.
Can I then use the functions within normal SQL queries or do I have to use them within the analysis process - ie build cubes with the functions within.
Thanks in advance.
June 16, 2003 at 8:00 am
This was removed by the editor as SPAM
July 1, 2003 at 8:35 am
Not sure about using the Excel functions in TSQL, but to use them in AS, you do need Excel installed.
If you're wanting to use PV in TSQL you could wrapper the excel function libray in your own library, then bring it in as an extended stored procedure. This seems [to me anyway] like a long (hard) way around it. Maybe try posting this query in the T-SQL forum.
Steve
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply