Answer / bharani

IF I were u wll expalin my proj like this

I working for ....(name of the proj) proj,client is ....
(name of the client), which is saless and distribution
domain, technology in my proj is .......(like Informatica
as ETL TOOL, BI TOOL AS COGNOS, Backend database is ORacle)

describe a bit about ur client business a bit.
( suppose for a mall inventory level, itemsold per week and
pregressive businessd timings like festivals)

as a report author i developed ..... these kind of
reports , which are very useful for enduser to take
business decisions.

Generally DWH group contains
1.database team( like oracle)
2.ETL team
3.BI team
4Testing Team
5.Support Team

team 1: perople generally load the data into database and
architect will prepare ER model for that and constraints
ofthe table.

Team2: once data entered into the dbase, Etl architect
prepares star schema for Dwh and Etl developers extract
data from dbase and made some transformations (depend on
business requirements like scrubbing) and load that data
into Datawarehouse in the form of datamarts.

Team3. Bi architect extract the data from Dwh and prepares
a model (universe)and work wll be assigned to Report author
to populate the data in the form of the reports asd per end
user requirement.
Team 4: testing team generally test the report and if any
bugs found dt will be forwarded to support team.
Team 5. this team people try to resolve those issues if it
is not possible for them again it wll transformed to Etl
team.


completely this is a cyclic process.

As of my knowledge.

Bharani working for IBM

Answer / naveen

thank u
it is very useful to all

Answer / vijay kalyan.v

It is always good to know about your Project teams. Report
Authors has to regularly interact with ETL team for data
related Queries.

Answer / priya

Thanks bharanai.im a report developer is it necessary to
explain about ETL process.clarify

Answer / sharath

thanx bharani


nice answer,it helps us a lot.
great patience yaar.

Answer / ramgupta

Thank u ! bharani

Answer / uma

yes its very usefull.....

Answer / bharath

THank you very much Bharani

How can we find out cardinality between two tables?

3 Answers   IBM,

What is the disadvantages of using Database functions instead of using Cognos Functions in Report studio?

1 Answers   Cognizant, Niteo, SacSoft,

In which types of reports does the page breaks applicable in Cognos...?

1 Answers   IBM,

I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

0 Answers   IBM, KKL, Reliance,

Is cognos models are version compatible?

2 Answers  

how u provide security in power play transformer???

3 Answers   iFlex, ITC Infotech, TCS,

What is meant by drill down?

0 Answers  

What is architectue of Cognos 8

4 Answers  

at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???

1 Answers   Covansys, IBM, Wipro,

Can you define set to be cardinality?

0 Answers  

What is an open session command in cognos connection?what is it meant for?

1 Answers   Infosys,

HI,can one suggest best institute for cognos Training in Hyderabad

14 Answers