changing the RDL at run time

Does the RS need RDL once the report is deployed. I need to change the RDL at
run time.Although there is no rdl file on the webserver, when you deploy it the rdl
gets stored in the database. The database is where RS retrieves the report.
If you change the rdl at runtime you have to deploy the report before it can
be viewed. This is possible but keep in mind, you would need to uniquely
name the report for the current user you are modifying the rdl for otherwise
if two people try to view the same report they will see whichever was the
latest you modified and deployed. Most people that do this are using web
services to accomplish this. Although doable it is non-trivial. I would make
sure that there is not some other way around your problem before going this
route.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vcs" <vcs@.discussions.microsoft.com> wrote in message
news:00D56442-ABC3-48E9-9BE7-285198BA14C2@.microsoft.com...
> Does the RS need RDL once the report is deployed. I need to change the RDL
at
> run time.

Changing MOLAP dimensions to ROLAP

I have a working SSAS 2005 cube running against a small SS2005 database and successfully deployed so that it can be seen across the internet, and Excel 2002 or 2003 with the correct OLEDB provider installed can view the cube in a pivot table.

I want to be able to demonstrate that the cube dynamically updates when the underlying data changes.

I have therefore changed the measure partition to ROLAP, and now realise that I need to change the dimensions to ROLAP too. I have changed all except one of them successfully. Trying to change the last one causes SSAS2005 to crash during deployment, apparently with no explanation.

On some occasions, deploying the cube reports error:

Internal error: An unexpected error occurred (file 'mdhierarchy.cpp', line 3142, function 'MDUnmaterializedHierIter::Init'). 0 0

rather than killing SSAS2005.

If I try to specify Proactive Caching for this dimension, it gets very confused, because it reports it as a MOLAP dimension, when it isn't.

The dimension it is getting upset about accesses the database through a view.

Has anyone else run into this? If so, what can be done about it? It looks like I have found a bug in SSAS2005.

Have you tried installing SQL Server 2005 service pack 1 to see if you still get the same problem there? http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

If this is not working, please try and contact Customer Support to report the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights

|||

Dear Edward,

Thanks for the suggestions.

The problem has shown up after upgrading to SP1, so I will have to take up your suggestion of contacting Customer Support.