Question { TCS, 20401 }

how many facts&dimensions tables in a sales project?can any
body name those dimensions and fact tables please

Answer

There is no mandatory for maintain Dimension and Facts.

We cant specify.why bcz its depends on clent requirement
itself they will tell everything.

Normally u can say like this

Dimensions------> we have Product Dimension,
Time Dimesion,
Country Dimension,
Customer Dimension,
Order Deimension,
Shippers Dimension,
Order Details Dimension,
Inventory Dimension,

Facts------------> We have Sales
Fact,Revenue,Discounts,Quantity,Price etc................

I hope now its clear for u.

If still any thing else pls letme know.

Question { 9962 }

various types of joins

Answer

Joins-------------------- We have
Equi join,
Non-Equi Join,
Outer Join,
Self Join,
Cartesian Join.

Question { 14028 }

How to do deployment?

Answer

Deployement: It is Export and Import.

Export: Export Package From datasource goes into File.

Import: Import package from File goes into Datasource.

How to do Export and Import---------------- Open -->
Cognos Connection ----> Go to Tools Tab--->Expand Tools--->
select Content Administration--->Then u will get1 window-->
Select required Package--->Then Right side top we have
Export and Import Icons are there ----> Select Export--->u
will get widow ----> There we have 3 options willbe there->
Then Read and select Raio buttons-->then again u will find
1 window-->There u have to specify package name-->Clickok-->
Then Package is Exported

Question { 14028 }

How to do deployment?

Answer

Continution----

Import--->Click on Import--->u will get 3 options u have to
specify all the 3 options---->Cilck Ok----> Then u will get
1 window there u have specify package name---> Click Ok--->
Package will be Exported.

Question { 12917 }

what is the difference between cascading prompt and drill-thru

Answer

Cascading report contains one report and it works based on
the condition.

Uses the value from the previous prompt to filter in the
cureent prompt.

EX: If u select a Country----- India.
in the next prompt all the States will be displayed.
those which are under india.
If u want to c the details for the state------TN,
Then select TN from the list which will display all
the details for TN.

Drill Through Report: This shows current context of a
report,to access information in another report.(i.e Based
on the current data detail data of another report will be
seen.

Question { SAP Labs, 5031 }

Can anyone tell me which automation tool is used in
cognos,is it a testing tool or performance enhancing tool

Thanks in advance

Answer

Hi,

Your Question is wrong.

---------Cognos is a one of the Business Intelligence Tool.

--------- It is a Reporting Tool.

Question { HSBC, 5306 }

difference between imprompt and reportnwt1.1

Answer

Imprompt------------- It is a Cognos series--7 product.
We will create and develop the Reports and Publish their
reports in Upfront.

Whereas

Reportnet1.1v--------- It is one of the product in Cognos.
Cognos Connection -------- Webbased.
QueryStudio -------- Web Based.
We will create simple Reports in Query Studio.

Report studio -------- Web Based.
We will create List,Crosstab,chart,finanace,map,Blank
etc........

And

1 More thing
Framework Manager is--------------- DESKTOP-------BASED

Question { Syntel, 11414 }

what is your project workflow and your role in the project?

Answer

As a Developer---------------------- Develop the Reports.

And Based on spects Acoording to client requirement
Developer he will do Reports.




If it is not clear pls letme know.

Question { Syntel, 8905 }

difference between stored procedure and function?

Answer

PL/SQL------------- It is a named PL/SQL Block.
------------- Which can take 1 or more values.
------------- It accepts Parameters.

Usage-------------- Reusability.
-------------- Precompatibility.


Whereas

Functions----------- It is a named PL/SQL Block.
----------- Which can take 1 or more values.
----------- It must a Returns value by using
return statement.

Question { IBM, 25485 }

What is namespace and what it holds?

Answer

Namespace: It is used to Logically grouped Metadata.
(Qerysubjects and Queryitems.

Question { 11054 }

Any Cognos planning Queries Rise

Answer

I too dont no about Cognos Planning.

I am trying to get those information.

But i know little bit about Cognos Planning.

We have Analyst,
Contributor,
Contibutor Administrator.

Question { 4905 }

plz anybody help me, how many reports we can create in one
project?, and what are the names?in real time project at
first what we will do?

Answer

we can develop many reports.
It depends on requirement.

we do list report with
Promts,ConditionalFormatting,Filtes,Cascading Prompts,Drill
through Report,Charts etc...

We can do any type of reports.There is no limit.

I hope now its clear for u .

Question { 14558 }

what are the uses of report studio,q.studio,analysis
studio,event studio&.metric studi.

Answer

Query Studio: Query Studio Reports aare Adhoc-Reports.

Report Studio: It is used for doing Reports.
And we have able to do mulitiple reports in Report Studio.
Blank Report,
List Report,
Crossstab report,
Chart Report,
Repeater,
Finanace Report,
Map Report.
These reports are we will do in Report studio.

Analysis Studio: We will do only cubebased reports.

We suppose to do only Crosstab Reports.


Metric Studio: We will do Score card Reports.

Event Studio: We will create Events.


I Hope its give some Ides on studio's what exactly we do in
Stusio's.

Question { iFlex, 8462 }

advantages of cascade prompt ???

Answer

A prompt whivch takes the value from the other prompt is
known as cascade prompt.

EX:If u select any Country (India) it will display the
Region.

Then Select any Region it will diplay the State. by
selected values. Like that it will display the City also.


This kind of situation we will use this prompt.

Question { 6918 }

What is Crossproduct?

Answer

Each row Table A is join with all rows from Table B.

Ex---- Table a has 3 Rows.
Table B has 2 rows.


Now the Cross Product of Table A and Table B gives 3*4=12

Totally 12 rows are displayed as the Output of Cross
Product.