Skip to Content
S N

Merge dimension issue

I am merging 2 diemnsions from different queries. But issue is I can only pull one of the query objects in a single block. Its not allowing me to add objects from both the queries to add in same block.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Aug 16, 2017 at 02:55 PM

    you can add all the data from 1 query to the block and to add date from the other query you have to create "detail"variables of the merged object..for measures you do not need to do the same

    par example

    query 1 ID and address and amount

    Query 2 ID and email and quantity

    Merged object: ID

    Detail variable: email of merged object ID

    in report

    merged object ID / address / detail variable email / amount / quantity

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2017 at 02:53 PM

    you have to create detail variables for un-merged objects which you want to use in the table.

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2017 at 04:35 PM

    Thanks Guys it worked

    Add comment
    10|10000 characters needed characters exceeded