Skip to Content

Dummy values in Webi

Hi Expert.

I want to add some values into the variable .Can you please tell me how to do .

Scenrio:

I have webi report connected Bex report.

Want add two values(Standard,variance) into Webi variable . Because need split values based on these(Standard,variance) two combination).

sample screen shot attached .

webi.png (4.8 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2017 at 02:17 PM

    Merge the header cells, or create a break on the header, remove the break footer and set the 'Duplicate Values' to be merged.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      If these are literal strings in the WebI header then you should be able to merge them...

      Another option is to create static dataprovider from a Spreadsheet, not sure what version you're using but Rich Client has the capability.

      Failing that, add two standalone cells for the headers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2017 at 12:53 PM

    How would you identify the Standard/Variance difference in the columns in BEx?

    What are the names of the Key Figures used?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2017 at 01:03 PM

    Hi,

    vertical access contains two objects "Material Text" and "Material key" it has values respectively 1,2,3 and bannri,ram ,reaf.

    Horizontal access contains one object which has two values "Business" and "Conception".

    One key figure has amount ,it is dragged under standard header of business and conception dimension

    another key figure(adding two key figure values) which is dragged under variance header of business and conception dimesnsion.

    Regards

    Ganapathy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 21, 2017 at 01:25 PM

    You've a few options:

    Create two crosstab blocks, one for key figure Amount, and one for Variance, hide the vertical columns in the variance block and relatively position the block next to the amount block, or,

    Create four variables amount - business, amount - conception; variance - business, variance - conception and add these to a table and format the headers accordingly.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 21, 2017 at 01:36 PM

    Hi,

    I have already tried your suggestion but unable merge the header of Standard and variance It has header values for each column like below.

    unable to merge header values.


    webi1.png (4.8 kB)
    webi1.png (5.3 kB)
    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.