Search results for query: *

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.

When somebody tries to open a spreadsheet we get this message: FileXXX.xls is locked for editing by ''. We don't see who's using it.

There's an heirarchy of how the system pulls the GL account and this applies to vendor,customer and item. First, the system looks at the maintenance card in your case the Vendor Maintenance then if that's blank, goes to the Posting Account setup. If this is blank then will leave the distribution...

I'm not a programmer so looking at that link doesn't help me. I need somebody who can point me what's missing and where to insert in the script. I got the script on a VB script site. tks.

This script is working but only can look at one folder. I have around 300+ subfolders and want the script to loop and look at each folder: strFolderName = "c:\Billing\Invoices" Set objWMIService = GetObject("winmgmts:") Set objFolderSecuritySettings = _...

I need a script so it'll give me the owners of certain folders/subfolders.