Cognos Data Warehouse

Based on country column find out the territory.create territory column in model level. In my expectation we should hard code using case condition.

If u find any best answers please give me solution.

Add a list footer and a text messsage inside "No Data". create a booloean conditional variable "Test" with code "rownum()>0". Select the complete list footer and set Style Variable, if Yes, Box Type of the List footer should be set to "none". This should work...RD

The junk dimension is simply a structure that provides a convenient place to store the junk attributes

Macro-A macro is a set of instructions that can run applications.Example : A macro can open your catalog,select a report(say for instance) convert that to another format and export it to any specified location,provided the code (Program)is such.Prompt-A prompt specifies the manner in which data in the reports are to be displayed.A Prompt can be defined at the catalog level either or during report generation.

Cognos Powerhouse is High-Productivity Application Development Solutions equips you with high-productivity development environments for creating your data-driven business solutions faster,whether for Web-based, client/server, or traditional terminal-based access. PowerHouse has gained a worldwide reputation for productivity, reliability, performance, and flexibility.

Select Properties, and then click the Headers/Footers tab.

Drill across means when you are moving from one report to another report like country in one report and States in another Report whereas if the report is using same report from moving from country to state. In other when you are moving details level if you are using the different report it is drill across and if you are using same report it is drill through.

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

In cognos report net by the validate report option a report can be tested. If there will be any error, it will specify the the error, unless it will give message -'report specification is valid'.

After creating the report we will connect to the oracle and we will write the sql query and we will compare this 2 reports .

Cognos 6.6 7.0,7.3(PowerPlay, Impromptu)--ReportNet1.0,1.1mr1, 1.1mr22---ReportNet 8.0(latest)IWR is use by Impromptu to publish reports, PPES is used by PP, Cognos Connection is used by repornet. there are many other tools but these are the main.

By using Cognos Schedular, one can schedule the running reports in Impromptu to execute and save it in desired format.

By using Cognos MACRO script language the reports can be executed and distributed to recipients by using mail applications.

Compiled Cognos MACROs can be scheduled using Cognos Schedular.

You can create measure once you import all the data into the data source.You can create measures and dimensions by draging the required source from datasource into dimension map and measure tab.(need to find scope of measures for all the dimensions)

n impromptu menu go to Catlog->User profiles -> userclass tab -> click on Creator ->u can give there folder access,table access,filters,Governor etc

you can crate users by using USERS PROFILE option......and you can give permissions using ROLE IN C8 and GOVERNERS in C7

Big Organizations have a lot of diversified sources of data.There might be a dataware house exclusively for transport and others for data related to the project the company runs.In such case the complete enterprise's(company's) date ware house is a big combination of all and is known the Enterprise data Warehouse(EDW)

Alternate drill down path means there will be two path to opt.For example- We will have time dimension now the client requirement is they want two type of year -one is calender year(Jan-Dec) and another is fiscal year(Apr-Mar).

go to tran former,

build the cube

right click on the cube and open properties

go to drill through tab and select your report from that browse option

Section-section is eliminate the duplicate recod.but report looking separate bluck.

setpagebreak means to display the reports in onepage. eg. suppose u create a list report ordermethod,orderyear,revenu

when u create section on ordermethod.it will eliminate the duplicate record.but when u apply the set pagebreakc.report display in onepage.like fax reports in onepage,email reports in another page.this in cognos 8 querystudio.

Drilling lets you quickly move from one level of detail to another to explore different aspects of your business. Drilling down moves you down in the hierarchy; drilling up moves you up in the hierarchy.

Slicing and Dicing

While you can drill to look at information at any level, you can slice and dice to select the exact information you want in your report.