MTS Launches Mobile Service in Tamil Nadu

Sistema Shyam TeleServices (SSTL), a joint venture between Sistema of Russia and Shyam group of India, has announced the launch of its global brand 'MTS' in India.


MTS will launch its CDMA-based mobile services in Tamil Nadu circle first. The company plans to expand pan-India over the coming months.


The company is offering its subscribers a scheme of one million minutes of free talk time to its customers with a limit of 150 minutes usage everyday.



Prospective subscribers can choose to purchase a handset from MTS, and they can also choose to use their own handset.



All local MTS-to-MTS calls will be charged at 35 paisa per minute; MTS-to-non MTS calls and calls to landlines will cost 70 paisa per minute.


STD calls will cost Rs. 1.40 per minute.



For ISD rates click here.Local SMS (on all networks) will cost subscribers 50 paisa per SMS, while international messages will cost Rs. 5 per SMS.



The company aims to cover 560 cities and towns in Tamil Nadu within a month and will also launch its services in Kerala next week, followed by West Bengal, Bihar and Jharkhand.



The MTS service will also be replacing Rainbow in Rajasthan.



For further details on tariff and other information, you can log on to MTS India http://mtsindia.in/

Cognos 8 Author Certification Sample Questions

A Cognos Certification Study Guide for

Cognos 8 BI Author

EXAM INFORMATION

Exam Title: Cognos 8 BI Author (Cog-112)
Number of questions: 50
Format: Multiple choice – single response
Passing score: 76%
Time: 60 minutes
Cost : $ 100 USD
Registration : http://www.prometric.com/Cognos

1. In Report Studio, an author wants to ensure detailed report data is summarized using the default aggregation specified inthe package. Which of the following is true?
A. The Aggregate Function must be set to Total.
B. The Aggregate Function property must be set to None.
C. The Auto-Group and Summarize property must be set to No.
D. The Auto-Group and Summarize property must be set to Yes.

2. In Report Studio, what kind of filter must an author create to filter the report on a data item that is not included in the report?
A. Slicer
B. Detailed
C. Summary
D. Not possible, the item must be included in the report

3. In Report Studio, an author wants to create a variable for a conditional block so the report displays either a crosstab or a chart, depending on what the user selects in the prompt. What property of the conditional block must the author define to create this variable?
A. Style Variable
B. Current Block
C. Block Variable
D. Render Variable

4. In Report Studio, which of the following is true when the Alias member unique names option is selected?
A. Report Studio creates an alias in the expression for each member that the author adds.
B. The author must create an alias in the expression for each member that the author adds.
C. Report Studio creates an alias in the layout for each member that the author adds.
D. The author must create an alias in the layout for each member that the author adds.

5. The following report was created in Report Studio using a relationally modeled package. How can the author change the report so that the quantity values for EACH product line show the AVERAGE quantities sold, not total which is currently displayed?
A. Define the Aggregate Function property as Average.
B. Define the Roll up Aggregate Function property as Average.
C. In Query Explorer, define the Auto Group & Summarize property as Average.
D. Click the Quantity column, click the Aggregate button and then click Average.

6. In Report Studio, an author merges Query1 and Query2 into one result set (Query3) using a union set operator, Query1 contains two data items: Order method and Revenue, Query2 also contains two data items: Product line and Quantity sold.The author wants to display the data from Query3 in a list report, how can the author ensure that all the order method results appear together line results appear together in the report?
A. The author must add a sort key data item directly to Query3.
B. The author must sort the Order method data item in Query1 and the Product line data item in Query2.
C. The author must sort the data item in Query3 that retrieves both Order method and Product line data.
D. The author must add a sort key data item to Query1 and Query2,and then add this sort key data item to Query3.

7. Which member is used for dimensions in package that are not referenced in the expression?
A. Tabular data includes a column for each data item in the query, No grouping is applied to the tabular data.
B. Tabular data includes a column for each data item in the query. Grouping applied in the report layout is also applied to the tabular data.
C. Tabular data can only include columns for data items that appear in the layout. No grouping is applied to the tabular data.
D. Tabular data includes a column for data item that appears in both the query and the layout. Grouping applied in the report layout is also applied to tabular data.

8. In Report Studio, an author uses the tuple function to retrieve the intersection of members from two dimensions. Which member is used for dimensions in the package that are not referenced in the expression?
A. No member is used.
B. The root member is always used.
C. The last sibling of the lowest member is always used.
D. The default member for that Dimension is always used.

9. In Report Studio, an author wants to use a join object to create a relationship between two queries. Which of the following is true?
A. The author can use a join object to create either an inner or outer join between the queries.
B. The author can use a join object only if both queries contain data from OLAP data sources.
C. The author can use a join object only if both queries contain data from relational sources that has not been modeled dimensionally.
D. Both queries must contain the same number of data item, the data items must be compatible and must appear in the same order.

10. In Event Studio, which of the following tasks are available to a report author?
A. Run an agent
B. Run an export
C. Run an import
D. Run an index update

11. In Report Studio, an author wants to conditionally format a list report according to the revenue generated by each product line. The Revenue data item does not appear in the list report but is contained in Quety1. Which of the following must the author do in order to apply this conditional formatting?
A. Make the Revenue data item a property of Queery1.
B. Make the Revenue data item a property of the list object.
C. Make the Revenue data item a property of the Page object.
D. Make the Revenue data item a property of the Variable object.

12. In an OLAP package, the Years dimension appears as show below:If the expression for Year level in this dimension is [great_outdoors_company].[Years]. [Year].which member will be retrieved by the following expression?descendants(closingPeriod([great_outdoors_company].[Years],2)
A. Ench Month member for the latest year in the Year level.
B. The latest Month member for the each year in the Year level.
C. Each Quarter member for the latest year in the Year level.
D. Each Month member from the latest quarter in the Quarter level.

13. In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a corsstab. After editing the SQL, the author wants to add a new data item to the query. How can the author add the data item?
A. The author must convert the edited SQL back to a query object and then add the data item.
B. The author must edit SQL statement so that the query retrieves an additional data item.
C. The author must add the data item to the query from the package displayed on the Source tab.
D. The author must add a query reference to the existing query and then add the data item to the referenced query.




ANSWERS: 1-D; 2-B; 3-C; 4-A; 5-A; 6-C; 7-D; 8-B; 9-D; 10-B; 11-B; 12-A; 13-B; 14-?; 15-?;

Cognos PowerPlay QnA

1. Explain the various interfaces in Transformer?

2. Explain the process of building a modal and cube?

3. Explain the technique for optimizing the cube?

4. What is the difference between fiscal time dimension and calendar dimension?

5. Can we use both calendars, fiscal dimensions in a single model?

6. What are the different data sources used in transformer?

7. What is the difference between dimension and level?

8. How do implement a security in the model?

9. What is a dimension view?

10. What are the extensions of the model?

11. How do you calculate the model size if categories are not generated?

12. What is the difference between incremental update and refresh?

13. What are the different states of rollups?

14. What is a time state rollup?

15. What is regular rollup?

16. How to move the Transformer model in development to production?

17. What is s Special Category?

18. Shall we use drill through from cube to report. Cube to cube is yes where shall we define?

19. Can we generate a user defined level in the model?

20. What is alternate drill down?

21. What is convergence level?

22. How do you define a cube?

Note: Answers will be posted very soon

Cognos FM QnA

1) What is the FM and what is significance of FM in Cognos reporting.

2) What are the different types of import source available to create a new model?

3) What does a project contains?

4) What is difference b/w model & package?

5) How many files Framework manager creates while saving project?

6) What is IQD? What is contained in IQD?

7) What is parameter mapping explain with an example.

8) What is the meaning of stitched query?

9) What is namespace?

10) How can we identify ambiguous relation ships in frame work manager?

11) What is the Query subject and types of Query subjects available in FM?

12) How do we provide security in frame work manager for a query subject?

13) How can we generate the cubes in framework manager?

14) What is the cardinality and how do you define the cardinality in FM?

15) What is the Query item in FM?

16) What is the use of governors in Frame Work manager?

17) What is loop in framework manager?

18) How can we improve performance at FM level?

19) How can we set security at FM level?

20) What is the Dimension and how many types of Dimension are available in FM?

Note: New Questions and Answers will be posted very soon

Cognos Reports QnA

1) What are the different types of reports which can be created by Report Net?

2) Can report net connect multiple data source at a time in report creation time?

3) What function should you use to display the value entered or selected by a user in
Response to a prompt?

4) How can we limit the max no of rows retrieved in the report?

5) Difference between filter and condition?

6) What are the advantages of query studio compared to report studio?

7) What are components of reportnet?

8) What is difference between query studio and report studio?

9) How can i create prompts in report net?

10) What is the Crosstab and Graphs in Report Studio?

11) What is the main advantage of impromptu over cognos reportnet?

12) What are the filter and how many types of filters available in reportnet? Explain briefly.

13) Is it possible to convert the repeater to “List” after I convert the List to Repeater?

14) What are the various file formats involved in reportnet?

15) What is the difference between Native SQL and Cognos SQL?

16) How can I test report in reportnet?

17) What are components of report studio?


18) Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?

19) What is the difference between drill through and master-detail reports?

20) What is calculation and how many types of calculations are there?

21) What is the meaning of drill down and drill up in cognos?

22) What is the level span in cognos?

23) What is the Repeater report in Cognos?

24) What is prompt? Types of prompts? Use of prompts? Syntax of prompt?

25) What is cascading prompt?

26) What is the difference between parameter and variable in report studio?

27) What is conditional formatting?

28) What is a drill through report?

29) What is diff. between Master Detail and Drill Through report?

30) What is bursting of Reports?

31) How can we improve performance at report level?

32) How can we set security at report level?

33) How many reports you created so far in your career?

34) What is the complex report you created and explain about it?

35) What is Cognos Connection? Explain about it?


Note: New Questions and Answers will be posted very soon