jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

Dashboard may be simple or complex depending upon the interactivity it has. It is the collection of may reports....

SUDHEER

• Jul 26th, 2012

In simple understandle way ,dashboard is a ,to view number of reports in a single page.

Answer Question  Select Best Answer

Sandy

• Sep 24th, 2013

Different aggregate functions are used to perform different operations on the column of the table. Aggregate functions are MAX,MIN,SUM,AVG and COUNT. It makes the calculation more easier.

Prakatta

 Profile Answers by Prakatta Questions by Prakatta

• Mar 21st, 2013

Aggregate Function specifies what type of aggregation to be applied on a data item like Total ,Average, Min etc., The roll-up aggregation of any item is important only when you create the aggregatio...

Answer Question  Select Best Answer

How to create a IQD in Cognos? Which is tool Used?

sreenivasulu pokuru

• Aug 5th, 2013

IQD is nothing but IMPROMPTU QUERY DEFINITION.It contains sql query instead of data. IQD can able to create in two ways. 1)By using Impromptu version. 2)By using "EXTERNALIZED METHOD" property in Fr...

sravan.job

 Profile Answers by sravan.job Questions by sravan.job

• Dec 25th, 2010

IQD is an SQL statement which is generated by Impromptu

Answer Question  Select Best Answer

Can someone tell me whether can we apply filter on list of values in the 'Value Prompt' e.g. I have a value prompt (named city) and the prompt is holding around 2000 cities but I want to apply a filter on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enough to select any 15 cities from the list. Is it possible. Please advice!

jaya

• Jul 31st, 2013

Just add a value prompt and use query and put use value and codes or any unique values.
use display values.
Then put the filter in the query.
Assign this query to the prompt.

sreenivasulu pokuru

• Apr 26th, 2013

1)Open the value prompt query
2)Drag a filter from tool box into detailed filter
3)Write the filter condition like country in (India,Japan,china,- - - - - - - )

that's it

Answer Question  Select Best Answer

What is scenario of determinents?

Sreenivasulu pokuru

• Apr 8th, 2013

Determinants are nothing but a need two joins between two query items at lowest granularity of data.Determinants are used for avoiding double counting results in Framework manager.

Vijay

• Apr 25th, 2012

Determinants are used when we need to join tables with different granularity. Determinants are generally used to avoid double counting.

Answer Question  Select Best Answer

1.Create a calculated column which contains the information that the header is to contain, such as "Report for year 1999" (concatenated text and date to string sub string extraction). 2.Highlight the report, and then right-click. 3.Select Properties, and then click the Headers/Footers tab. 4.Clear the Column Title Header check box. This will remove the headers from your columns. 5.Reinsert the rest...

Read Best Answer

Editorial / Best Answer

Answered by: moissi

• Nov 4th, 2007

---

1. add a data item to the query(the query on which the report is based)
2. define an expression which u want to use for the dynamic column label
3. from the report page click on the column label
4. from properties pane look for "column label" the default would be "data item label/name" change that to "data item value"
5. in the same pane change the "data item" property to have the data item that u created for the column label.

srihari

• Apr 6th, 2013

Two ways to used in dynamic columns in Report Studio

1.Query Calculation
2.DataItem

Joseph Thekkath

• Jan 16th, 2012

Mgani, How we can create the column headers dynamically using parameter maps. Here is what I am facing, in the data table we have following columns Id, Fact Period And in a Translation Table I have...

Improve Answer

srihari

• Apr 6th, 2013

Burst: you can send the data in n no of recipients through emails burst option types is: automatic email addresses ...

Shankar

• Aug 24th, 2011

Burst is; Sending information to people when the information meets the criteria. i.e Balance to the the financial controller.
Schedule; Time the production of reports.

Answer Question  Select Best Answer

Hello,I need to create schedule, based on day of week and time.Here is requirement for schedule: Report should run each business day at 08:00 A.M and return data for: ProcessStartTime (some data item) BETWEEN MON run - data from prior FRI 04:00 P.M. and today MON, 08:00 A.M. TUE run - data from prior MON 04:00 P.M. and today TUE, 08:00 A.M....

Neeraj Shukla

• Apr 5th, 2013

Create a radio button on the report and set its value Sch, create a filter on the report and set it like that

case when dayofweek is monday then (somedate between (currentdate-2 day)+8:00:00 and current date 4 hrs)
else somedate between (currentdate-1 Day)+8:00:00 and current date + 4 hrs)
end

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• Jul 23rd, 2011

Since you want data for last one week so put condition on the report to fetch data only for last week.

While creating schedule you can click check boxes for the required days.

let me know if you need any help.

Answer Question  Select Best Answer

What exactly Cognos 4GL? What are the resources of Cognos 4GL?

sohil

• Mar 23rd, 2013

Cognos 4GL is a 4th generation language by IBM, which is used for reporting in Cognos, but these days it is outdated and not much organisations are using it.

It contains 4 tool:
QTP
QUIZ
QDESIGN
QUICK

Answer Question  Select Best Answer

Ravinaga

• Jan 18th, 2013

Generally cube size is 2GB only but if we want to increase the cube size then we need to go to partition scenario. For exp: I am creating one cube with year basis that means that year cube having 2 G...

Aruna2008

 Profile Answers by Aruna2008 Questions by Aruna2008

• Dec 10th, 2011

Use of Prompt in Framework Manager: Filter on query subject - to restrict the rows that are returned by filtering out the unwanted data by creating one or more embedded filters for query subject. pr...

Answer Question  Select Best Answer

How to change database option in cognos10 content store as it has already fixed by DB2.I need to change to MSSQL Server.

Subba Reddy

• Sep 17th, 2012

I created value prompt, when I select Few values in prompt these values showing in report header between (,)s.
I need (-) in between two values.
Could you please suggest me.

moluguri

 Profile Answers by moluguri Questions by moluguri

• Aug 30th, 2012

1. Open the IBM Cognos Configuration
2. Go to Database Access,
Select ContentStore then right click on it then Delete
after that
Select ContentManaget then right click on it then Select New Source->Database->Name:xxxxx -> Type MSSQL Server-> Click OK and give the User Name and Password.

Answer Question  Select Best Answer

Hi Techies,
Need your help for achieving this requirement.

We have got a requirement to display a report in a page which should display max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should...

ASHOK KUMAR GUNTUPALLI

• Jun 14th, 2012

1.Drag a list report 2.Add the query items you need for the list report 3.Add a Query Calculation to the list report and name it as Running total,In the Expression Definition Type in running-count...

Ashish Sharma

• Apr 17th, 2012

Instead of doing this at cognos level, try to do it at SQL level using rownum function. Take the max of mod(rownum,5). then save the rownum value in a ?variable? and then take all the records where rownum>? Variable?

Answer Question  Select Best Answer

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

Join concept is same in cognos.Union concept is also same in cognos.
Since you are doing union of two tables so it will need same kind of columns in order and number this is similar to SQL.

Answer Question  Select Best Answer

What is use of Metadata?

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

MetaDeta - Is the raw data that we model as per our business requirement. Thats why we do modelling of the data (Tables and joins) in frame work.

karthi

• May 22nd, 2012

Allowing the user to search for the existing data and avoid the data duplication.

Answer Question  Select Best Answer

How we will tune reports to have better performance?

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

There are few points - 1) If you need one parameter in your report then use equal to (=) in place of in. 2) In Framework manager -> Governor -> allow usage of local cache. 3) In Report Studio -> Quer...

balajishriram

• Aug 5th, 2011

We can Improve the performance of reports in Report Studio with the help of following points : 1. We should create indexes on tables 2. We should avoid using FULL outer joins if possible.... 3. We sh...

Answer Question  Select Best Answer

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

Framework Manager supports stand-alone filters and embedded filters. Use a stand-alone filter when you want to reuse the expression. You can add a stand-alone filter to one or more dimensions or ...

Answer Question  Select Best Answer

SHYAM

• Mar 17th, 2012

If we apply filters,prompts,calculations in a report then that is called Complex report.

Answer Question  Select Best Answer

Prabhjeet Singh

• Mar 8th, 2012

Parameters generally act as a filter to a report. Depending on the user selection the report is been filtered and is provided to the user. They can be used to display what value user has selected or w...

Sateesh

• Feb 5th, 2012

Parameters are usually used for defining some characteristics of the modeled object. They are helpful when object instances have the same behavior described in class, but differ in some parameter valu...

Answer Question  Select Best Answer

Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count = 1) then (skill) else nullif (count = 2) then (skill) else nullif (count = 3) then (skill) else null4. Create 3 more calculated columns using the maximum function. Call them maxskill1, maxskill2,...

cognos10consultant

 Profile Answers by cognos10consultant Questions by cognos10consultant

• Feb 25th, 2012

To achieve this you have to create list first ...from the source tab add employee..after that click on toolbox tab add repeater as 2nd column...from the source tab add skill to the repeater...then we ...

prabakar.bi

 Profile Answers by prabakar.bi Questions by prabakar.bi

• Mar 31st, 2009

I feel we can use the tool functionality to achieve this as follows.1. Create a list report having employee column2. Create a cross tab - contains emp in row and skill in column3. Provide Master Detai...

Answer Question  Select Best Answer

Can someone help me with the question below?
How can we handle Empty reports other than using "No Data Contents" option in Report Studio?

This question was posed to me in an interview.

aba.aguiar

 Profile Answers by aba.aguiar Questions by aba.aguiar

• Feb 1st, 2012

Specify Not to Render a Page If It Does not Contain Data You can specify not to render a report page if the page does not contain any data when the report is run. Steps 1. In the report page, click a ...

Answer Question  Select Best Answer