If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

IIS 7.5 Rewrite with Congos URL

Started by dbahiker, 14 Feb 2013 02:27:34 PM

Previous topic - Next topic

dbahiker

I'm having a issue with trying to IIS rewrite the cognos URL. I know the rewrite function is working because I have a simple setup in place. http://server/ibmcognos  --> http://rpt103/hotdog

I'm not looking to do a DNS Alias.

Pattern:
c10/(.*)

Ignore Case checked

RewriteURL:
/ibmcognos/cgi-bin/cognos.cgi?b_action=cognosViewer&ui.action=run&ui.object={R:1}

Append query string checked.

My wish is to shorten URLs for sharepoint hyperlinks.

example:
http://server/c10/content/package[@name='Audit']/report[@name='Execute reports by user']

rewrites to :
http://server/ibmcognos/cgibin/cognos.cgi?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&ui.action=run&ui.object=content/package[@name='Audit']/report[@name='Execute reports by user']

dbahiker

Discovered Problem: %20 added in the rewrite URL.

I would enter http://server/c10/content/package[@name='Audit']/report[@name='Execute reports by user'] in the URL.

And the rewrite results would be http://server/c10/content/package[@name='Audit']/report[@name='Execute%20reports%20by%20user']

Testing I found this URL works fine with: http://server/c10/content/folder[@name='Test']/report[@name='testing']

Working on Solution in IIS Rewrite to keep the blank spaces in the folder and report names.

I will post final rewrite solution once I have it.

Also discovered this solution if you want to pay for it.  ::)

http://www.xploreplus.com/blog/ibm-cognos-url-mapping-in-sharepoint/#!prettyPhoto

dbahiker

For Reports

Pattern:
c10/(.*)

Ignore Case Checked

Rewrite URL:
/ibmcognos/cgibin/cognos.cgi?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&ui.action=run&ui.object={URLEncode:{R:1}}

Append query string Checked