Error in Query display

[Former Member]

Hi All

I am using 0Instl_dur for calculating installation duration. Its flaoting point number tyoe infoobject. However when I display this in query in BEx. the Duration is shown with suffix ERR. e.g. duration 5,0000000000000000E+00 ( 5days) is being shown as 5.0 ERR.

Can I anyone explain me what needs to be done to get rid of unnecessary charecters 'ERR'?

Cheers

PB

[Former Member]

Thanks guys I have fixed it applying ur solution.

[Former Member]

Hello,

please define a formular with NODIM.

Like NODIM('your keyfigure')

This is described in note: 539638

Kind reg.

Michael

[Former Member]

Thanks Michael

However, I am not sure How do u want me to define formular.

Ihave raed the note it talks about the inconsistancies in Units in Cube. give patch numbers for 30A and 30B, I am on 310.

In my case Unit is TAG, it wasnt getting populated in in the Cube I however made it constat in Xfer rule now and is getting populated in Cube. But the query still displays 5.00 days and 5.00 ERR

Kindly advice

[Former Member]

Hi,

please look in addtion to note 543613.

If you want to remove the ERR then please use the NODIM function in the BEx formular.

If the ERR is displayed in the Query an inconsitency in the InfoCube is the reason. The system can not determine the correct unit.

kind reg.

michael

[Former Member]

Hi PB,

to come around the 'ERR' you can do 3 things. First one is already suggested by Michael. Just create a new formula or a calculated keyfigure to get your keyfigure without a unit --> nodim(keyfigure)

Second is: put the unit infoobject into the rows of your query.

Third is: Reload your cube completely and make sure the unit is populated correctly.

regards

Siggi

Message was edited by: Siegfried Szameitat