Showing posts with label cube. Show all posts
Showing posts with label cube. Show all posts

Friday, March 9, 2012

How to import cube definition from SSAS 2000 to SSAS 2005

Hi.
I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done? Any suggestions would be greatly appreciated!

Regards
Kjetil

AS2005 won't read the backup files produced in AS2000, but AS2005 comes with MigrationWizard.exe that can be used. You will need to:
- have AS2000 running and containing the database you want to migrate
- run MigrationWizard.exe, specify the source AS2000 and then you can decide to migrate directly to an AS2005 or to just generate the migration script (and XML/A script that you can later run on AS2005 with SQL Management Studio)
- you will need to reprocess the database on AS2005

Adrian.

|||Hello Adrian,

I tried your solution but I still have a problem.

In my case the MSAS 2000 (with cubes) is on a separate server. I can connect and start the wizard but when the wizard is checking the data source it fails.

CONFIG:
Server #1: MS SQL Server 2000 (SP4) + MS AS 2000 (SP4)

Server #2: MS SQL Server 2005 + MS AS 2005

I have a local account on Server #1 and a local account on Server #2. Both same name + password.

The DTS-wizard is working fine, but the MSAS migrationwizard not.

Any ideas?

Thanks in advance for any help.
Marco.|||Hi,
The error occurs in the validation page (where there is a tree with the AS2000 objects) or on the next page (migration page - where the script is being sent to AS2005) ?
Can you please post the error ? Or the log if the error occured in the validation page (there are some buttons under the tree, one can be used to get the log).

Thank you,
Adrian Dumitrascu.|||Hello Adrian,

Thanks for your reply.

My first server (SQL 2000), SERVER#1 is on domain AAA.DOMAIN.COM
My second server (SQL 2005), SERVER#2 is on domain BBB.DOMAIN.COM

The message I get is: Source server: The following system error occurred: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Any suggestions?

Why not just easy use the .CAB file?

Thanks in advance,
Marco.|||Thank you!
Sorry for the delayed reply but I'be been rather busy lately.
I am starting on this project next week and will try out your suggestions.

Best regards
Kjetil Smile

How to import cube definition from SSAS 2000 to SSAS 2005

Hi.
I have a SSAS project CAB-file created in SSAS2000 and would like to import/convert it to a SSAS2005 project but I can't find any way to do this... Does anybody know how this is done? Any suggestions would be greatly appreciated!

Regards
Kjetil

AS2005 won't read the backup files produced in AS2000, but AS2005 comes with MigrationWizard.exe that can be used. You will need to:
- have AS2000 running and containing the database you want to migrate
- run MigrationWizard.exe, specify the source AS2000 and then you can decide to migrate directly to an AS2005 or to just generate the migration script (and XML/A script that you can later run on AS2005 with SQL Management Studio)
- you will need to reprocess the database on AS2005

Adrian.

|||Hello Adrian,

I tried your solution but I still have a problem.

In my case the MSAS 2000 (with cubes) is on a separate server. I can connect and start the wizard but when the wizard is checking the data source it fails.

CONFIG:
Server #1: MS SQL Server 2000 (SP4) + MS AS 2000 (SP4)

Server #2: MS SQL Server 2005 + MS AS 2005

I have a local account on Server #1 and a local account on Server #2. Both same name + password.

The DTS-wizard is working fine, but the MSAS migrationwizard not.

Any ideas?

Thanks in advance for any help.
Marco.|||Hi,
The error occurs in the validation page (where there is a tree with the AS2000 objects) or on the next page (migration page - where the script is being sent to AS2005) ?
Can you please post the error ? Or the log if the error occured in the validation page (there are some buttons under the tree, one can be used to get the log).

Thank you,
Adrian Dumitrascu.|||Hello Adrian,

Thanks for your reply.

My first server (SQL 2000), SERVER#1 is on domain AAA.DOMAIN.COM
My second server (SQL 2005), SERVER#2 is on domain BBB.DOMAIN.COM

The message I get is: Source server: The following system error occurred: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Any suggestions?

Why not just easy use the .CAB file?

Thanks in advance,
Marco.|||Thank you!
Sorry for the delayed reply but I'be been rather busy lately.
I am starting on this project next week and will try out your suggestions.

Best regards
Kjetil Smile

Wednesday, March 7, 2012

How to implement cube to ODS jump target reports

I have implemented a few reports against Analysis Services cubes in
reporting services. I have more detailed data contained in the cubes
in the underlying SQL datawarehouse. I have build a couple of reports
in RS against the datawarehouse tables as well. Now I want to link
these together some scenarios are in the cube I am storing data for
each product at a monthly level so if a user select a particular
product and month combination I want to trigger the reports against
the datawarehouse and pass the values like product# and month chosen
in the report against the cube to the report against the datawarehouse
to enable users to see all the data for the month at a more detailed
level.
Please can anybody share thoughts how this can be done in reporting
services. Currently we use Cognos reportnet we can do this we are
trying to migrate from Cognos reportnet to Reporting Services from a
standardisation and cost perspective.
Thanks
KarenAre you trying to link from AS cubes to RS reports through actions?
If you are looking at integrating AS 2000 and RS 2000, you may want to check
the following MSDN article about how to use RS URL access in AS actions:
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp#olapasa_topic8
The good news is that setting up these actions and passing parameters will
be much easier in AS 2005 / RS 2005.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504050456.be5acfb@.posting.google.com...
>I have implemented a few reports against Analysis Services cubes in
> reporting services. I have more detailed data contained in the cubes
> in the underlying SQL datawarehouse. I have build a couple of reports
> in RS against the datawarehouse tables as well. Now I want to link
> these together some scenarios are in the cube I am storing data for
> each product at a monthly level so if a user select a particular
> product and month combination I want to trigger the reports against
> the datawarehouse and pass the values like product# and month chosen
> in the report against the cube to the report against the datawarehouse
> to enable users to see all the data for the month at a more detailed
> level.
> Please can anybody share thoughts how this can be done in reporting
> services. Currently we use Cognos reportnet we can do this we are
> trying to migrate from Cognos reportnet to Reporting Services from a
> standardisation and cost perspective.
>
> Thanks
> Karen|||Rob & Deepak
Thanks very much for the update. This was one of our pressing needs as
business
objects is asking the business to switch from reporting services to
Business Objects.
I must say the support in reporting services for Analysis Services at
this point
please note we are still on SQL 2000 is very limited. We are already
using Reporting
Services and constantly we face issues from people like Business
Objects who are
coming to our IT Managers and recommending to switch from Reporting
Services
to Crystal. Their justification is in Microsoft the reporting services
and
Analysis Services and the Excel teams refuse to talk to each other and
the product
be it Excel reporting or reporting services reporting lack integration
with
SQL & analysis services what Crystal can achieve.
We do not want to move from reporting services the competition
constantly goes to
the business with the story of lack of integration.
Thanks

Friday, February 24, 2012

How to impersonate known user to AS 2000

I am developing an application in C# 2.0 that will access a AS 2000 cube. I want the application to access the cube with a known account. I do not want to use XMLA.

My ConnectionString looks like this:

Data Source=MyServer; Catalog=GL; User ID=ReportUser; Password=mypass

My code looks like this:

AdomdConnection Connection = new AdomdConnection(ConnectionString);
Connection.Open();

ReportUser is a local account on the server. The cube has a single role where ReportUser is a member.

When trying to open the connection I get an exception that the connection was actively refused by the server.

Help?

Thanks

Sorry - you can't do that unless you set up http authentication and use basic auth for your virtual directory. (please use https)

And that takes Enterprise edition in 2000 (but standard in 2005!).