BIP Report Layout - Chart Values rounding up and showing as K (thousands)

GoSaaS

Screenshot 2024-03-11 175057.png

Hello everyone,

I am using Oracle PLM Cloud Version 24A (11.12.24.01.0) And I am creating a data model with FSCM Database source and then I am creating report template on top of it.

I'm currently utilizing Oracle BIP Report Layout, and within my charts, I'm displaying item counts. However, I'm encountering an issue where the counts are being shown in thousands and are also being rounded up. My objective is to display the numbers as they are, without any scaling.

Could you please assist me in resolving this matter? Please look at screenshot for reference.

Thank you

SteveF-Oracle

Hi @GoSaaS

Please consider adding some additional context, so that your post can be moved to the correct forum.

Let the community know if you are are using Publisher on-prem in the context OBIEE, OAS, or standalone. The version/update is helpful, in case there are known issues/fixes, etc.

Let the community know, if you are using publisher within the context of a SaaS product (OTBI), or any other context such as specific industry product.

Any other properties, configuration you have set is also important information.

Thanks.

GoSaaS

https://community.oracle.com/products/oracleanalytics/discussion/comment/52625#Comment_52625

Hi @SteveF-Oracle,

I am using Oracle PLM Cloud Version 24A (11.12.24.01.0)

And I am creating a data model with FSCM Database source and then I am creating report template on top of it.

GoSaaS

Hi @SteveF-Oracle ,

Is there any update on this?

SteveF-Oracle

Hi @GoSaaS ,

Please update your profile, so we know whom we are speaking with :-)

I see this same issue reported in 2017

https://community.oracle.com/products/oracleanalytics/discussion/15258/pie-chart-in-interactive-mode-is-round-numbers-that-are-greater-than-10-000

So, some of this may be intentional for data marker display, printing, etc.

I also see a very old / open enhancement request:

Enh 33632777 - BI PUBLISHER BAR CHART GRAPH DEFAULTS TO AN ABBREVIATED VERSION OF A NUMBER

ENHANCEMENT REQUEST DESCRIPTION

===============================

In BI Publisher bar chart graph defaults to an abbreviated version of a number for the report that are created using XPT.For example, 26,384 shows up as 26.4K

Currently there is no property to change the K for thousands

Since you appear to be using a SaaS product, I do not know if this has been delivered as "out-of-the-box" content, or if custom built, any of the properties or values you have configured (i.e. - I asked in the original reply).

• These may be your only options: Format Pie Slice

I suggest you open a service request to a.) have your details reviewed as Support may need to review your configuration, or template XML, etc., and b) confirm if this is still an open enhancement.

A note on enhancements, they are now enabled directly by customers in the Ideas Lab, so if it is determined to e an enhancement, I would suggest up-voting and commenting on an existing enhancement, or filing a new one if necessary.

Other comments, welcomed.

GoSaaS

@SteveF-Oracle Thank you so much

GoSaaS

@SteveF-Oracle ,

Can you please share the link for the enhancement request so I can upvote it? I cannot seem to find it.

SteveF-Oracle

@GoSaaS

I did not see one specific to Publisher

https://community.oracle.com/products/oracleanalytics/search?domain=discussions&query=pie%20chart&scope=site&categoryOptions%5B0%5D%5Bdata%5D%5BparentLabel%5D=Home&categoryOptions%5B0%5D%5Blabel%5D=Oracle%20Analytics%20Cloud%20and%20Server%20Idea%20Lab&categoryOptions%5B0%5D%5Bvalue%5D=13&includeChildCategories=true&types%5B0%5D=idea&source=community

So you will need to file a new one. Product Management reviews on a periodic basis