Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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 ...

Former Member
Not what you were looking for? View more on this topic or Ask a question