Join is not working in DMR (cognos 10.1)

[UseCog]

Hi All,

I tried to join 2 query in DMR and it gives me the following error 

DPR-ERR-2056        The Report Server is not responding.

I have a classic scenario in a Cross tab, where I basically needed to show all the lines (along with the cost centers) of a Profit and loss even if It the value is 0. The SQL query now brings back only the lines have a value.

Can you please let me know
1. Does the join work in DMR (Oracle as backend)
2. Any other methods to force the rows in the DMR even if they dont have any values

Thank you in advance

[UseCog]

Even though the join wont work, I have used a if condition to check the total(currentMeasure within set []) is null and replaced with 0. This worked for the cross tabs without nesting on another dimension and I want to get to work with the same with nesting and cant get this out ....any ideas

[cognostechie]

The DMR is re-structured data in the form of OLAP from relational. The DMR uses the joins of relational modelling so if you have a proper join then it should work. That error usually comes up when the processing takes a lot of resources which could be the result of a cross join or something like that.

[UseCog]

Thanks for your answer,

I have tested the join with 2 simplest queries I can create with just 4 members in each queries.