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.

Giving roles access to perspectives

In BOL, the page on creating perspectives says

"Dimension and cell security for a perspective are derived from the source cube. However, roles can be given or denied access to a perspective. A role can be denied access to a cube and given access to a perspective of the cube."

However, I can't find out how to grant access to a perspective. There doesn't seem to be anything about it on BOL, and the perspectives don't appear anywhere in the role editor.

Can anybody tell me how to do this? Sorry if I'm being stupid and missing something obvious!

Unfortunately in this version of Analysis Services it is not possible to assign security permission to perspective.

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

|||Is this a feature that is likely to be implemented in the future? Is there any other way to grant access to specific attributes of a dimension?|||

Of cource you can't expect any public commitment to any particular feature :). It has been requested by many customers.

You can create a role object and use BI Dev Studio to grant/deny permissions to dimension members of specific attribute.

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