Skip to Content

No common dimension

Hi Guys,

I need to use objects from 2 different classes in my Webi report. The 2 classes are -

1) Date

2) Employee

However, there is no common dimension to merge the classes and if I use both classes in the same query, I get less rows in my report.

In the universe, "Date" class is derived from the "DATE" table and "Employee" class is derived from the "WORKER" table.

The tables are joined in the universe (UDT 4.1) as shown below.

Now, I need to use objects from the "WORKER" and "DATE" table in my Webi Report, but there is no field I see that can join the 2 tables. Could anyone please help me with this issue?


TABLE JOINS.jpg (30.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 15, 2014 at 03:38 PM

    Does the EmployeeInteraction table have a unique ID for each row? If it does you could include that in the results of each query and then merge on that dimension.

    Noel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2014 at 08:41 AM

    create a primary key for the employeeintraction table and merge based on that.

    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.