Skip to Content
0
Former Member
Jun 07, 2011 at 09:28 AM

How to use common object from two tables with out join.

74 Views

HI,

I have two tables called A & B In A table i have the following objects

1.weekend

2.S1(measure)

3.S2(measure)

4.S3(measure)

5.S4(measure)

And In B table i have followning columns

1.week end

2.p1(measure)

3.p2(measure)

4.p3(measure)

5.p4(measure)

Now in universe i created all the measure objects i.e.s1,s2,s3,s4,p1,p2,p3,p4 A.weekend,B.weekend.

instead of using week end two times i wnt to use only once because this is common in both table.

if i use join between these tables i am getting values fine

But With out join is there any thing to do in universe level to create common objects to use from both the tables..I tried using aggregate awareness but while reporting it is taking as two SQL.which is not synchronized.

Please help me on this ...