Skip to Content
avatar image
Former Member

Merge dimensions

Hi All,

I had created a report on multiple datasources,

in Query-1: Customer, year, revenue

    Query-2: Customer,Cost

So, here the common dimension is Customer, i have merged on customer field But, here in Query-2 some of the customers are not there.

help me how it will comes in the report level, it will show as null values or what?

Please help me on this....

Thanks in Advance...

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 13, 2015 at 02:46 PM

    Hi ,

    when you merge dimensions, the merged dimension wil contains values from both providers (as you are doing a UNION query).

    To identify from which query the Customer come in, you will need to create detail variables on year, revenue and cost, with associated dimension = Merged customer. If dropping the detail variable on a table as well as the merged dim, whenever the detail variable show null, the Customer will come from the other query.

    Bear in mind that, if you drop the merged dimension and any object from the others queries, the table will reflect the Intersection of it.

    Please see How to Find Matches e No Matches in Dimensions from 2 Queries (Union, Intersection and Difference)

    Cheers,

    Rogerio

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 07:41 PM

    Hi Chaitanya,

        Merging similar dimension from different data providers give as an opportunity to link the same field in all the datasources.

    Query 1 - Customer -> contains the customer values from Query 1

    Query 2 - Customer -> contains the customer values from Query 2

    Merged Dimension - Customer -> contains union of customers from both Query 1 and Query 2

    Kindly refer to the below article for more details,

    Merge Dimensions and extended merge in Webi

    Regards,

    Balajee

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 03, 2015 at 08:46 AM
    Add comment
    10|10000 characters needed characters exceeded