Archives

Seaching Cognos 10 Content Store for an XML string

Seaching Cognos 10 Content Store for an XML string

We recently migrated our knowledgebase from Collab to sharepoint, which meant all reports that had links to collab needed to be identified and edited. This query proved helpful – it searches the content store for occurrences of the old string, ‘collaboration.au’, and displays the report name and location. The query does take a while to run though – almost 40 minutes against our beast-mode content store…

read more

Auto-Generated prompts in Cognos 10 BI

Auto-Generated prompts in Cognos 10 BI

I had an issue with Cognos 10 today whereby the automatically generated prompt control for a BI report was showing a drop down list, rather than a type in prompt. The reason this was an issue is that I wanted to set up a schedule of this report, with this particular prompt being for ‘Client Code’. As we have many thousands of clients, there seems to be a limitation with auto-generated drop down prompts whereby they only showing the first thousand or so records. After some experimenting, I was able to find that coalescing the column with a null string would force the auto-generated prompt to be a type-in box, thus allowing the client code to be entered. Here is the code originally used by my filter: #/* Strategic Client */# [Engagement Revenue].[Strategic Client Level Dimension].[cons_client_cd] = ?pStrategicClient2? and here is the modified code that uses a type-in prompt box: #/* Strategic Client */# coalesce ([Engagement Revenue].[Strategic Client Level Dimension].[cons_client_cd], ”) = ?pStrategicClient? Below is a picture showing both these prompt behaviours: Note: I’ve since discovered you can also set the prompt behaviour in the Framework Package

read more

Launch Internet Explorer as another AD user

Launch Internet Explorer as another AD user

Here is a script I wrote using a DOS batch file for testing Active Directory security of a web application. It will launch an Internet Explorer session as a selected AD user then open a selected page.

read more

A new blog

It’s been a while since I started a blog, and this one is purely self serving!

read more