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 are the complexities faced in your Project?

Jay

• Nov 21st, 2014

Performance issues plays a major role , some reports take a lot of execution time due to the huge amount of data retrieval

nikhil

• Feb 18th, 2014

1)sometimes Understanding the requirement will not be clear as per the business 2)you develop one code by understanding one requirement but from onsite(client) again they will tell u the changes to ...

Answer Question  Select Best Answer

Try to answer it

Abhishek

• Aug 22nd, 2014

There are 3 layers 1. Database Layer - Tables are imported in this layer. 2. Model View Layer - All the relationships, renaming of query subjects and query items, resolving loops etc are done in thi...

Bhaskar reddy tamatam

• Jul 23rd, 2014

In cognos three types of layers are there

1.physical layer
2.business layer
3.presentation layer

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

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

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

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

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

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

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

srihari

• Apr 6th, 2013

Burst: you can send the data in n no of recipients through emails burst option types is: automatic email addresses ...

Shankar

• Aug 24th, 2011

Burst is; Sending information to people when the information meets the criteria. i.e Balance to the the financial controller.
Schedule; Time the production of reports.

Answer Question  Select Best Answer

Prabhjeet Singh

• Mar 8th, 2012

Parameters generally act as a filter to a report. Depending on the user selection the report is been filtered and is provided to the user. They can be used to display what value user has selected or w...

Sateesh

• Feb 5th, 2012

Parameters are usually used for defining some characteristics of the modeled object. They are helpful when object instances have the same behavior described in class, but differ in some parameter valu...

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

Can u give me small example of cognos testing?

arunkiranrega

 Profile Answers by arunkiranrega Questions by arunkiranrega

• Aug 11th, 2008

Cognos unit testing includes1) Data checking - you need to match against data exactly what you desired2) You need to check the data format - eg check number of decimal places,date format,time format 3...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

binay.bk  

 Profile Answers by binay.bk Questions by binay.bk

• Member Since Jan-2008 | Jan 24th, 2008

---

Hi

Drill Through is used to link the master & detail reports.
After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that particular item (Order ID 1234).

Cascading prompt uses the value from the previous prompt to filter the value in the current prompt.

  For Cascading no need of two reports.If a report having two related columns (e.g. Country & States),then we can cascade these two columns by adding two value prompts.

If you select a country (e.g INDIA),in the next prompt all the states will be displayed those which are under INDIA.

If you want to see the details for the state Tamilnadu,then select TN from the list which will display all the details for TN.

binay.bk

 Profile Answers by binay.bk Questions by binay.bk

• Jan 24th, 2008

HiDrill Through is used to link the master & detail reports.After putting drill through if you click on a link (e.g. Order ID 1234) in the master report then the details will be displayed for that...

subbu

• Nov 4th, 2007

Cascading report contains one report and it work based on the condition.drill through contains two reports parent report(summary),child report(detail report)child report contains a parameter that must accept the values passed from parent report.

Improve Answer

Read Best Answer

Editorial / Best Answer

zecar  

 Profile Answers by zecar Questions by zecar

• Member Since Sep-2006 | Sep 17th, 2007

---

1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.
2. Under frequency, select how often you want the schedule to run.
3. Under Start, select the date and time you want the schedule to start.
4. Under End, select the date and time you want to end the schedule.
5. Under Formats, click the format you want to run the output.
6. Under Languages, select the languages to select different languages.
7. Under Delivery, choose any one delivery method.
8. If you want to be prompted, under Prompt values,select the Prompt for Values checkbox.
9. Click Ok.

zecar

 Profile Answers by zecar Questions by zecar

• Sep 17th, 2007

1. In Cognos Connection, Go to Public Folders or My Folders, click the schedule button for the report you want to schedule.2. Under frequency, select how often you want the schedule to run.3. Under St...

P Ramesh

• Sep 13th, 2006

There are three types of Schedules in CognosRun with Option ? Single time SchedulingRecurring Scheduling ? U can specify u r date and time hereJob or Batch Scheduling ? A Job is a group of reports whi...

Improve Answer