Sonu Questions

Q1. How to create model in powerplay transformer from SQL Server 2005 database without using .iqd file as a datasource? Ans: We can use architect model to use multiple datasources like DB2 , SQL Server 2005 in powerplay transformer other then this there is no other way except using .iqd . Q2. How to make compatible impromptu 7.X .iqd files with other tools of Cognos 6.X like powerplay transformer to use it as a datasource? Ans: Manipulate cognos.ini file and odbc.ini file by giving the proper connection string for your catalog. Q3. What Cognos.ini file consist of? Ans: It has the connection information of the catalog. Q4.What is the named range in excel and why it is required when we take excel as a datasource in cognos? Ans.Named range is range defined in the excel which tells cognos which data it has to take and atleast one named range should be defined? Q5. How to customize prompt manager in impromptu? Ans: By editing the SQl generated by impromptu. Q6.What is the size of catalog generally? Ans: 3 MB Q7. How to Migrate reports from Cognos Impromptu 7.x to Cognos ReportNet ? Ans: to migrate a report from impromptu to report net the administrator must configure impromptu on reportnet server with proper credentials then only we can open and logon, we should log on to both other wise we can't Q8. what is the security module used in cognos? Ans: Cognos Access Manager Q9. what is cube group and when will you create cube group?

Ans: Set of similar cubes built by Transformer. Each cube group relates to a single level in one dimension of the model. Each member of the group is targeted at one of the categories in the level. This cube group is generally used in case of creating smaller cubes based on the data in the level of a dimension. Q10.How to give set of users permission to access particular cube in Cognos? Ans: In cognos we can create users,groups,roles by using third party authentication like COGNOS ACCESS MANAGER, LDAP and by creating namespaces in LAE.After creating the users we can provide the permission (like read,write,set policy,travers,execute) to users. Q11. what is Associated grouping? and how it works in cognos impromptu? Ans: An associate is used to make one to one relationship. but before associate u must have to apply group. Ex: ordeno,orderDate,Productname is there apply group on orderno and apply associate on order date then it will give one to one relationship between orderno,order Date. Q12. what is loop in frameworkmanager ? Ans: Loop: loop is a closed path (relation) that exists among 3 (or) more tables. For example, if we have '3' tables T1, T2, T3 then, a loop exists among these tables only when we create joins in the following fashion: Loop:

T1 ---> T2 ---> T3 ---> T1

To resolve the above problem, we have to create a shortcut (or) Alias to the Table T1. No Loop:

T1 ---> T2 ---> T3 ---> Alias (or) Shortcut of T1

Q13.What is the Cube size? And can we drill through powerplay cube to impromptu reports? Ans:Size of cube is maximum 2 gb and yes we can drill through powerplay cube to impromptu reports by defining it in the properties of cube. Q14. diff between drill down and drill through? Ans: Drill Down - an action that shows the child categories

Drill Through - A n action that uses the current context of a report, to access information in anotherreport, cube, Impromptu report, or macro. Cubes with drill-through access are set up in Transformer and must match on of dimensions, measures, and details, although not necessarily all of them. Q15. What are the limitations of generating reports in CSV format in Cognos reportnet/cognos 8? Ans: csvYes, there is some limitation of generating the report in CSV.The maximum no. of rows is 65000 and columns is 256. if the data exist more then 5MB. then the report would take long time to excute and some time it wont......i will mail u the excat no. of rows soon.