Skip to Content
avatar image
Former Member

Merge on dimensions[not measures]

I am getting data from two different universes. I am trying to merge these two results based on a common dimension. Universe is not letting me do this. it's disabling one universe data elements when I select another universe elements in the report. Is it possible to Merge dimensions or BObj allows merging only measures?

query1:

Staff Name Service Name

query2:

Staff Name Activities Name

query 1 brings different rows from quey2 for same staff, but staff name is same. can these two be merged?

Thanks for any info on this.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 21, 2010 at 05:57 PM

    Universe doesn't allow merging. You will have to do this in report.

    So create 2 Queries in Report.

    There is nothing like merge of measures. Only merge of dimension is allowed.

    You can select the dimensions(Ctrl+Click) you want and click on the merge dimension option to merge the dimensions.

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks for all your valuable suggestions. I think I got the solution. Two ways we can solve as per the replies here:

      1) Create Seperate blocks for all dimensions and create a section on merged dimension. Easiest solution (easy to explain users) might not look like a single report but we can manage.

      2) Merge dimensions by creating varables for other dimensions and then check row aggregation property. Too much work for end users as they have to create as many varaibles as data elements in the report (other than merged dimension). But looks like a single report 😊

      Thanks for all your help.

      Sree