Keyfigure creation wit 4 to 5 decimals

[Former Member]

HI,

I am loading data from flatfile

But I have a problem with the MS Access export to CSV-FlatFile.

> In my CSV-FlatFile the revenue have only 2 decimals, that’s

> because I have in the BW system only 2 decimals, too.

> Do any one know somebody who can export the MS Access dataset to

> a CSV File with all revenue decimals?

Actually this KF is created previously by one of our collegue as the KF defined in the BW system is defined in such a way that it will have only 2decimals data ,I think its also possible to define the KF to accept all the decimals which I have in the data , as i dont have access to my BW sys its not possible to check for mw could any one please let me know whether this is possible

Regards,

Priya

[Former Member · Accepted solution]

Priya,

If you use Floating point data type in BW, It will accept 4 Decimals I Guess.

check wheather they are displaying only 2 decimals in the Queries.

Nagesh Ganisetti.

[Former Member]

hi priya,

As nagesh said u can use floating point in this case...

When u select floating point data type u can have upto 9 decimal points .

To set this property select ur keyfig(object)->rightclick and display->data type as floatingpoint->additionalproperties-> select the no of decimal points u want..

check it out how its work in report and pls revert me..

Regards,

sri

[Former Member]

Hi,

Thanks to both of u . I have done the same thing in in my previous proj ,but it didnot strike me ,thanks a lot . If w e select floating point the data in the cube will be presented in float format where as in the query we can see it normally

Thanks

Priya