edgar.valdez

Useful document that explain how to set up audit database and report package.

https://www-304.ibm.com/support/docview.wss?uid=swg21370536

I got an error when i wanted compile DSServlet.java file, later i will try to fix it.

Too useful when “something strange” has happened and you need to get back sysadmin rol…you should to execute AddSysAdminMember.sql script in the content store database

Then in cognos connection add your “admin user” to sysadmin group and quit “everyone” group from it.

Script is placed at:

installationDirectory /cognos/c8/configuration/schemas/content/yourRDBMS

the answer is here:

https://www-304.ibm.com/support/docview.wss?uid=swg21343435

it works!

Open IIS Manager, go to web-sites properties then go to Directory Security, Authentication and access control, untick all boxes with authentication methods other than “Integrated Windows Authentication” click ok and then Apply.

Open IBM Cognos Configuration, go to Secutity, Authentication and then select your Active Directory namespace, click in Advanced Properties and add the follow:

In name column: singleSignOnOption

In Value column: IdentityMapping

save your changes and then restart Cognos and IIS services.

Some R code to achieve:

• Read Data
• Summary variables
• Histogram graphic
• Boxplot
• Covariance Matrix
• Principal component analysis

Read & load data

oDatos ← read.table(“/home/edgar/…”, header=TRUE)

attach(oDatos)

Quantitative variables

summary(oDatos$eachVariable)

Categorical variables

summary(factor(oDatos$quality))

Histogram graphic

hist(eachVariable, col=”lightblue”, main=”Title’s Graphic”, ylab=”Y Label” , xlab=”X Label”, xlim=c(n,n), ylim=c(n,n))

Boxplot

boxplot(eachVariable, col=”lightblue”, ylab=”Y Label”)

save graphic

savePlot(“/home/edgar/…” type=”png”)

Covariance matrix

cor(oWine[,1:11])

Principal component analysis

oACP ← princomp(oWine[,1:11], cor=true)

summary(oACP)

plot(oACP, type=”l”, col=”lightblue”)

title(main=”Title’s Graphic”, xlab=”X Label”, ylab=”Y Label”)

Add an “Html item” object to the page and then write this:

<script type=”text/javascript”>
      var fW = getFormWarpRequest();
      var prompt = fW._oLstChoicesValuePromptObjectName;
      prompt.options.selectedIndex= 2 ;
</script>

where ValuePromptObjectName is the object name and prompt.options.selectedIndex is the item position in the list.