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

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

I need answer

fpaulraj

 Profile Answers by fpaulraj Questions by fpaulraj

• Jun 17th, 2011

Macro is a object embeded with in the query or the sub query which can be executed while runing the query.

fpaulraj

 Profile Answers by fpaulraj Questions by fpaulraj

• Jun 17th, 2011

Junk dimension means, The dimension value which has absolute value in the dimensional hierarchy. and the lowest level of the the dimensions does not have corresponding measures in the face table. When...

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

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

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

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

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

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

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

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