Recent content by Dukester0122

Can Cognos 6.5 open an OLAP cube from SQL Server 2005?

Perfect!

I'm trying to add another field - CUSTNBR (tables PK) and i'm getting this error: Msg 8120, Level 16, State 1, Line 1 Column 'TABLE.CUSTNMBR' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Thanks George, first script is enough.

I tried this and was failing: select CUSTNAME from CUSTTABLE where CUSTNAME in (select count(adrscode) from CUSTTABLE)

I have a database with customers and some with more than one address. I'm trying to capture the customers with more than one address and return the resultset. I tried to do count(ADRSCODE) and distinct but never really got the result I wanted. Appreciate any help from the group, the following...

Did you run grant.sql against all DBs?

What O/S will be running on your Blade server - Windows 2003? If your answer is Yes then there's no difference.

I'm moving all our SQL Servers and is now half-way. While we were doing I tried to check the versions and found that the old & new had different SP2 installed. The old server was in 9.0.3054 while the new servers were in 9.0.3042. I know these are different versions of SP2, can I just install...

Let's all pray for their safety.

I haven't seen table name changes in the core modules(refer to David's post above) but saw some in Manufacturing so I don't know what msndba is referring to.

You normally have this issue when installing remotely. I found that it helps to have the file saved locally.

A few questions as you're not very clear: 1) Were you in an inquiry window when this happened? If yes, then it nothing should have happened when you lost connection. 2) How can you lose an invoice when the document you're working on is a payment? Or was the invoice unposted?

I always advise to run a sales edit list before posting the batch.

That's true you definitely need to do some calculations or roll-up in Crystal. Here's what might help, look at GL10111. This table shows summary of each account so in Crystal you can put a parameter where the user enter a data range or a period/year.