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

what is exact catalog size?

4 Answers   IBM,

How to move reports one server to another server?

2 Answers   Wipro,

when can i use the STAR Schema and SNOWFLAKE Scgena

4 Answers   IBM,

Explain what is the difference between microstrategy and cognos reporting tool?

0 Answers  

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  

What is Crossproduct?

2 Answers  

what is cube size?

4 Answers   IBM,

What are the differences between main Cognos 8.2 and 8.3 ?

2 Answers   IBM,

hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd

1 Answers  

how u migrate reports to cognos 8 from previous versions

3 Answers   TCS,

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,

can any one say the which is the best performance in framework manager

1 Answers