Hi,

we do incremental cube partition processing daily basis. We have
dimension table whose name value may change. ex: assume my dim table as


1 login
2 open
3 closed

there is a chance that value for 3 may change. In this case I have to
reprocess whole cube for this change to happen across all the
partitions.

Heard that there is some new feature in AS2005 which makes cube to go
and pickup some attribute values from the physical table column.

Please help me.

Thanks

do you talk about the label of a dimension member?
if your key column is NOT based on the name, then an update of the dimension
will change the label for this key.
this works with AS2000 too. but if this doesn't works on the dimension
himself, this works fine on the properties of a dimension. (a change made to
a property for a member update this property value)
so if you use this property to create a dimension in AS2000, this virtual
dimension is updated when the label change.

AS2005 is better then 2000 for all the processing steps, so this version
will help you for sure.


"siva" <kbrsiva (AT) gmail (DOT) com> wrote

Can anybody help to set the label for a dimension member in AS2005.

Thanks.

Jeje wrote:

the "label" is the name of the member. look at the name column property of
your attrbibute in the dimension.
open the dimension
select the attribute you want to change the name column
open the properties windows
near the end of the property list, you'll found some properties:
key columns
name column
value column

change the name column option to use the column from your database which
contains the label you want to display.
save and process.

if the key column is NOT the same column has your name column, a simple
update process is required to change the labels of your members when the
source table value change. so, for exemple, if the name of the key 1 change
from "Open" to "reopen", an update of the dimension will update the member
name and there is no need to reprocess the cube because the key value has
not change (the key still = 1)

does it what you looking for?


"siva" <kbrsiva (AT) gmail (DOT) com> wrote

Thanks jeje for your help.One more small clarification. "Update of the
dimension will update the member name and there is no need to reprocess
the cube because the key value has not change" , In this statement
Update of dimension means processing the dimension alone , Am I right?
I need not reprocess the cube but reprocessing dimension will do. Is it
correct. Thanks.

exact

a simple update process on the dimension is enough.

"siva" <kbrsiva (AT) gmail (DOT) com> wrote