Help-Forecasting Model Viewer

Hi,
I am working in Share point service now.

I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.

My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!

Was your question answered in the newsgorup, or do you still need more information?

Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.

|||

Hai,

I used pivot table OWC to show my data.

Unfortunately, it doenot work with DMX query.

But spreadsheet OWC accepts DMX query. why not pivot table?

I need some solution to run my DMX query and give as input to my chart/pivot control.

plz help me.

its urgent

Tx in advance.

|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot table

Help-Forecasting Model Viewer

Hi,
I am working in Share point service now.

I created a website using share point.
I worked in mining algorithms in sqlserevr 2005.
I am able to view scorecard, BIP in my website.

My Question is:
I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.
I need viewer to view my forecasting model, I created.
Plz suggest me any viewer like DataAnalyzer, to view my forecasting model.
Tx in Advance!

Was your question answered in the newsgorup, or do you still need more information?

Realistically you can use any charting control and simply query the model for the data if the redistributable viewers don't work for you.

|||

Hai,

I used pivot table OWC to show my data.

Unfortunately, it doenot work with DMX query.

But spreadsheet OWC accepts DMX query. why not pivot table?

I need some solution to run my DMX query and give as input to my chart/pivot control.

plz help me.

its urgent

Tx in advance.

|||You will have to write some custom Excel code (you can find samples on sqlserverdatamining.com) to execute the DMX query and put it in a worksheet. Then you can put the result into an Excel pivot table

HELP: Connecting to a secure file share using DTS

I have a dts package that works in connecting to a secure file share when I run it manually. When I schedule it to run on its own - it fails due to the lack of a log on. Is there something I can do to initiate the log in via the schedule rather than me manually doing it ?

Thank you!

When you run it manually, it's executing under your security context. When you schedule it, it will run under the security context of SQL Server Agent service account if the job is owned by a sysadmin. You need to grant the SQL Agent service account permissions to the share. The following article explains this issue:

INF: How to Run a DTS Package as a Scheduled Job

http://support.microsoft.com/kb/269074

-Sue