A : There are 3 types of viewers in TM1.
- Cube Viewer.
- Web Sheet Viewer.
- Navigation Viewer.
Q2 : What are the basic features of Cognos TM1?
A :
- Real-time, interactive multidimensional database also with write-back functionality
- 64-bit, in memory OLAP server capable of concentrating huge volumes of data
- Enterprise level planning and analysis capabilities
- Guided modeling environment to facilitate planning, analysis and forecasting
- Rapid development of flexible models, including profitability models, without batch processing
- Integrates with IBM Cognos Business Intelligence, to establish a single view of performance.
Q3 : What are the functions required to be called for enabling or disabling the bulk load of mode?
A : Functions:
- EnableBulkLoadMode() = Enable
- DisableBulkLoadMode () = Disable.
Q4 : Name the data sources which are available with TI?
A : Data Sources available with TI are:
• SAP via RFC
• IBM Cognos Packages
• Microsoft Analysis Services
• Relational databases using ODBC Connectivity
• Comma-delimited text files including ASCII files
• Other Cubes and Views
Q5 : Give the options which are available after importing data using TI?
A :
- Create Cube and populate data
- Create and Update dimensions
- Re-create Cube. It destroys the existing cube definitions and overwrites it
Q6 : How do you use TM1 cubes in Framework Manager?
A : TM1 v10.1 has the interoperability function designed to allow packages to be published from TM1.
Q7 : What is the limit of string length in Turbo Integrator?
A : The limit of string length in Turbo Integrator is 8000 single byte character. If the length will become more 8000 bytes then it gets reduced.
Q8 : Define TM1 architecture?
A : TM1 is based on 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.
Q9 : Define snapshot?
A : 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 of this month with the previous month.
A : 2.0 GB. It depends as per your project requirements.
Materialized views loading or replicated takes place only once which gives you better query performance.
Q12 : Define FEEDERS?
A : It creates a placeholder on the cells so that the cells will not be skipped during the consolidation.
Q13 : Define Over Feeding?
A : Over Feeding means defining feeders for consolidated cells. (Feeding a consolidated cell automatically feeds all children of the consolidation.)
Q14 : What is the role of the transformer?
A : It is used for building the Cubes (Multidimensional Structure used for OLAP processing).
Q15 : Define Under Feeding?
A : 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.
Q16 : Define Cognos Reporting tool?
A : It’s a reporting tool from IBM which helps in reporting and analysis of various data from a data warehouse.
Q17 : Define Cognos Connection?
A : It is a Web portal for Cognos 8 and a component which interacts with the Content Store. It is a frontend to publish, find, manage, organize, and view organization’s business intelligence data.
Q18 : Name the prompt which are available in Cognos?
A :
- Value prompt
- Text Prompt
- Date prompt
- Time prompt
- Date and time prompt
Q19 : What kind of system requirement is needed to run TM1 for a small installation?
A : The minimum requirement to run the sample TM1 servers provided will be:
• Disk Space: Minimum 500 MB
• Memory: Minimum 2 GB RAM
• Processor: Pentium 4 or higher
• OS: Windows 2003(x86, x64), Windows 2008(x86, x64), Windows 7(x86, x64), Linux
Q20 : What is the difference between list and crosstab?
A : List
• List report shows the data in row and column(detail information of the report).
• List can be converted to Crosstab
Crosstab
• Crosstab report shows the data in grids, dimensions in row and column and measures in cells or an intersection point.
• Crosstab can’t be converted to list. There is no direct option available in Report Studio to convert the crosstab to list.
Q21 : Define Drill Through?
A : By using Drill-through reporting you can link from one report to another. There are number of ways to Drill Through:
Drill Through id developed with two reports• Parent Report
• Child Report
Q22 : Where is TM1 Web Logging information found?
A : 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.
Q23 : Can TM1 Web be set up for load balancing?
A : 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.
Q24 : How you can enable Bulk Load Mode in TI?
A : a) In Prolog or Epilog section of TI, Bulk Load mode can be enabled.
b) It always recommended that Bulk Load Mode should be enabled in the Prolog section.
Q25 : Name the function which is used to serialize the TI process?
A : Synchronized () function can is used to serialize the TI process so they can be processed sequentially.