Question { IBM, 9548 }

what is cube size?

Answer

cube size is not static. it may vary.the max size of the
cube is 2GB. if the cube size is increase,it decrease the
performance.

Question { TCS, 19693 }

what is query subject

Answer

Query subject is a set of query items that have an inherent
relationship.

Question { IBM, 47057 }

how to retrive only second row from table?

Answer

select * from emp a where 2=(select count(distinct(b.rowid)) from emp b where a.rowid>=b.rowid;

Question { Wipro, 11180 }

what is meant by roll up and roll back in dataware housing????

Answer

Roll Up: A method used to summarize measure values up the category tree structure.

Roll Back: I think this method is available only in oracle. roll back retrieve all records after delete the records from table.
for example if the emp table contain 100 records. delete these 100 records using delete command like *delete from emp* we can also retrieve all these 100 records using roll back method.

Question { iFlex, 9102 }

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

Answer

Tabular model defines a simple list query item.it contains
a tabular model reference.

Question { TCS, 34166 }

16. How can we create top 10 and bottom 10 records in
the same list?

Answer

Hi,

All are wrong.for ex. if u have list report with
region,staff name and revenue. if u want show top 10 and
bottom 10 performance based on the revenue, drag new data
item from tool box to query item box then expression window
will show in that type like

For Top 10 performance:rank([revenue]desc for [region])
and give name for new query item like Rank or anything.
then drag this new query item to the detail filter window.
then type [Rank]<=10.

For Bottom 10 performance:rank([revenue]asc for [region])
[Rank]<=10.

if u want any query about cognos don't hesitate call me
by mobile:9787642227

Question { EDS, 8784 }

can anybody tell me when do use 'running total'...give an
example for the usage of running total

Answer

Returns a running total by row (including the current row) for a set of values

*For example if our list container contain order no,product name,quantity
*Then we drag query calculation
*Then we give name for new column. that name is Total.
*In expression definition window drag running-total function from summaries function of left side available components.
*If we want ruuning-total for quantity,drag quantity data item within running-total function. like running-total(quantity).
*Finally in report output in total column the first quantity value will display in first row of total column, in second row of total column add first quantity and current row quantity, in third row of total column add first,second and current row quantity.

Question { HCL, 7103 }

what is view? types of views?

Answer

A view is a tailored presentation of the data.contained in
one or more tables or other view.it takes the o/p of a
query and treat it as a table. it does n't require any
space in database.

ex.create view emp1 as select empno,empname from emp;

types of view:Materialised view.

Question { Syntel, 5312 }

how can you create a report like if country=india then true
if contry=spain then false?

Answer

1.Go to Report Studio
2.Select list container
3.Drag query item to the list container. i.e for example we take country,staff name,revenue query item from source tab
4.Drag query calculation from tool box tab to right side of the container.
5.In the box give new query item name. in this example Result is new query item name.
5.Expression definition window will show. in that we type like this.

case
when [country]='India'
then 'True'
when [country]='Spain'
then 'False'
end

6.Then run the report. u will see new column is result. in that true value will display equivalent of India country and false value will display equivalent of Spain country.

Question { HCL, 7141 }

write a query to display the third record from the employee
table?

Answer

No friends,

rownum is one of the column name of table like
emp_no,emp_name etc. if u have not rownum column in ur
table,how to solve it.

we can retrieve this record through physical location that
is using rowid not rownum.

select min(rowid) from emp not in(select min(rowid) from
emp not in(select min(rowid) from emp));

Question { TCS, 15593 }

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?

Answer

Hi Everybody, This is very simple.don't have any calculation to solve this question.

1.Drag any one of the data container to the work area.

2.Adding data item to the container

3.Create prompt page

4.When we Add value prompt to the prompt page. we create parameter then select package item, and then when we select operator we will see more operator like =,<,>,<=,>=,in,not in, in_range. in that operator we should select in_range operator.

5.After that we do normal procedure .

6.when we run the report, If the value prompt contain 100 numerical values, we should select 1 in From drop down box and select 100 in To drop down box. If the value prompt contain char type .that is it may contain product name,select first product name in From drop down box then select last product name in To drop down box.

7.Finally in report output we will see all values in value value prompt instead of particular value.

Question { IBM, 6508 }

what is a bookmark? what concept we use in bookmarking?
please tell me how to create bookmarks(with explore)?

Answer

Hi,

Bookmark can be used to quickly move from one part
report to another part of report.

if u have morethan one page in a report, at that point
in time u can use bookmark.

first u create table of contents and create morethan
one page and save unique page name. then drag book mark
icon from tool box to top of the table of contents(table of
contents means like index of the Book) and in the
properties pane give name for book mark. then each page of
bottom drag text item then type text like Go back to book
mark then right click the text and then select drill
through definition then will show the window in that window
select book mark tab then select the name of book mark what
u defined earlier. then run the report.

if u clik a one page then u will get detailed
information then u can get back to the front page using
book mark.

if u want any query about cognos call me:9787642227

Question { Satyam, 9723 }

What is a Complex report and explain?

Answer

Complex Report is not separate report. In our project we faced complex queries and complex calculations in a report. That report is called complex report.

Question { 5869 }

What is Index?

Answer

Index is one of the databse object.it is used to quickly
locate the particular record.

i.e.if a table contains thousand's of record, in which
retrieving the particular record is difficult.so if we
create index in primary key column, we can retrieve
particular record very soon. so we can save the time.

ex.create index indexname for tablename of columnname.

Question { 4758 }

what are the tabs in cognos ?

Answer

Hi Suresh,

I think ur answer is wrong.
There are 3 tabs in cognos. They are 1.Source Tab 2.Query Tab 3.Tool Box Tab