I did So..

dear sir,

i am facing problem while making perspectives in sql server2005(Analysis Services) through C#.perspectives are made well but cant update within a Cube...i mean cant be added to a cube... i dont know what is the problem.so if someone can help me in this regard i will be really thankful to u.

Thanks.

Hi,

I would suggest you to post this question in any of the ADO related or SQL Services (Analysis Services) related forums.

There you should find a quick answer to your question.

Rgds,

Rodrigo

|||

dear sir,

i did post it on many of other forums like code project and microsoft india...but i dont know i got no clear response.anyhow thanks alot for giving me time and considering my problem...

thanks.

Adnan Khan.

|||

Moved to SQL Server Analysis Services forum.

Thanks.

|||

First question comes to mind after reading about your problem.

After creating perspective object did you do something like cube.Update(UpdateOptions.ExpandFull) ?

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

|||

dear sir,

thanks alot sir....i did appy ur option is working perfectly...thanks alot sir.....i am really happy for ur help...all my senior developers are shocked when i told then that i have done it......thanks alot sir....

Adnan khan..

|||

Edward,

Can you point us to anywhere that details what the three ProcessingOptions enum values actually mean?!?!

Thanks,

Steve.

|||

In following whitepaper you will find a table with processing options for Analysis Services objects

http://msdn2.microsoft.com/en-us/library/ms345142.aspx

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

|||

Thanks Edward, I appreciate the link and the information contained within. I would still like to see the documentation (BOL) covering items such as the UpdateOptions enumerator (values of Default, AlterDependants and ExpandFull) as well as the UpdateMode. Both of these have a column labeled 'Description' in BOL next to the enum values but these columns aren't populated. It tends to make coding against AMO a little hit and miss as to the intended outcome and actual outcome.

Thanks again,

Steve.

|||

well i am here find out how can i add or load pictures to a dll..i mean when i add that dll to a project all those images should me added also....i hope u will help me....

Thanks...

Adnan Khan.

sql

i cannot connect to the database engine ...

I can connect to Analysis Service and Integration Service but I can not connect to the Database Engine. I receive the following error message:

Cannot connect to homebase.

Additional Information:

An error has occurred whlie establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server doesn not allow remote connections. (provider: SQL Network Interfaces, error: 25 - COnnection string is not valid)(Microsoft SQL Server, Error:87)

(Click on OK to continue)

the problem seems to be Remote Connection is not configured in this server for Analysis Service and Integration Service.

Start -- Programs -- MS SQLSERVER 2005 -- Configuration Tool -- SQL Server 2005 Surface Area Configration -- Surface Area Configuration for Services and Connections

Now you will have all the Services running on this machine like Database ENgine,Analysis Services, Reporting services, Integration services etc

Expand each one in which you want to enable remote connection adn select Local and Remote connections

Madhu

|||Once you have enabled remote connections if it's still not working, check out this FAQ I wrote over on tek-tips http://www.tek-tips.com/faqs.cfm?fid=5481.

I can be connected to services analysis 8.00.194 through HTTP?

I can be connected to services analysis 8.00.194 through HTTP?
Hi
Analysis Services is not a HTTP endpoint, so in SQL 2000, you can not
connect to it using HTTP.
Maybe SQL Server Reporting Services is an option for you.
Regards
Mike
"Maricela" wrote:

> I can be connected to services analysis 8.00.194 through HTTP?
|||My understanding is you ought to be able to connect to analysis service via
HTTP if you're using Enterprise Edition. Just make sure that you have the
msolap.asp file in your web server directory before trying to connect
Nestor
"Maricela" <Maricela@.discussions.microsoft.com> wrote in message
news:ED09850B-71F8-4039-8D7F-8101F4383677@.microsoft.com...
>I can be connected to services analysis 8.00.194 through HTTP?

I am unable to access Analysis Server with AMO

Hi All,

I developed one web service,Here i am making connection to the Analysis Server and working on Database,cubes,partitions.when i deploy this code it is failing to run and it is throwing error like."object reference not set to an instance of the object",so i added Impersonate = true code in my web service config file then it is working fine.

( am expecting My Analysis Server is not allowing to create object ,how to handle this)

But what i want is it should work with out providing Impersonate in config.

Help is needed it is very urgent.

Thanks in Advance.

You code has to run under the priviledges of some sort of account. There are only 3 possible configurations that I can think of.

1. Setup an account in the application pool (if using IIS6)

2. Set a fixed account using the <identity impersonate="true" userName="..." password="..." /> tag in the web.config

3. Set the current client account to be impersonated using <identity impersonate="true" /> in the web.config

Note that 3) will only work if the web service and SSAS are on the same machine, or if you have Kerberos configured. Otherwise the user credentials will not pass from client to Web server to SSAS server.

I am new to this OLAP & OLTP - Analysis Services.

Hi,

I am working on .Net tech with SQL Server 2000.

I want to update my technical skills to DW.

I mean, i planning to learn Analysis Services and i am new this topic.

Please help me........

thanks

babu

http://www.databasejournal.com/features/mssql/article.php/1429671

maybe this will be a good start