BO4 - Object format applied in IDT tool not working

[former_member272336]

Hi

Using BO4 SP6 adn have numeric columns (6 digits in length).

Year and week

Showing in reports as 201,312  rather than 201312.

Tried custome format in universe as ###### and 123456 and 999999.

However when report runs doesn't apply the mask

i.e instead of showing as 201312 as we want shows as 123456 or 999999 or  ######

Anybody know how to solve this?

Thanks

Philip

[Former Member]

Hi Philip,

You can handle this format at web intelligence layer as well, if you don't have a specific reason to do at universe layer.Moreover if you apply it at universe layer format you set would be reflected across all the reports

Replace([Object];",";"")

FormatNumber([Object];"######")'

Thanks

Mallik

[former_member272336]

Hi,

Had to select numeric format and delete grouping part to get this to work.

Din't look to accpet getting rid of all formatting and then just applying format mask of ######.

Thanks