Hi, I am developing the cognos reports to webi and looking for help in writing the below formula. The backend database being used is Sql server. I need help in writing the below formula in Webi using backend database as sql server. maximum(i...

Hi Folks,I need to display data for all month end along with current date data in a single columnOCT-31-2016NOV-30-2016DEC-31-2016JAN-27-2017 (considering data available for current day date)I was able to display for month end using lastdayofmonth f...

Hi All,I would like to calculate the value for attribute Beginning balance based on user response as shown below. Here user would be selecting the month number and Year in the filter as prompt and based on month number and year selection he should se...