Create a Trend Line at Cognos Report Studio

One day, I got an assignment to make a trendline at Cognos Report Studio, and after searching from Google, i found out how to make it from IBM site <http://www-01.ibm.com/support/docview.wss?uid=swg21340501>


From that site, u'll find how to resolve this problem, ..here is it..

You have to using N values of X and Y, and fitting the line to the expected Y' values for given X values we do the following

Y' = a + b*X

a = (Average(Y)*Total(X*X) - Average(X)*Total(X*Y))/(Total(X*X)-N*Average(X)*Average(X))

b = Total(X*Y) - N*Average(X)*Average(Y)/(Total(X*X)-N*Average(X)*Average(X))

Then it'll be:

Y'= ((total(minimum([X]*[Y] for [X]) for report)-total(minimum(1 for [X]) for report)*average(minimum([X] for [X]) for report)*average(total([Y] for [X]) for report))*[X] + (average(total([Y] for [X]) for report)*total(minimum([X]*[X] for [X]) for report)-average(minimum([X] for [X]) for report)*total(minimum([X]*[Y] for [X]) for report)))/(total(minimum([X]*[X] for [X]) for report)-total(minimum(1 for [X]) for report)*average( minimum([X] for [X]) for report )*average( minimum([X] for [X]) for report ))

Go to try it.. :p

Installing IIS (Internet Information Services)

ON Windows Server 2003:

1. Insert Windows Server 2003 Cd
2. Click Start, Control Panel, and chose Add or Remove Programs
3. Click Add/Remove Windows Components and in the Windows Components Wizard, select Application Server
4. Click Next and wait until the installation complete, click Finish
   

ON Windows XP:

1. Insert Windows XP Cd
2. Click Start, Control Panel, and chose Add or Remove Programs
3. Click Add/Remove Windows Components and in the Windows Components Wizard, select IIS
4. Click Next and wait until the installation complete, click Finish

How to Install Cognos BI Server 8

This is step by step how to install Cognos BI Server at Windows..
First of all, make sure that:
- U've already installed the IIS (Internet Information Services)
- U've already installed the database application (ex.SQL Server 2005)

This is how to install Cognos BI Server:
- Run issetup.exe
- Follow the command at the installation











- After the installation completed, open the Cognos Configuration, and open up the Content Manager.
- Fill up your Content Store-Resource Properties with the right information (Type, Database Server n Port Number (port number 1433 is the default), User ID and Password, Database Name). Before that, u have to make a new blank_database, then u can put the database name at this Resource Properties.

- After that, start the Cognos Service
- If the Service has run properly, open the IIS. (Control Panel-Administrative Tools-Internet Information Services)
- Make a new virtual directory on Default Website, named it Cognos and put the path to/C:\Program Files\cognos\c8\webcontent, this virtual directory has read access
- Make another new virtual directory inside Cognos virtual directory, named it cgi-bin, put the path on C:\Program Files\cognos\c8\cgi-bin , it has read an execute access.
- If all of that steps have done, then open up the Web Service Extensions, still inside the IIS, then set ALLOW the ‘All Unknown CGI Extensions’


- The last step, open ur browser, then type http:\\localhost\cognos, and the Cognos BI Server has been completed.