Skip to Content

ADD two calculated measure from different queries into ONE

Hi Folks,

For one of the requirement of report (OR most of the report has this), need to calculate Total = Total Purchase price + Total Sales Price. These two prices are from two different queries.

The last line at the second table shows the Net Total, Here I'm unable to achieve Total Purchase Price + Total Sales Price. Could you please guide me on how to get this value?

Additional information:

1. Both Purchase/Sales price and Total Purchase/Sales Price are calculated at WEBI. Even Total Purchase/Sales Volume are calculated.

2. Rest other are coming from same universe. i.e., both queries from one universe.

3. We can't push these calculation to Universe because of the complexity in calculation. We are on BO 4.0, using UDT for universe development.

4. Have tried using context operation (In, ForEach, ForAll, Where, Report, Block, Section) but didn't get the desired values.

Right now I can't think of any solution other than bringing this model to BW and then build BEX along with WEBI. But user says NO to BW.

Please let me know your ideas to achieve the requirement.

Thanks in advance,

Umashankar

WEBI.jpg (230.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 01, 2016 at 02:38 PM

    is there dimensions are merged from both the webi queries? if not then merge the base two dimensions and then use variables in the total row.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 04, 2016 at 02:03 PM

    Hi Uma,

    Did you try to use REPLACEMENT PATH using QUERY? I think it will work..I just don't know if it can be used in WEBI..

    Regards,

    Loed

    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.