Best Of

Thank you Antonio.

We've done some research and agree that this is a widespread problem that also affects Microsoft Excel. 

Microsoft Knowledgebase Article 

This link to Microsoft Support site explains the issue as follows:
"The IEEE 754 standard is a method of storing floating-point numbers in a compact way that is easy to manipulate. This standard is used by Intel coprocessors and most PC-based programs that implement floating-point math.
IEEE 754 specifies that numbers be stored in binary format to reduce storage requirements and allow the built-in binary arithmetic instructions that are available on all microprocessors to process the data in a relatively rapid fashion. However, some numbers that are simple, nonrepeating decimal numbers are converted into repeating binary numbers that cannot be stored with perfect accuracy.
For example, the number 1/10 can be represented in a decimal number system with a simple decimal:
.1
However, the same number in binary format becomes the repeating binary decimal:
.0001100011000111000111 (and so on)
This number cannot be represented in a finite amount of space. Therefore, this number is rounded down by approximately -2.78E-17 when it is stored.
If several arithmetic operations are performed to obtain a given result, these rounding errors may be cumulative."

Thanks

Hi Egon Santoni, one option to perform the logic inside BOARD is to load both tables as they are and perform the processing via dataflow action of a procedure.

For this you need 4 cubes:

A Begin Date (Date type cube dim by Person) - populate from SQL

B End Date (Date type cube dim by Person) - populate from SQL

C Day (Date type cube dim by day only) - populate via dataflow using Day = day() function to hold date values for every day

D Active Flag (Integer cube by Day by Person)

To populate D, you need IF statement =if(and(c=>a,c=<b),1,0)

You can then multiply any anagraphic data by this ACTIVE flag mapping to have only values shown in days the Person was active, or even use the Active Flag as a filter in the layout depending on what you are trying to do.

I hope it helps!

Thanks,

Audrey