Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

How change name of level (All)

 
   Database Forums (Home) -> Data Warehouse RSS
Next:  ODBC Direct vs Passthrough  
Author Message
Dorota Papiernik

External


Since: Dec 20, 2007
Posts: 4



(Msg. 1) Posted: Thu Dec 27, 2007 3:18 am
Post subject: How change name of level (All)
Archived from groups: microsoft>public>sqlserver>datawarehouse (more info?)

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

 >> Stay informed about: How change name of level (All) 
Back to top
Login to vote
Jeje

External


Since: Apr 17, 2006
Posts: 184



(Msg. 2) Posted: Tue Jan 08, 2008 11:38 pm
Post subject: Re: How change name of level (All) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

you can't rename it
you want to change it to which value?

"Dorota Papiernik" wrote in
message
> 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
>

 >> Stay informed about: How change name of level (All) 
Back to top
Login to vote
Dorota Papiernik

External


Since: Dec 20, 2007
Posts: 4



(Msg. 3) Posted: Wed Jan 09, 2008 3:11 am
Post subject: Re: How change name of level (All) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


"Jeje" wrote:

> you can't rename it
> you want to change it to which value?
>
> "Dorota Papiernik" wrote in
> message
> > 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
> >
 >> Stay informed about: How change name of level (All) 
Back to top
Login to vote
Jeje

External


Since: Apr 17, 2006
Posts: 184



(Msg. 4) Posted: Wed Jan 09, 2008 8:06 am
Post subject: Re: How change name of level (All) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.


"Dorota Papiernik" wrote in
message
> 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
>
>
> "Jeje" wrote:
>
>> you can't rename it
>> you want to change it to which value?
>>
>> "Dorota Papiernik" wrote in
>> message
>> > 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
>> >
 >> Stay informed about: How change name of level (All) 
Back to top
Login to vote
Dorota Papiernik

External


Since: Dec 20, 2007
Posts: 4



(Msg. 5) Posted: Wed Jan 09, 2008 8:06 am
Post subject: Re: How change name of level (All) [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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


"Jeje" wrote:

> 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.
>
>
> "Dorota Papiernik" wrote in
> message
> > 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
> >
> >
> > "Jeje" wrote:
> >
> >> you can't rename it
> >> you want to change it to which value?
> >>
> >> "Dorota Papiernik" wrote in
> >> message
> >> > 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
> >> >
 >> Stay informed about: How change name of level (All) 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
How change name of level (All)? - 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..

Transaction Log as data change trigger - I am looking into using Apex SQL Log explorers command line interface to implement a source system data update trigger process. I was wondering if this is feasible and if anyone has attempted this. Thanks, Rafi

Transaction Log as data change trigger - I am looking into using Apex SQL Log explorer's command line interface to implement a source system data update trigger process. The current triggers to indicate data updates are not very reliable (surprise :-) I was wondering if this is feasible and i...

Measure change updates in Fact tables - Is there an industry standard method to populate Fact table columns with the amount of change of a measure from one row to the next? I have a FactSubscriptions (1 row = 1 week), and I wold like to have a column of the price change from the previous..

how to reduce PAGEIOLATCH_SH waits? - Hi, I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH wait type. The update is blocked by himself (using the sp_who1, I see the lock) what can I do? there is any hint or option to test? which counter of performance I have to..
   Database Forums (Home) -> Data Warehouse All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]