Skip to Content
0

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

Aug 10, 2017 at 03:52 PM

55

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Aug 10, 2017 at 03:55 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded