ibm i2 documentation and learning

 

ibm i2 ibase

few referral documents:

Click to access 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

 

 

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I was getting following Cognos framework error while opening the model.

BME-EX-0047 Unable to read preferences for the requested interface. Please use another repository and/or ProjectAccess Interface.

I got this error for framework 11.0 after we had a patching on windows.

I reinstalled the software in same path with same version and it worked.
None of the framework models were effected.

 

source:

https://www.ibm.com/support/pages/node/260415

 

python TypeError: can’t multiply sequence by non-int of type ‘float’

 

This error shows up when there is a type mismatch.

Example:

When you execute below code you will get this error-
 

>> hrs = input(“Enter Hours:”)
Enter Hours:40
>>> rate =float( input(“Enter Rate”))
enter rate: 10
>>> pay = hrs*rate
TypeError: can’t multiply sequence by non-int of type ‘float’

 

Solution for this:

hrs = float(input(“Enter Hours:”))
rate = float(input(“enter rate”))
pay = hrs*rate
print(‘Pay:’ , pay)

Cognos cross tab percentages

 

How to get percentages in cognos cross tab

I need to calculate % for count distinct value. to do this in the query we need 3 data items.
data item 1 – count (distinct item_id) . solve order 1
data item 2 – count(distinct item_id for report) . solve order 2
data item 3 – data item 1/ data item 2

use data item 3 in your crosstab and format it as percentage.