vij yad


{ City } thane
< Country > india
* Profession * bi-consultant
User No # 27588
Total Questions Posted # 0
Total Answers Posted # 10

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 80
Users Marked my Answers as Wrong # 12
Questions / { vij yad }
Questions Answers Category Views Company eMail




Answers / { vij yad }

Question { IBM, 19548 }

How to create users and permissions in cognos?


Answer

This is regarding Cognops 8
to creat users open Access manager -Administration from
Tools of cognos.
first create Root User Class and then create Users in the
User folder and associate that user with ur Root User Class.
After creating Users in Access Manager-Administration go to
Portal page in that select Tools at the right most side and
then Select Directory in that u can specify Permission for
selected users or user Classes.

Thanks,
VIJ

Is This Answer Correct ?    1 Yes 0 No

Question { 5266 }

When You Import data into catalog You have complex columns
names. How do you change the Name of those columns?


Answer

Hi ,
If you want to change the name of columns of tables then
open that particular catalog click on Catalog option on
Menu Bar then Click on Folders and then expand the ur
paricular Tables folder then select the column which u want
to change the name and then Click on Edit button at the
right hand side.and give the name u want.


Thanks & Regards,
VIJ

Is This Answer Correct ?    1 Yes 0 No


Question { 29741 }

wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB
REPORT?


Answer

The main difference is
List report is detailed report ,later we can group the rows
or columns according to the requirements.

Crosstab report is already grouped data in that we can't
group any row or column.

Thanks
VIJ

Is This Answer Correct ?    16 Yes 1 No

Question { Satyam, 9299 }

1.Can we create a cube in a Transformer from multiple
IQD's ?if so, how?
2.Also , explain some of the best practises used ,while
creating a cube in powerplay transformer.


Answer

yes we can create a cube with multiple IDQ's as data
sources,for this insert data source of tyye Impromptu Query
Definition in Transformer model.
afer creating a cube u can---
1)Partition a cube
2)Update a selected cube by batch file or by macro
3)Apply security to a cube
4)Compress a cube.
5)Publish that cube on Upfront.
6)Use that cube as DataSource in FM in Cognos Series 8

Is This Answer Correct ?    1 Yes 0 No

Question { 8132 }

How can we convert imr report into Impromptu web report?


Answer

first create the IMR reports,then Publish that report by
using Cognos Server Administration on Upfront i.e. IWR.this
is the way u can convert ur IMR to IWR.

Thanks ,
VIJ

Is This Answer Correct ?    1 Yes 1 No

Question { TCS, 40465 }

what is render variable


Answer

Render Variable: - Specify a variable based on which object
can be conditionally rendered.

Example for Render Variable:--

if the case is like you want to see the particular page in
HTML or PDF or CSV format then


1)Create 3 pages in your report
2)every page conatins some specific data
3)name these pages as HTML PDF CSV
4)create a String vaiable with 3 values as HTML PDF and CSV
5)now in string variable put expression as .....
case

when ReportOutput() 'HTML' then 'HTML'
when ReportOutput() 'PDF' then 'PDF'
when ReportOutput() 'CSV' then 'CSV'
end

6)now go the page named HTML and select page object
7)in properties pane click on Render Variable select that
string variable
8)check only HTML check box value for HTML page
9)repeat step No. 6 to step No.8 for remaining 2 pages.

now run the report :-)


hope it will answer your question .
regards
vij

Is This Answer Correct ?    22 Yes 3 No

Question { 14959 }

what is the meaning of drill down and drill up in COGNOS 8BI


Answer

Drill down and Drill up is possible only if you have
Dimensional data .
In dimensional data there are 1 or more than one levels in
one dimension.
in that when u drill down for a perticular dimension then
it will show u the level below that main level.like from
summarised data to detaild data.
and for drill up viceversa.

Thanks
VIJ

Is This Answer Correct ?    13 Yes 0 No

Question { 6202 }

whis meant by Thumbnails on cagnos?


Answer

When you use thumbnails, Impromptu retrieves only the
number of rows you specify and then saves them temporarily
on your computer.
Impromptu attempts to use only the data in the thumbnail
when you run a query. If your query requires information
that is not in the thumbnail, Impromptu accesses the
database and retrieves the information required. When you
close the current report, the thumbnail is discarded.

For example, if you work with a thumbnail of 30 rows,
Impromptu retrieves the first 30 rows from the database and
then uses the 30 rows as the data source for your queries.
If you add a column to the query, Impromptu must retrieve
the new data from the database.

A thumbnail is an efficient way to test your report before
running the query against a large database.

Thanks,
Vij

Is This Answer Correct ?    0 Yes 1 No

Question { 12724 }

What is Render Variable? where u can use?


Answer

Render Variable: - Specify a variable based on which object
can be conditionally rendered.

Example for Render Variable

if the case is like you want to see the particular page in
HTML or PDF or CSV format then

1)Create 3 pages in your report
2)every page conatins some specific data
3)name these pages as HTML PDF CSV
4)create a String vaiable with 3 values as HTML PDF and CSV
5)now in string variable put expression as .....
case

when ReportOutput() 'HTML' then 'HTML'
when ReportOutput() 'PDF' then 'PDF'
when ReportOutput() 'CSV' then 'CSV'
end

6)now go the page named HTML and select page object
7)in properties pane click on Render Variable select that
string variable
8)check only HTML check box value for HTML page
9)repeat step No. 6 to step No.8 for remaining 2 pages.
now run the report :-)


hope it will answer your question .
regards
vij

Is This Answer Correct ?    9 Yes 0 No

Question { TCS, 15128 }

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 Vijay,


In your value prompt add the static chioce as 'All'
and in filter put the expression as....

(column in (?Parameter1?)) or (?Parameter1?='All')


hope this may help u :)
vij

Is This Answer Correct ?    16 Yes 6 No