find better solutions for analytics world
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)
run below command on your database to get space of the database
EXEC sp_spaceused
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:
Data Engineering and BI BLOG 