Re: new feature in AS 2005??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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@xxxxxxxxx> wrote in message
news:1146893939.317742.177640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Can anybody help to set the label for a dimension member in AS2005.

Thanks.

Jeje wrote:
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@xxxxxxxxx> wrote in message
news:1146769667.563879.188740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Possible ROLAP Cube Design Scenario
    ... > we have very limited time window for cube processing. ... > I am just curious if we have a way to design acube with both MOLAP & ROLAP ... >> While 2M is a big dimension, I don't see why it isn't doable. ... but so long as you keep it at 2M with no member properties then ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... The more I think about it, the more I fear the "almost instantaneous" display of this dimension member was just a dream:'( ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from 2K to 30K with a 2K step... ... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... I couldn't process the cube anymore or load 2 smaller cube with 500MB dimtree. ... with the cube browser in Visual Studio, the first load is long, but then the add/remove from the browser became instantaneous. ... and it is longer than a similar member data set (the only difference is this big parent child dimension which is smaller) ...
    (microsoft.public.sqlserver.olap)
  • Re: Slow member loading in excel 2003 pivot table
    ... it loads member quickly... ... I'm gonna add a transform step in my cube loading and just truncate the data... ... Maybe a simply filter another file extension dimension table with a ">3)" and set all the fact with the missing key error to a default member... ... I'm gonna sound crazy, bu I need to find a way to create various sized dimension and see how excel react and display them, I want to range from ...
    (microsoft.public.sqlserver.olap)
  • Re: Why would NonEmptyCrossJoin fail on a virtual cube which joins
    ... I had previously assumed that when defining a virtual cube containing ... default member from all missing dimensions would be used to define the ... as the coordinate for that dimension when defining the virtual cube to ...
    (microsoft.public.sqlserver.olap)