Answer / prasad

Vidya,

What is ur intention behind scolding the person who asked
this question. He may not know the process.

You can help him with out scolding also rt ??

Thanks,
Prasad

Answer / vidya

To set oracle Database at Content managet:

1> start Cognos confg. at content manager

2> In the explorer window, under data Access, content
Manager Delete Content manager to select right clk.

3> Right clk content manager, and then clk New resource
Oracle Database.

4> In the Name box, type name for Resource.

5> At type box, type name for resource.

6> In properties window, provide value depend on Database
type.
Put appropriate value for Database Server and portno,
service Name Properties.

7> If you want to change the Logon credential specify a
user ID and PW, clk the value box next to the user ID &PW
property then clk the Edit Button.

8> From the file menu, clk save.

The logon crtedentials are immediatly Encrypted, Content
Manager Now able to create the required table in the
content Store with Oracle Database.

Regards,
Vidya
SSE, SCSL.

Answer / vidya

Hi Valraj

I written there steps to Configure Cognos8 with Oracle
Database. After read ur's view I come to know that you do
not have single Day exp. in Cognos so you asking ambiguous
things.

My answer was to help Real time working Associate who have
any trouble to configure cognos, Not for any false or fake
candidate to Qualifying Any Interview.

Create any Database on Oracle is not responsibility of a
Cognos Reporting team. Oracle Functional or DBA Associate
will responsible for Database creation in Oracle.
Securities can be Define at Cognos framework manager for
Cognos Reporting.

Being a OCA Certified associate I can tell you few steps
for create Database at Oracle it may help you beco’z I come
to know that u r a beginner in IT industry:
Steps are:

1> Create initialization file spfle &pfile
( '/ora/xyz/int.ora; )

2> Create a database creation script (@crdb.sql)

3> Connect to the instance

4> Decide &set ORACLE_SID

4> Create db Authentication db_name= ...

5> connect to the instance

6> Create a server parameter file

7> start the Instance

8> Issue the create Database

9> create Additional tablespaces

10> Run script to build Data Dictionary view

11> Run script to install any additional reqiered

For Create a password u may write script as:
Create user username identified by passward default
tablespace data quata unlimited on data;

on unix env. you may write as:
$ orapwd file= $ORACLE_HOME/dbs/orapwxyz
password = oracle

regards,
Vidya
SSE, SCSL

Answer / aashish

Vidhya,
You might be a good OCA but not a good trainer. You must
know how to address issues one is facing . Each one is
having skills so rather than showing urself superior you
should concentrate on bringing others up.

Cheers!!!

Answer / velraj9

Thanks for your help Vidya.
You have given the details for Cognos Configuration area
only. Can you help me how to create a new database in
oracle? (For example i want to create database name CM).
Also how to give access permission(User-ID and Password) for
that database in oracle. In SQL SERVER 2000, we can create
new database directly(Just Right clicking New database) also
we can give login details in Security area of SQL Server
Enterprise Manager. Like that Can we create in
Oracle Enterprise Manager? The same User ID & Password we have to
give in Cognos Configuration. Pls help me.

Answer / timekeeper

Move to framework manager bin and select cogconfigw and
select the content store and name the Database name as orcl
and give the port number related to orcl.And select any
oracle Database and create it in cognos connection.
This is my view.

Answer / l m patel

Yes i agree with Prasad n Ashish.

What are different events in Report studio?

0 Answers   Wipro,

what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,

What is content Manager?

3 Answers   HCL, Kekran Mekran,

how u provide security in power play transformer???

3 Answers   iFlex, ITC Infotech, TCS,

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,

Hai frnds, Any body tell to What is Granularuty in cognos Please help me.i can search in so many browsers but i canot get the answer

3 Answers   Wipro,

Use of Text Source Variable in Report Studio?

2 Answers  

suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?

5 Answers   TCS,

Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos

2 Answers   IBM,

i am having a table having name cust_employee.i use this table in my model after i published that to cognos connection .i generate some reports. after that in my data base cust_employee table is changed to cust_emp.how can i get this table into my report.i again import and published means its time consuming,in simple how can get the changed table in to my model pls pls ans me....

2 Answers  

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

0 Answers   HCL,