Top Cognos TM1 Interview Questions And Answers
1. Cognos TM1 Characteristics
| Criteria | Result |
| Distinguishing features | Analyzing complicated plans, budgeting, and forecasting |
| Modeling methodology | Generate flexible models, including profitability models, without batch processing |
| Processing & storage characteristics | Data storage in RAM, efficient calculation engine & high scalability |
2. What are the essential highlights of Cognos TM1?
Constant, intelligent multidimensional information base likewise with compose back usefulness
64-cycle, in memory OLAP worker fit for concentrate tremendous volumes of information
Endeavor level arranging and investigation abilities
Guided displaying climate to encourage arranging, investigation and determining
Fast improvement of adaptable models, including benefit models, without clump preparing
Coordinates with IBM Cognos Business Intelligence, to set up a solitary perspective on execution.
3. How would you use TM1 blocks in Framework Manager?
TM1 v10.1 has the interoperability work arranged to permit bundles to be distributed from TM1.
4. What number of sorts of watchers accessible in TM1?
There are 3 sorts of watchers in TM1.
3D shape Viewer.
Web Sheet Viewer.
Route Viewer.
5. How to run Turbo Integrator Process from Command Line?
To start the TI cycle TM1RunTI is an order line interface instrument.
6. Characterize Data Tab?
Arrangement of proclamations that controls esteems for each record in information source.
7. Characterize TM1 bundle connector?
TM1 bundle connector assists with bringing in information from bundles/measurements and custom questions.
8. What is Epilog Tab?
Arrangement of articulations that will be executed after the information source is handled.
9. Name the capacity which is utilized to serialize the TI cycle?
Synchronized () capacity can is utilized to serialize TI measure so they can be handled consecutively.
10. What are the capacities needed to be called for empowering or handicapping the mass heap of mode?
EnableBulkLoadMode() = Enable
DisableBulkLoadMode() = Disable.
11. What is the constraint of string length in Turbo Integrator?
The constraint of string length in Turbo Integrator is 8000 single byte character. On the off chance that the length will turn out to be more 8000 bytes, at that point it gets shortened.
12. What are the defects of Chore Start Time?
TM1 executes errands in GMT norms. It doesn't have any auto instrument to oblige DayLight Saving. Its Chores Scheduled time should be altered when DayLight time starts and finishes.
13. Name the various methods inside TI?
Characterizing Data Source
Setting Variables
Planning Data
Altering Advanced Scripting
Booking the finished Process.
14. Name the window by which you can make your own custom contents?
You can make your own custom contents utilizing Advanced Window
15. How you can empower Bulk Load Mode in TI?
In Prolog or Epilog segment of TI, Bulk Load mode can be empowered.
It generally suggested that Bulk Load Mode should be empowered in Prolog segment.
16. Name the sub-tabs which are ahead of time tab of TI
The sub-tabs which are ahead of time tab of TI are:
Prolog
Metadata
Information
Epilog
17. What is the importance of Ending Bulk Load mode?
All the framework and User strings will be continued and client logins will likewise be permitted.
18. How we can produce 3D shapes in Cognos?
Strategic maneuver Transformer contains measurement, measure, model and 3D shape. There are various approaches to create a 3D shape.
Steps to be followed:
On the money click on 3D shape name and assemble.
We can compose content in UNIX. Utilizing that we can undoubtedly produce the block.
19. Name the information sources which are accessible with TI
Information Sources accessible with TI are:
SAP by means of RFC
IBM Cognos Packages
Microsoft Analysis Services
Social information bases utilizing ODBC Connectivity
Comma delimited content records including ACII documents
Different Cubes and Views
20. What is Chore Commit property?
It permits you to indicate if the cycles in errands will be submitted as a solitary exchange or either as different exchange
In a solitary submit mode all cycles are submitted as a solitary exchange. It is default ordinarily.
In various submit modes any cycles that should be submitted do as such as they are prepared.
It is conceivable to change errand property just when task is INACTIVE.
21. Characterize preview?
Preview isn't anything it's just a duplicate of information, at whatever point we make any depiction it just duplicate the specific information that is identified with the specific report. It is utilized to think about reports.
For ex: we need to contrast the report of this current month and earlier month.
22. Separate among see and appeared see?
Perspectives
It contains question at whatever point execute sees it has perused from base table Materialized View
M perspectives stacking or recreated happens just once which gives you better question execution.
23. Characterize Bulk Load mode?
It empowers TM1 to run in an uncommon streamlined Single-client mode. This mode has an ability to boost the presentation for devoted errands during when there is no heap on worker or at evening time.
It doesn't show a message to end-client to caution them. No new associations can be made.
24. What really happens when Bulk Load mode begins?
All the planned tasks will be deactivated
All the handling by different strings will be stopped
Running tasks and any of the current client strings will be suspended
TM1 Top associations and all the framework explicit strings will be suspended
25. Characterize Drill Through?
By utilizing Drill-through detailing you can connect starting with one report then onto the next. There are number of approaches to Drill Through:
Drill Through id created with two reports
Parent Report
Kid Report
26. What is the contrast among list and crosstab?
Rundown
Rundown report show the information in line and column(detail data of report).
Rundown can be changed over to Cross tab
Crosstab
Crosstab report show the information in frameworks, measurements in line and segment and measures in cells or in convergence point.
Crosstab can't be changed over to list. There is no immediate choice accessible in Report Studio to change the move tab over to list.
27. Give the alternatives which are accessible in the wake of bringing in information utilizing TI
Make Cube and populate information
Make and Update measurements
Re-make Cube. It decimates the current block definitions and overwrites it
28. Characterize Prolog tab?
System is executed before the information hotspot for the TI is opened. TI straightforwardly goes to Epilog if the information hotspot for the cycle is none and on the off chance that there is no information source, at that point Metadata and information tabs are disregarded.
29. Characterize Metadata?
Arrangement of explanations that refresh or make 3D shapes, measurements and other metadata structures during the handling
30. What is the 3D square size?
2.0 GB. It depends according to your undertaking prerequisites.
31. What sort of framework necessity is expected to run TM1 for a little establishment?
The base necessity to run the example TM1 workers gave will be:
Plate Space: Minimum 500 MB
Memory: Minimum 2 GB RAM
Processor: Pentium 4 or higher
Operating system: Windows 2003(x86, x64), Windows 2008(x86, x64), Windows 7(x86, x64), Linux
32. What number of clients can open or associate with one of the TM1 web application simultaneously?
Utilizing the disseminated approach of TM1 10 they have done testing in great many clients.
33. Characterize FEEDERS?
It makes a placeholder on the phones so the phones won't be skipped during the union.
34. What is the method of composing a FEEDER Statement when taking care of one solid shape from another?
Computation proclamation consistently dwells in the objective block, however the FEEDER articulation ought to live in the source 3D square.
The Feeder is essentially the opposite of the estimation explanation in the Target Cube that requires the feeder.
35. What are the means to investigate the FEEDERS?
Use Rules Tracer will be utilized to aid the turn of events and investigating of rules.
The usefulness of Rule Tracer is accessible in Cube Viewer
36. How does Rules Tracer help us?
It follows FEEDERS; it guarantees that chose leaf cells are taking care of rules-determined cells appropriately or not.
It checks FEEDERS, guarantees that the offspring of chose united cells are taken care of appropriately or not. Check Feeders choices is accessible from combined cells and it's not accessible from leaf hub.
37. Characterize the rationale behind the Sparsity in solid shapes?
The more measurements a solid shape has, the more noteworthy will be the level of sparsity.
38. Characterize Over Feeding?
Over Feeding implies characterizing feeders for solidified cells. (Taking care of a merged cell consequently takes care of all offspring of the combination.)
39. Characterize Under Feeding?
Depriving implies neglecting to the feed cells that contain rules-inferred values. This consistently brings about wrong qualities and should be maintained a strategic distance from no matter what.
40. What is the job of SKIPCHECK in TM1?
SKIPCHECK powers TM1 to utilize the Sparse Consolidation calculation in all the cases.
41. What is the job of transformer?
It is utilized for building the Cubes (Multidimensional Structure utilized for OLAP handling).
42. Name the segments of report studio?
Insertable Objects panProperties sheet
Wayfarer bar
Report Viewer
43. Name the segments of Report Net?
System administrator
Cognos association
Inquiry Studio
Report Studio
44. Name the brief which are accessible in Cognos?
Worth brief
Text Prompt
Date brief
Time brief
Date and time brief
45. Characterize Cognos Connection?
It is a Web entrance for Cognos 8 and a segment which interfaces with the Content Store. It is a frontend to distribute, find, oversee, coordinate, and view association's business knowledge information.
46. Characterize Cognos Reporting device?
It's a detailing apparatus from IBM which helps in revealing and investigation of different information from an information distribution center.
47. Characterize Junk Dimension?
It is likewise called as trash measurement. A garbage measurement is a helpful gathering of regularly low-cardinality banners and pointers.
48. Characterize is list and sorts of inventories in Cognos?
List is a document containing the data (Database tables) that Impromptu clients need to make reports.
Sorts of inventories are:
Individual
Appropriated
Shared
Made sure about
49. Separate between Power play transformer and strategic maneuver reports?
Strategic maneuver transformer
It is an 'MOLAP' device utilizing which one can make multi dimensional structure called "CUBE".Power play reports
Strategic maneuver for reports is utilized to create report from the block. Just one report can be produced from one solid shape. In the event that you need 'n' reports you should make 'n' blocks.
50. Characterize Sparse Cube?
It's a 3D shape in which number of populated cells as a level of complete cells is excessively low.
51. Characterize Query Subject?
A Query Subject is an assortment of Query Items. For the most part inquiry things have a characterized relationship. It is fundamentally an information base table whereupon inquiry activity happens.
