Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Data Warehousing / January 2008

Tip: Looking for answers? Try searching our database.

How change name of level (All)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dorota Papiernik - 27 Dec 2007 11:18 GMT
Hi,

I’m creating dimension with SSAS 2005 – Business Intelligence Development
Studio. Dimension has  attribute hierarchies and user hierarchies.  
For attribute hierarchies and user hierarchies I can define my own all
member name ( property AttributeAllMemberName for attribute hierarchies and
property AllMemberName for user hierarchies). But I can’t find a place where
I could change the name of  all level. It’s name is now “(All)”. But I need
to change it. How can I do it with AMO or with BI Development studio? Please
help me.

Thanks for the answer
Dorota
Jeje - 09 Jan 2008 04:38 GMT
you can't rename it
you want to change it to which value?

> Hi,
>
[quoted text clipped - 13 lines]
> Thanks for the answer
> Dorota
Dorota Papiernik - 09 Jan 2008 11:11 GMT
Hi,
Thank you very much for the answer. I’d like to rename it to polish name,  
for example instead of “(All)” I need “Calosc”.
Thanks for the help.

Dorota Papiernik

> you can't rename it
> you want to change it to which value?
[quoted text clipped - 16 lines]
> > Thanks for the answer
> > Dorota
Jeje - 09 Jan 2008 13:06 GMT
well...
in fact it's never used, and the end user generally never use (All) level
directly.
the end user use the all member name you defined.

I know that few applications display "(All)" in the interface.

But it's not possible to change it today.
Log your request in the connect website as an improvment.

> Hi,
> Thank you very much for the answer. I’d like to rename it to polish name,
[quoted text clipped - 24 lines]
>> > Thanks for the answer
>> > Dorota
Dorota Papiernik - 09 Jan 2008 14:31 GMT
Hi,
In Analysis Services 2000 it was possible to change name of the level (All).
So for polish users I changed it to polish value “Calosc”. I have migrated
database of my customer to Analysis Services 2005, and  I have expected that
on Analysis Services 2005 I also can change name of level (All). Now I see it
is not possible. So polish users will have to work with the name “(All)”.
Thank for help and for information once more. As you suggested,  I’m going
to log  my request in the connect website.

Dorota Papiernik

> well...
> in fact it's never used, and the end user generally never use (All) level
[quoted text clipped - 34 lines]
> >> > Thanks for the answer
> >> > Dorota
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.