Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 10, 2017 at 03:55 PM

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

    Add comment
    10|10000 characters needed characters exceeded