Percentages in Database, how to use it in IDT? Dimension or Measure? Database Delegated or None?

[Former Member]

Hi,

We have a percentage field in database on which calculation is already performed. (Sample Values: 20, 40, 50, 100 etc).

When I pull this field into Business Layer, is it better to leave it as Dimension or Measure?

If I change it to measure, then is it better to leave Projection Function as None or Database Delegated?

FYI, Currently there are no business requirements for this field to be used in reports.

I am using BO 4.1 SP 9.

Thanks & Regards.

Naveen.

[amitrathi239 · Accepted solution]

keep it to measure and projection to none as this will hold numeric values and you have already calculated percentage.