Month: June 2018

Cognos how to hide pages/fields based on output format

Posted on by tekweirdo in Cognos Analytics

 

create a render variable with ‘Expression Definition:’ as

ReportOutput () in ( ‘spreadsheetML’) –this would give output only for excel output report
ReportOutput () in ( ‘PDF’) — this would give specified output only for pdf output report.
ReportOutput () not in ( ‘PDF’) — This will hide specified output for pdf output report

Values that you could pass are:
items: [xlsxData, CSV, spreadsheetML, HTML, layoutDataXML, PDF, XML, XLWA, MHT, rawXML, XHTML, singleXLS, HTMLFragment]
case sensitive: true
Source:
https://www.ibm.com/support/knowledgecenter/SSEP7J_10.2.1/com.ibm.swg.ba.cognos.ug_md.10.2.1.doc/c_crx_reportoutput.html

 

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

Posted on by tekweirdo in Cognos Administartion, Framework Manager, Uncategorized

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

 

Cognos analytics temp folder files unable to delete

Posted on by tekweirdo in Cognos Analytics

At cognos Server- UDA and TMP files are few files which get created when a report is been run. These files will be deleted automatically after the report run is finished.
We might be in a situation when this files go big and not getting deleted after the session. At that time you can delete them manually. But if you are not able to delete manually (assuming you are having admin rights) then you need to check at cognos connection if any reports are running at background. Make sure there are no reports running in background, if they are then notify user and kill them.
An other option is  to kill few services at task manager(not the cognos server related) and check whether the temp files are deleted or not.

 

topic:
cognos analytics uda files unable to delete
cognos analytics UDA Temp Files

resource:
http://www-01.ibm.com/support/docview.wss?uid=swg21358858
https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.tg_bitshoot.doc/c_cognos8runsoutoftempspace.html

Microsoft sql server MDS

Posted on by tekweirdo in Microsoft SQL Server

Documents and links related to implement Microsoft MDS

Checklists/Points to be aware off-
Make sure the version of DB and MDS are same.
You can download excel plugin from MDS web url.
Make sure all the required IIS programs are added.
Package file cannot be deployed using MDS-UI if the package has data.
To deploy package with data, use MDSModelDeploy.exe tool (accessed via command line utility)
To deploy package without data you could use create/deploy option at MDS-web UI.

This is a good course to get an idea –
https://www.udemy.com/sql-server-master-data-services-master-data-management/learn/v4/questions/6408682

Master Data Services Installation and Configuration
https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-installation-and-configuration?view=sql-server-2017#InstallMDS

Uninstall and Remove Master Data Services
https://docs.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?view=sql-server-2017

Master Data Services Developer Documentation
https://docs.microsoft.com/en-us/sql/master-data-services/develop/master-data-services-developer-documentation?view=sql-server-2017

https://docs.microsoft.com/en-us/sql/tutorials/enterprise-information-management-using-ssis-mds-and-dqs-together-%5Btutorial%5D?view=sql-server-2014

https://docs.microsoft.com/en-us/sql/master-data-services/master-data-services-overview-mds?view=sql-server-2017