Deployment Issue

We have a requirement to display some 80,000 records in the report. The Stored procedure in the back end is displaying results in less than 2 mins..but the system hangs when we run the report.

Any work around for this strange behaviour?

When you run a report, not only do you have to collect the data, you also have to render the report, 80K records is 800 pages if you have 100 records per page.

What happens if you run the report as a scheduled report, and set the run time to the middle of the night when database and report server activity is low?

Deploying an Assembly in "Analysis Server" through Code

Hi,

I have a requirement wherein I have to deploy an assembly in "Analysis Server" through Code. I tried using "CREATE ASSEMBLY .... " which works fine with Database Server, but is not being recognized as a command in "Analysis Server".

Is there any other way of doing this except the Wizards.

Thanks!!

You could go a couple of routes...

1. XMLA - If you add an assembly via Management Studio and click the Script button at the top of the dialog, you'll see the XMLA for adding an assembly. Then you will need to figure out how to encode the bytes of your DLL as it expects and create your own XMLA request.

2. AMO - If you use Analysis Management Objects, you can do this through an API and don't have to mess with XMLA.

I would suggest #2. I haven't seen code to do exactly this. But there is some open source code to do the reverse (inspect a deployed DLL) which might help you get a feel for the AMO objects you'd use:

http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=ListFunctions&referringTitle=Home

Hope that gives you enough info to get a little further than before. Post back here if not.

Deploying an Assembly in "Analysis Server" through Code

Hi,

I have a requirement wherein I have to deploy an assembly in "Analysis Server" through Code. I tried using "CREATE ASSEMBLY .... " which works fine with Database Server, but is not being recognized as a command in "Analysis Server".

Is there any other way of doing this except the Wizards.

Thanks!!

You could go a couple of routes...

1. XMLA - If you add an assembly via Management Studio and click the Script button at the top of the dialog, you'll see the XMLA for adding an assembly. Then you will need to figure out how to encode the bytes of your DLL as it expects and create your own XMLA request.

2. AMO - If you use Analysis Management Objects, you can do this through an API and don't have to mess with XMLA.

I would suggest #2. I haven't seen code to do exactly this. But there is some open source code to do the reverse (inspect a deployed DLL) which might help you get a feel for the AMO objects you'd use:

http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=ListFunctions&referringTitle=Home

Hope that gives you enough info to get a little further than before. Post back here if not.