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

Can you define a query subject?

0 Answers  

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

What is cognos connection?

0 Answers  

How to hide value prompt box and list when run report?

4 Answers   IBM,

Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain

0 Answers  

Define report item?

0 Answers  

What are cognos connection initial page components?

0 Answers  

What is the deployment requirements used in cognos?

0 Answers  

How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

1 Answers   Mind Tree,

in u r data u having duplicates how to fetch the latest data in our report?

2 Answers  

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

0 Answers   NEC,

Can you define transformer?

0 Answers