BI BLOG

ibm i2 documentation and learning

Posted on September 21, 2019November 10, 2019 by tekweirdo in ibm i2 ibase, Uncategorized

ibm i2 ibase

few referral documents:
http://www.cloudbreakanalysis.com/uploads/2/2/0/4/22049470/ibm_i2_ibase_white_paper.pdf

i2 ibm documentation:
https://www.ibm.com/support/knowledgecenter/SSXVXZ_2.3.0/com.ibm.i2.landing.doc/eia_welcome.html
https://www.ibm.com/support/knowledgecenter/SSXVXZ_2.3.0/com.ibm.i2.landing.doc/enterprise_insight_analysis.html

i2 ibase learning
https://www.ibm.com/services/learning/ites.wss/zz-en?pageType=search#(cc%3A”%2Cfilters%3A()%2CnumberOfResults%3A’20’%2CpageNumber%3A1%2CpubEntIdentifier%3A”%2Cquery%3Aibase%2Csorting%3Arelevance%2F%2Fasc%2Ctype%3Aall%2CviewMode%3A0)

ibm i2 ibase
https://www.securitylearningacademy.com/local/navigator/index.php?level=spaa04&courseTypes=Video%20Course

IBM i2 EIA Lab enviroment:
https://www.securitylearningacademy.com/mod/hvp/view.php?id=6513#
https://labs.edu.ihost.com/sec9769.a1ba8c1383f7@1f80433ec391a3e43.b2b.foo/0eed

ibm i2 videos

https://www.ibm.com/support/pages/i2-youtube-video-index
https://www.youtube.com/user/IBMSecuritySupport/playlists?sort=dd&shelf_id=13&view=50

tableau pdf remove margins

Posted on September 21, 2019 by tekweirdo in tableau

Default pdf output from tableau would have a huge margin. Currently using tableau server I don’t see a solution. But using Tableau desktop i was able to fix this.

in tableau desktop
1. go to file–> page setup–> remove margins
2. go to file–> print to pdf –> paper size – Unspecified.

tableau page setup1 tableau page setup2 tableau print to pdf

sql server spatial

Posted on September 16, 2019September 16, 2019 by tekweirdo in Microsoft SQL Server, sql, Uncategorized

Below URL’s provide very good understanding of spatial joins in sql server

https://docs.microsoft.com/en-us/sql/t-sql/spatial-geography/spatial-types-geography?view=sql-server-2017

Introduction to Spatial Queries in SQL SERVER 2012

https://docs.google.com/file/d/0B0hWbrRTteuIekZtQ0NqWTBoNVk/edit

sql server distance between two points coordinates

Posted on September 1, 2019 by tekweirdo in Microsoft SQL Server, sql

select GEOGRAPHY::Point(lat1, long1, 4326).STDistance(GEOGRAPHY::Point(lat2, long2 , 4326))

sql – how to get decimal for an inetger

Posted on August 29, 2019 by tekweirdo in Microsoft SQL Server, sql

multiple ways of doing this.

select distinct inputvalue,
, round(CAST( inputvalueAS DOUBLE PRECISION ) / 1000.0, 3) — doesn’t secure 3 decimals
, round(inputvalue/1000.0,3) — by default 6 decimals
, cast(inputvalue/1000.0 as float)
, convert(numeric (15,3), inputvalue/1000.0)

sql server space used by database

Posted on August 26, 2019 by tekweirdo in Microsoft SQL Server

run below command on your database to get space of the database

EXEC sp_spaceused

Cognos Visualization error

Posted on August 4, 2019August 4, 2019 by tekweirdo in Cognos Analytics

error:

The web request failed.

Details:

404 – Not Found
URL: http://cognosserver/ibmcognos/bi/common/palettes.json

Solution:

On your webserver pallettes.json needs to be copied from install location analytics\webcontent\bi\common to the analytics\webcontent\bi\common folder

Key words for search:

Source:

404 – Not Found – palettes.json