I have recently installed IIS on my home machine ( Windows XP SP3) and built a simple web site to allow family members to browse 'photos etc stored on an external hard drive from their own devices via WLAN.
What I have found is that when IIS is running and I try to browse the internet from the...
Try scheduling the report to run in little later. BTW Cognos 10 renews the credentials each time a scheduled report/job is run so the problem of renewing cedentials goes away.
If fishing was easy it would be called catching
Have a look at the SQL Position function. For example, find the position of the 'dot' delimiter of the file name and then the position of the first 'space' before the filename and so on.
If fishing was easy it would be called catching
Have a look at Package Protection again. It's likely that the password is not being saved. Set it to Encrypt sensitive with password and set the password. Then edit the step in SQL Server Agent job and apply the same password
If fishing was easy it would be called catching
Have a look at Package Protection again. It's likely that the password is not being saved. Set it to Encrypt sensitive with password and set the password. Then edit the step in SQL Server Agent job and apply the same password
If fishing was easy it would be called catching
thread401-1392169
Cognos 8.4 Report Studio
Using a listbox to prompt for Fiscal Year. Current fiscal year should be highlighted (selected) by default, but still allow user to select another year.
In other words I'd like an example script which focuses the list item based on some sort of...
Extracting data from a Progress SQL database truncates varchar columns.
Environment :
Windows 2000 SP 4
MS SQL Server 2000 Microsoft SQL Server 2000 - 8.00.760
Standard Edition (Build 2195: Service Pack 4)
ODBC Driver is DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E
99% of the time all is...
I can't see a way to get it all together in a single select.
What about using a stored procedure then use coalesce to get all the Addresses into a variable separated by commas?
Something like:
SELECT @AddessList = COALESCE(@AddressList + ', ', '') + CITY FROM Address
If fishing was easy it...
Interesting! Let me get this staight...
Entity 001 has Names
001 - 01 Jim
001 - 02 Jimmy
001 - 03 James
and Addresses
001 - 01 Chicao
001 - 02 New York
001 - 03 Los Angles
How do you determine that Jim is associated with Chicago,
James with New York and Jimmy with Los Angeles unless...
Open Excel, click Fle > New > New Workbook. Then Tools > Options
and on the General tab set 'Sheets in new workbook' to 1.
If fishing was easy it would be called catching
Might be permissions or could be you need to apply fix pack.
Try searching http://www.ibm.com/support/us/ for SQL0443N ALTOBJ
If fishing was easy it would be called catching
Have you checked that all the Virtual Directories in IIS are pointing to the correct path and have correct permissions?
If fishing was easy it would be called catching
Navigate to ..\Cognos\c8\bin and open Logview.exe then Load ..\Cognos\c8\logs\cogserver.log. This might give you some clues
If fishing was easy it would be called catching
I'm assumimg you do not want days/weeks as it's a financial calendar. In which case don't use the date wizard - just add a Date dimension snd add FIN_YEAR as first level and then FIN_MONTH as next level down
If fishing was easy it would be called catching
What CognosProfessional says is true, but your can also import User Defined Functions. You have to include the appropriate collection (libray in i-series speak) in the data source.
If fishing was easy it would be called catching
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.