Merge 2 Derived tables to 1

[Aino]

Hello,

A have build 2 Derived tables (same structure) because the SQL script is to long to put it in one.

Can I merge them to one (derived) table ?

I tried this but it would work:

Select * from [DERIVED_TABLE_01]
union
Select * from [DERIVED_TABLE_02]


Thanks

 

[skrandel]

No. Your database doesn't know what your derived tables are.

Just take the SQL from DT1 and union it with the SQL from DT2.

DT=Derived Table.

Steve Krandel
Intuit

 

[Aino]

Skrandel,

Thanks for your reply.

The reason I used 2 DT, is because BO has a limit space to put your SQL statement.

So the only way to resolve my problem is to build a view in de RDBMS......... :-( (I have to ask the DBA)

I hoped there was another way because I have to build and release my report today to the users.....

Thanks.

 

[blom0344]

Well, since you can build a union construction at the reporting end you can use two seperate DT's and fix things in query panel..

Ties Blom

 

[Aino]

Blom0344,

Thanks for your reply.

Bottem-line is that all those solutions are work arrounds because BO has put a limit to a DT.
I know, the right way is to build a View in the RDBMS, but why offer a solution in a product what I can't use ?

I have to join every DT with other tables to fully use them. So fix things in a query panel is also no solution to me.

With COGNOS I don't have this limit....... (sorry).

 

[blom0344]

I have to join every DT with other tables to fully use them.

Which is exactly the solution that will work.
Create a context for each DT (consider them as facttable) and create a union in query panel. This is fairly basic stuff..

Ties Blom