renaming column labels, pivots
 

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07

As you can see, the lables come up as "sum 01-Jan07". How do I rename
several of these lables to show just "01 Jan07" without the "sum" in front of
it? I know how to rename single lables, but don't know how to do several at
one time.
Thanks
Kirthana

renaming column labels, pivots
 

Based on what you hvae posted i am assuming that each column is it's own
dimension (field) within the cube. That being the case you can not rename
the fields as a group. You could try hiding that row and in an empty row
above add your own titles...
--
HTH...

Jim Thomlinson


"KM" wrote:

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07

As you can see, the lables come up as "sum 01-Jan07". How do I rename
several of these lables to show just "01 Jan07" without the "sum" in front of
it? I know how to rename single lables, but don't know how to do several at
one time.
Thanks
Kirthana

renaming column labels, pivots
 

thanks.....you just solved my problem......

"Jim Thomlinson" wrote:

Based on what you hvae posted i am assuming that each column is it's own
dimension (field) within the cube. That being the case you can not rename
the fields as a group. You could try hiding that row and in an empty row
above add your own titles...
--
HTH...

Jim Thomlinson


"KM" wrote:

Hi,
Could someone pls help me with this. I have "weeks" in my column labels.
Sum of 1-Jan-07 Sum of 8-Jan-07 Sum of 15-Jan-07 Sum of 22-Jan-07

As you can see, the lables come up as "sum 01-Jan07". How do I rename
several of these lables to show just "01 Jan07" without the "sum" in front of
it? I know how to rename single lables, but don't know how to do several at
one time.
Thanks
Kirthana