Cognos Interview Questions from Geek

How to change database option in cognos10 content store as it has already fixed by db2.I need to change to msSQL server.
1. Open the IBM Cognos Configuration > 2. Go to Database Access, Select ContentStore then right click on it then Delete > after that  > Select ContentManaget then right click on it then Select New Source->Database->Name:xxxxx -> Type MSSQL Server-> Click OK and give the User Name and Password.

There are many ways to improve database performance. One of them being creating indexes on table columns that are queried the most. Another is create table partitioning. A whole lot else can be accomplished at the report level by fine tuning the query or the filters created automatically by CognosReport Studio.

Asked By: shah_nawazzz | Asked On: Apr 12th, 2012
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should display max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!

Ans) Instead of doing this at cognos level, try to do it at SQL level using rownum function. Take the max of mod(rownum,5). then save the rownum value in a ?variable? and then take all the records where rownum>? Variable?

Ans) 1.Drag a list report 2.Add the query items you need for the list report 3.Add a Query Calculation to the list report and name it as Running total,In the Expression Definition Type in running-count([Query Item]) 4. Add a Query Calculation to the list report and name it as Rows Display,In the Expression definition type in floor([Running total]/17)
5. Go to the page Explorer and drag the page set to the page are 6. Change the Query of the page set to your list query 7. In the properties of the page set,click on the ellipses of sort and grouping
 8.Drag the Row Display data item under grouping 9.Save and run the report.

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?
Answered by: mani on: Apr 18th, 2012
there is no option for converting a crosstab to list but we can do this by using cross tab the designing page it should look like a cross tab only but when u run the report the report will shown to u in list format..u can do this by unlocking and insert a cross tab space at the intersection point and in that add a text item with the desired query item name....

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

Query subject simply means a table...a table contain columns...columns called as query items

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 what data the user wants to see.
Whereas Variables are used to conditionally format or conditionally hide/show the object in the report. They cant be used to filter the data in the report.

Asked By: Jagan | Asked On: Oct 9th, 2005
Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count = 1) then (skill) else nullif (count = 2) then (skill) else nullif (count = 3) then (skill) else...
I feel we can use the tool functionality to achieve this as follows.

1. Create a list report having employee column
2. Create a cross tab - contains emp in row and skill in column
3. Provide Master Detail relationship between 'emp' of list & CT
4. Hide emp of CT and format appropriately

You can see the result as
1 abc and 2 def

Handling Empty Reports

Specify Not to Render a Page If It Does not Contain Data
You can specify not to render a report page if the page does not contain any data when the report is run.
1. In the report page, click a data container. > 2. In the
 Properties pane, click the select ancestor button and click the data container type. > For example, if the data container is a list, click List. > 3. Set the Render Page when Empty property to No.
4. Repeat steps 1 to 3 for all other data containers in the page as well as any table of contents > objects (p. 143). > When you run the report, if no data is produced in all data containers and table of contents objects > in a page, the page is not rendered. The page is not rendered even if the page contains other objects, >such as text items or images.

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

Qube size is 2GB but in Cognos 10 qube size may be increased to 2.5 GB or 3 GB
In Cognos 7 powerplay Cube support less than 1 GB.
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.
prompt in filter with usage set to always - user need to supply a value to filter.
propmt in filter with usage set to optional - user need to supply a value for the filter / if user dont supply a value, filter will not be applied.

Cardinality, a component of relationship. defines how query subjects are related.

1..1 one and only one record from this side of the relationship
1..n one or more records from one side of the relationship
0..1 zero or at most one record from one side of the relationship
o..n zero or more records from one side of the relationship
package security - which defines access permissions to the package to author and run reports
 > object security- which allows to apply security to individual elements in the model. > data security- in which you apply security filters to restrict rows.

CAST is a complex function that transforms one or more values from one data type into another.
.-<< , <<-----------.
 V | >>-CAST--(----source_expression +-- AS--DataType---------------->

'-CCSID--expression-' '-ENCODING--expression-'

'-FORMAT--expression-' '-DEFAULT--expression-'

In practice, you cannot specify all of the above parameters at the same time. For example, CCSID and ENCODING parameters take effect only on string-to-string conversions, while FORMAT applies only to string-numeric and string-datetime conversions (in either direction).

What is the best way to convert Crystal Reports to Cognos ?

Crystal Reports and Cognos are fundamentally two different technologies with very different solutions. As per my knowledge, there are'nt any such ready tool to do the conversion. Though Cognos offers a migration path and supports importing a BO universe through a metadata-bridge and rebuild using a migrated metadata layer, You will also need to have BO designer installed.

Can we apply a filter on list of values in the Value Prompt

yes,Its very simple to achieve.When we create a prompt it will create a query for it separately(Prompt query) other than the report main query.In that prompt query you can drag and drop a filter and develop the filter expression like " country in ('India','Australia','South Africa') " (what ever countries you want to see you can mention in the list).

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
Poor Performance of Cognos Reports
Data not in correct NF > Loops in retriving data > Too many parameters
Pulling data from muliple sources
There can be many reasons otherwise the question needs to be more specific.
1) Use the native SQL from the Cognos report to do an explain plan
2) Check the sqlof the prompt page queries and use static values for prompts whenever possible. > 3) Validate the joins in Framework manager. > 4) Limit the number of rows displayed in an HTML report. > 5) Add filters to limit the amount of data returned.

Yes. It is possible > Yes, We can insert more than one measure in crosstab. Just drag and drop all the data items like columns one after the other in the fact/measure area in crosstab.

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.

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?
well, two things to do.> 1- Use Static Choice for Prompt > 2- Apply render variable to render the pages
Ans) 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 select the respective choice for the Page. I believe, that can solve your problem.

?Par_Text_Prompt? = 'Page 1' then 'P1'
?Par_Text_prompt? = 'Page 2' then 'P2'
Hi friends what is main difference between content store and content manager?Give me one example for these related ?
Answered by: krishnachaitanyaa on: Aug 1st, 2011
Content Store: It is Cognos Database.
Content Manager: It is the application which controls the Content Store .

List: It shows detailed Information, We can use any data item available.
CrossTab: It Shows summarized information, At least one measure must be included.

cardinality tells the relationship how many rows from one of the query subjects defined in the relationship are expected to match a row in the query subject on the other side of the relationship.

The cardinality tells
 Cognos 8 if one of the tables is expected to have more than one matching record in the other (many-to-one relationships), or if a matching record is not required at all (outer joins).

Asked By: GIBoris | Asked On: May 18th, 2011
I need to create schedule, based on day of week and time.
Here is requirement for schedule:
Report should run each business day at 08:00 A.M and return data for:

ProcessStartTime (some data item) BETWEEN
MON run - data from prior FRI 04:00 P.M. and today MON, 08:00 A.M.
TUE run - data from prior MON 04:00 P.M. and today TUE, 08:00 A.M.
WED run - data from prior TUE 04:00 P.M. and today WED 08:00 A.M.
THU run - data from prior WED 04:00 P.M. and today THU 08:00 A.M.
FRI run - data from prior THU 04:00 P.M. and today FRI 08:00 A.M.Answered by:
 shailendra32 on: Jul 23rd, 2011
Since you want data for last one week so put condition on the report to fetch data only for last week.

While creating schedule you can click check boxes for the required days.

Aggregate Function: This function specifies what type of Aggregation to be applied on a data item. The Aggregation can be of the types "Total", "Average", "Minimum", "Maximum" etc.

Roll Up Aggregation: One above you have determined what type of aggregation you are applying on a data item e.g. Unit cost then here you can decide about the type of aggregation on the summarized values. In case of our Unit cost, if you have applied "Aggregate" choose here as "Maximum". Remember "The roll-up aggregation of any item is important only when you create the aggregation of 'Aggregate' type. Otherwise leave it as automatic.

What is the use of generated prompt? Can u give complete information with scenario
Answered by: Cognos on: Jul 17th, 2011
The prompt should be used when you are not sure of which type of prompt best suits for requirement.

What is meant by Junk Dimension? How do you perfom while running the report? Where will you see the time of running report?
Size of the cube? What are the types of prompts in ReportNet?
What is macro and how it will be work? What is difference between Cognos and Cognos ReportNet? How do you create cube in ReportNet?
There are 10 facts are there.How will you connect all?
Junk dimension: All the attributes which are not related to any other 
dimension are put together to form a Junk dimension.
Types of Prompts: date prompt, time prompt, datetime prompt, interval prompt,
select and search prompt, tree prompt, generated prompt. 
Macro: Marco is nothing but symbolic representation like #, (, en i.e is nothing
but shortly used things which will be done in framework manager to improve the
performance of the reports.
Cube can be created either by generating IQDS which will be source with in the

Different data sources available with in the transformer are
1) Cognos Report  2) Cognos Package 3) IQD 4) Delimited fixed text with column titles
5) Delimited fixed text
 6) Access table 7) Access query 8) Excel crosstab 9) Excel database
10) Powerhouse portable subfile
 11) Fixed field text 12) Fixed field text with out crlf

the most common problems are -
1.No Data Appears in the Report (to remove this check data source or package)
2.Unexpected or incorrect values appears in reports , may be report is running with limited data
3.The report filter does not work, values are not coming in filter option is not able to oprm in excel ,cvs or xml 

1) Report performance - Prompt page takes a long time to load or the report takes a long time to generate.
 Data is not accurate in the report.3) Ambiguous columns 4) Time/date filters do not match the format of the time/date data 5) Incorrect joins 6) Union queries do not have the same columns names

What are the components of Cognos connection?

Cognos connection is the single point of entry to all of the report writing
tools. You can customize your pages and tabs. It contains cognos administration
allowing you to setup security, performance tuning, data sources and
import/export packages.

What are the components of query studio? 
Query Studio is the ad-hoc reporting tool that allows you to create filters,
conditional formatting, custom groups, charts and summaries.

What are the components of report studio? 
Report Studio allows you to create complex reports with custom prompt pages, 
drill thru pages, master-detail joins, unions and also allows you to imbed java
script into the report.

What are difference between master detailed relationship and drill through 
A master-detail relationship allows you to create joins within the report. A 
drill through report allows you to create a join to a separate report object.

What are the steps to be taken care to increase the executing of reports?
Answered by: bonniewade1 on: Jan 14th, 2011
1)Use static values or list of values in prompts when possible.
2) Perform calculations on the database side.
3) Limit the number of rows to be displayed at one time when possible.
4) Take off theauto summarization of the query when you're only displaying attributes.
5) Use the sql to do an explain plan on the query and tune the query.
Answered by: Lakshmi on: Jul 16th, 2008
By applying the filtres, to eliminate the un wanted data,by using local limited local processing,by using agregations for facts(numerics).
To improve the performence of the report move all the calculations and filters from report level to frame work manager.

A calculated measure is data item values that have been transformed into one value.
A Measure folder is a folder used to stored calculated measures.

Yes, Cognos 8.2 have the capability of mouse over a data field like tooltip, changing colors when ever mouse move to the dataitem.
I am going to describe the tooltip. For example:
Suppose we can take the list report with single item and take html item to the both sides of the item and put the below one and after that run it you can found in Cognos viewer the mouse over option.
<a title="Order number">Orderitem

What are the types of data containers in cognos report studio?

List > Crosstab > Charts > Repeater >
and also Nested Objects like
Block > Table > Conditional Blocks

What are the advantages of tree prompt? Why tree prompt was included in cognos 8?
Answered by: lalithagaru on: Nov 23rd, 2010
A data driven prompt control that shows hierarchical information and allows you to select one or more members. If you take Order number, Product name, Return quantity the list will show products that were returned more than 30 days after the order date.
Answered by: cgns.cgns on: Mar 23rd, 2008
We use a Tree Prompt when working with dimensional data to prompt for hierarchial values.
A Tree prompt returns a set of members from with in a hierarchy.Add a tree prompt to let users filter the level of detail they want to report on in a single hierarchy.

GROUP is used to suppress the duplicate values having one to many relations.
Associate is used to suppress the values having one to one relations.

How will you provide security?How will you provide row level security?
Answered by: liladd on: Oct 5th, 2009
You can use session parameters to map a data item to one of the ldap user values.depending on what you authentication source is and if the necessary values are there. EX: Your ldap has employee #, Answered by: reply_me_web on: Sep 5th, 2008
Row Level Secuirty can be given in Framework Manager using Parameter Map

In cognos we can create users,groups,roles by using third party authentication likeCOGNOS ACCESS MANAGER, LDAP.After creating the users we can provide the permission (like read,write,set policy,travers,execute)to users.

A model is an set of metadata objects organized for report authors according to the business models and rules. It is an business presentation of the structure of data from one or more data sources.
A package is an subset of query subjects and other metadata objects defined in the project.

Slicing is a process in which you do an equality selection of data from one or more dimension(perspective of facts how it can be interpreted).
In dicing, you obtain a dataset in a range of selection.
Create a report with two lists. > Insert a single Data Item (Product Name) in list one.
Right click the Data Item (Product Name) in the list and go to Drill Through.
Add a new Drill Through, and choose the Bookmark tab. Set Source Type to Data Item Value.
Now insert some data items along with product line (Product Name, Quantity, Unit price e.t.c.) > Click on product name and create section. > Insert book mark by unlocking the report into the Product Name section. > Set the Bookmark property for Source Type to Data Item Value. > Set the Bookmark property for Data Item Value to Product Name. Note: These book marks will not work in HTML format as the page gets changed. Test it in PDF.

By using HTML objects we can fulfill some requirement which is not possible directly by Cognos in built components.
By using HTML object, We can insert multimedia file into report. At the run time we can see the file.
What is the usage and procedure to create a repeater object?

Repeater Object is used to repeat data in a particular order. Its mainly used for mailing lists. for example, say you want the Name, Address and telephone, one below the other in a 3X3 table. You can drag in the repeater table, set 3X1 table for Name address and phone, and this information would get repeated in the 3X3 table. Your output would have three names in the first table row followed by the information.

Enhance a report by adding conditional formatting. For example, use conditional formatting to identify exceptional data in a report.
With conditional formatting, you can hide and show objects, highlight data, add multiple layouts, create a multilingual report

By using date prompt . Can we schedule the report ?
Yes we can schedule a report to run on specified date and time. We can even get the output as in email.

Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.
Answered by: chinnuchaitu on: Feb 13th, 2007
Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.

A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension
A junk dimension is a convenient grouping of flags and indicators.

Using Current_Date function, you will get the current date. Then use the extract function to extract day, month and year. Then hardcode the filter in the query for day and year.

In Cognos configuration cognos under authentication the > Allow anonymous access should be false. > In cgi-bin properties (under IIS) the enable anonymous  > access should be false.

Hierarchy defines the order of query items for report to report interactions [RRI]. Hierarchies are defined in query subject to support drill-down and drill-up functionalities.

We can access "Query Studio" to create and view simple reports via cognos connection after selecting the package that got imported from cognos content store. We can now select Required Query Items from different Query Subjects to generate ad-hoc reports. 

Loop: Loop is a closed path (relation) that exists among 3 (or) more tables. Loop gets created when "N" tables have "N" joins.For example if we have '3' tables T1 T2 T3 the...
Answered by: rkiranbedi on: Mar 2nd, 2007
 Loop is a closed Path. it can be exist b/w fact &dimensions, to resolve these we have to use shortcuts

Can you apply the master detailed relationship between query studio report and report studio report? How?
Answered by: vishal_9009 on: 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.

Render Variable: - Specify a variable based on which object can be conditionally rendered.Style Variable: - Specify a variable based on which object can be conditionally styled.
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.
Yes this was the aproch in previous version but from Cognos 8 specifically from 8.3 you have no data option provided to handle missing values.
By Enabling the GOverner Settings we can improve the performance.
The format that the column value uses.
For example, if Display Type is set to picture, MIME Type could be jpeg.
This property is for query items only.
Note: The MIME Type property is not used by SAP BW.

Report security ? > How to apply security on report?
Answered by: sivabisani on: Nov 13th, 2008
For reports we apply the security in Cognos connection.
Go to cc from the actions->setpropertiesicon->permissions->click the check box overide the permission and then set required properties to protect to your reports.
Let me know if you have any another solution.

Catalog contains metadata which is used retrieved by warehouse database is called catalog.
Actually 4 types
 catalogs. They are Personal catalog Shared catalog Secured catalog Master Distributed catalog. > MDC is better one
Just an addition to the above description's, Catalog also hold the relationships between the tables selected from the database.

The major difference between query conditions and document filters is that a condition is applied to the query and limits the data retrieved from the database, whereas the filter is applied to the data in the document to hide information and display only the information that you want to appear
What are the unique advantage of having 3 explorer in cognos i.E 1) page explorer 2) query explorer 3)variable explorer
If there is no calculations and the data is summerized, will you use materialized view? Give reason > they can be used to summarize, precompute, replicate, and distribute data.> but if there are no calculations needed and the summarization is already been done then not sure if we need to use them

1. Getting the requirements for report creation. (could be any functional document)2. Tables creation.3. Working on the framework manager for data modelling 4. Starting report development according to the specifications. (can refer to any technical document) 5. Testing of report (Writing test cases etc) 6. Delivering the report 7. Working on change requests (if any) for the same.

Factless fact table Explain with an example for factless fact table in real time project ?
Factless Fact Table: A fact table with a key section but without a measure section.  There are 2 types of factless fact table: 1. Event Tracking Tables: A table that records an event.
A Fact table, without any measures is called Factless Fact Table.For Ex.Survive Fact Table

Impromptu Query Definition - Database metadata - Select the query subject items in FM that we want to export in the form of an IQD and select the right option from the contextual menu
Let us assume that I have to create a report whose output has 1 million rows. When I create the report and run it may take several hours to show me the complete report. So can I limit the output to just 100 rows to save time while testing the report? Thanks in advance.
Answered by: arunkiranrega on: Aug 11th, 2008
You can limit data by applying filter  on some query item - for example if you have somany contract ids - you can apply filter contract id -1234
Answered by: angel987 on: Jun 26th, 2008
In the run options set the data mode to limited data.

What is the process of cognos testing Can u give me small example of cognos testing?
Answered by: arunkiranrega on: 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...
Click on the Set Properties button of the particular report. You get a lot of details of that report like report name and description. 
You can change the name of the report.
i guess by partitioning it in date, month, year, hours, minute, second.

What do you record in unit test documents?
Answered by: Pavithracts on: Jun 29th, 2008
in Unit testing we will check the fontsize,Filters etc as per in the requirement document all these things are recorded in the document.
Only in system testing using toad software will match the toad records with report output in cognos. > generally we are using toad is a predefined tesing software

Analysis Studio - an application to analyze cubes and explore business data in a multidimensional manner. Mainly used by business analysts. 

• Metrics Studio - used for the scorecarding. The idea behind it is to put performance indicators next to the organization's key performance measures (red, orange, green status notation).

• Event Studio - a process (an agent) which runs in the background and monitors the data and reacts when ocurrs something which may be cause a problem in the future in the business. For instance, if quantity of product X on stock is less than a given value, event manager can send an email to the responsible person which will contain a warning with problem description and a
 cognos report attached.

Prompts in framework manager How can you create prompts in framework manager?
We dont actually create prompts in FM.There is a property known as Prompt for each Query Item (field/column name). You just set this property to the required prompt type.After the properties are set, ... you publish the package.
In Report Studio, you just drag and drop this Query Item and define a filter with ?Query_Item?. You can set the Data Format for the Query Item here.

Repeater table What is the repeater tablethanks,
Answered by: srilug on: Apr 25th, 2008
Repeaters are tables in which you can insert items that are repeated when you run the report. For example, use repeaters to create mailing labels. To build a repeater, drop the items you want in the repeater object. Then modify the properties of 
the repeater to obtain the results you want. For example, you can specify how many repeater
 frames appear per page by typing values in the Across and Down properties.

Fact less fact table What is the fact less fact table? Why we use this table?
Answered by: chandrarekha on: Feb 13th, 2008
A fact table without measure is called a fact less fact table 
for negative analysis report we use this fact less fact table

we can use 1.incremental updates,2.use multiple data sources or 3.partition your cube using auto-patition, the size of the cube but runtime performance will increase drastically.
4.check power cube status and
 5.perform test cube .Refer step by step transformer guide for more details.

Please explain me how to import two data sources into framework manager?Can anyone tell me what is role of reporter writer in cognos?
Answered by: binay.bk on: Jan 23rd, 2008
We can import two data sources to Framework Manager  in the Run Metadata  Wizard.
Go to Run Metadata  Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.

Static choice Could u explain briefly what is static choice?
Answered by: ittoolboxcognos on: Jan 5th, 2008
Static Choice is set of choice you provide to user for selection. These choices are manually entered in the field. E.g for value prompt when you select Radio GUI then you give choices to your users by manually entering the choices by selecting Static Choice property and clicking add new.

In report level:
1)you can reduce the calculation and condetions in the report
 > 2) you can limit the cut copy phaste operations for user's > 3) you can limit access no of report's at peek time you can improve performence at report level
in model:
1)you can remove loop's at that time you can improve performence at model level
2)use indexces you can improve performance

Level span is used to eliminate duplictes in data, in cognos it is used repeat grouped item.using levelspan we can see the grouped data group by group.For example, when country and city are both group...
Answered by: venu on: Sep 16th, 2007
Level Span is used to eliminate duplicates in a report which contains columns with one-one relationships. Usually we use grouping to eliminate duplicates when there is one to many relation. But if there is one-one relationship and still there are duplicates, then we have to level span.
By using Framework Manager we can create IQD files ,By using IQD files we can creat cubes in powerplay
Usage property identifies the intended use for the data represented by each query item and it determines the aggregation rules of query items and calculations.
The different usage property settings are Identifier,Fact,Attribute, and Unknown.

One possibility would be to review the data available and use prompts if possible.  This way, you could limit the amount of data being retrieved and thus allow for a faster response time.

The syntax is as follows: LOOKUP (name) in (value1 --> value2) default (name)Name: the name of your columnvalue1: value you would like to be replacedvalue2: value you would like to replace it withd...
Answered by: narender on: Jul 23rd, 2007
By using parameter map
Asked By: chim | Asked On: Mar 15th, 2006

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.

Snapshot is the permanent local copy of the data in your report.

You have missed one more important point. > For incrimental update cube additionally we need to create hot files and frequently update the cube and over write the old hot files with latest hotfiles and then update the cube.

      --->  Select Impromptu Admin.      --->  Catalog     ---->  Folders     ---...
Answered by: rkiranbedi on: Apr 13th, 2007
Open Impromptu Administrator -> Catalog -> Folders option Select the 
column you want to > Click the Edit button, From Left Pane Select Particular
 Column which you wants to Rename Drag that into Right Pane then >Select that Column and Click on Rename Button then Change the name.

We've 2 ways to import data into a catalog.
They are 1. Database which contains all the data
               2. Hot file which is meant as local database. this also contains Meta data.

Actually there is no limitations for fact and dimensions tables. That depends upon the data and the project. Normally we have 60 dimensions and 17 fact tables.

Yes. You can do this by following the steps below:1. Configure Access Manager runtime on your desktop using "Access Manager - Configuration Wizard"
2. Update Catalog properties in Impromptu to use Access Manager by specifying the namespace.
3. Finally, use Access Manager memberships to control the Table/Folder access in Catalog using the menu option "User Profiles" or use the Access Manager variables that are available in the Expression Editor of Impromptu.

to day function is used for represent the to day date(sys date) while now function is sys time

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.

Cognos uses KERBORES security model. It was the model which was found in 1980.
by using third party authentication.

Hi,You can change database connections in Catalog level.Catalog-->Tables-->retrieve table.You will see radio button for Atached dB. 
use the list box and select a desirable DB if it is attached toCognos. or else create DB connecting by selecting the following option
Catalog-->databases-->ODBC-->New database-->Create a new connection.

Answered by: Mohan Potla on: Jun 14th, 2007
Set of similar cubes built by Transformer. Each cube group relates to a single level in one dimension of the model. Each member of the group is targeted at one of the categories in the level. 
We can create as many as it support.
We can navigate between them using CubeGroup
Which consist all together.

We can provide border for that chats you select chat and select properties you will set there box type there.
An associate is used to make one to one relationship. but before associate u must have to apply group. Ex: ordeno,orderDate,Productname is there apply group on orderno and apply associate on order date then it will give one to one relationship between orderno,order Date.
A datawarehouse is collection of "data marts". A data mart satisfies one aspect of your business. 
Data mart consist of "Dimensions" and "Facts"
Dimension are things like Location , Time etc.
Facts are numeric values (KPI) > Dimension "describe" a fact value.

Cube data could be quickly evaluated using powerplay for windows

Use transformer to build Time dimension in a model and create multiple cubes using the same model.
Transformer supports a wide range of local data sources, including
Impromptu query definition files (.iqd), which can query local or server-based databases
delimited ASCII files (.asc) and comma-separated variable files (.csv)
fixed-field text files
local databases, including Microsoft Access, which can specify SQL queries against local or
server-based databases, Clipper, dBase, FoxPro, and Paradox
PowerHouse portable subfiles
spreadsheet crosstabs and databases, including Excel and Lotus 1-2-3
A:  3MB
refreshing a cube means getting the latest records fron content store.we have one option refresh to do that.
Conditional Blocks adds an empty block that you can use for conditional formatting.You can hide and show objects in a report based on a condition you define.

Type In prompt is User entered Values, but Pick List Prompt is User selected Values

Yes, there is some limitation of generating the report in CSV.The maximum no. of rows is 65000 and columns is 256. if the data exist more then 5MB. then the report would take long time to excute and some time it wont.

at package level we can provide security, by selecting and unselecting the query subjects(tables).we can also hide the tables.
at report level save ur report in personal folder.
By using ACESS MANAGER we can set security to users.

macro is a dynamic object which is used to substiute the values at query run time.prompt is dynamic conditon which select the value or enter the value at query run time

in power play transformer   on toolbar select RUN menu .in RUN menu there is one option that isTEST BUILD

In FM right click on the Namesapace in which you want the stored procedure to be imported...Select Create->QuerySubject....
New Query subject window appears... Select the third option "Stored Procedure" -->Click Ok...New Querysubject Wizard appears in that...Select the Datasource...-->Next
In the select stored procedure window select the appropriate stored procedure and click "Finish"...Define the properties for the Procedure.....That's it and you can view the procedure as a query subject inside your namespace.

In Cognos 8, you can do it in three stages 1) Package Leveln2) Object level 3) Data level

Package level
Object level
Data level
Expan the namespace, 

R click on package > Click on Edit Package

Package Access window appears,

Remove "All users" from it

Click Adds,

select Cognos

Select "Report Administrator",

OK it,

save the package in Framework Manager (FM)

Publish the package
Expan the namespace, 
R click on a table > Click on "Specify Object Security"
On "specify Object Security" window,
click on ADD
On "select users and group" dialog box,
select Cognos
Select Report Administrator & Consumers
Click Add
In new window, under allow Report Administrator, deny consumer
Now R click on namespaces,

click on " Specift Object Security

"Here allow both consumers & Report Admni

Right click on packages,

"Explore package "

window opens

Select "Object security tab" appears

You will be allowed see who is allowed and who is not

Right click on a table

Select query subject,

select "specify security filter"

"specify data security" dialog box appear

click on ADD

select cognos

select consumers,

Ok it

click the first row,

click on insert

In Filters folder,

select the appropriate filter

save the package and publish it

1 Start Cognos Impromptu Administrator.
2.From the File menu select Catalog -> New.
3. In the File name text box, type the desired name of the catalog. In the Description text box you can add a description but this is not mandatory.
4. In the Database dropdown select the database that you want to use or click on the "Databases" button select an ODBC connection that you want to use i.e. DB2, Oracle etc. and click the "New Database" button.
5. Click "Ok" and enter the database logon and password.  Click "OK" again.  You should see a database icon in the lower left of you screen without a red X over it.
6. Select the tables that you want to use my highlighting them  on the left side and using the "Add" arrow key to add them to the "Catalog Tables" side. Click "Ok" when your finished.
7.  To create Joins in your tables select the table under the "Join path" window and the table that you want to join it to from the "Available tables" window.
8. Click "Add" and choose the fields to join the tables, click the "Add link" button to create your join.
Visualizer is a representation of data cubes in a dashboard format. We can drill through to the ground level of a hierarchy as like in power play report but cannot add or remove fields dynamically.
Cognos script editor : We can write cognos macros or programs in this tool and can fine tune or process some execution.
 Data source for defining a catalog may be any database.Whether it may be a relational database(like Oracle,sql server, DB2,Tera data etc)

You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)

powerplayFrom format menu-->title, header & footer-->title-->insert report filename

Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.



Post a Comment