Interview Questions.

Q1. What Is Meant By Alternate Drill Down With Ex?

Alternate drill down path me there might be two direction to opt. For instance- We can have time dimension now the customer requirement is that they want two sort of yr -one is calender year(Jan-Dec) and another is fiscal yr(Apr-Mar).

Q2. What Is Log In Cognos?

While developing reviews or growing models logs have all data until consultation closed.

Q3. What Is The Difference Between Filter And Condition?

A Filter is a restrict that reduces the amount of data displayed inside the file.

The file filters are non-reusable and specific to the record.

Filters are

before aggregation: non-aggregated facts are filtered(info report)

after aggregation: summary statistics are filtered

Q4. What Is Cognos Powerhouse And What Is It Used For?

Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity improvement environments for creating your facts-driven business solutions quicker,whether for Web-based, consumer/server, or traditional terminal-based get admission to. PowerHouse has received a worldwide reputation for productiveness, reliability, performance, and versatility.

Q5. What Is Trformer?

Trformer is used for constructing the Cubes (Multidimensional Structure used for OLAP processing).

Q6. What Is The Difference Between Enterprise Data Warehouse And Data Warehouse?

Big Organizations have a number of different resources of data.There might be a dataware house completely for trport and others for data related to the assignment the agency runs.In such case the complete company's(employer's) records warehouse is a big combination of all and is understood the Enterprise statistics Warehouse(EDW).

Q7. What Is Cube Size?

2.Zero GB (It relies upon for your challenge requirements).

Q8. How You Provide Security To Reports? How You Provide Security To Packages ?

For framework supervisor programs, before you head away with developing a brand new package deal it asks whether or no longer you need to have safety installation for the package deal in use. Even if you have not described any protection at this level, you can always goto the movements >> bundle >> Edit package settings and there you can define the security settings for the package deal.

For reports, you can either deliver file-degree or folder- stage security by way of going to the houses of that and deciding on appropriate roles/person organizations which might be speculated to be entitled to view/regulate/create reports.

Q9. What Is The Difference Between Group And Association?

In cognos 'organization' is used to suppress the reproduction values. And 'accomplice' is used to suppress the values if it's far one-one relationship.

Group - It Eliminates the Duplicate values from the record damage the columns. Its having a one to many dating.

Association-It Eliminates the Duplicate values from the document and its having one-one dating.

Both Group & Association eliminate duplicates in a column.But we can not use Association alone.It ought to have one to one courting with grouped column.

Using Association is a overall performance enhancement approach.

 

Q10. What Are The Different Ways Of Adding Data In Trformer?

In trformer you import metadata from architect or catalog to create a dice. We simply import metadata. We don’t upload records to it.

Q11. What Is The Importance Of Dimension In The Cognos.?

Without Dimension and Fact can't make a relation between tables it could not be use for joins and retrieve the information as a form of news in cognos. Dimension is a primary challenge place via which we will evaluation our business.

Q12. What Is Drill Down And Slicing And Dicing Whats The Difference Between Them?

Drilling lets you quickly pass from one degree of element to every other to discover extraordinary elements of your commercial enterprise.

Drilling down moves you down inside the hierarchy.

Drilling up moves you up inside the hierarchy.

Slicing and Dicing While you can drill to observe facts at any degree, you can slice and dice to select the exact information you need to your record.

Q13. What Are The Special Features In Cognos Reportnet?

CRN is net primarily based tool. So it'll very beneficial to view the reports very without difficulty. So that they preferred CRN

Q14. What Is The Security Module Used In Cognos?

The security module utilized in cognos is cognos access manager.

Q15. What You Mean By Drill Across And What Is The Difference Between Drill Through, Drill Across?

Drill across me while you are transferring from one report to some other record like u . S . In one document and States in some other Report while if the record is the use of same record from shifting from country to kingdom. In different when you are shifting information level in case you are the usage of the distinctive file it's far drill across and in case you are using identical report it is drill via.

Q16. What Junk Dimension Contains?

It includes the miscellaneous attributes together with flags , which does belong to the primary size table.

For eg; In a sales order reality table ,some informations like, internet-order , whether this is a online order or no longer new_cust-Is this individual a brand new client , verification- whether the order has been proven.

Q17. What Are Products Of Cognos?

Cognos 6.6 7.Zero,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.Zero(ultra-modern)IWR is use with the aid of Impromptu to publish reviews, PPES is utilized by PP, Cognos Connection is utilized by repornet. There are many other equipment however these are the principle.

Q18. What Is Query Subject?

A query concern is the primary constructing block in Framework Manager. A question challenge is a set of question gadgets which have an inherent courting.

Q19. How To Create Measures And Dimensions?

By the usage of the Framework Manager we are able to create measures and dimensions according to our enterprise wishes.

Q20. How To Configure The Cognos Configurations To Work In The Windows 2000 Server Machine?

Go to Cognos Configuration and spot the settings for cognos inside the explorer web page. There you could set for win2000 server.

Q21. What Is Report Item?

Report item is nothing but a query item while it's far drag and drop into the work region.

Example in Go sales and outlets package deal-> Product (is a query situation) and-> Product line is(a query object)->while PL is dropped into the paintings vicinity then its a record object.

Q22. How Do Add Dynamic Titles In Pp?

PowerplayFrom format menu-->identify, header & footer-->identify-->insert report filename.

Q23. Suppose You Run A Report With Empty Data, How Will You Inform The End User That It Has No Data While Running The Report In Report Studio? Is It Possible, If So How?

Add a listing footer and a text messsage interior "No Data". Create a boolean conditional variable "Test" with code "rownum()>zero". Select the complete listing footer and set Style Variable, if Yes, Box Type of the List footer need to be set to "none". 

Q24. What Is Model And How To Create Model And How To Test Model?

Create a Model In framework Manager and then publish it, ensure that Model meets the requirements, don't overload the model with undesirable question gadgets.

Model is nothing but a undertaking. And the venture may be created through framework supervisor wherein we can extract the metadata from the various operational resources... We are able to take a look at the version by using the usage of the TOAD.

Model consists of meta records that's related to commercial enterprise reporting Information. We import this facts from the records base. Using this metadata we're creating Packages, Publishing programs, This metadata carries question topics and namespaces.

Q25. What Is Difference Between Drill Through And Drill Down?

Drill via lets in you to navigate from summary to specific statistics.

Drill down also similar form of element,for instance will do drill down on 12 months if we drill down in this the following stage will come me year includes quaters, it incorporates

months,

months contains weeks,

week contains days.

So,we are able to view all of the stages thru drill down.

Q26. How You Migrate Reports To Cognos eight From Previous Versions?

The use of deplyement tool we can migrate the reports.

Q27. How Many Levels Can Be Used In Drill Through Reports?

Two ranges: summary and detail.

Q28. What Is The Difference Between A Cascading Report And Drillthru Report?Why Do We Go For Drill Thru Report?

Cascading report works based at the circumstance but drill thru work based totally at the records object what we choose as a drill through alternatives.

Q29. What Is The Difference Between Macros And Prompt?

Macro is about of commands to run file.

Prompt is similar to a conversation container with a purpose to ask user to pick/enter the statistics what he desires.

 

Q30. How Can We Create A Dynamic Column Name In Cognos?

Select Properties, and then click the Headers/Footers tab.

Q31. How Can I Convert A List Report/cross Tab Report In Cognos Ep Series Into A Bar Chart Or Pie Chart Etc.?

This may be accomplished in Impromptu administrator.

Q32. What Are The Enhancements In Cognos Reportnet ?

Enhancements in Cognos reportnet is Cognos 1.Zero, 1.1, MR1.1, MR1.2 Cognos 1.0,1.1, MR1.1, MR1.2 AND cognos eight, 8.1.1MR, eight.1.2MR, now new version is eight.2

Enhancement in cognos within the list report:-

Apply list column identify patterns

Apply list column body styles

Apply table patterns.

Q33. What Are The Limitations Of Cognos Reportnet? What Are The Enhancements In Reportnet ?

ADVANTAGES:

PURELY WEB BASED REPORTING TOOL

WE CAN CREATE MULTILINGUAL REPORTS

IT CAN SUPPORT ANY TYPE OF OPERATING SYSTEM & DATA BASE

WE CAN CREATE SINGLE MODEL IN FRAMEWORK MANAGER COMING FROM MULTIPLE DATA SOURCES

DISADVANTAGES:

WE CAN'T DRILL DOWN AND DRILL UP

IT CAN'T SUPPORT MULTI DIMENSIONAL ANALYSIS

Q34. What Is Cognos Visualizer And Cognos Scripting?

Visualizer is a illustration of statistics cubes in a dashboard format. We can drill via to the ground degree of a hierarchy as like in energy play file but can't add or do away with fields dynamically.

Cognos script editor : We can write cognos macros or packages on this device and may quality tune or technique a few execution.

Q35. What Is Snapshot ?

A Snapshot is a Permanent Local Copy Of the Report.Snapshot is Static Data Source it's miles stored with .Imr File it's miles suitable for Disconnected Network.

Q36. How Create Measures And Demensions?

You can create measure after you import all of the information into the information supply.You can create measures and dimensions by way of draging the specified source from datasource into dimension map and degree tab.(need to discover scope of measures for all the dimensions)

Q37. How You Burst The Reports? If You Are Bursted Reports Is Not Reached To Destination How You Identify?While You Import Data Into Catalog You Have Complex Columns Names. How Do You Change The Name Of Th

First you have to click on on column header which you have to trade. Then in property pane you'll determined name option. Then change column call.

Q38. How Many Numbers Of Cubes Can We Create On A Single Model? How Can We Navigate Between Those Cubes?

Using a single Model, we are able to create as many quantity of cubes u want. By the usage of the size views...And many others. Regarding the navigation, whilst we store cubes, these act as separator multidimensional databases. There wont be any family members. Navigate me opening the cubes separately.

Q39. Can Reportnet Supports Cubes?

No

Q40. How Can I Test Reports In Cagnos?

In cognos report net with the aid of the validate record choice a report can be examined. If there might be any mistakes, it'll specify the error, except it will supply message -'file specification is valid'.

After developing the report we can connect with the oracle and we can write the square question and we can examine this 2 reports .

Q41. What Are Slowly Changing Dimensions? Why We Are Used Scd?

Slowly Changing Dimensions are those whose records aren't fixed.

SCD sorts:

SCD type 1: Whose information isn't constant.

Historical facts are not saved. Data keeps on changing.-> Current Data

SCD kind 2: Whose statistics is fixed and additionally shop historic facts.

SCD type 3: Like SCD kind 2 handiest however save historical facts in another desk. In one desk records will updated and in some other desk historic information will be there.

 

Q42. What Is The Difference Between List Report And Crosstab Report?

List record show records in rows and columns versus a move tab document show records in grids with measurement in rows and columns and measures in cells or within the intersection points.

List Report and Cross tab document both carries rows and columns but difference is list document is a detail report for analysis whereas go tab document is the intersection of statistics or summarized facts for analysis.

Q43. What Are The Names Of The Reports That You Prepared?

List file, Cross tab document, pie charts and so forth.

Master detail, Drill thru, CascadingList, Cross tab, Chart, Map file are the simple file of Cognos.

Q44. How Can I Change Reports To Another Package?

Open that file and keep as that reportSelect public folder and then choose package deal wherein package you need to store then save it.

Q45. What Are The Migration Tools Available In The Market With Respect To Cognos Such As Impromptu Reports Are Migrated To Cognos Reportnet?

Reportnet1.1 migration device is to be had emigrate the impromptu document to reportnet.

Q46. What Are Versions Of Cognos From Starting Release To Latest In The Market?

EP7 series is the oldest cognos series.

Cognos record internet is the subsequent series.

Cognos eight.@

cognos 8.3 is the modern version.

But most of the corporations use cognos eight.@

Q47. What Is Drill Down And Slicing And Dicing What Are The Difference Between Them?

Drill down me it will explains the precis stage facts to lowest stage information.

Slicing is not anything but slicing fringe of the cube.

Dicing is nothing however viewing the cube in all possible guidelines.

Drill down is the way to get the extra specified records.

Slicing and dicing is to get the statistics in step with where clause.

Q48. What Is Associated Grouping? And How It Works In Cognos Impromptu?

You can accomplice one or more records objects with a grouped facts object. An related facts item should have a one-to-one courting with the grouped records object. For example, Order No. Is a grouped facts object.

For every order quantity, there is an Order Date. Order No. And Order Date have a one-to-one dating.

Q49. How To Create Cubes In Trformer ?

Cube may be created by means of the usage of one-of-a-kind data assets.

Data sources: iqd, tex document Cube advent by using the use of iqd records sources.

These iqd assets are coming from impromptu.

Q50. What Is Cardinality?

Cardinality is not anything however relation among tables like

One to One,

One to Many and

Many to Many.

Cardinality is the character of the relationship. 1-1,1-many relationships Cardinality is the nature of the relation among  question items.