If you're looking for Cognos TM1 Interview Questions & Answers for Experienced or Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research Cognos TM1 has a market share of about 1.8%. So, You still have the opportunity to move ahead in your career in Cognos TM1 Development. Mindmajix offers Advanced Cognos TM1 Interview Questions 2021 that helps you in cracking your interview & acquire a dream career as a Cognos TM1 Developer.
Computations on the leaf data are performed in real-time (for example, to aggregate numbers up a dimensional hierarchy). IBM Cognos TM1 includes a data orchestration environment for accessing external data and systems, as well as capabilities designed for common business planning and budgeting requirements (e.g. workflow, top-down adjustments).
IBM Cognos TM1 (formerly Applix TM1, formally Sinper TM1 – Table Manager 1) is enterprise planning software used to implement collaborative planning, budgeting, and forecasting solutions, as well as analytical and reporting applications. Data in IBM Cognos TM1 is stored and represented as multidimensional OLAP cubes, with data being stored at the “leaf” level.
Changing IBM Cognos TM1Web to be a java based application allows the same version of the application to run on multiple platforms. Cognos TM1 Web version 10.2 is the first version that will be able to run on a non-Microsoft Windows platform. The initial release supports MS Windows, AIX, and Linux. TM1 Web 10.2 has a service-oriented architecture with a number of improvements that increase performance and usability:
It is possible to set up TM1 Web underneath a load-balancing product. A load-balancing product is not provided by IBM. To set up TM1Web for load balancing, install TM1Web version 10.2.0 on multiple servers behind a load balancing product. TM1 Web’s API is not stateless and will require sticky/persistent sessions.
|Want to enrich your career and become a professional in IBM Cognos TM1, then enrol "IBM Cognos TM1 Training" This course will help you to achieve excellence in this domain.|
TM1 Web still outputs a log file. The location of this log file has changed to install_dirwebappstm1webWEB-INFlogs. If you are having problems with TM1 Web, check this log to find out more about the errors that may have been generated.
TM1 v10.1 must have the interoperability function configured to allow packages to be published from TM1.
TM1 is based on a client-server architecture and different components that interact with each other in a seamless manner to achieve the desired functionality. The following figure depicts the development process in a broad manner:
As depicted in the preceding figure, multi-dimensional cubes reside on TM1 data servers.
These cubes in turn take their dimensional structure from multi-dimensional models, created by the modeler. Data is fed to these cubes from one of the backend data sources through inbuilt turbo integrator processes. Please note that these ETL processes can be modified as per the user requirements.
TM1 v10.1 has the interoperability function configured to allow packages to be published from TM1.
There are 3 types of viewers in TM1.
To initiate the TI process TM1RunTI is a command-line interface tool.
Series of statements that manipulate values for each record in the data source.
TM1 package connector helps to import data from packages/dimensions and custom queries.
Series of statements that are to be executed after the data source is processed.
A synchronized () function can is used to serialize the TI process so they can be processed sequentially.
EnableBulkLoadMode() = Enable
DisableBulkLoadMode() = Disable.
Ans: The limit of string length in Turbo Integrator is 8000 single-byte characters. If the length will become more than 8000 bytes then it gets truncated.
TM1 executes chores in GMT standards. It doesn’t have any auto mechanism to accommodate Daylight Saving. Its Chores Scheduled time should be edited when DayLight time begins and ends.
You can create your own custom scripts using Advanced Window
The sub-tabs which are in the advance tab of TI are:
All the system and User threads will be resumed and user logins will also be allowed.
Power Play Transformer contains dimension, measure, model, and cube. There are different ways to generate a cube.
Steps to be followed:
Data Sources available with TI are:
Snapshot is nothing it’s only a copy of data, whenever we create any snapshot it only copies the exact data that is related to the particular report. It is used to compare reports.
For ex: we want to compare the report for this month with the previous month.
By using Drill-through reporting you can link from one report to another. There is a number of ways to Drill Through:
Drill Through id developed with two reports
The procedure is executed before the data source for the TI is opened. TI directly goes to Epilog if the data source for the process is none and if there is no data source then Metadata and data tabs are ignored.
Series of statements that update or create cubes, dimensions, and other metadata structures during the processing.
2.0 GB. It depends on your project requirements.
The minimum requirement to run the sample TM1 servers provided will be:
Using the distributed approach of TM1 10 they have done testing on thousands of users.
It creates a placeholder on the cells so that the cells will not be skipped during the consolidation.
The more dimensions a cube has, the greater will be the degree of sparsity.
Feeding means defining feeders for consolidated cells. (Feeding a consolidated cell automatically feeds all children of the consolidation.)
Under Feeding means failing to the feed cells that contain rules-derived values. This always results in incorrect values and must be avoided at all costs.
SKIP CHECK forces TM1 to use the Sparse Consolidation algorithm in all the cases.
It is used for building the Cubes (Multidimensional Structure used for OLAP processing).
It is a Web portal for Cognos 8 and a component that interacts with the Content Store. It is a frontend to publish, find, manage, organize, and view an organization’s business intelligence data.
It’s a reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
It is also called a garbage dimension. A junk dimension is a convenient grouping of typically low-cardinality flags and indicators.
The catalog is a file containing the information (Database tables) that Impromptu users need to create reports. Types of catalogs are:
It’s a cube in which the number of populated cells as a percentage of total cells is too low.
A Query Subject is a collection of Query Items. Generally, query items have a defined relationship. It is primarily a database table upon which query action takes place.
Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.