TM1 Forum

Happy to say it has worked like a charm Jim.

Thank you again - very helpful!

Thank you for the two posts, I have done as Jim suggested and will let you know how that goes by the end of the day but it is all set up to go, I just need that report running. Fingers are already crossed. I might try the second option at some point to see if I prefer doing it that way, but thank yo...

Hi All, I use CognosExpress version 10.1. I have a process which loads data in on a weekly basis (or will do in the future). The data is loaded in by the date on which the a report is run. I.e. external report is run on the 10th, the TM1 process connects via ODBC and is run linking to this report an...

Further to this point if I wanted to include two conditions I have tried doing

eg.

WHERE ((PAIRRPT.DEAL_NO)=1734) AND ((EVENTS.CASHFLOW)="Y")

but this fails to work even though the two conditions work seperately.

Cheers for all the help so far.

Robin

Further to my previous post I have arrived at a new issue. I am extending my query now and there are several joins required however I am only able to do the one join with my SQL knowlegde. The query below is what I have so far and leaves. select DEALS.DEAL_NO, PAIRRPT.THEKEY,PAIRRPT. MATURE_DT, PAIR...

Cheers Renaud,

I will have a look at SQL also - do you have any suggestions since it is not the same as Microsoft access SQL

Robin

Hi all, I think this is a fairly simple issue but I am not sure how to sort it out. I have information in an SQL database which I want to obtain. I have set up a query to bring in the information from one table and this uses the code SELECT DEAL_NO, DEALTYPE FROM DEALS however now I want to be able ...