Skip to Content
avatar image
Former Member

Display objects from two queries in one report

Hello @ll,

how can I display several objects (defined as Dimension) from two or more queries in one report ?

For Example:

Query 1

+ ID Number

+ Date

Query 2

+ ID Number

+ Customer

+ Address

Although I bring together the ID Number in two queries it is not possible to display the objects Date, Customer, Address in one report. The error is "incompatible objects"

Please, can you help me to find a solution for this problem ?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 12, 2010 at 12:58 PM

    One Webi document can have multiple queries and multiple reports but each report can only contain data from a single query.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 12, 2010 at 01:05 PM

    Hello ThHein,

    Are the queries against two different Universes or one? I assume two or else you could put all the data in one query. When you say you bring together the ID Numbers, do you mean you merged the ID Number dimensions? I am not sure what you are trying to do, but it may work if you pull a date into query 2 and merge that dimension also, or same with customer in query 1.

    Can you provide more details?

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 12, 2010 at 02:15 PM

    There are a few ways around this issue. You can either bring in date into the second query and merge on that, as long as it corresponds to the date in your first query.

    You could define Customer and address in a formula as measure objects, since measures can be used across query if there is a link. Or if you still want them to behave like a dimension object, you could define the objects as Details, with the ID being their parent dimension.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Dave..

      Thanks for such a detailed explanation..

      Finally, you can include any detail objects that are associated with linked dimensions

      With above point, We can conclude that Customer + Address +Date can be part of block, if we make them detail of Linked dimension (ID number)

      Also will there be any scenarios where, We can not include unlinked dimension objects from exactly one data provider in the block..

      Thanks in Advance !!