AS2005 Redistributable DLLs

I am referencing Microsoft.AnalysisServices.dll in my C# project to get to the sweet AS2005 object model for automated cube processing among other things but know I need to start getting the deployment of these DLLs figured out for client releases. Currently our installs are deployed to relative paths on the client machines and we have avoided any GAC installations. So my questions revolve around - Are we free to redistribute the Microsoft.AnalysisServices.dll? What other dependencies does it have or redistribution requirements Microsoft may have for it

Thanks in advance for any help or if someone could point me into the correct direction

PS - I have been extremely impressed with the programmability and ease of deployment of AS2005 databases in these latest revs - well done, I am a huge fan of the toolset and the exposed technology.

Brad Osterloo

Probably Microsoft.AnalysisServices.XmlaClient.dll will be enough.|||

1. Microsoft.AnalysisServices.dll does't depends on Microsoft.AnalysisServices.XmlaClient.dll

2. If you want to have a compression in XMLA over TCP, your schould have msasxpress.dll

in %PROGRAMFILES%\Microsoft SQL Server\90\shared\

|||

It took me a bit while before I looked at your thread.

I would try and explan the general policy for redistibuting Analysis Services components:

You cannot redistibute any single file, or group of files with your application. It is going to create huge mess of files with different versions copied all over on user's machine. Also known as: "dll hell".

To redistribute Analysis Services functionlity you should use Redstributable packages found on http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

The one you need in this particular case is "Microsoft SQL Server 2005 Management Objects Collection "

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

|||OK, Thank you Edward for your response. Much appreciated.

AS2000 - Different default dimension member according to cube

Dear all,

Is it possible, in AS2000, to choose a different default dimension member according to the cube we are looking at? I'm in a project where the Accounting cube should open on the last closed month and the sales cube on the current month. Is this achievable?

Regards,

Pedro Martins

Portugal

Hello. This is from my(weak) memory. If this is possible in SSAS2000 you should be able to set the default member on the dimension in the cube editor.

Have you checked this?

I do not think it is possible if you use a shared time dimension in two cubes. I think that you set the default member in the dimension editor(advanced properties).

One solution is to build two separate time dimensions, shared or cube.

Another approach depends on if you have a third party tool for building reports on top of SSAS2000, like ProClarity. If this is the case you can build two different named sets in each cube(on the same shared dimension) that points to the different default members, and use them in the tool.

Regards

Thomas Ivarsson

AS/400 with Arabic Code Page (420)

Hi yeah.

I am doing a project which retrieves data from a AS/400 machine.
The code page of the machine is 420.
I used "OLE DB\IBM DB2 UDB for iSeries IBMDASQL OLE DB Provider" to connect from SQL Server.
The problem is, all the arabic characters coming from this machine becomes unreadable, becoming some machine code text.
What could be the problem and how can I solve this?

Thank you.

Did you try setting the code page value explictly in your ole db source connection?

Thanks

|||

Yes, I'd try to set to 420 in my OLE DB connection, but it still does not work.

I had tried putting nvarchar, add the data conversion in between, using various drivers, ODBC, OLE DB, DB2, iSeries driver, forcing CCSID in AS/400 machine and still unable to extract the data properly.

Would it be the AS/400 problem or my SSIS setting problem?

AS Processing Task

When using the AS processing task with a connection to "an Analysis Services project in this solution", only some processing options are available for processing dimensions. For instance, it is not possible to select "Process Update". Once I change the connection manager to point to the deployed cube database, I can choose from all the options. Is this by design?I have searched the documentation and the net for information on this. I have not been able to find an explanation. Anyone? At all?

'AS IS' Upgrade from SQL 2K to SQL 2K5

My advice is to do functionality or, preferably, load testing in a dev\test
environment. As well as create a detailed project plan. I have run into a
lot of issues with upgrades but the clients that did throrough testing made
the fixes a part of the project plan instead of a Monday morning fire fight.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"sacgar" <sacgar@.discussions.microsoft.com> wrote in message
news:8D9F1A4F-B591-4E8D-8F63-0ACF2D0ED91C@.microsoft.com...
> Hi ,
> We are planning for ‘in place’ SQL Upgrade from SQL 2000(Ent. Edition with
> SP4) to SQL 2005 Ent.Edition with SP2 for
> 1)Replication Distribution Server that serves to PULL subscriptions.
> 2)One for the Subscriber Cluster (Active Passive)Server (its distribution
> server already upgraded to SQL 2005)
> We have gone through the requirements from Microsoft Technical Resource
> Guide but looking if somebody had any issues or any advice other than
> Upgrade
> Advisor reported before we move for Upgrade for both of above cases as
> some
> people indicated they had issue with Password Policy , Appreciate your
> reply…
>
Please go through the below article as I have faced this issue , check if
applicable in your scenario...
Thanks
Ajay
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:26E92972-53B2-4063-8D68-24B72C69FB94@.microsoft.com...
> My advice is to do functionality or, preferably, load testing in a
> dev\test environment. As well as create a detailed project plan. I have
> run into a lot of issues with upgrades but the clients that did throrough
> testing made the fixes a part of the project plan instead of a Monday
> morning fire fight.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "sacgar" <sacgar@.discussions.microsoft.com> wrote in message
> news:8D9F1A4F-B591-4E8D-8F63-0ACF2D0ED91C@.microsoft.com...
>
|||Sorry Missed this link earlier
Please go through this link for DB Move
http://support.microsoft.com/kb/314546/
Thanks
Ajay
"Ajay" <ajudba@.gmail.com> wrote in message
news:OsXeYk0ZIHA.4272@.TK2MSFTNGP05.phx.gbl...
> Please go through the below article as I have faced this issue , check if
> applicable in your scenario...
> Thanks
> Ajay
> "jason" <jason-r3move@.statisticsio.com> wrote in message
> news:26E92972-53B2-4063-8D68-24B72C69FB94@.microsoft.com...
>

AS 2005 browse cube problem

I have successfully deployed an Analysis Services Project on Analysis
Server 2005 with SP1. However, when I try to browse the cube using
either BI studio or SQL Server management studio, everything stucks.
Dimensions browsing and cube processing works fine!
Any ideas?
Thanks, MakisYou can use Profiler to trace against Analysis Services with 2005. I suggest
you give that a try to examine what is happening behind the scenes
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@.MutuallyBeneficial.com
<gmarketos@.gmail.com> wrote in message
news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...
>I have successfully deployed an Analysis Services Project on Analysis
> Server 2005 with SP1. However, when I try to browse the cube using
> either BI studio or SQL Server management studio, everything stucks.
> Dimensions browsing and cube processing works fine!
> Any ideas?
> Thanks, Makis
>|||Thank you David for your answer.
After all I realized that my firewall created the problem.
Makis
David Lundell wrote:[vbcol=seagreen]
> You can use Profiler to trace against Analysis Services with 2005. I sugge
st
> you give that a try to examine what is happening behind the scenes
> --
> David Lundell
> Principal Consultant and Trainer
> www.MutuallyBeneficial.com
> David@.MutuallyBeneficial.com
> <gmarketos@.gmail.com> wrote in message
> news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...

Articles on SQL Server capacity

I have been doing some reading for a project comparing various RDBMS and I
have read that SQL Server is not very stable for DBs over 300GB but I have
also read about terrabyte-plus databases running just fine. Are there any
recommendations or articles from Microsoft about the capacity of SQL Server
(2000 or 2005)?Hi
Probably you can check this:
http://chanduas.blogspot.com/2005/05/maximum-capacity-specifications.html
please let me know if you have any questions
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Robert Kinesta" wrote:
> I have been doing some reading for a project comparing various RDBMS and I
> have read that SQL Server is not very stable for DBs over 300GB but I have
> also read about terrabyte-plus databases running just fine. Are there any
> recommendations or articles from Microsoft about the capacity of SQL Server
> (2000 or 2005)?|||> I have read that SQL Server is not very stable for DBs over 300GB
Sounds like either advocacy or marketing misinformation. I have worked
on and know of many SQL Server databases that are much larger. Equally,
bad design or improper hardware can defeat a database of any size.
Take a look at:
http://www.microsoft.com/sql/techinfo/administration/2000/scalability.mspx
--
David Portas
SQL Server MVP
--

Articles on SQL Server capacity

I have been doing some reading for a project comparing various RDBMS and I
have read that SQL Server is not very stable for DBs over 300GB but I have
also read about terrabyte-plus databases running just fine. Are there any
recommendations or articles from Microsoft about the capacity of SQL Server
(2000 or 2005)?
Hi
Probably you can check this:
http://chanduas.blogspot.com/2005/05...fications.html
please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
"Robert Kinesta" wrote:

> I have been doing some reading for a project comparing various RDBMS and I
> have read that SQL Server is not very stable for DBs over 300GB but I have
> also read about terrabyte-plus databases running just fine. Are there any
> recommendations or articles from Microsoft about the capacity of SQL Server
> (2000 or 2005)?
|||> I have read that SQL Server is not very stable for DBs over 300GB
Sounds like either advocacy or marketing misinformation. I have worked
on and know of many SQL Server databases that are much larger. Equally,
bad design or improper hardware can defeat a database of any size.
Take a look at:
http://www.microsoft.com/sql/techinf...alability.mspx
David Portas
SQL Server MVP

Articles on SQL Server capacity

I have been doing some reading for a project comparing various RDBMS and I
have read that SQL Server is not very stable for DBs over 300GB but I have
also read about terrabyte-plus databases running just fine. Are there any
recommendations or articles from Microsoft about the capacity of SQL Server
(2000 or 2005)?Hi
Probably you can check this:
http://chanduas.blogspot.com/2005/0...ifications.html
please let me know if you have any questions
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Robert Kinesta" wrote:

> I have been doing some reading for a project comparing various RDBMS and I
> have read that SQL Server is not very stable for DBs over 300GB but I have
> also read about terrabyte-plus databases running just fine. Are there any
> recommendations or articles from Microsoft about the capacity of SQL Serve
r
> (2000 or 2005)?|||> I have read that SQL Server is not very stable for DBs over 300GB
Sounds like either advocacy or marketing misinformation. I have worked
on and know of many SQL Server databases that are much larger. Equally,
bad design or improper hardware can defeat a database of any size.
Take a look at:
http://www.microsoft.com/sql/techin...calability.mspx
David Portas
SQL Server MVP
--

Arkhan:Re: putting dbo explicitly in select staetement

I have witten a lot of stored procedures in my project where I did not put dbo before the user tables.My colleague told me that I have to put dbo for all statements other there could be a problem.

Any thought?,

Please assist.

Arkhan:

There are at least a couple of places in which the owner name prefix -- dbo -- is required including (1) naming of a scalar functions and (2) objects used with schemabinding. In addition, if your "shop standards" are to always designate object names with the owner name then you need to do so.

I can think of at least one situation in which I prefer that objects NOT be owned by dbo. This is at least somewhat controversial so take it with a grain of salt. In DTS "staging" tables I like to have a designated table owner so that that owner has the right to truncate the table without needing the database owner privilege. This does not figure to be relevant to your problem. It is good practice to include the owner name as part of your qualified name. One thing that worries about your question has to do with the practice of deployment of privileges.

I do not like it when I see scores of tables or other database objects that are owned by many different database users. When I see this type of stuff my knee-jerk reaction is that privileges are beging deployed to liberally. And I would guess that if you and your colleagues are seeing many problems from NOT including the owner name that you likely have this privilege problem.

Short answer: Include the dbo portion of the name.

Dave

|||

I've heard it said that not including the schema owner (usually DBO) on your object prefix can result in a "Compile lock" against your stored procedure while the client determines whether there is an object in existence for its own schema. In this situation, multiple users executing the same stored procedure would suffer from a queuing effect as each would place a compile lock on the procedure (or statement).

That being said, I've never been able to repro this is a testing environment and I have yet to see any white papers or KB articles that discuss this so I'd love it if somebody could chime in on this.

|||

Specifying the owner can help the system find the stored procedure faster. It also prevents issues if someone creates the same name procedure with a different owner (or schema in 2005) by mistake. At least if everyone uses two-part names, they will be less likely to make mistakes.

As for the compile locks, I have reproduced recompile locks in my stored procedures. I'm not 100% how I did it, but it seemed to be with temporary tables stored procedures. I added dbo in the front of each stored procedure and table name within the stored procedure and it elliminated most of the problems we had.