cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Analyzer displays wrong number of decimal places after implementing BW patch

Former Member
0 Kudos

Hey folks,

we patched our BW 7.31 from PL10 to PL15 last weekend and now we got some issue with the number of decimal places shown in BEx Analyzer 7.x.

One example for KF X

Settings Info Object X

Decimal Places:                         Not defined

RSRT - Display X

Shows 3 decimal places

Query Designer Settings using KF X

Number of Descimal Places:     0  [Use Default Settings: NO]

BEx Analyzer Properties for KF X

Decimal Places:                         0

______________________________________________________________________

Resulting in BEx Analyzer workbook shows 3 decimal places instead of 0!

Anyone with an good idea about that?

Thanks,

Andreas

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

We got answer by SAP and after implementing note 2094848 the problem is solved.

0 Kudos

Hi Andreas, Thx for this info & your groundwork ;o) We have the same problem after SP15. Unfortunateley note 2094848 is not yet released ... i.e. I have to wait for an answer from SAP on monday ... Best regards, Markus

Former Member
0 Kudos

Hi Markus,

Our problem was same. we told SAP and they released for us. They started to release customer by customer

Best Regards

former_member976
Active Contributor
0 Kudos

Hi,

can you share the screen shot for the KF proparty and query designer seeting for particular KF ?

some thing happened after upgrading the BW patch.

Former Member
0 Kudos

Hi Andreas,

Have you used the list calulation like "Calculate Result As Average" or "Calculate Single Values as normalization of result" in the relevant key figures?

For "Calculate Single Values as normalization of result",iIt is the known design that it is always displayed with three decimal places for normalized values, and the setting in Query Designer for
decimal place doesn't take effect.

For "Calculate Result As Average", the following note maybe relevant.
2096911 - Decimal places in query result is wrong, if average is used and display precision is set to less than 3, it will always show 3 decimal places.

Another clue is to check if the key figure is a Quantity type with unit, and what's defined in table
T006 field ANDEC for this unit.

Hope this helpful.

Regards,
Ceciclia

Former Member
0 Kudos

Hi Cecilia,

no I did not and it is also no issue regardingg the T006 table.

I reported it as an incident to SAP now, hopefully this will help me out.

Thanks,

Andreas

former_member239465
Discoverer
0 Kudos

Hi Andreas.

Here at Molson Coors we are having exactly the same issue.

Can you please make sure you share the OSS note that SAP is going most likely to recomment you implement?

Thanks!

André

former_member186053
Active Contributor
0 Kudos

Hi Andreas,

Can you take a look at sap note 1843847,might helpful to you.

Regards,

vengal.

Former Member
0 Kudos

Hi Andre,

I will - but at the moment I did not have any news on this.

BR,

Andreas

Former Member
0 Kudos

Hi Andreas we have same problem and we will ask SAP too. Did you get any news about the problem?

Former Member
0 Kudos

Hi Gurcan,

no news on that one until now. I will let you know after I got some news from SAP.

Andreas

Former Member
0 Kudos

Hi Andreas,

We got a reply from SAP

The note 2096911 has been extended validity to SP15 by the developer.

So you can apply it.

Firstly we will implement our DEV system and if problem is solved we will transport production system.

I will inform you again

former_member186053
Active Contributor
0 Kudos

Hi Andreas,

Continuation to the Swati's questions, what is the data type of your KF X. Can you check how the values are displaying in underlying infoprovider of this query. Is the issue with only this report or with others also.

Thanks,

Vengal.

Former Member
0 Kudos

Hi Swati, hi Vengal,

seems to be no data type issue, all data types are affected by this, also all reports are.

Got to be some general problem!

The infoproviders of the queries are allright, they are showing exactly the formats which are specified for the info objects in it.

BR,

Andreas

former_member186053
Active Contributor
0 Kudos

Hi Andreas,

Seems to be a special case, have you searched for any sap notes related to this.

If you stuck here, then raise OSS note and check with SAP.

Thanks,

Vengal.

swati_gawade
Contributor
0 Kudos

Hi Andreas,

Can you please check the data at your infoprovider level? upto how many decimal places the records are being stored for that KF?

can you please share screenshots for the setting that you mentioned above?

Have you tried the 'generate report' option in RSRT tcode?

Also, can you please let me know what settings are you maintaining for RSRT to display upto 3 decimal places?

-Swati.