I have included a key figure (counter) in a cube, defining it using a formula and the value is 1.
When I load with this key figure in the cube the number of records almost double - which is not what we require.
I have had a look at the other key figures in the cube which skip a record if a total key figure is 0. I also changed my formula definition to reflect the same. However, the number of records added is still almost double.
The key figure is based on Exception Aggregation is used in a seperate cube (as a stand alone key figure) - where the number of added records is the same as that transferred (this is correct)
For what reason could I be experiencing this problem? Thanks