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.
This error shows up when there is a type mismatch.
When you execute below code you will get this error-
>> hrs = input(“Enter Hours:”)
>>> 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)
create a new query subject based on below calculation
use the above query subject as filter and set filter application to – “After Auto Aggregation”
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.