How can you create prompts in framework manager?

sandeep8000861

 Profile Answers by sandeep8000861 Questions by sandeep8000861

• Jun 19th, 2008

We dont actually create prompts in FM.There is a property known as Prompt for each Query Item (field/column name). You just set this property to the required prompt type.After the properties are set, ...

b.srilakshmi

 Profile Answers by b.srilakshmi Questions by b.srilakshmi

• Jun 12th, 2008

it showed be done in Frame work manageras#prompt('Parameter','datatype')#

Answer Question  Select Best Answer

What are the challenging tasks in report studio?

mayank_sanghvi

 Profile Answers by mayank_sanghvi Questions by mayank_sanghvi

• Aug 2nd, 2016

The answer for this question is based on your work. For example for me its using Cognos SDK to run the report from Java and .Net Code.

jaga

• Jan 6th, 2012

Challenging tasks in reports are using parameters, complex calculations, bookmarks and complex prompts

Answer Question  Select Best Answer

What do you record in unit test documents?

Pavithracts

 Profile Answers by Pavithracts Questions by Pavithracts

• Jun 29th, 2008

In Unit testing we will check the fontsize,Filters etc as per in the requirement document all these things are recorded in the document.Only in system testing using toad software will match the toad records with report output in cognos.

sathish.devireddy

 Profile Answers by sathish.devireddy Questions by sathish.devireddy

• Jun 12th, 2008

Generally we are using toad software.it is a predefined tesing software

Answer Question  Select Best Answer

How will you provide security?How will you provide row level security?

liladd

 Profile Answers by liladd Questions by liladd

• Oct 5th, 2009

You can use session parameters to map a data item to one of the ldap user values.depending on what you authentication source is and if the necessary values are there. EX: Your ldap has employee #, you...

reply_me_web

 Profile Answers by reply_me_web Questions by reply_me_web

• Sep 5th, 2008

Row Level Secuirty can be given in Framework Manager using Parameter Map

Answer Question  Select Best Answer

What are the differences between drill through and master-detail relation ship

mahesh.amk

 Profile Answers by mahesh.amk Questions by mahesh.amk

• Jul 11th, 2008

Master detail relationship is used to include large amount of info in a single report output where as a drill thru concept uses navigation from one report to another report

richardson

 Profile Answers by richardson Questions by richardson

• Jul 9th, 2008

Drill thru navigates the summery level information to detail level information from report to report. (Parent-Child)              ...

Answer Question  Select Best Answer

Explain with an example for Factless Fact Table in Real Time Project ?

kranthi.kunta

 Profile Answers by kranthi.kunta Questions by kranthi.kunta

• Aug 12th, 2008

Factless Fact Table: A fact table with a key section but without a measure section.? There are 2 types of factless fact table: 1. Event Tracking Tables: A table that records an event. Ex: A table ...

shree_uday

 Profile Answers by shree_uday Questions by shree_uday

• Jul 19th, 2008

A Fact table, without any measures is called Factless Fact Table.For Ex.Survive Fact Table

Answer Question  Select Best Answer

What is the diff. between filter & condition? Explain with an example?

Mehul@DWH

 Profile Answers by Mehul@DWH Questions by Mehul@DWH

• Oct 10th, 2008

Filter and condition are both the same things, when used in context of report creation, but if you mean condition with respect to report layouts, etc that apply to page design, then they do diffe...

avani_19

 Profile Answers by avani_19 Questions by avani_19

• Jul 25th, 2008

The major difference between query conditions and document filters is that a condition is applied to the query and limits the data retrieved from the database, whereas the filter is applied to the data in the document to hide information and display only the information that you want to appear

Answer Question  Select Best Answer

What are the unique advantage of having 3 explorer in Cognos i.e 1) Page explorer 2) Query explorer 3)Variable explorer

fly2anshul

 Profile Answers by fly2anshul Questions by fly2anshul

• Sep 18th, 2008

Here it goes: Page explorer: You use this to navigate through pages of a report (page by page). You can also use this to add more pages to your report.Query Explorer: You use this to view or modify th...

angel987

 Profile Answers by angel987 Questions by angel987

• Sep 17th, 2008

For the ease in accessing / arranging pages, queries and variables.?

Answer Question  Select Best Answer

What are Balanced Cubes (cube balancing) and Sub Cubes? What can be the maximum size of a cube?

Ajju B

 Profile Answers by Ajju B Questions by Ajju B

• Sep 11th, 2008

The size of cube is mostly in GBs. however it will also be in MBs.

4myfuture

 Profile Answers by 4myfuture Questions by 4myfuture

• Sep 7th, 2008

The maximum size of the cube must not be more than 2GB in size.byeRavinder

Answer Question  Select Best Answer

What is Conditional Formatting? What you used finally in the Condtional formatting?

bvsr007

 Profile Answers by bvsr007 Questions by bvsr007

• Jul 17th, 2009

You can define the condition to control, what the user see when they run the report.By three ways we are doing the conditional formatting1) Boolean variable2) String Variable3) Report Language Variabl...

bkamila

 Profile Answers by bkamila Questions by bkamila

• Oct 24th, 2008

Enhance a report by adding conditional formatting. For example, use conditional formatting to identify exceptional data in a report.
With conditional formatting, you can
hide and show objects
highlight data
add multiple layouts
create a multilingual report

Answer Question  Select Best Answer

How many rows can you add above a selected row in a list report

friswana

 Profile Answers by friswana Questions by friswana

• Jan 6th, 2010

Answer is infinite.. But its better to restrict the number of rows based on the requirement to avoid performance issues..

sivabisani

 Profile Answers by sivabisani Questions by sivabisani

• Nov 13th, 2008

I tried with this query we set rows upto 10000 and?infinet also.(it is casuing perfomance issue more than? 1000).Thankssiva

Answer Question  Select Best Answer

What is the most challenging task you have faced while working with report studio?

bonniewade1

 Profile Answers by bonniewade1 Questions by bonniewade1

• Jan 14th, 2011

Having to use a query that has 100 fields and 60,000 rows and getting maximum performance out of it.

friswana

 Profile Answers by friswana Questions by friswana

• Jan 4th, 2010

Creating Price Waterfall chart in Cognso 8.4

Answer Question  Select Best Answer

What should the usage property of an interest rate be in Framework?

Martina

• Jun 26th, 2017

Usage property should be measure

shashi

• Apr 5th, 2017

Fact: Measures default aggregation total
Attributes: Dimensions
Identifier: Are key columns default aggregation count
unknown

Answer Question  Select Best Answer

How to burst a report? What are the steps for bursting?

Birjesh

• Nov 27th, 2019

Bursting is used to distributing the report with different client

sreenivasulu pokuru

• Aug 5th, 2013

Bursting is nothing but a process of runs once report and dividing the results for various recipients through burst group. There are two ways for bursting the reports. 1)through mail option. 2) throug...

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

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

A List report which has Company name as report item along with many other report items. When the above list report is run-The report output also pulls another report called "company details" automatically.Report developed has no idea about the "Company Details" report until he sees the report output.When ever we run any report that has company name as a report item, "company details" report should...

port.poo

 Profile Answers by port.poo Questions by port.poo

• Sep 25th, 2009

Create an HTML Item in Main Report. When first report get exceuted then HTML Script should call another report which will conatin Company Details.Hope it helps!!Cheers,Julie

arjun vuppala

 Profile Answers by arjun vuppala Questions by arjun vuppala

• Aug 28th, 2009

A List report which has Company name as report item along with many other report items.?When the above list report is run-The report output also pulls another report called "company details" automati...

Answer Question  Select Best Answer

What are the session parameters in Frame work managers, how exactly we use in Report studio?

Sai Nandigam

• Feb 1st, 2016

A session parameter is a variable that is associated with a session. These parameters are the values that provides session properties like the user id, user name, run locale, machine name, and timesta...

CognosT

• Jan 20th, 2016

Session parameters are macros available in either Framework Manager that can be used to dynamically determine and display information about a users session. This can be especially handy for general di...

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