Here is the issue:
PowerPlay enterprise server is serving up cube pages via IIS. The issue arises in the URL string format, when the page is refreshed or served the URL is in a proprietary format. The page either static or bookmarked is
saved as a URL which transforms itself I think in the backend as a COGNOS query string to build the view or refresh it when the user accesses the page or bookmark again.
The problem is that these pages or bookmarks or report views are compressed URL strings so they meet the 2048 byte limit (in other words they are in some sort of hex, GUID or weird format in the dynamic Query string-- I am having issues getting or finding a good example) which COGNOS understands and can translate some how to refresh the report in the browser, the issue is that the engine that translates the query string from what i researched
so far is proprietary. what happens next is the it logs in IIS as a GET but in the original bookmark format not the translated format.
What i want to do is reprot off the IIS log GETs however i need to translate the URLs so they make sense to the business mngt users. The customer is using webtrends and they have an add-on product bascially a Content mngt systems
conduit that can do ODBC calls for dynamic page translation however, they are not sure if it will work in this type(PowerPlay and Bookmarked) of environment.
Questions:
1)Has anyone out there had any experience translating or reporting off IIS logs using a Log analysis tool? and to get some sort of friendly name based on the cryptic URL passed to the GET statement in the LOG that Powerplay creates?
2)Or simpler yet is the PowerPlay system accessible via ODBC calls to translate bookmarks or saved views and are these URLs stored in a catalog or table structure accessed via ODBC? what si the name of the table of catalog?
3)Are the saved views passed in the URLs saved in COGNOS via metadata in a friendly manner vs the cryptic manner they are logged or displayed in the URL string?
Any help on any of these questions are extrememly appreciated.
Travis
PowerPlay enterprise server is serving up cube pages via IIS. The issue arises in the URL string format, when the page is refreshed or served the URL is in a proprietary format. The page either static or bookmarked is
saved as a URL which transforms itself I think in the backend as a COGNOS query string to build the view or refresh it when the user accesses the page or bookmark again.
The problem is that these pages or bookmarks or report views are compressed URL strings so they meet the 2048 byte limit (in other words they are in some sort of hex, GUID or weird format in the dynamic Query string-- I am having issues getting or finding a good example) which COGNOS understands and can translate some how to refresh the report in the browser, the issue is that the engine that translates the query string from what i researched
so far is proprietary. what happens next is the it logs in IIS as a GET but in the original bookmark format not the translated format.
What i want to do is reprot off the IIS log GETs however i need to translate the URLs so they make sense to the business mngt users. The customer is using webtrends and they have an add-on product bascially a Content mngt systems
conduit that can do ODBC calls for dynamic page translation however, they are not sure if it will work in this type(PowerPlay and Bookmarked) of environment.
Questions:
1)Has anyone out there had any experience translating or reporting off IIS logs using a Log analysis tool? and to get some sort of friendly name based on the cryptic URL passed to the GET statement in the LOG that Powerplay creates?
2)Or simpler yet is the PowerPlay system accessible via ODBC calls to translate bookmarks or saved views and are these URLs stored in a catalog or table structure accessed via ODBC? what si the name of the table of catalog?
3)Are the saved views passed in the URLs saved in COGNOS via metadata in a friendly manner vs the cryptic manner they are logged or displayed in the URL string?
Any help on any of these questions are extrememly appreciated.
Travis