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

How to change the margin of a PDF report in Cognos

Leave a comment

Question

If you run a report as a PDF, you will get a default margin. You can’t change this within the Page Setup. So how it is possible to change the margin in a PDF output?

Answer

1. In Report Studio, click any element within the report page.
2. Click the small up-arrow in the property section and select ‘Page‘.
3. Once selected, click the property ‘Margin‘.
4. In the window that appears, you can specify the margins used for report rendering.

          ExampleIf you set the top margin to 0 px, you will have no top margin in the PDF.

5. Make adjustments to the four margins as necessary to allow your PDF report to display properly

UDA-SQL-0227 Equivalence types are incompatible Cognos Report

Leave a comment

Try to use cast function and convert both query items to same data type.
This is common when joining on date as once date may have time part and the other only date.

How To Read Cogserver.log Easier With IPF Log Viewer

Leave a comment

Use LogviewV2.exe located in the Congos\bin directory.

_add_months in Cognos

Leave a comment

When using this _add_months function it adds one month to the date, when using as end of the Month date to add a month, then if the current date is 30th and add a month to get the next month end date it will be 30th not 31st, so use last_of_month function to get the next end of month date.

Finding what tables are being used in what reports

Leave a comment

1) In Framework Manager click on any item(s) that you want to know if a report uses.
2) Under the “Tools” menu in the menu bar, click “Find Report Dependencies”
this opens the “Report Dependency” window
3) Specify your Scope by using the selections you want and click “Search”
4) It will query the content store and return you results.

Older Entries