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.
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
We can limit the maximum number of rows by setting the web page size option in the manage file tab in the report studio.
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
Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing
Webmaster 23rd of May 2012
Tell us what you feel about Reportnet Interview Questions and Answers
All comments will be published after review. No login or registration is required to post a comment on Reportnet Interview Questions and Answers We offer and invite you to submit your valuable comment now; Please be respectful of others when commenting. Insulting others, self-promotional comments, website promotional comments, marketing stuff, SEO Techniques, SMS-style content and off-topic comments will not be approved at this information portal.
So start sharing your thoughts regarding Reportnet Interview Questions and Answers
Thank you.