Can''t Deploy Cube SSAS step by step

Hi,

This is extremely frustrating, I really hope someone can give me a hand.

I've just completed all the steps from the book and clicked deploy. I was asked for a password and since it wouldn't accept blank I entered a string.

This apparently was a big mistake as i got the

"Error 1 Parser: The syntax for the ImpersonationInfo object is incorrect. If the ImpersonateAccount value is used for ImpersonationInfo, then the Account property cannot be empty."

message. Now I don't know what to do next.

2 questions:

1. How do I change the fake password I entered?

2. What do I need to do to make the process work.

Thanks,

Y.

in visual studio AS, right-click in the datasource and there is options relatite to this subject, like using the service account or a specific user to deploy the cube...

helped? if not, I could give you more specific answer!

Regards!

|||

hanks Pedro,

I managed to change the password using your instructions.

Best,

Yaniv.

Can't deploy a cube project to the Analysis Server using BIDS

I am working through the Microsoft SQL Server 2005 Analysis Services Step by Step book and I can't deploy the first cube project to my Analysis Server from my workstation.

I have a server running Windows 2000 Server SP4 and a laptop running Windows 2000 Pro SP4. On the server I am running SQL Server 2005 SP2 complete installation, including workstation components. On my laptop I am running SQL Server 2005 SP2 workstation components.

I have used the Cube Wizard to create a cube without a Data Source (as described in Chapter 3) and then used the Schema Generation Wizard to create the schema which I then populated with data.

When I go to Deploy the cube using BIDS I see the status bar message Build started... and then Deploy started... and then I get an error that says The connection either timed out or was lost.

If I perform the same actions on the server so that BIDS is running on the server and all connections are to localhost the deploy works and I can then browse the cube.

From my laptop I can see all the AS objects on the server through SSMS, including the AS database I created from the server.

Thinking that there maybe some incompatability between the software on my laptop and the server, I did a clean install of the workstation components to a new machine, created a new project and I still get the same error.

I have followed all the advice from Resolving Common Connectivity Issues in SQL Server 2005 Analysis Services Connectivity Scenarios (http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/cisql2005ascs.mspx) but I have not found any solution yet. I also tried increasing the connection and query timeout properties in BIDS (Tools/Options/BI Designers/AS Designers) - that didn't work either.

Really stuck now and any help would be greatly appreciated.

TIA
Caryl Wills
Hi,

U need to test the connectivity. Once u pass this test, u will be able to deploy the cube. On the deployment configuration window, make sure u properly give the name of the Server where u want to deploy. Else create the script file and execute it from the Management Studio..

Hope this will help

--Imran|||Hi Imran,
Thanks for your suggestions. I am trying to test connectivity and now seem to have a problem creating an Analysis Services database from my client computer. In SSMS Object Explorer I have the Analysis Services server. If I right click the 'Databases' node and select 'New Database' and then fill in the dialog with a unique database name and Impersonation set to 'Use the service account' and click OK the progress wheel just goes forever. Restarting the Analysis Services service is required to stop the process.

How do I trace the process and do you have any idea what might be preventing it from working?

Thanks for your help.
Caryl
|||Thanks for your help folks - all problems now solved by shutting down ZoneAlarm on server. For some reason ZoneAlarm will not allow connections to Analysis Services over my LAN even though the firewall is turned OFF for the trusted zone.

cant create object on sql server

When i try to deploy my project or the cube within it i first i get a message 'The server content appears out of date'

then in the error list it tells me 'user does not have permission to create object on [servername] or object does not exist.

Why is this?

Should i create a database first in sql managment studio with a particular name, the name of the project for example. I have tried different impersonation modes...

What login account does analysis services run under when it tries to connect to deploy?

Does it try to create an analysis services database?

Any advise or pointers would be greatly appreciated. Thanks alot.

Jules

The project deployment in BI Dev Studio is happening under your account. You need to have administrative rights ( in many cases ) to deploy your project.

By default all local machine Administrators are also administrators of Analysis Server.

Check check your project properties to see which server you deploy your project to.

You can also open SQL Management studio to see the state your database after your deployed it to Analysis Server.

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

Can't Create cube

Is there is a way to create cube against database which tables get new records every few seconds?

I get these errors

Thanks in advance

Warning -2128674815 : Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_Log, Column: InsertDate, Value: 2/23/2007 9:22:32 AM.

Thanks in advance

Hello. I have not build anything like this but my guess is that you will have to use ROLAP for dimensions and Measure Groups.

The error you see probably depends on that you have a MOLAP cube where the dimensions have not been processed before the partitions/measure groups.

Keep your datamart in the relational engine is my recommendation. Five seconds is a very short batch window. I suspect that you have a cube directly on top of an OLTP-system.

Maybe Notification Services is a better choise than SSAS2005?

Regards

Thomas Ivarsson

|||

You'll need to update the time dimension and your data incrementally and "lock" the database updates while the update is being performed (to maintain consistency). This'll take some careful consideration of your partitioning scheme, to make sure you maintain a reponsive system.

How often do you need to update the cube? Could you consider doing the following steps:

a) materials the dimension information into a "Time" table

b) use a view "dbo_Log_view", that joins to the "Time" table to only return records that exist in the "Time" table. (Alternatively, you could do the same on the partition SQL statement, but I recommend abstracting it to the view.)

c) Process the cube / partition incrementally?

Note: You could set this up in a SQL Agent job, to run as a two step process automatically.

|||

Thank you guys.

I will have to carefully review all the options. Thank you for all suggestions.

Best Regards,

|||I think you need Integration Services for this. I haven't figured it out myself yet, but I need to make this too, and I came across functions in SSIS wich seemed to be usefull to accomplish this.

Regards,

Eyso

Can't connect to data source

I've got a report (2005) that is sourcing from an AS2000 cube. Everything works fine in the BI Dev Studio, it builds and deploys without a hitch. The report has a shared data source and is using a generic login (i.e. it's not set to my NT login).

However, when I navigate to the Report Server and try to run the report, I get the following error message...

Cannot create a connection to data source

On the Report Server, I'm using the same credentials that I used in BIDS. I've tried a number of Connection Types and I've copied the Connection String from BIDS to the Report Server, but still no luck.

Any clues? I'm kind of at a loss.

UPDATE...I've just created a very vanilla report where the data source is on the same box as my previously mentioned report, and it worked. The only difference is that this vanilla report is using a SQL Db as the source and not an AS cube.

Are there special security concerns when sourcing from a cube?

|||

After the report is deployed to the report server, edit the data source properties of the report and store credentials in the report server database (instead of e.g. using integrated security which won't work unless you have Kerberos delegation enabled).

Also, check the report server logfiles for more information on the error returned from the AS data provider. It may help to determine why the connection fails.

-- Robert

|||

Yeah, I've got the 'credentials stored on server' option checked for the data source.

I've checked the logs and the errors say ...

Cannot create a connection to data source 'PCR_Source'. > System.Data.OleDb.OleDbException: Database 'AHL_PCR' does not exist.

The cube located in the AS db 'AHL_PCR' has been processed (and, I can source from it just fine in BIDS), so I'm not sure why I'm getting this message.

Can''t connect to Analysis Services Cube using Excel 2007

Hi, i made a cube using Analysis Services 2005, but when i try to connect to Analysis Services using Excel 2007, i got the following error: (excuse me but i had the spanish version of Microsoft Office 2007, y hope you understand):

"El asistente para conexión de datos no puede obtener una lista de las bases de datos del origen de datos especificado"

i got that error when i put the name of the server and the authentication. Previously i made a report on excel 2007 using other cube with exactly the same configuration of server an credentials, but i erase that cube and made a new one, i only change the structure of the cube, the credentials, even the names, are the same as the old one.

i don't know what happens or what i'm missing out this time.

i had sql server 2005 with sp2 installed.

i'm working on Windows Vista. i applied all the patches to make sql server 2005 and visual studio 2005 work perfect on vista. I GOT ALL THE PATCHES FOR VISTA.

i also started all the services for Sql Server 2005 (Analysis Services, etc etc.)

I hope you can help me.

Thanks.

Guillo.

I found the solution for my problem:

Because of the securities of windows vista, it's necesary to delegate the right permissions to the current user you are working with.

In my case, i delegate the permissions when i installed SQL Server 2005, but it seems that for some unknown reason they were erased. So, i open "Configuración de superficie de SQL Server" (sorry, i'm using sql server 2005 spanish), then i re-delegate the right permissions to my current user in windows, and i made the report on excel 2007 with my cube.

That easy.

Can''t connect to Analysis Services Cube using Excel 2007

Hi, i made a cube using Analysis Services 2005, but when i try to connect to Analysis Services using Excel 2007, i got the following error: (excuse me but i had the spanish version of Microsoft Office 2007, y hope you understand):

"El asistente para conexión de datos no puede obtener una lista de las bases de datos del origen de datos especificado"

i got that error when i put the name of the server and the authentication. Previously i made a report on excel 2007 using other cube with exactly the same configuration of server an credentials, but i erase that cube and made a new one, i only change the structure of the cube, the credentials, even the names, are the same as the old one.

i don't know what happens or what i'm missing out this time.

i had sql server 2005 with sp2 installed.

i'm working on Windows Vista. i applied all the patches to make sql server 2005 and visual studio 2005 work perfect on vista. I GOT ALL THE PATCHES FOR VISTA.

i also started all the services for Sql Server 2005 (Analysis Services, etc etc.)

I hope you can help me.

Thanks.

Guillo.

I found the solution for my problem:

Because of the securities of windows vista, it's necesary to delegate the right permissions to the current user you are working with.

In my case, i delegate the permissions when i installed SQL Server 2005, but it seems that for some unknown reason they were erased. So, i open "Configuración de superficie de SQL Server" (sorry, i'm using sql server 2005 spanish), then i re-delegate the right permissions to my current user in windows, and i made the report on excel 2007 with my cube.

That easy.

Can't connect to / see cube

Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I can't connect to it. I can log
into the server, and see my Foodmart demo base. But I can't see my new
database.
I restored the database from a cab-file, and it restored OK. I can
prosess 2 out of 4 individual cubes. If I right-click the database and
choose "Process the Database", it fails to process. There seems to be a
problem with the database.
Is this why I can't connect to the database / cubes from other
computers? I can log on using http and the right username and password,
and I get to see Foodmart, but not the database / cubes I want to work
with.
Please advise, or at least give a hint on where I can find more info.
Kaisa
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Two possibilities typically occur:
1) either you have an old version of PTS on your client machine (run
ptslite.exe from the SP3 Analysis Services distribution), or
2) you don't have security rights to the cube, i.e. if you've not included
the everyone role. Foodmart has such a role, and thus you can see it.
--
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa" <kaisaremoveml@.hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
> Please advise, or at least give a hint on where I can find more info.
> Kaisa
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message news:<O8F#B6ruEHA
.684@.TK2MSFTNGP10.phx.gbl>...
> Two possibilities typically occur:
> 1) either you have an old version of PTS on your client machine (run
> ptslite.exe from the SP3 Analysis Services distribution), or
> 2) you don't have security rights to the cube, i.e. if you've not included
> the everyone role. Foodmart has such a role, and thus you can see it.
> --
Hey Dave!
Thanks a lot! I added the Everyone role and now I can use my database.
I'm so happy right now!
:D
Kaisa M. Lindahl

Can't connect to / see cube

Need some input please.
I have a development domain, with one server running SQL Server 2000 sp
3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
REporting Services.
I used to be able to connect to my databases in Analysis Services, but
today I updated one of them, and now I can't connect to it. I can log
into the server, and see my Foodmart demo base. But I can't see my new
database.
I restored the database from a cab-file, and it restored OK. I can
prosess 2 out of 4 individual cubes. If I right-click the database and
choose "Process the Database", it fails to process. There seems to be a
problem with the database.
Is this why I can't connect to the database / cubes from other
computers? I can log on using http and the right username and password,
and I get to see Foodmart, but not the database / cubes I want to work
with.
Please advise, or at least give a hint on where I can find more info.
Kaisa
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Two possibilities typically occur:
1) either you have an old version of PTS on your client machine (run
ptslite.exe from the SP3 Analysis Services distribution), or
2) you don't have security rights to the cube, i.e. if you've not included
the everyone role. Foodmart has such a role, and thus you can see it.
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa" <kaisaremoveml@.hotmail.com> wrote in message
news:%23QRcNQpuEHA.2804@.TK2MSFTNGP14.phx.gbl...
> Need some input please.
> I have a development domain, with one server running SQL Server 2000 sp
> 3 Enterprise edition, Analysis Services Sp 3 Enterprise Edition and
> REporting Services.
> I used to be able to connect to my databases in Analysis Services, but
> today I updated one of them, and now I can't connect to it. I can log
> into the server, and see my Foodmart demo base. But I can't see my new
> database.
> I restored the database from a cab-file, and it restored OK. I can
> prosess 2 out of 4 individual cubes. If I right-click the database and
> choose "Process the Database", it fails to process. There seems to be a
> problem with the database.
> Is this why I can't connect to the database / cubes from other
> computers? I can log on using http and the right username and password,
> and I get to see Foodmart, but not the database / cubes I want to work
> with.
> Please advise, or at least give a hint on where I can find more info.
> Kaisa
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||"Dave Wickert [MSFT]" <dwickert@.online.microsoft.com> wrote in message news:<O8F#B6ruEHA.684@.TK2MSFTNGP10.phx.gbl>...
> Two possibilities typically occur:
> 1) either you have an old version of PTS on your client machine (run
> ptslite.exe from the SP3 Analysis Services distribution), or
> 2) you don't have security rights to the cube, i.e. if you've not included
> the everyone role. Foodmart has such a role, and thus you can see it.
> --
Hey Dave!
Thanks a lot! I added the Everyone role and now I can use my database.
I'm so happy right now!
:D
Kaisa M. Lindahl