Updating of Category Labels in Transformer / PowerPlay

[JGirl]

Hi,

I have a cube that includes the organizational structure as a dimension. Im using the cost centre code (eg. 12345) as the source value for the category, and using the cost centre code and the cost centre description (calculated in the IMR report eg. 12345 - Accounting). Now, in the source system, the description 'Accounting' was changed to 'Accounting and Finance', however when i rebuild the cube the label isnt being refreshed from the source database.

If i look at the column being used to populate the label in the datasource viewer, it is showing the updated value, but the category labels are not being updated. If i delete the category containing the old value and regenerate the cube, the new value is shown in the label instead of the old one.

Does anyone have any ideas what is going on here?

J

 

[yksvaan]

When you click (activate) the label column definition, below there is a Refresh checkbox. You should always check this.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]