Skip to Content

No custom number format in Web version of Web Intelligence?!?

When using the "Rich Internet Application" version of Web Intelligence (see WebI preferences below) I can specify a custom number format. I have some users that have so many Java related problems when using that version I have them use the "Web" version. For the most part that works despite the annoying subtle differences such as button placement.

Today one of my users who is using the Web version asked me how to do a customer number format that he had seen me do. Unfortunately, there doesn't seem to be a way to do this in the Web version. Are we really stuck here?

Thanks,

Noel

pastedImage_0.png (20.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on May 30, 2013 at 01:53 PM

    Hi Noel,

    the answer is at page 190 of the Web Intelligence User Guide:

    http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp5_ia_en.pdf

    it is stated:

    "You cannot apply custom formats to numbers in tables in the Web interface (DHTML interface)"

    Please see also KBA 1747822 - How can I format a custom number for
    a web intelligence report in the web viewer in BI4?

    Best regards,

    Simone

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2013 at 11:25 AM

    Another alternate would be to train your users to use Format number function as below.

    =FormatNumber(Sum( [Invoice Amount]);"$####0")

    Thanks

    Mallik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2013 at 09:39 AM

    Hi Noel,

    We did experience the same behavior when using web viewer from the Design mode of the report. It works fine through rich client

    If you want users to use custom format, one thing that can be done is provide the custom formats required by them on static cells of the report giving some default number like "12345.99" and then you can ask them to use Tools>Format painter to copy this format and paste wherever they would wish to change the format.

    Again there are limitation in this approach that they cant go for any custom format that is no defined on the report.There is chance of overwriting formats in reports using Formatting Rules.

    I would say best way is to push them back using RIA viewer and resolve the issues they have, if its easy to do.

    Thanks

    Mallik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.