Skip to Content
author's profile photo Former Member
Former Member

merging 2 dimensions from different universes not working

Hi,

I've created a WEBI report with queries from 2 different universes.

In my first query, I select all accounts (aka Pt No) for a specific time frame.

In my second query (from the other universe) I select charge code where the account is in the list of accounts from query 1.

In each universe, the Pt No field is char(13) and is actually stored as a 12 character value padded with leading zeros (ie. each universe stores the value as 000022220001)

This works and I see results when I preview the results of query 2.

When I get to the point of designing the report on the canvas, I merge the two dimensions because I want to see some of the dimension values from query 1 married with some of the dimension values from query 2.

Qry 1: Pt No, Person, Date

Qry 2: Pt No, Charge Code

If I drop Pt No from each query individually I see this:

But when I try to put them together on the canvas, I get this:

There are more records in qry 1 than in qry 2 but there are most definitely pt no's between the two queries that match, so why does it act as though there are no matches?

Since I can't get this to work, creating detail variables to display the rest of the data is not successful.

If I create detail variables for person and charge code and display the merged dimension, and the two variables, I end up with the Pt No repeating like this rather displaying one line per Pt No:

Can someone please explain what I'm doing wrong or how I can get around this issue?

Thank you!

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2015 at 07:54 PM

    For trial, I changed my queries so that I check for accounts in query 1 that are present in query 2 (the opposite of my original design) and now everything is working, so I'm selecting all accounts (aka pt no) from Query 1 where the account is in the list from Query 2.

    I'm not sure why changing the logic in the query affected this, but at least it's working. :-)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2015 at 07:48 PM

    Is datatype for PT NO is same in both the universes?

    WHat is your backend database?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The datatype in each universe is string. The backend is SQL Server (same database) and the datatype in each table is char(13). One universe is maintained by a vendor (we cannot change) and the other universe was designed and built by my team.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2015 at 08:08 PM

    Hi, instead of bringing the individual objects to your report, bring the merged dimmensions.

    When creating the detail variables associate them to the merged dimensions

    Regards,

    Rogerio

    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.