Rename attributes for each instance of a role-playing dimension

Hi,

Chris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).

Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?

Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||

Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...

Chris

sql

Rename attributes for each instance of a role-playing dimension

Hi,

Chris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).

Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?

Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||

Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...

Chris

Rename attributes for each instance of a role-playing dimension

Hi,

Chris Webb submitted this request on the Connect site, please see details on this page. Someone from Microsoft has replied, saying they will consider it for the "next release" (as at Aug 2006).

Does anyone know if this has been included in the Katmai (2008) beta releases so far? Or is it likely to before RTM?

Thanks
Ken
No, this feature will not be in Analysis Services 2008. We are still tracking it for possible inclusion in the next major relase after SQL Server 2008.|||

Shame... it might seem like a minor change, but I've lost count of the number of times I've started off using role-playing dimensions and then had to go back and change to separate but practically identical dimensions just because of this...

Chris

Removing Characters in Field grouping

Hello,

I am using the following expression to strip the last 11 characters in a field group and it returns an error saying that Len cannot use a negative number. It must be 0 or greater. Is there a better alternative?

Code Snippet

left(Fields!TestName.Value,len(Fields!TestName.Value)-11))

you can use Rtrim|||

Are you always removing 11 character regardless of the field length or do you simply want to restrict it to a certain size?

For example, the following code restricts the length to 5 characters:

=iif(len(rtrim(Fields!TestDATA.Value)) > 5, mid(rtrim(Fields!TestDATA.Value),1,5), rtrim(Fields!TESTDATA.Value))