Reportnet

The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information which is equal to Group by and Having clause in SQL statement

Yes it can connect multiple datasources at a time when the frame work manager has the metta data regarding that datasources.

We have a function called param Display Value. By using this function we can display the parameter value selected in prompt.

There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.

Adv of reporting directly against the database(OLTP): No need to sepertaley maintain a Database for it.(Space consumption is recduced).

Disadv of reporting directly against the database(OLTP): It slows down the process bcoz OLTP system is designed for the online application but a DataWarehouse application which requires to do analysis and hence takes the same data but takes a long time.

If we wanna test the report in report net, first we can intially check by validating it in the report page.

After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.

One of the advantage's of Reportnet, is

1. It is web-based reporting wherein, reports can be easily accessed from anywhere through a browser.

by using ipromptu we can use multidimensional analysis to see the data in diff formates.i.e we have drillup,drilldown features in cognos impromtu,but it is not possible in reportnet.

Model is a representation of the metadata structures(imported from the soure datawarehouse).A model contains organized metadata objects(organizing depends on business needs).After the completion of a model(obviously in a framework manager environment) it has to submitted to ReportNet server.There enterts the object called Package.A Package compresses(or includes) the developed meta data definitions and publishes (forwards) it to ReportNet server.Then the reportnet server moves it into a content store(repositiry) and now this repository acts as a source for report developers for generating various types of reports(list reports, cross tab reports etc etc.)

Template extension is .imt

Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing

Tabular model: It is the basic list query. It contain the data items, filters and child tabular objects.

Tabular SQL: We can write and edit our own SQL

Tabular ref: It is a shortcut to another tabular object somewhere in another query within the same report specification.

Tabular set: Tabular set object returns a single result set using union, intersect or minus operators

In cognos reportnet

Native SQL is used for the single datasource to import the meta data

Cognos SQL used for multiple datasources to import the metadata

We can limit the maximum number of rows by setting the web page size option in the manage file tab in the report studio.

You can follow this procedure :::

Lets assume revenue is the field in which we have to display null values as 0.

First create a calculated item and

Then write the expression of the cal item using If Then Else construct as

If (Revenue is null) Then ('0') Else(Revenue)

I think u can easily understand this.

Now u can see that the null values r displayed as '0' in the calculated item.

Select the data item in which you want to replace null with 0 .Go to Properties pane, Click Data Format, in this put 0 in Missing value Characters.