Convert date to yymmdd

Leave a comment

convert(varchar(8), getdate(), 112)
convert(int, getdate(), 112)

Date operation in Cognos

Leave a comment

_months_between ([Prompt Selection],[Reported Date])

Sum function in Cognos Report

Leave a comment

Sub Total
TOTAL([Claim] FOR [Risk Profile])

Grand Total
TOTAL([Claim] FOR REPORT)

Report Studio Ranking

Leave a comment

This will give you the Rank # for each of the Product Line based on Gross Margin
RANK (Gross Margin FOR Product Line)

This will give you the Rank # for each of the Product Line and Product Type based on Gross Margin
RANK (Gross Margin FOR Product Line, Product Type)

Leave the Aggregate and Rollup Aggregate Functions to Automatic

Adding a Static Choices Prompt (Custom value drop list)

Leave a comment

http://www.ibm.com/support/knowledgecenter/en/SSFUEU_7.2.0/com.ibm.swg.ba.cognos.Report_Authors_Guide.7.2.0.doc/t_rag_adding_a_static_choices_prompt.html

Convert yyyymmdd to date in Sybase IQ

Leave a comment

dateformat(convert(CHAR(8),20170101),’YYYY-MM-DD’)

Data lakes and the promise of unsiloed data

Leave a comment

http://www.pwc.com/us/en/technology-forecast/2014/cloud-computing/features/data-lakes.html

Older Entries