good morning sir...

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.

gmaniz service failed

Dear all,
please help me to find error about 'the gmaniz service failed to start
due to the following error'
Thanks
This is not a SQL Server service. In fact, I didn't get one single hit (except this post) on Google.
My guess is that this is some in-house developed software, so you need to find what it is and talk
to the people responsible for it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ekodian" <ekodian@.gmail.com> wrote in message news:e8beptSUFHA.3944@.tk2msftngp13.phx.gbl...
> Dear all,
> please help me to find error about 'the gmaniz service failed to start due to the following error'
> Thanks

gmaniz service failed

Dear all,
please help me to find error about 'the gmaniz service failed to start
due to the following error'
ThanksThis is not a SQL Server service. In fact, I didn't get one single hit (except this post) on Google.
My guess is that this is some in-house developed software, so you need to find what it is and talk
to the people responsible for it.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ekodian" <ekodian@.gmail.com> wrote in message news:e8beptSUFHA.3944@.tk2msftngp13.phx.gbl...
> Dear all,
> please help me to find error about 'the gmaniz service failed to start due to the following error'
> Thanks

gmaniz service failed

Dear all,
please help me to find error about 'the gmaniz service failed to start
due to the following error'
ThanksThis is not a SQL Server service. In fact, I didn't get one single hit (exce
pt this post) on Google.
My guess is that this is some in-house developed software, so you need to fi
nd what it is and talk
to the people responsible for it.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ekodian" <ekodian@.gmail.com> wrote in message news:e8beptSUFHA.3944@.tk2msftngp13.phx.gbl...

> Dear all,
> please help me to find error about 'the gmaniz service failed to start due
to the following error'
> Thanks

Global Variable

Dear All!
I want to know that how can i declare a global variable in database, assign some value to it, then using it in multiple triggers and procedure then deallocating that.
Please provide a smal example.
Regards,
Shabber.Create a User-Defined Function that returns the value?|||And deallocate it?

What the heck are you doing?

UDF is the only way to simulate a global variable, but if you then wipe out your UDF it will break your sprocs.|||I'd assume Shabber has no big need for deallocating. It's probably just that if there would have been such a thing as a global variable, then it would have been a good habit to deallocate once it wasn't needed anymore.|||Thanks for replying.

But how function will provide the functionality of Global Variables. A bit confusing.

Regards,
Shabber.|||You call the function, which will return the value you're after.|||Thanks for replying.

But how function will provide the functionality of Global Variables. A bit confusing.

Regards,
Shabber.

CREATE TABLE MyParameter (
SiteID int IDENTITY (1,1) NOT NULL,
SiteName varchar(255) NOT NULL
)

CREATE FUNCTION udfMyFunction
(@.p1 int)
RETURNS varchar(255)
AS
BEGIN
DECLARE @.sTemp varchar(255)

SELECT @.sTemp = SiteName FROM MyParameter WHERE SiteID = @.p1
RETURN @.sTemp
END

Example Data and Usage:

insert into MyParameter(SiteName) Values ('Foo')
insert into MyParameter(SiteName) Values ('Bar')

SELECT dbo.udfMyFunction (2)

I don't know that this example is all that useful, but maybe it will give you some ideas.

Regards,

hmscott

Giving java application sufficient permission to create tables

Dear All
How is it possible to give a Java application sufficient permission to
create tables in SQL Server 2005?
Thanks
DanielDaniel Malek (DanielMalek@.discussions.microsoft.com) writes:
> How is it possible to give a Java application sufficient permission to
> create tables in SQL Server 2005?
You cannot give an application per se permission to do anything. The ways
to go in your case are:
o A stored procedure signed with a certificate, associated with a user
that has the privs.
o A stored procedure with EXECUTE AS.
o Use an application role.
o Authenticate users in the middle layer, and connect to SQL Server with
proxy login that has the required privs.
I discuss these methods in different levels of details on
http://www.sommarskog.se/grantperm.html.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx