obli prabu

• Aug 7th, 2007

CAMID stands for Cognos Access Manager ID, and it represents an internal search path to the recipients. Specify search paths when you want to save burst reports in a directory. You can obtain the ...

Answer Question  Select Best Answer

There is a prompt page having the options for ascending and descending, based on the prompt value selected , the report page generates the list column value sorted in either ascending or descending:

Vishalakshi

• Feb 12th, 2021

First step : Create a static prompts namely Ascending and Descending for asscociated with one paramater .
Second step : Create a macro with same parameter to which value in the list you wanted to create Asc and Desc. syntax: #macro(parametername, token)#

Martina Vaz

• Jun 26th, 2017

Create 2 lists. one with ascending one descending. depending on the prompt selection display the list

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

naveen

• May 23rd, 2019

Object security mode is applicable for it. Hence it allows or denies for the objects like namespaces, query subjects etc,

binduandme

 Profile Answers by binduandme Questions by binduandme

• Mar 10th, 2009

These management or all permissions granted users are known as power users and without restricting or creating any security for this level you need to grant all permission.

Answer Question  Select Best Answer

Production Support: Where and how to check Cognos Logs?

Rafiq

• Dec 17th, 2018

In your Cognos installed server, the logs are present in /installation_path/c10/cognos/logs/cogserver.log

This is the log file, but it is not helpful most of the time.

Answer Question  Select Best Answer

How to Validate Date in cognos report studio (eg start date should be less than end date)

srijib mandal

• Aug 12th, 2018

You can use date range prompt if you need it in prompt page, in filter you can convert to timestamp and then compare

Answer Question  Select Best Answer

I have two prompts with country and product line, for the selected item in country prompt few items of the product line should be shown instead of showing all, how can I achieve this?

Mayank Sanghvi

• Mar 21st, 2018

Cascading prompt is the answer for your question. We use cascading when we need to load data in one prompt based on the other. So in the above scenario Country is the first prompt and Product Line is dependent on Country.

Martina Vaz

• Jun 26th, 2017

Use cascading prompt feature. For the product prompt select cascading prompt property as Yes, and select country parameter. the product query is filtered with selected country.

Answer Question  Select Best Answer

ravindra

• Nov 19th, 2017

Yes, we can use

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

Yes, It is 100% possible...

Answer Question  Select Best Answer

Hi , can any one tell how to convert crosstab into list?what is the main use of unlocking the report?what is the meaning of repeater & repeater table and when r they useful?plz answer these if any one knows?best regardspaddu

Manogna

• Aug 30th, 2017

We cant convert crosstab to list but reverse is possible by using pivot table function

Anil Kumar

• Jul 28th, 2016

We don't have any feature to change the cross tab report to List.
only we change the list report to Cross tab with Pivot

Answer Question  Select Best Answer

geetha

• Aug 14th, 2017

Query subject is a customised table created in FM using table imported from data source. We call it as data source query subject

bhaskar jha

• Nov 8th, 2014

Query subject is a basic building block in Framework Manager. Query Subject is a set of query which have inherit relationship.

Answer Question  Select Best Answer

What to do at database side to improve performance?
What is Performance tuning?

Khalid Mehmood Awan

• Jul 25th, 2017

Creating Table Partitions, Indexes, Materialized views, remove normalization where it is unnecessary, increasing hardware power and many other factors.

Lakshmikar

• Apr 5th, 2016

1.Partitioning
2.Indexes
3.Avoid maximum no. of joins.

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

Cornelius Goodwin

• Jul 7th, 2017

Catalogs have not been used since Impromptu

maryjane

• Mar 7th, 2017

A catalog is an inventory of bookkeeping of the librarys contents.

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 many types of dimensions in Framework manager? Which dimension are used in project and who decide that?

cognos_anu

• Jun 21st, 2017

Role Playing Dimension
Junk Dimension
Conformed Dimension
Degenerate Dimension
Slowly Changing Dimension.
Regular Dimension & Measure Dimension in DMR Model.

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• May 27th, 2012

Regular dimension and Measure dimension are two dimension.Regular dimension is used in dimensional modelling of Relational data.It generally gives drill up drill down facility of OLAP to relational data.Generally Business analyst or Data Modeller experts decide this.

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

How to add 2 different colors for alternative rows in a report?

cognos_anu

• Jun 16th, 2017

You can create advanced conditional style having below expression :
mod(row number,2)=0 then you can assign first colour
mod(row number,2)=1 then assign second colour.
by this you will get alternate colours for object.

shashi

• Apr 5th, 2017

By using mod(rownuber,3)=0 for 3 colours
mod(rownuber,2)=0 for 2 colours

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

lakshmikar lebaka

• Aug 9th, 2016

1.Governor settings
2.Avoid unnecessary functions like in, between, like operators 3.Execution concurrent method
4.Avoid complex calculations
5.Local cache-yes
6.Parameter information-yes

Anuj

• Sep 11th, 2015

Hi Bhaskar thank you for the tip. How to turn on this feature in 10.2

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