If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Need help to implement PARTITION BY statement in Report

Started by snehal, 03 Aug 2008 09:54:39 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

snehal

03 Aug 2008 09:54:39 PM
Can anyone give me solution for this question.........I have a SQL query like  MAX(NVL(a.DueDate,'01-JAN-00'))Over (PARTITION BY b.StateName,b.CityName,TRUNC(b.ID))Max_DueDate  which is in the Select Statement...Now I want to Implement this in the Report studio By using the Model.So please let me know the solution for this ....


Thanks,
snehal
Print
Go Up Pages1
User actions
BSP Software Documentation
MetaManager Documentation and Knowledgebase
Version Control Documentation and Knowledgebase
BSP Software Resources About Us
MetaManager BSP Software Training BSP Software
Integrated Control Suite YouTube Channel Micro Strategies Inc
Security Migration IBM Cognos
Integrated Management Suite