creat a solution in SQLServer 2005 and intall that solution in SQLServer 2005 Express

Hi,

can i develop a solution in SQLServer 2005 with the analysis Services (OLAP cubes) and then put that solution in a client that only have the SQLServer 2005 Express?

Thaks

Larokas

Analysis Services are not part of SQL Server 2005 Express installation.

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

cr90devwin_en.exe error

Hello,

In our organization we are using a mat work a client registration software.
To generate reports there we are using the Crystal reports.
De client registration application running on 4 Citrix servers.
Last month after an abdate of the application there were problems with the reporting system.
The advice of the application liverancier was the installation of the (cr90devwin_en.exe). I have installed the exe on 3 servers without problems and the problem is resolved.
When I run the exe on the fourth server he begins with the stopping of the www, smtp and IIS manager services, and then I am getting the error message (can not create backup folder). check the attachment

Maybe you know how can i solve this problem.

Thanx in advanceSee if you find answer here

http://support.businessobjects.com/

CR9 Runtime Components ?

Dear All,
I developed an application in VC++ 6.0 with Crystal Reports 9.0.

Now i want to deploy my application on client machine but i don't now what components (files, dll) of CR are required to register or deploy with my application.

Would some body please help me, its really very urgent.Hi! All!

I'm aslo having the same problem in CR9 Runtime Components in Client machine.

I'm using VB 6 & Crystal Reports 9.

What are all the CR9 componenets or dll files need to be installed in Client machine?

Please if anyone help me to solve this problem.

Thanks.

-Raja|||Visit the next urls -->

http://support.businessobjects.com/communityCS/TechnicalPapers/rdc9_deployment.pdf.asp

http://support.businessobjects.com/documentation/installation_resources/crystal_reports/cr9.asp

CPU Usage on AS 2005 Server

I have 5 cubes with 15 dimensions and one cube (like Virtual cube before) with 5 linked cubes.

My client is Excel 2003 Pivot table.

From Excel/Pivot table if I run a query which is taking long time. I press "Esc" key to cancel my query. However if I look into my Server "CPU Usage" even after canceling my query is very high. Looks it doesn't cancel my query on server. I am the only user using this server.

If I restart my Analysis Services 2005 the CPU Usage drops in 90 degrees to almost 0%.

Where is the problem any idea?

Thank you - Ashok

Looks like you have a classic case of "runaway query". It is always hard to get to the bottom of who sent the query and why the query is running that long.

Oten the one of the better recommendations for improving query performance and therefore improving responcivness of your cube is to desing aggregations. Aggregations are the key to Analysis Services performance.
Try and run Aggregation Design wizard and create aggregations for your cube. On top of that you can capture queries sent in the query log and then use Aggregation Manager sample application to desing aggregations supporting exact set of queries.

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

|||

In other words how to cancel/kill these "runaway query" without restarting server?

I do have aggregation setup. In SQL Server database we can kill any running query... can we do same in Analysis Services?

|||I had the same problem, if you run a query and you close the tool executing it then the query will still keep on running and slowing down the system. I don't think you can kill it. Maybe you can try to set the timeout much lower so that it will kill any query running longer than 30 seconds. I'm not sure if this will work but it should sure prevent the query of running longer than 30 seconds protecting the server from a resource eating *** query from hell.

|||

you can use the MSAS Activity Viewer tool and you can kill sessions.

|||

What is MSAS Activity Viewer tool ?

CPU Usage on AS 2005 Server

I have 5 cubes with 15 dimensions and one cube (like Virtual cube before) with 5 linked cubes.

My client is Excel 2003 Pivot table.

From Excel/Pivot table if I run a query which is taking long time. I press "Esc" key to cancel my query. However if I look into my Server "CPU Usage" even after canceling my query is very high. Looks it doesn't cancel my query on server. I am the only user using this server.

If I restart my Analysis Services 2005 the CPU Usage drops in 90 degrees to almost 0%.

Where is the problem any idea?

Thank you - Ashok

Looks like you have a classic case of "runaway query". It is always hard to get to the bottom of who sent the query and why the query is running that long.

Oten the one of the better recommendations for improving query performance and therefore improving responcivness of your cube is to desing aggregations. Aggregations are the key to Analysis Services performance.
Try and run Aggregation Design wizard and create aggregations for your cube. On top of that you can capture queries sent in the query log and then use Aggregation Manager sample application to desing aggregations supporting exact set of queries.

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

|||

In other words how to cancel/kill these "runaway query" without restarting server?

I do have aggregation setup. In SQL Server database we can kill any running query... can we do same in Analysis Services?

|||I had the same problem, if you run a query and you close the tool executing it then the query will still keep on running and slowing down the system. I don't think you can kill it. Maybe you can try to set the timeout much lower so that it will kill any query running longer than 30 seconds. I'm not sure if this will work but it should sure prevent the query of running longer than 30 seconds protecting the server from a resource eating *** query from hell.

|||

you can use the MSAS Activity Viewer tool and you can kill sessions.

|||

What is MSAS Activity Viewer tool ?

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and online
jobtracking for are websites.
If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and onlin
e
jobtracking for are websites.If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.

CPU or Client Version

We will use are SQL server as a search engine for are clients docs and online
jobtracking for are websites.If you are asking what licensing model to use, you will probably have to use
per processor. I base that recommendation on the fact that you mention that
youe clients are accessing SQL Server through your websites.
--
Keith Kratochvil
"George" <George@.discussions.microsoft.com> wrote in message
news:B37091AA-C4D4-48A9-8270-6FBDCCA815F2@.microsoft.com...
> We will use are SQL server as a search engine for are clients docs and
> online
> jobtracking for are websites.

Coverting mixed case data to UPPERCASE

I am trying to convert all my client first and last names in my table to uppercase. They are currently listed as mixed case. Also I wanted to know what is the best way to force the data to UPPERCASE hwen a end user tries to insert or update the clients name. I am thinking about trying a trigger, but I am unsure how to set it up. Thanks for all the help.upper (COLUMNNAME) ?|||I tried your suggestion and it fixed my first issue, but now I have to figure out how to force the data to be uppercase whenever the user inserts/updates a client name. I would like to do this in a BEFORE trigger. Can anyone suggest a way for me to do that. Thanks.|||ahhhhh...smell the Oracle background...

nope INSTEAD of AND AFTER Triggers...

Have you thought about a constraint?|||User updating the column through the application or through QA ??
if application then
update table_name set column_name = upper(variable_here) will do

if you want a trigger
see instead of triggers in BOL ...

Couple of Questions about RS2005

My client was using Reporting Services 2000, but is currently leaning toward
Crystal Reports XI. The reason being is that most of their data is filtered
through DLLs providing business logic. In RS2000, the only way to use the
DLLs as a data source was to write an extension and essentially hard code
the calls to methods and parameters inside the extenstion. Their complaint
was that every time they had to add something they had to recompile the
extension, send it to the server admins, wait for installation and so on.
With CRXI, all they had to do was point to the DLL as a data source and they
were prompted for the method to use as well as paramters and so on. Is
something like what CRXI (and CRX for that matter) provides in RS2005? Can
they use a DLL for a Datasource without writing a wrapper every time?
On a second question, another client of mine is using SQL RS2000 with
Oracle providing the data for the reports and VS 2003 as the application.
We are late in the developement of the application but are considering
upgrading to RS 2005. I have been unable to give them several reasons why
upgrading to RS 2005 would benefit them, since i can only see a few
drawbacks. One drawback is that they would have to use a seperate IDE to
create the reports (the VS2005 like IDE). One thing they liked was the
ability to run ad-hoc reports and use an embedded viewer instead of a web
browser (we currently have IE embedded in the app to display reports). I am
under the impression that the Report Viewer component will only work with
VS2005 (.NET 2.0). Is this correct? Is there any way to use the component
with VS 2003 and .NET 1.1? We can't upgrade the app to 2005 anytime real
soon. Also, a list of benefits to RS 2005 would be greatly appreciated.
Thanks,
Rob Edwards
For the first question, I don't see why you need to hard code the method calls. for the query language for their data extension, they can use a syntax like:

class.method (parameter1, parameter2)

They can parse the call, load their assembly, use reflection to grab the class definition and execute the method (look at Type.GetMethod) using the parameters. The extension never needs to change, just the business object.

For the second question, the ReportViewer controls don't work with VS 2003. You can, however, use VS 2003 to publish to RS 2005. You won't get any of the new report design features (multi-value parameters, end user sort, etc.) until you move to VS 2005.