Tejas Bi helpdesk

• Feb 5th, 2014

I am working with cognos10. Too much user Friendly GUI.

Bipin

• Oct 9th, 2011

Cognos Impromptu 6.0, Cognos Impromptu 7, Report net 1.1,Cognos 8.0, Cognos 8.1, Cognos 8.2, Cognos 8.3, 8.4 and latest is cognos 10

Answer Question  Select Best Answer

Hi All,
There is a scenario.There should be one prompt page having choice to choose between:
->List
->Cross tab
According to the choice selected, the page generates either List or Cross tab.
Please suggest the solution with steps.
Thanks

Samir

• Nov 19th, 2013

1. Create the List and Cross tab reports with required data. 2. Drag and drop a value prompt to the prompt page. 3. Name the parameter as selection, then click on finish. 4. High light the value promp...

santosh

• Oct 9th, 2013

In your first page Drop your list and CrossTab Insertable objects fill ur data in those. Then create a Prompt page where in drop Value Prompt Object with paramter1 just click finish In the properties...

Answer Question  Select Best Answer

Using Java script, how we can check the value of the value prompt, that the value entered should always be alphabet.

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

1.Choose Run with Options 2.Click on advanced options link3.Click run in the background (Now) 4.Change Format option to desired Option (Excel, PDF, HTML, CSV, etc.) 5.Select Delivery Option of Send th...

Joe

• Mar 13th, 2013

Cognos connection

Answer Question  Select Best Answer

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