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

What is procedure of deployment in Cognos installation?

Jimmy Zorald

 Profile Answers by Jimmy Zorald Questions by Jimmy Zorald

• Nov 20th, 2011

After completing the preceding configuration procedures, you can deploy IBM Cognos Now! on the application server. Start the IBM WebSphere application server, if it is not currently running, and open...

Namrata Gade

• Aug 13th, 2011

1. Copy contents of attached notepad file i.e. XML code of the report. 2. Launch Report studio, select package Package Name. 3. Open Report studio as a blank report. 4. In Report Studio, go to Tools -...

Answer Question  Select Best Answer

Hi ,suppose if a report contains n pages like page1,page2, upto pagen, in a textbox prompt when we enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer?

Chandra Kiran

• Aug 17th, 2011

You can use the Render Variable method. Make a String Variable and place the CASE WHEN Statement with the Parameter values. In the Page Explorer, go to Page Properties, Set the Render Variable and s...

buddy

• Aug 2nd, 2011

Well, two things to do.
1- Use Static Choice for Prompt
2- Apply render variable to render the pages

Answer Question  Select Best Answer

Devi Archana

 Profile Answers by Devi Archana Questions by Devi Archana

• Jan 26th, 2012

A few of the date fields have a time stamp attached to them... time stamp is nothing but the time in the format of HH:MM:SS:NN.... for example.. i have an update today at 9:30pm then time stamp would be 26 January 2012 21:30:15:11

sasikalyan

• Dec 26th, 2011

These are called delta attributes. You could define only one delta attribute while creating generic delta. 1. Time stamp - The field is a DEC15 field which always contains the time stamp of the last ...

Answer Question  Select Best Answer

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

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

cognos_anu

• Jun 21st, 2017

Scope relationship exists between Regular Dimension & Measure Dimension.
It determines the level at which facts/measures are available for reporting.
We can view, edit, create scope relationships.
They are automatically created based on the joins between tables of Modelling layer.

shyam

• Mar 17th, 2012

Scope is used to join the regular dimensions and measure dimensions to perform multi dimensional analysis such
as drill down and drill up.

relationship is join the two tables (specifies cardinality 1-1,1-n

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

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

There is a scenario: Display the list data in the order-first even position rows and then odd position rows.....Can anyone help on this issue..

Soumyadeb Halder

• Feb 17th, 2014

Suppose your table is "employee" and column name is "empid" . Now you want a list which contains EVEN empids first and then ODD empids. Your query will be like below, Select empid from employee orde...

Gajendra kumar

• Nov 28th, 2013

First check based on which column the odd and even value should come. For example in a list EVEN EMP_ID should display first and than ODD EMP_ID. Now drag this column to query subject. Create an...

Answer Question  Select Best Answer

What is Scope in report studio?
Can you write a YTD FUnction?
What is global Variable?

Lakshmikar

• Aug 17th, 2016

Extract(date,YYYYMMDD) from dual;

lakshmikar

• Aug 10th, 2016

Extract(date,yyyymmdd)from dual;

Answer Question  Select Best Answer

How restrict the user to add a new data item in a container (List) in Report Studio?

Khalid Mehmood Awan

• Jul 25th, 2017

In that case, the report will be a snapshot report.

Reddy25

• Oct 25th, 2016

In Report properties, Goto Permissions page and select the user/group/role in which the user belongs to and deny the write permission.

Answer Question  Select Best Answer

swift_s

 Profile Answers by swift_s Questions by swift_s

• Jun 11th, 2009

A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that p...

kiranbandari

 Profile Answers by kiranbandari Questions by kiranbandari

• Mar 16th, 2006

A junk dimension is a convenient grouping of flags and indicators.

Answer Question  Select Best Answer