---------------How to identify First Record and Last Record?

Answer Posted / sowji

Using Head function u can get first record ,Using tail
function u can get last record.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

914


Why is auto-regression used in forecasting used on cognos platform?

542


What is meant by Reportstudio shortcut?

1729


What is the size of database for you project?

1113


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

1882






How security is concerned with Reportnet? Explain its implementing steps.

1614


What are the types of studio present in Cognos?

617


------------- How to identify the Revenue Column in Report?

1823


can we insert all types of charts in a list report? what r the realtime prompts?

1673


What are all the types of indexes in Cognos?

717


How to deploy from one server to another server?

2021


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

1633


what is the difference between list report and crosstab report?

715


----------------Diff b/w Dimensional modeling and Relational modeling?

13912


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1601