We know that Alias never effects if the parent updates where as Reference will. My question is if suppose I took an Alias shortcut for a Query Subject and linking that with parent and if I took a Reference from that query subject what will be the difference for those in performance.

RemyaG

• Feb 4th, 2016

A regular shortcut (Reference) is nothing but a simple reference to another object. Its a soft link. An Alias shortcut is a copy of an existing object and is treated independantly. It is easier ...

Sai Nandigam

• Feb 1st, 2016

Regular shortcut is as reference to the target object. Alias shortcut is like a copy of the original object with completely independent behavior. Alias shortcut is available only for query subjects an...

Answer Question  Select Best Answer

vpulender

 Profile Answers by vpulender Questions by vpulender

• Nov 27th, 2009

In Cognos Connections we can only able to create Groups,roles and contacts.But if we want to create new users we have to log on Cognos Access Manager there we can create users andWe can grant the permission based on their requets like for specific Folder or reports..

swift_s

 Profile Answers by swift_s Questions by swift_s

• Jun 11th, 2009

Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine.

Answer Question  Select Best Answer

rkiranbedi

• Apr 13th, 2007

Hi Using Hot Files u can join Hot Files in Catalog

Hamid

 Profile Answers by Hamid Questions by Hamid

• Feb 15th, 2007

Basically catalog deals with single data base, we cannot use multiple data base and that is the disadvantage of catalog, but we can use Hot files to bring another data base source. one more thing by ...

Answer Question  Select Best Answer

bhaskar jha

• Nov 8th, 2014

List report show the data in row and column(detail information of report).
crosstab report show the data in grids, dimensions in row and column and measures in cells or in intersection point.

jjrkl_sandeep

 Profile Answers by jjrkl_sandeep Questions by jjrkl_sandeep

• Oct 22nd, 2013

List can be converted to Cross tab but Cross tab cant be converted to list...There is no direct option available in Report Studio to convert the cross tab to list....

Answer Question  Select Best Answer

Can you apply the Master detailed relationship between Query studio report and report studio report? how?

vishal_9009

 Profile Answers by vishal_9009 Questions by vishal_9009

• Mar 17th, 2009

Master detailed relationship from query / Analysis studio report and Report Studio report can be created only with the use of Package level drill through.

simik

 Profile Answers by simik Questions by simik

• Feb 24th, 2009

Master detail relationships link information between two data containers (such as list, crosstab, or chart) within a report: a master data container, and a detail data container.Using a master detail ...

Answer Question  Select Best Answer

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Generally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my...

Ana

• Dec 19th, 2011

We can actually use numbers to represent the subject names, use these numbers as a measure and then by using string variable we can show the subject names in the measure section.

shailendra32

 Profile Answers by shailendra32 Questions by shailendra32

• Oct 14th, 2011

Yes you can put subject as peer to period in rows.this will work fine.

Answer Question  Select Best Answer

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

kadarla

 Profile Answers by kadarla Questions by kadarla

• Aug 17th, 2009

These are the differences between Cognos Reportnet report studio and Cognos 8 report studio: 1. In Cognos 8 we can use dimensional data for reporting.2. We can drill through from chart also in Cog...

elizabethzen

 Profile Answers by elizabethzen Questions by elizabethzen

• Apr 20th, 2009

Cognos 8 Report Studio is the reporting tool for ReportNet, the Web-based reporting solution.

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

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

Administrator wrote on Monday, 21 May 2007 01:48:53:-- test

hi chandra mohan

• Dec 19th, 2011

Qube size is 2GB but in Cognos 10 qube size may be increased to 2.5 GB or 3 GB

gbcreddy

 Profile Answers by gbcreddy Questions by gbcreddy

• Nov 24th, 2008

In Cognos 7 powerplay Cube support less than 1 GB.

Answer Question  Select Best Answer

How will you analyze the reason for poor performance of reports in Cognos 8?

Iamrr

• Oct 18th, 2011

It depends also on Query that has been written to build the package, Analyse your query try to Optimise it and see the difference.

Chandra Kiran

• Aug 17th, 2011

Agree with all of the above answers. In addition to those, 1. The report performance also can be impacted based on the Calculated columns and the aggregations defined at the Report level. 2. It e...

Answer Question  Select Best Answer

Hi Friends What is main difference between content store and content manager?Give me one example for these related ?

krishnachaitanyaa

 Profile Answers by krishnachaitanyaa Questions by krishnachaitanyaa

• Aug 1st, 2011

Content Store: It is Cognos Database.
Content Manager: It is the application which controls the Content Store .

kadarla

 Profile Answers by kadarla Questions by kadarla

• Jul 25th, 2011

A content store is a data base which stores the meta data of the reports.when we publish the project from framework manager it will save in the content store. It is configured in database layer. ...

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

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

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

ARK CHOWDARY

 Profile Answers by ARK CHOWDARY Questions by ARK CHOWDARY

• Dec 23rd, 2008

By Enabling the GOverner Settings we can improve the performance.

thakkalapelly anil

• Aug 30th, 2007

To improve the performence of the report move all the calculations and filters from report level to frame work manager.

Answer Question  Select Best Answer

If you have a report with list and cross tab in the same page. How do yourestrict one user can see only the list and the other user can see both?

Sandeep

• Jun 4th, 2014

You can use the function CSV IdentityName (or something similar). This will return the details of the user.
Use this to check the current user, and base your conditional blocks on this.

Smita

• Apr 4th, 2014

You have to create a variable to check which user is logged in uning the session parameter (eg. account.defaultName) and then assign this variable to either conditional block or use it as render variable for the Cross tab.

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

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

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