1. How to build a cube in Cognos 8 using Framework Manger?

2. Master detailed relationship?

3. Fact less fact table?

4. How to evaluate the cube?

5. what are the different performance tuning techniques of a cognos cube?

6. what is the difference between the render variable and the style variable?

7. Framework Manager ?

8. Query Studio ?

9. what is the difference between a cascading report and drillthru report?why do we go for drill thru what is the difference between a cascading report and drillthru report?why do we go for drill thru report?

10. How can I create a dynamic column name in Cognos

11. Import two data sources to Framework Manager in Cognos

12. What is object security in framework manager?

13. Cognos Decision Stream

14. Materialized view

15. Performance tuning in model and report level

16. Static Choice

17. what are complex reports?

18. What is the difference between parameter and variable in report studio

19. how to configure content store in Cognos?

20.What is level span? How it is used in Cognos? what is the main advantage of level span.

21. cognos improve report performance

22. What different kinds of SQL you can write at the report level What is tabular SQL,Tabular Modal and Tabular Set

23. Cognos Model

24. What is usage property?

25. How to show the data reported horizontally? For example, employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def

26. How to combine two crosstab reports in to single crosstab report?


27. How do you handle this DB Schema changes in our Framework manager to update automatically our meta How do you handle this DB Schema changes in our Framework manager to update automatically our meta data

28. How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)


29. what is drill down and slicing and dicing whats the difference between them.


30.what is model and say about process how to create model and how to test model

31. Define Dimensions, measures, Regular dimensions and Measure Dimensions

32. What is data processing?

33. How can we use NVL function/Dataformat to resolve the Blank spaces in our report. Explain with navigation

34. How do you utilize Java Script within Cognos?

35. How do you speed up the report execution even though it has lot of charts.

36. How to pass multiple values from picklist prompt to sub report filter


37. what is spaning of tree

38. How to use Lookup Command?

39. What are the steps involved in migrating CRN enviroment to Cognos 8

40.how can i schedule reports in cognos

41. what is snapshot

42.
What is meant by Junk Dimension?
How do you perfom while running the report?
Where will you see the tWhat is meant by Junk Dimension?How do you perfom while running the report?
Where will you see the time of running report?
Size of the cube?
What are the types of prompts in ReportNet?
What is macro and how it will be work?
What is difference between Cognos and Cognos ReportNet?
How do you create cube in ReportNet?
There are 10 facts are there.How will you connect all?

43. what is incremental refreshing of a cube and how can we do it


44. When You Import data into catalog You have complex columns names. How do you change the Name of those columns?

45. What are the Ways to Import Data into Catalong?(2 ways)


46. What is catalog and types of catalogs in Cognos and which is better

47. what is the difference between cognos 8 and cognos reportnet 1.1mr1,cognos reportnet 1.1mr2?

48. What do you mean by slow dimensions?

49.
1.In middle level project aprox How many Number of Dimension and Facts are exists?
2.In a complex report how much maxm. No. of dimension are exist in a Cube?

50.How to improve Report performance in ReportNet?

What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?

1. Create a new namespace.

2. Create a new query subject inside IQDReportNet.

3.In the query subject definition window, pull in all the data you need.

4. after creating, click on the new query subject, from the properties pane, select "IQD" from the drop down menu of externalizeMethod.

DONE.

to Publish. u need to create a package.

1. create a new package. a WIZARD will open.

2. Name the new Package; select the IQDReportNet object from the project.

3. add security, select language, select the funtion list(DB), select the location from the WIZARD

4. Publish the package.


--------------------------------------------------------------------------------

Give me any example of semi and non additive measures?
Semi-Additive: Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table but not the others. Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. Current Balance and Profit Margin are the facts.Current Balance is a semi-additive fact as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?) but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information). Profit Margin is a non-additive fact for it does not make sense to add them up for the account level or the day level.



--------------------------------------------------------------------------------
How can you restrict access onto different parts of report given a report?

In Cognos 8 you can do it in three stages

1) Package Level

2) Object level

3) Data level


Package level

Expan the namespace

R click on package > Click on Edit Package

Package Access window appears

Remove All users from it

Click Adds

select Cognos

Select Report Administrator

OK it

save the package in Framework Manager (FM)

Publish the package

----------------------------------------------------



Object Level

Expan the namespace

R click on a table > Click on Specify Object Security

On specify Object Security window

click on ADD

On select users and group dialog box

select Cognos

Select Report Administrator & Consumers

Click Add

In new window under allow Report Administrator deny consumer

Now R click on namespaces

click on Specift Object Security

Here allow both consumers & Report Admni

Right click on packages

Explore package

window opens

Select Object security tab appears

You will be allowed see who is allowed and who is not

-------------------------------------------------------



Data level

Right click on a table

Select query subject

select specify security filter

specify data security dialog box appear

click on ADD

select cognos

select consumers

Ok it

click the first row

click on insert

In Filters folder

select the appropriate filter

save the package and publish it

Diff b/w Report Functions and Database functions?

How can you link a query to a data container manually in Report Studio?

How do we convert from Numeric to be Words?

please can you give me some banking domine calculations developed in framework manager?

Diff between Crossproduct and Outerjoin?

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

I have ten columns that needs to be totalled... but some columns are empty...how do

I get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?

Interval Prompt's Usage? Example for usage in Project?

How can we create regular dimensions & measure dimensions?

How u will determine the performence tune will occur either in report or system?

How to deploy from one server to another server?

What is use of Field Set present in toolbox?

How to perform back drill through in cognos 8 what is the use of it?

How to give a securites in object level&datalevel&pakege lavel in frame work manager?
Explain about scorecarding?

Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

What are user classes?

What is meant by Reportstudio shortcut?

wat is bus schema?

what are the features in cognos8ui?

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

I have a sales project interviewer asked tel me the how many facts&dimensions used in ur project.

what is sdibling function tell me the some functions

what is surrogate key give example?

how to add a new query item by using 2 query subject? For Ex: i want to create a revenue query item in products query subject(revenue=Quantity*Unitprice). Quantity is in products query subject & unit price in orders query subject it will be possible in report studio(perment/temporerally) otherwise u have create in Freamework Manager... pls any body knows explain /answer me ?

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

Give me scenario on cascading prompts&master-detail relation

what is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

Can we test the report other than manual testing?

What is the use of content store in cognos?

It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?

Difference between impromptu and cognos8

What is snapshot thumbnail