What is meant by Tabular SQL in Cognos Report net
Answers were Sorted based on User's Feedback
Answer / venkatesh
tabulat sql is used to create u r own query or modify query
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / prudhvi
Hi Pawan,
Tabular SQL is that which we can write our own SQL to
create the report.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vsandhyana
A SQL statement that is declared as a derived table whose
items may be reused within the tabular structure.
Relationships between multiple derived tables will be
determined by the query engine.
Is This Answer Correct ? | 3 Yes | 0 No |
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
drillthrough vs master detaild report,which one is the best by performance?
How many number of cubes can we create on a single model? How can we navigate between those cubes?
what is the security module used in cognos?
What is catalog and types of catalogs in cagonos and which is better?
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...
What do you mean by drill through report?
Can any one give the example for slicing and dicing of data ?(with simple query)
What is Portal Tab?
Where do you edit cognos sql in report studio?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!